10 Things You May Not Know About Excel – But You Should.

Course Curriculum

Chapter 1: Work FASTER and Avoid ERRORS at the Same Time

Lecture 1: 10 Things You May Not Know About Excel – But You Should!

Lecture 2: Autofill Feature – You Think You Know it, But There is More to it!

Lecture 3: Use Cell and Range Names to Simplify Creating Formulas

Lecture 4: Add Range Names

Lecture 5: Edit and Delete Range Names

Lecture 6: Use Range Names in Formulas

Lecture 7: Watch Formulas That Are Not on the Same Screen and See What Happens!

Lecture 8: How to Verify That Your Complex Formulas Work Properly

Lecture 9: Customize Formula Options to Specify How Formulas Are Calculated and More

Chapter 2: Customize the Ribbon and Quick Access Toolbar

Lecture 1: Save Clicks by Placing Your Most Often Used Commands in the Quick Access Toolbar

Lecture 2: Customize the Ribbon to Your Needs

Chapter 3: Make your Workbooks Look Great

Lecture 1: Apply Cell Styles Instead of Formatting Each Cell on its Own

Lecture 2: Understanding Sparklines Will Add Value to Your Data When Used Wisely!

Chapter 4: Sharing Workbooks is Much More Than Sending an Email with an Attachment

Lecture 1: You Use Spell Check in Word – Start Using it in Excel as Well

Lecture 2: Add Comments to Guide Others Through Your Workbook

Lecture 3: Merge Workbooks From Team Members When You Can!

Lecture 4: Consolidate Data from Multiple Workbooks to Improve Workflow

Lecture 5: Use Trust Center to Avoid Messages Like, "Do you trust this workbook?"

Chapter 5: Useful Functions We do Not See Often Enough!

Lecture 1: Automate Data Analyzation with Logical Functions

Lecture 2: Counting Made Easy – Count(), Counta() and Countif()

Lecture 3: This is Tricky But Cool! HLookup/VLookup Helps you Find Data Based on Criteria

Lecture 4: Text Manipulations with Concatenate and &

Chapter 6: Manage Large and Multiple Workbooks Without Getting Lost

Lecture 1: Managing Large Workbooks – Now Hassle Free!

Lecture 2: Format Worksheet Tabs – Red for Input Sheets, Blue for Output/Reports, or ….?

Lecture 3: Manage Worksheets with Ease

Lecture 4: Perfect the View of Worksheets to Make Managing Larger Workbooks Easier!

Lecture 5: How to Work with Multiple Workbooks

Chapter 7: The Advantages of Organizing Data in a Table. Yes, a Table Within Excel!

Lecture 1: The Basics First: Create and Modify Tables

Lecture 2: Sort Data in Tables – One of the Advantages of Working with Tables in Excel

Lecture 3: Filter Data with the Auto Filter – It's as Easy as 1-2-3 in Excel!

Lecture 4: Filter Data with the Advanced Filter – Only Possible with Tables in Excel

Lecture 5: The "Total Row" Helps you Calculate the SUM, Average, and Count with One Click!

Lecture 6: Section Summary

Chapter 8: Remove Duplicates

Lecture 1: Every Large Data Collection Has Duplicates – Learn How to Remove Them

Chapter 9: Pivot Tables – Analyze your Data Like Never Before!

Lecture 1: Analyzing Data with Pivot Tables

Lecture 2: Create a Pivot Table – Take the First Steps

Lecture 3: Advanced Field Settings – Make Your Pivot Table More Readable

Lecture 4: Slicers – Make Filtering Easy for Everyone!

Lecture 5: Analyzing Data by Using a Pivot Chart – Adds a New Perspective to the Data

Lecture 6: Section Summary

Chapter 10: Automatically Update Data From the Web Like Exchange Rates, Stocks and More

Lecture 1: Create a Web Query