Excel Advanced- Standard – Full Day

$ 285.00

Class Duration: 7 Hours

Class Agenda

Morning Session 3 Hours
Lunch 1 Hour
Afternoon Session 3 Hours
Other Breaks Prescribed by Instructor

After you’ve mastered formatting tables of data, creating formulas between cells, using built-in functions, and creating charts, there is a standard set of more powerful features you’ll eventually need. Whether you’re looking at someone else’s spreadsheet and wondering “how did they do that?” or simply lacking enough firepower to get your own spreadsheets to do what you want, this class will probably solve that problem.

  • Use Database Functions: XLOOKUP(), SUMIF(), and AVERAGEIF()
  • Fix errors using auditing, or handle inevitable errors with backup values
  • Apply data cleanup and isolation/consolidation techniques.
  • Find optimal values for a single cell or a set of inter-related cells. 
  • Create and run basic macros to automate repetitive tasks.
  • Add macros to the Excel ribbon
  • Creating and Applying Names In A Worksheet
  • VLOOKUP Function
  • XLOOKUP Function
  • ROUND function
  • Using the Formula Auditing Tools
  • Using the IF Function and Nesting Functions
  • Using the IFERROR Function
  • Summary Based Functions: SUMIF(S), COUNTIF(S), AVERAGEIF(S)
  • Text Functions: LEFT, RIGHT & MID
  • CONCAT function and Text-To-Columns Feature
  • Using the Data Consolidation Tool 
  • Using the Goal Seek Tool
  • Using the Solver Tool
  • Using the Scenario Manager
  • Recording and Running Macros
  • Understanding the Macro/VBA Developer Interface
  • Editing Macros with the Visual Basic Editor
  • Adding Buttons to Run Macros From the Ribbon
“Our outlines are a guide to the content covered on a typical class. We may change or alter the course topics to meet the objectives of a particular class.”

The ability to work with and analyze data is critical to the success of your organization. For decades, Microsoft Excel has been the go-to application for doing so. Begin adding it to your professional skill set with our foundational Excel course. You will learn to navigate the application confidently while creating and developing worksheets and workbooks that employ the most popular features Excel has to offer.

DETAILED COURSE OUTLINE

Getting Started with Access

Working with Table Data

Querying a Database

Using Forms

Generating Reports

“Our outlines are a guide to the content covered on a typical class. We may change or alter the course topics to meet the objectives of a particular class.”

Event Details

Phone: (602)252-3955

Email: registration@trainingtoyou.com

Scroll to Top