Module 1: The Basics of Excel
This is the very first module, which serves as an introduction to the basics of Excel. We'll lay a little bit of a foundation here to make sure that we're all on the same page going forward.
Lessons:
- How Excel Is Laid Out
- Getting Around
- Files and Programs
Module 2: Formatting
No matter how hard you actually work, if your final product looks ridiculous or is poorly formatted, it will reflect poorly on you. Like every other topic in this course, we are going to cover the formatting that you actually need to know, the stuff that will make your job easier.
Lessons:
- Learning the Controls
- Learning the Controls: Redux
- Number Formatting
- Format Painter
- Paste Special
- Odds and Ends
- Printing
Module 3: Formulas
The bulk of Excel's power lies in its formulas and functions. You could study for years and still not know every formula Excel has to offer. Luckily for you, we're going to show you the important ones.
Lessons:
- Introduction to Formulas
- Summary Formulas
- Text Formulas
- Boolean Algebra
- Time Formulas
- Errors
Module 4: Data and Analysis
Making sense of large amounts of data is going to be crucial to doing your job well. In this module we are going to cover several different ways to analyze your data.
Lessons:
- Filtering and Sorting
- Introduction to Charts
- Pivot Tables
- Analysis Functions
Module 5: Tips and Tricks
If you thought the previous modules sounded fun, you're going to be downright delighted by this one! There are a couple of Excel features that aren't generally taught that are just inordinately helpful to know.
Lessons:
- Remove Duplicates
- Quick Sum
- Text to Columns
- Transpose
- Find Hardcoded Numbers