Microsoft Excel – Excel from Beginner to Advanced

At completion of this course you will have mastered the most popular Excel tools and come out with confidence to complete any Excel tasks with efficiency and grace. Below are just a few of the topics that you will master:

Creating effective spreadsheets

Managing large sets of data

Mastering the use of some of Excel’s most popular and highly sought after functions (SUM, VLOOKUP, IF, AVERAGE, INDEX/MATCH and many more…)

Create dynamic report with Excel PivotTables

Unlock the power and versatility of Microsoft Excel’s Add-In, PowerPivot

Audit Excel Worksheet formulas to ensure clean formulas

Automate your day to day Excel tasks by mastering the power of Macros and VBA

Microsoft Excel 101 Course Introduction
Microsoft Excel Fundamentals
Entering and Editing Text and Formulas
Working with Basic Excel Functions
Modifying an Excel Worksheet
Formatting Data in an Excel Worksheet
Inserting Images and Shapes into an Excel Worksheet
Creating Basic Charts in Excel
Printing an Excel Worksheet
Working with Excel Templates
Excel 101 – Practice What You’ve Learned (DOWNLOAD)
Congratulations! You’ve Built a Solid Microsoft Excel Foundation

Microsoft Excel 102 Course Introduction
Working with an Excel List
Excel List Functions
Excel Data Validation
Importing and Exporting Data
Excel PivotTables
Working with Excel’s PowerPivot Tools
Working with Large Sets of Excel Data
Excel 102 Additional Practice Exercises
Congratulations! You’re an Intermediate Excel User

Microsoft Excel 103 Course Introduction
Working with Excel’s Conditional Functions
Working with Excel’s Lookup Functions
Working with Excel’s Text Based Functions
Auditing an Excel Worksheet
Protecting Excel Worksheets and Workbooks
Mastering Excel’s “What If?” Tools
Mastering Excel’s “What If?” Tools
Automating Repetitive Tasks in Excel with Macros
Excel 103 Additional Practice Exercises
Congratulations!

Microsoft Excel Macros and VBA Course Introduction
Project #1: Using Excel’s Macro Recorder Tool
Excel VBA Concepts
Working with Excel VBA Logic Statements
Project #2: Moving Beyond the Basics and into VBA
Project #3: Preparing and Cleaning Up Data with Excel VBA
Project #4: Using VBA to Automate Excel Formulas
Project #5: Bringing it All Together and a Weekly Report
Project #6: Working with Excel VBA User Forms
Project #7: Importing Data from Text Files
Course Wrap Up