Microsoft Excel Level 3 EXL-03

Clearly, you use Excel a lot in your role. Otherwise, you wouldn't be taking this course. By now, you're already familiar with Microsoft Excel 2019, its functions and formulas, a lot of the features and functionality, and its powerful data analysis tools. You are liked called upon to analyze and report on data frequently, work in collaboration with others to deliver actionable organizational intelligence, and keep and maintain workbooks for all manner of purposes. At this level of user and collaboration, you have also likely encountered your fair share of issues and challenges. You're too busy though, to waste time scouring over workbooks to resolve issues or to perform repetitive, monotonous tasks. You need to know how to get Excel to do more for you so you can focus on what's really important, staying ahead of the competition. That's exactly what this course aims to help you do.

This course builds upon the foundational and intermediate knowledge presented in the Excel 2019 Level 1 and Level 2 courses. to help you get the most of your Excel experience. The ability to collaborate with colleagues, automate complex or repetitive tasks, and use conditional tools to constructor and apply elaborate formulas and functions will put the full power of Excel right at your fingertips. The more you learn about how to get Excel to do the hard work for you, the more you'll be able to focus on getting the answers you need from the vast amounts of data your organization generates.

During this one-day, instructor-led course, students will explore advanced Excel concepts, including validating data and formula integrity, using formulas across files, work with text functions, use what-if scenarios, secure data use graphics in Excel, import and export Excel data. Students will also be introduced to the use of macros in automating processes

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.

Students should be familiar with basic and intermediate concepts of Microsoft Excel. This includes being able to build basic formulas and functions, charts, and pivot tables. Completion of the following courses or equivalent knowledge and skills is recommended: Microsoft Excel Level 1 Microsoft Excel Level 2