This course covers naming a range, specialprinting titles of rows & columns, paste between work-sheets, pasting values and links, viewing and workingwith multiple work-sheets, 3D formulas,  protecting a workbook \ worksheet, & cells, checking for duplicates, Excel as a database, autofilters, slicers,and creating a graph with two axis.

Excel Level 2 is a continuation of Level 1, participants should have those skills before taking Excel Level 2. Course objectives are how to work with multiple files and worksheets, naming a range and benefits, sorting and filtering data using Excel as a database, tables and their benefits, data validation, sub-totals, Pivot Tables, conditional formatting, graphs with two axis and sparklines.

This course covers naming a range, specialprinting titles of rows & columns, paste between work-sheets, pasting values and links, viewing and workingwith multiple work-sheets, 3D formulas,  protecting a workbook \ worksheet, & cells, checking for duplicates, Excel as a database, autofilters, slicers,and creating a graph with two axis.

Excel Level 2 is a continuation of Level 1, participants should have those skills before taking Excel Level 2. Course objectives are how to work with multiple files and worksheets, naming a range and benefits, sorting and filtering data using Excel as a database, tables and their benefits, data validation, sub-totals, Pivot Tables, conditional formatting, graphs with two axis and sparklines.

This course provides advanced tools for solving real-world problems in Microsoft Excel 2019: lookup and decision-making functions, auditing and error-handling, array functions, date and text functions, importing and exporting, what-if-analysis, and macros.

Excel Level 3 is a continuation of Level 2, participants should have those skills before taking Excel Level 3. Course objectives are If Statements, Lookup Functions, Date and Text Functions, What-If Analysis, Exporting, Importing using Power Pivot, Simple Macros and Form Tools.

This course provides advanced tools for solving real-world problems in Microsoft Excel 2019: lookup and decision-making functions, auditing and error-handling, array functions, date and text functions, importing and exporting, what-if-analysis, and macros.

Excel Level 3 is a continuation of Level 2, participants should have those skills before taking Excel Level 3. Course objectives are If Statements, Lookup Functions, Date and Text Functions, What-If Analysis, Exporting, Importing using Power Pivot, Simple Macros and Form Tools.

This comprehensive 6-hour course will teach you how to summarize data using these powerful Excel tools, enabling you to create summary reports and charts. With Power Query and Power Pivot, you'll learn to import data from multiple sources, manipulate it, and then review the consolidated data in a pivot table using multiple tables.

This class is a perfect for those who having been using Excel for years but don't know how to use these advanced features for data visualization and analysis.