Excel Level 3 reaches new heights in a student's journey towards Excel Expert, building upon skills learned in Levels 1 and 2, and teaching about some of Excel's most powerful and advanced tools for data analysis and presentation. This course covers logical and lookup functions, more advanced formulas, arrays, auditing, error-trapping, and the much beloved and useful date, time, text and other functions. 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 course. 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. Although Excel 1 and 2 are strongly recommended in order to better understand more advanced concepts taught in Excel 3, it is not a requirement for this course.

This class covers essential skills related to the latest version of Intuit's popular online bookkeeping program. Topics covered include customizing company-level settings, setting up customers, dealing with bank deposits, bank feeds, and reconciliation processes for bank and credit card accounts.

Excel Level 1 teaches basic concepts and skills to start being productive with Microsoft Excel and is a strong start on a journey towards becoming an Excel Expert. It covers how to create and format worksheets that contain calculations with formulas and functions, including using 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 consider 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.

This class covers essential skills related to the latest version of Intuit's popular online bookkeeping program. Topics covered include customizing company-level settings, setting up customers, dealing with bank deposits, bank feeds, and reconciliation processes for bank and credit card accounts.

Excel Level 2 continues the journey of transformation into an Excel Expert, teaching to use more advanced tools for analysis, rearrangement and presentation of more complex, yet realistic data. This course covers 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 also conditional formatting are taught, along with more advanced charts. 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. Although Excel 1 is strongly recommended for foundational concepts, it is not a requirement for Excel 2.

Excel Level 1 teaches basic concepts and skills to start being productive with Microsoft Excel and is a strong start on a journey towards becoming an Excel Expert. It covers how to create and format worksheets that contain calculations with formulas and functions, including using 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 consider 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 3 reaches new heights in a student's journey towards Excel Expert, building upon skills learned in Levels 1 and 2, and teaching about some of Excel's most powerful and advanced tools for data analysis and presentation. This course covers logical and lookup functions, more advanced formulas, arrays, auditing, error-trapping, and the much beloved and useful date, time, text and other functions. 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 course. 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. Although Excel 1 and 2 are strongly recommended in order to better understand more advanced concepts taught in Excel 3, it is not a requirement for this course.

Are you seeking to advance your data analysis capabilities? This course will help you gain a better overall understanding of data analysis, in particular by using tools such as Excel's PivotTables, PivotCharts and Power Pivot, to analyze data from a variety of sources, then organize, cleanse, manipulate and report that data with maximum insight and effectiveness, to improve business decisions. Books are provided, along with classroom hands-on activities. It is not mandatory, but strongly recommended that students already have some degree of Excel proficiency or have taken Excel Levels 1, 2 and 3, as this course qualifies as "Excel 4."