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
CONCAT. Then, you will learn to manipulate data in lists by sorting, filtering, adding subtotals, and more. You will learn to create engaging and insightful reports by visualizing your data using charts and sparklines. The class wraps up with important lessons on tables and advanced formatting, including conditional formatting, styles, and custom templates.
Excel Version: This course primarily targets Excel 365 and Excel 2021; however, we draw attention to features that are not supported in earlier versions of Excel, and point out alternative options, when available.