Excel Advanced
Excel Advanced Formulas and Functions
Understand how to create advanced formulas and functions to really tap into the power of Excel.
-
Understand how to utilize several of the advanced functions in Excel
-
Learn advanced ways to nest formulas and functions for more complex calculations
-
Learn to use the VLOOKUP and HLOOKUP functions effectively
-
And More
Excel Pivot Tables
What exactly is a Pivot Table? You may have heard about creating a Pivot Table in Excel, but you may not even know what a Pivot Table is, let alone how to create one. Learn what a Pivot Table is and how to use this incredibly powerful tool to analyze your data.
-
Understand what a Pivot Table is and how to use it
-
Learn how to setup your data so Pivot Table works correctly
-
Learn how to step up a Pivot Table to analyze your data
-
Understanding the 4 key areas of a Pivot Table
-
Learn how to modify your Pivot Table quickly and easily
-
And More…
Creating Macros in Excel
Automate your Excel Spreadsheet. With macros you can simplify those repetitive tasks and save tons of time.
-
Understand how Macros work and where/when to use them
-
Learn to record a macro to automate your work
-
Learn how to edit your macros
-
Learn how to create buttons and toolbars to run your macros
-
And More…