Microsoft Excel: Picking a Learning Path

If you have looked at the Microsoft Excel courses in MicroAge Training’s course catalogue, you might be left scratching your head on which one will be the best fit for your learning goals. Have no fear! Let’s look at all our available Excel courses.

Excel Level 1

This course is an introduction to Microsoft Excel. This covers the absolute basics of Microsoft Excel. Students will learn how to get started with Excel, how to modify worksheets, how to use formulas and functions, formatting and viewing worksheets, and how to print workbooks. Students should come with basic computer skills, but no prior Excel experience is necessary. This is a great course for anyone who has limited experience with Excel or for those already comfortable using Excel but what to brush up on some basics they may have missed.

Excel Level 2

Level 2 is the next step up from the previous level. In this course, students will learn worksheet organization, advanced formulas, how to use multiple workbooks and worksheets, how to work with charts, and applying formatting. The prerequisite for Excel Level 2 is Excel Level 1 or equivalent knowledge. This course is a good fit for a student who knows the basics of Microsoft Excel and who needs to learn more complex functions.

Excel Levels 3 – Data List Management, Spreadsheet Analysis, and VBA Macros

Microsoft Excel course flow chart

This is where the learning path diverges for our Microsoft Excel courses. Microsoft Excel is a very powerful tool with many functions. To keep content manageable for students and to stay relevant to their needs, we have different level 3 courses that all recommend Excel Level 2 as a prerequisite. Let’s dive in!

Data List Management

Data, data, data, and more data! This course is all about managing data in Microsoft Excel. Students will learn how to maintain, sort, and filter data, how to summarize data, learn how to create and use PivotTables, PivotCharts, use Slicers, as well as how to implement data from an external source into Excel.

Spreadsheet Analysis

Spreadsheet Analysis touches on specific functions in Excel. For students who need to do what-if analysis using tools such as Goal Seek and Solver, learn financial functions in Excel and more, Spreadsheet Analysis is a good course to take.

VBA Macros

VBA stands for Visual Basic Application. If a student needs to code a custom function for Excel, this is the course to take. Students will learn mbasics, using the Visual Basic editor, VBA code, creating custom toolbars and macros, troubleshooting errors, accessing external data, and more. This course is considered more technical than the previous Excel Levels; so if you are questioning whether or not this course is for you, please reach out to the MicroAge Training team to schedule a consultation at no cost.

Excel Level 4: Advanced Tools for Data Analysis

The final Excel course available through MicroAge Training is Excel Level 4: Advanced Tools for Data Analysis. This course requires Excel Level 3: Data List Management or equivalent knowledge as a prerequisite as students should be very competent with creating and using PivotTables and PivotCharts to analyze data. This course focuses on two powerful data analytical tools, Power Query and Power Pivot. Power Query allows you to connect to and extract data from almost any source and automates the cleaning and transforming of data. Power Pivot permits the creation of sophisticated data models, linking data from multiple sources. Visual key performance indicators add to Power Pivot’s ability to enable analysts to focus more on data interpretation and strategic decision-making, ultimately maximizing their productivity and the value extracted from the data. Both tools are key components of other business analytical tools such as Power BI.

If you are still unsure of which learning path is right for you and your organization, MicroAge Training offers consultations at no cost. We want to work with you to achieve your learning goals!

To book a consultation, use the Contact Us form and leave your contact information along with relevant details.