In this Intermediate Microsoft Excel class, you will use powerful tools and features to manage and analyze your data. Packed with tips and tricks, you will quickly gain Excel power-user skills to help you work effectively. The class starts with popular formulas and functions like VLOOKUP, SUMIF, and CONCAT. Then, you will learn to manipulate data in lists by sorting, filtering, adding subtotals, and more. You will learn create engaging and insightful reports by visualizing your data using charts and then adding shapes, images and logos. The class wraps up with important lessons on tables and advanced formatting, including conditional formatting, styles, and custom templates.
This popular course is approved by Microsoft and resold to Microsoft Partners worldwide as course number MS-55269-A.
Target Audience: Students who have basic Excel skills and are ready for intermediate Excel concepts. This class is for users of Excel 2019 or Excel 365 on Windows. (Users of Excel 2016 and Excel 2013 can attend the class and may notice some differences in their version of the software.)