Excel Level 1 is a one-day instructor led class providing the basic concepts and skills needed to be productive and efficient in Microsoft Excel. By the end of the class, participants will be able to create and edit worksheets and workbooks, perform basic formulas and functions, and understand how to format, manipulate, print, and protect their data.
The Excel Level 2 class provides training in intermediate-level features and tools within Microsoft Excel to organize and analyze data. Upon successful completion of the class, students will be able to perform an array of common tasks more confidently and efficiently, such as working with named ranges, tables, advanced formats, and charts.
Excel Level 3 is a one-day instructor led class that will take participants to an advanced level using formulas and functions in Microsoft Excel. By the end of the class, participants will be able to manipulate large data sets more quickly and easily using a variety of advanced functions and formulas. Participants will also be able to summarize data efficiently using the consolidate and subtotals features.
Excel Level 4 is a one-day instructor led class building upon the Level 3 course. The training continues with additional advanced features, macros, and data visualization features in Microsoft Excel. Upon successful completion of this class, participants will be able to use macros to automate repetitive tasks; what-if analysis to identify data solutions; validation to ensure the data in your workbook is appropriate; build lists; and use Quick Analysis features.
Excel Pivot Tables is a one-day instructor led class covering Pivot Tables, a powerful feature in Microsoft Excel which enables data manipulation with simple dragging and dropping. At the end of this class, participants will be able to sort, filter, group, summarize, and format data with ease and efficiency using Pivot Tables.
Excel Power Pivot is a one-day instructor led course covering the Excel add-in you can use to perform powerful data analysis and create sophisticated data models. With Power Pivot, you can combine large volumes of data from various sources, perform information analysis rapidly, and share insights easily.
VBA Coding is a two-day instructor-led advanced Excel class that teaches participants how to take complex and time-consuming tasks and automate them with code. You will learn how to use the macro recorder effectively, as well as how to write your own VBA code from scratch. You will use tools built into Excel to explore and learn VBA’s capabilities and to optimize and debug your code. As far as coding languages go, VBA is one of the easier languages to learn.