Intermediate Excel Course

In this training, you will discover how to make data usable for better decision making. You will learn by doing, for example, how to use data from different tables and worksheets, get the data ready for reports using tools featured in Microsoft Excel, and protect the worksheet using validation and permissions. Upon completion of this training, you will have developed the skills necessary to create a transformed dataset to develop informative dashboards or perform critical analyses. What You Will Learn: Calculating with advanced formulas (Concatenate, Left, Right) Creating and Enhancing Pivot tables (Slicers) Customizing and enhancing workbooks (Conditional formatting) Working with data from different tables and spreadsheets (VLookup, Match) Data Validation (Restrictions of cells) Data Analysis tools (SumIf, CountIf)