Excel - Level 1 teaches the basic concepts and skills needed for you to start being productive with Microsoft Excel, and it’s a strong start on the journey towards becoming an Excel Expert. We’ll cover how to create and format worksheets that contain calculations with formulas and functions, including how to use proper reference types. Moving and copying data correctly, basic chart creation and various other tips and tricks are also covered. Books are provided, along with classroom hands-on-keyboard activities. For students who might be considering the optional Microsoft Office Specialist Excel Associate and Expert exams, this course along with Excel 2 and Excel 3, map to the objectives of both exams.

Excel - Level 2 is a continuation of the journey into an Excel Expert. We’ll cover more advanced tools for analysis, rearrangement, and presentation of more complex, yet realistic data. We’ll also delve into managing workbooks with more elaborate functions, ranges, tables, validation and summarizing tools like consolidation and subtotaling. The very popular and powerful feature of PivotTables and conditional formatting, along with more advanced charts will be taught. Books are provided, along with classroom hands-on-keyboard activities. For students who might consider the optional Microsoft Office Specialist Excel Associate and Expert exams, this course along with Excel 1 and Excel 3, map to the objectives of both exams. Excel 1 is strongly recommended prior to taking this class, but it is not required.

Excel - Level 3 will build upon the skills learned in Levels 1 and 2, and we’ll cover some of Excel’s most powerful and advanced tools for data analysis and presentation. Logical and lookup functions, more advanced formulas, arrays, auditing, error-trapping, and the much beloved and useful date, time, text and other functions will be explored. Importing from other non-Excel data sources using Power Pivot, exporting data, exploration of What-If Analysis and finally, automating repetitive tasks with Macros are also covered in this class. These are all skills that elevate a student into an Excel Power User. Books are provided, along with classroom hands-on-keyboard activities. For students who might consider the optional Microsoft Office Specialist Excel Associate and Expert exams, this course along with Excel 1 and Excel 2, map to the objectives of both exams. Excel 1 and 2 are strongly recommended prior to taking this class, but they are not required.

Are you seeking to advance your data analysis capabilities? This class will help you gain a better overall understanding of data analysis through tools such as PivotTables, PivotCharts and Power Pivot. You’ll learn how to analyze data from a variety of sources, then organize, cleanse, manipulate and report that data with maximum insight and effectiveness, which can help improve business decisions. Books are provided, along with classroom hands-on activities. It is strongly recommended that students have some degree of Excel proficiency or prior registration in Excel Levels 1, 2 and 3 before taking this class, as this class qualifies as “Excel 4.”