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.

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 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.

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 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.

Ready to turbo-charge your Microsoft Excel skills and advance your data analysis capabilities? In this half-day course, the first of a 2-part series (followed by "Excel: Power Pivot"), this course will help you gain a better overall understanding of data analysis and how to take advantage of more advanced features of Excel's PivotTables (PTs) and PivotCharts, to analyze data from a variety of sources and then present meaningful data with maximum clarity and effectiveness, to improve business decisions. Topics covered include: preparing raw data, creating PTs from multiple sources, summarizing, organizing, filtering and formatting PTs, followed by creating, manipulating and formatting PivotCharts. Books are provided, along with in-person computer lab activities. As this course builds upon and extends numerous Excel concepts, it is strongly recommended to have completed Excel levels: 1, 2, 3 courses as prerequisites, although they are not mandatory for enrollment in this course. This course and its Part 2 companion: "Excel: Power Pivot," collectively qualify as "Excel 4: Data Analysis."

Do you enjoy the incredible data manipulation of Excel PivotTables? Ready to power-up and perform more impressive analyses on larger data sets? This half-day course, the second of a 2-part series (preceded by "Excel: PivotTables"), will teach you how to use Excel's powerful Power Pivot add-in, to grant access to an extensive set of data processing, rearranging and summarizing features, including the Power Pivot Data Model. Topics covered include: navigating Power Pivot, managing data relationships for creating Power Pivot reports, creating calculated fields, columns, KPIs, using CUBE functions and also DAX date and time functions. Books are provided, along with in-person computer lab activities. This course is the second of a 2-part series, so prior successful completion of "Excel: PivotTables" is required. As this course builds upon and extends numerous Excel concepts, it is also strongly recommended to have completed Excel levels: 1, 2, 3 courses as prerequisites, although they are not required for enrollment in this course. This course along with its Part 1 companion: "Excel: PivotTables," collectively qualify as "Excel 4: Data Analysis."