Excel Tables
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:
- 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
-
Ratings and Reviews
Wealth of Knowledge
Michele Moline-Ashby
The wealth of knowledge that Vickie has is so impressive! I am not sure how she keeps up with it all but I am striving to be just like here ;>.
The wealth of knowledge that Vickie has is so impressive! I am not sure how she keeps up with it all but I am striving to be just like here ;>.
Read LessThis was AMAZING
Lindsay Ross
I knew about half of the information and the new tricks I learned will save me so much time!
I knew about half of the information and the new tricks I learned will save me so much time!
Read LessExcel Tables taught me so much!
Michelle Milligan, MOS
Vickie is great at teaching tips and tricks for all things Microsoft. This program was no different. I knew some, but learned more. Thank you Vickie and RedCape Academy.
Vickie is great at teaching tips and tricks for all things Microsoft. This program was no different. I knew some, but learned more. Thank you Vickie and RedCape Academy.
Read LessMeet 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.