Module 1 - Students will learn to work with Excel's most common lookup functions VLOOKUP, HLOOKUP, INDEX, and MATCH. Students will learn to use VLOOKUP to compare two lists and combine INDEX and MATCH for more complex lookups. Intellezy Spotlight courses are designed to offer students instruction on focused areas of interest in lieu of the more comprehensive training available in our complete courses.
Module 2 - Students will learn to use Excel's powerful PivotTable and PivotChart features. Students will create PivotTables and PivotCharts using the wizard, work with the Fields pane, and format PivotTables. They will also learn how to organize data for the best results when using PivotTables.
Module 3 - Students will learn to use Excel's advanced IF statements. Students will summarize data with SUMIF, AVERAGEIF, and COUNTIF, created nested IF statements, and use the IFERROR function to handle errors.
Training 2 or more people?
Get your team access to 2,543 top CPD On Demand courses anytime, anywhere.