Conquer Excel with Ease.
We’ve reinvented Excel training with a course that brings you through 41+ business-critical topics and 160+ interactive, auto-graded exercises.
How It Works
Whether you work in Sales, HR, Marketing, or Finance, a proficiency in Excel is needed to further your career. Our innovative course takes you through 41+ business-critical topics and 160+ interactive, auto-graded exercises.
Ready to try the Excel training course trusted by the top brands in the indusrty?
What You’ll Learn
Based on years of deep experience and expertise, our team has narrowed down the primary topic areas you need to know for your company to be successful with Excel.
- The Essential Excel Basics
- Playing With Formulas
- Exploring Data
- Tips and Tricks
Cells and their properties
- Number types
- Move and autofill cells
- Absolute vs. relative references
The power of paste special
- Paste options
- The transpose functions
Basic to advanced formatting
- Colors and borders
- Text formatting
- Formatting tables
- Conditional formatting
Text to columns and find and replace
- Text to columns
- Find and replace
- Combining both functions
Manipulating rows and columns
- Adding, moving, and deleting
- Hiding and resizing
- Grouping
The drawing toolbar
- Grouping, ordering, and selecting tables
- Shapes, pictures, and object properties
Sorting auto-filters
- Sorting
- Auto-filters
Vlookup
- Vlookup basics
- Mistakes and errors
Statistical formulas
- Average, median, and mode
- Min and max
- Correl and Stdev
If Statement
- IF statement basics
- Key use cases
Basic math formulas
- Sum, Count, and Average
- Percentile, Percent Bank
- Rand and RandBetween
Text Formulas
- Quotes and ampersands
- Right, left, and trim
Pivot tables
- Pivot basics
- Key use cases
- Interpreting data with Pivots
Charts
- Building charts
- Formatting charts
- Data visualization
Email lists, Tabs and F5
- Making an email list
- Working with tabs
- The F5 key
Printing from Excel
- Printing basics
- Avoiding frustrations
Getting rid of duplicates
- Identifying duplicates
- Eliminating duplicates
The joy of keyboard shortcuts
- Tab / Enter and navigation
- Paste Special
- Ctrl-Y and F4
Basic Macros
- Simple macros
- How to approach complex macros
Who Is Excel Everest For?
Whether you work in Sales, HR, Marketing, or Finance, a proficiency in Excel is needed to further your career. Our innovative course takes you through 41+ business-critical topics and 160+ interactive, auto-graded exercises.
Inside the Excel course, you’ll find hundreds of embedded exercises categorized as Easy, Medium, or Hard. You'll work through our specially designed course directly in Excel and learn through practicing the skills right there in the course, saving your progress as you go. We'll help you identify common errors and pitfalls.
