Course Syllabus

This advanced Excel course goes beyond the basics of Excel and explores the advanced features that make this the most popular spreadsheet program available today. Picking up where our Excel 2013 online course leaves off, this course delves into Excel's world of functions and formulas, teaching you how to use Excel to enter, manage, calculate and display any type of data.  

You will learn how to:

·     Use outlining in Excel

·     Create templates

·     Work with sparklines

·     Create and manage scenarios

·     Use Goal Seek and Solver

·     Create, manage, and format pivot tables and pivot charts

·     Use the Excel mathematical functions

·     Perform data lookups

·     Create and use IF statements

·     Use Excel's data functions

·     Create and use data validation rules

·     Apply custom and prebuilt conditional formatting

·     Work with functions to manipulate strings of text and data

·     Create and use macros

·     Troubleshoot and audit formulas

·     And more