# 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.

### Accountable & Verifyable Training

Personal or corporate goal setting and tracking for exercise completion through built-in scoreboard.

### Interactive Learning That Sticks

Classes can be expensive, and content from videos is easily forgotten. Interactive lessons engage learner and develop a deeper understanding of the content that will stick.

### Focused on What Matters

Critical business decisions are often made from information completed in Excel. Avoid costly errors through skill development in the areas that matter most.

View the Journey

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

• 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

• Hiding and resizing
• Grouping

### The drawing toolbar

• Grouping, ordering, and selecting tables
• Shapes, pictures, and object properties

• 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.