Intermediate Microsoft Excel Training (EXC365.2)

This Intermediate Microsoft Excel course is designed for professionals who already have a basic understanding of Excel and are looking to enhance their skills to make the most out of this powerful tool. Ideal for employees seeking to improve productivity and efficiency, the course covers a wide range of functions and techniques to take your Excel capabilities to the next level.

We start with lessons on Common Functions, providing you with a solid foundation in using named ranges in formulas and working with data across multiple worksheets. You’ll practice using essential functions like IF, AND, OR, NOT, and SWITCH. Additionally, we cover functions such as COUNTIF, AVERAGEIF, and SUMIF, along with financial functions like PMT and NPER. You will also explore text functions, including the versatile TEXTJOIN function, and various date and time functions, with hands-on exercises to hone your skills.

Next, we’ll explore Working with Lists. In this section, you’ll learn what constitutes a list of data, and how to efficiently manage it. Topics include removing duplicates, sorting, and filtering data. You will also add subtotals to lists, with accompanying exercises to reinforce these techniques.

The course continues with Visualizing Your Data. This section covers the basics of chart creation and provides tools for editing charts. You’ll learn how to use the Chart Design Tool Tab, the Format Tool Tab, and the Format Task Pane. We introduce a variety of chart types, including line and area charts, hierarchy charts, statistic charts, and combo charts. You’ll work on sparklines, learning how to insert and customize them, and gain proficiency in adding and formatting objects, working with shapes, icons, and SmartArt. The Quick Analysis Tool is also featured to help make data visualization more accessible.

In Working with Tables, you’ll discover how to format data efficiently as a table, using the Table Design Tool Tab and formatting individual cells. You’ll learn how to select table rows and columns, create and modify tables in Excel, and utilize structured references. Converting tables to ranges is also included, ensuring you can manage and present your data effectively.

We’ll then cover Advanced Formatting. This section covers a variety of advanced formatting options to make your spreadsheets more effective and visually appealing. You’ll explore cell styles and engage in exercises to apply what you've learned. The segment on conditional formatting includes creating and managing rules, such as highlighting cells based on criteria, top/bottom rules, data bars, color scales, and icon sets. You’ll also learn how to remove conditional formatting when necessary, with exercises to practice these skills.

By the end of this course, you’ll be. able to manage complex data sets, create detailed visualizations, and apply advanced formatting. Whether you’re training a team or upskilling individually, this course will significantly enhance your productivity and efficiency in using Microsoft Excel.

Excel Version: This course primarily targets Excel 365 and Excel 2021; however, we draw attention to features that are not supported in earlier versions of Excel, and point out alternative options, when available.