With Excel Everest, you'll master the following business-critical skills: 

THE ESSENTIAL EXCEL BASICS

Cells and cell properties

• Number types

• Move and autofill cells

• Absolute vs. relative references

The power of paste special

• Paste options

• Transpose function

Basic to advance formatting

• Colors and borders

• Text options

• Formatting tables

• Conditional formatting

Sorting and auto-filters

• Sorting

• Auto-filters

Text to columns and find and replace

• Text to columns

• Find and replace

• Combing these functions

Manipulating rows and columns

• Adding, moving, and deleting rows

• Hiding and resizing

• Grouping

The drawing toolbar

• Grouping, ordering, and selecting objects

• Shapes, pictures, and object properties

PLAYING WITH FORMULAS

The critical business formulas

• Vlookup

• IF statements

Basic math formulas

• Sum, count, average

• Percentile, percent rank

• Rand & randbetween

Text formulas

• Quotes and ampersand

• Right, left, and trim

Statistical formulas

• Average, median, mode, max, min, correl, and stdev

ANSWERING QUESTIONS ABOUT NUMBERS

The basics that your boss will ask for

• Pivot tables

• Basic charting

• Chart formatting

TIPS AND TRICKS

Business tricks you'll love

• Making an email list

• Working with multiple tabs

• The F5 key

• Getting ride of duplicates

• Basic macros

• Printing from Excel

The joy of keyboard shortcuts

• Tab/enter & navigation

• Paste special

• Ctrl-Y and F4