Why should I know Excel shortcuts and productivity hacks?
Welcome
0.1 Welcome to the course
0.2 How to make the most of this course
0.3 Practice workbooks
0.4 Excel Shortcut Guide + Dictionary
0.5 Shortcut Flashcards
1. Getting Started
1.1 File Command Shortcuts
1.2 Mighty COMMAND Shortcuts
1.3 Navigating Shortcuts
1.4 Selecting Data Essentials
1.5 Customizing Your Workbook
1.6 Workbook View Tools
2. Entering Data
2.1 Entering Data Shortcuts
2.2 Autofilling Data
2.3 Building Series
2.4 Flash Fill
2.5 Importing Data
3. Formatting
3.1 Cell Formatting Shortcuts
3.2 Number Formatting Shortcuts
3.3 Worksheet Formatting Shortcuts
3.4 AutoFitting Data
3.5 Edit Multiple Worksheets
4. Formulas & Functions
4.1 Formula Writing Essentials
4.2 Auditing Formula Shortcuts
4.3 Summing Data Tricks
4.4 Copying Formulas Effortlessly
5. Analyzing Data
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
6. More Fan Favorites
6.1 Data Types
6.2 REPT Charts
6.3 Sparklines
6.4 Fill Blank Cells
6.5 Delete Blank Rows
6.6 Scannable Barcodes
Meet Emma
Emma is the founder of Excel Dictionary, your ultimate source for impactful, digestible Excel tips and tricks. After graduating from The Ohio State University in 2019 with a degree in Actuarial Science, Emma began her professional career as an actuary, just in time for COVID to hit. New to the industry, new to the company, adjusting to a new WFH environment, and new to Excel, Emma quickly realized how overwhelming those Excel projects could be and didn’t know where to turn for help – so she taught herself.
Emma created Excel Dictionary to help others avoid Excel overwhelm and to be the coworker that you can turn to. She was recently awarded the Microsoft MVP award and has built a community of over 5 million people across the globe! Join her across all social channels to learn quick, actionable skills that will make you more efficient, comfortable, and confident in your daily work!
