The feature every Excel user should know
Frustrated with the amount of time you spend fixing and formatting data in Excel? Ashamed of how your spreadsheet looks and behaves?
Discover the true power of Excel to make your life incredibly easier when managing and tracking data. Whether you are working with employee data, sales transactions, event lists, expenses, or job candidates, you want to ensure that the information is accurate and easy to consume. After all, if anyone spots a mistake in your spreadsheet, nothing else can be trusted.
Learn how to effectively manage information to get the best results in less time. You’ll work smarter and faster than ever before and improve the integrity and confidence in your reporting!
In this session, you will learn how to:
This course applies to Microsoft Excel for PC and Mac.
Introduction and Files
Lesson 1: Format a List as a Table
Lesson 2: Expand the Table as You Type
Lesson 3: Create a Calculated Column
Lesson 4: Add a Total Row
Lesson 5: Using Slicers
Lesson 6: Move Columns and Find Duplicates
Lesson 7: Pivot Tables