Microsoft Excel Level 2

About this class

Whether you need to crunch numbers for sales, inventory, information technology, human resources, or other organizational purposes and departments, the ability to get the right information to the right people at the right time can create a powerful competitive advantage. After all, the world runs on data more than ever before and that’s a trend not likely to hange, or even slow down, any time soon. But with so much data available and being created on a nearly constant basis, the ability to make sense of the data becomes more critical and challenging with every passing day. You already know how to get Microsoft Excel to perform simple calculations and how to modify your workbooks and worksheets to make them easier to read, interpret, and present to others. But, Excel is capable of doing so much more. To gain a truly competitive edge, you need to be able to extract actionable, organization intelligence from your raw data. In other words, when you have questions about your data, you need to know how to get Excel to provide the answers for you. And that’s exactly what this course aims to help you do. During this one-day, instructor-led course, students will learn how to perform advanced calculations; use advanced functions, including IF and VLookup; use sort and filter options; create Excel tables; create Excel templates and themes; create pivot tables and pivot charts; create and modify charts; and use Excel Sparklines

Features and functions in Office 365 and Office 2019 / 2016 are nearly identical. For this reason, users for all three versions (365, 2019 and 2016) attend the same class. The instructor will explain the few visual differences in the versions to you; just let the instructor know what version you are using.

Before you attend

Completion of the following course or equivalent knowledge and skills is recommended:
-Microsoft Excel Level 1