Excel Dictionary Courses

Welcome to Excel Dictionary's Shortcut & Productivity Hacks Course!

How to make the most of this course

Practice Workbooks

Excel Shortcut Guide + Dictionary

Shortcut Flashcards

Intro

1.1. File Command Shortcuts

1.2. Mighty CTRL Shortcuts

1.3 Navigating Shortcuts

1.4. Selecting Data Essentials

1.5. Create Your Own Shortcuts

1.6. Workbook View Tools

Module 1 Quiz

Module 2 Intro

2.1. Entering Data Shortcuts

2.2. Autofilling Data

2.3. Building Series

2.4. Flash Fill

2.5. Importing Data

Module 2 Quiz

Module 3 Intro

3.1. Cell Formatting Shortcuts

3.2. Number Formatting Shortcuts

3.3. Worksheet Formatting Shortcuts

3.4. Autoformatting Data

3.5. Edit Multiple Worksheets

Module 3 Quiz

Module 4 Intro

4.1. Formula Writing Essentials

4.2. Auditing Formula Shortcuts

4.3. Summing Data Tricks

4.4. Copying Formulas Effortlessly

Module 4 Quiz

Module 5 Intro

5.1. Analyzing Data Shortcuts

5.2. The Excel Underdog: Tables

5.3. Letting Excel Analyze Data

5.4. Find Tips

5.5. Find & Replace Tips

Module 5 Quiz