This course teaches advanced Microsoft Excel features and functions, including VLOOKUP, HLOOKUP, consolidation, 3-D references, data validation, protecting worksheets and workbooks, macros, Sparklines, mapping, What-If analysis (data tables, scenarios, Goal Seek), and forecasting data trends.

This course is designed for students and professionals who already have intermediate Excel knowledge and want to become experts. You should already know how to create, edit, format, and print worksheets, use basic formulas, and understand intermediate functions.

You will learn to:

• Use links, external references, and 3-D references
• Consolidate data from multiple sources
• Use lookup functions (VLOOKUP, HLOOKUP)
• Trace cells, watch, and evaluate formulas
• Collaborate on workbooks and protect worksheets and workbooks
• Apply data validation and search for invalid data and formula errors
• Work with macros
• Create Sparklines and map data
• Determine potential outcomes using data tables, scenarios, and Goal Seek
• Forecast data trends

Yes. You will learn lookup functions, 3-D references, and advanced formula evaluation techniques, including tracing cells and watching formulas.

Yes. The course covers consolidating data, using data tables, scenarios, and Goal Seek for What-If analysis, and forecasting data trends.

Yes. You will learn to protect worksheets and workbooks, apply data validation, and search for invalid data and formulas with errors.

Yes. The course includes working with macros to automate tasks in Excel.

Yes. You will learn to create Sparklines and map data for advanced data visualization.

You should have intermediate Excel knowledge, including how to create, edit, format, and print worksheets, use basic formulas, and understand intermediate functions.

You can register through the enrollment process on the course page. Course schedules and registration details are provided online.

Learners are encouraged to review the course requirements and prerequisites provided on the course page before registration. Intermediate Excel knowledge is required.