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: 

  • Use Excel tables to manage any list
  • Easily find and remove duplicates
  • Find the right information using sorting, filtering, and slicers

This course applies to Microsoft Excel for PC and Mac.

What's Inside This Course

  • 1

    Excel Tables

    • 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

Meet Your Instructor

Vickie Sokol Evans

Microsoft Certified Trainer

Vickie Sokol Evans is a globally recognized digital productivity instructor and comedic speaker who trains the world's smartest people how to use their technology to get better results in less time. Her clients include: Microsoft, The Gates Foundation, Stanford University, The New York Times, Starbucks, Amazon, UK's Parliament, and most notably Bill Gates' team, among many others. A Microsoft Certified Trainer with 25+ certifications and over 20 years' training experience on PC and Mac platforms, Vickie is founder of The Red Cape Company headquartered in Austin, Texas.

Available exclusively to members of the RedCape Academy