Microsoft Excel Level 1

In this Introduction to Microsoft Excel training class, students will create and edit basic worksheets and workbooks. This course is designed for students who want to gain the necessary skills to create, edit, format, and print basic Microsoft Excel worksheets. Our instructor-led online classes are conducted in the 2013 version of the software. Your instructor will point out the minor differences between versions where they exist. For our custom instructor-led online and onsite classes, we use the version of the software you use in your office.

Create a basic worksheet by entering text, values, and formulas, Change the appearance of worksheet data by using a variety of formatting techniques, Create formulas by using some of Excel's built-in functions, Filter and sort Excel data, Plan, create and modify charts., Prepare a document for printing by using a variety of printing options.

Microsoft Excel Level 2

This Intermediate Microsoft Excel training class is meant for students who want to advance their skill set by learning to work with advanced formulas, lists, and illustrations. Students will also work with charts and advanced formatting including styles. Our instructor-led online classes are conducted in the 2013 version of the software. Your instructor will point out the minor differences between versions where they exist. For our custom instructor-led online and onsite classes, we use the version of the software you use in your office..

Use workbooks as templates for other workbooks. Manipulate worksheet data. Use intermediate data management tools such as filters and advanced filters Summarize data that meets specific conditions. Link to data in other worksheets and workbooks. Locate and use some of the more complex Excel functions. • Create and modify charts.

Microsoft Excel Level 3 Advanced training

This is not an introductory course, is designed for Excel users who already have skills in Excel level 1 and 2, the materials presented assume this knowledge. This course requires logical thinking and analysis of raw data given.

Understand Excel logical functions Use Lookup functions Use advanced list management functions Manipulate data using PivotTables and Pivot Charts Use ‘What-If Analysis tools Create macros for perform repetitive tasks

Microsoft Excel Level 4 Advanced training

This is not an introductory course. This is a continuation of Excel Level 3 Part 2 and is designed for Excel users who already have skills in Excel level 1, 2 and level 3 Part 1, the materials presented assume this knowledge. This course requires logical thinking and analysis of raw data given. Some VB coding will be covered in this course.

Understand Excel logical functions Use Lookup functions Use advanced list management functions Manipulate data using PivotTables and Pivot Charts Use ‘What-If Analysis tools Create macros for perform repetitive tasks Create and edit macros in VB to perform complex repetitive tasks

Microsoft Excel Level 3 Assignments

Microsoft Excel Level 3 Assignments

Microsoft Excel Basic Tutorial

Microsoft Excel Advanced Tutorial

Microsoft Excel Assessment Tests