Back To Shop

Excel Everest: Free Demo Course

Excel Everest is an entirely different way to learn Excel. No, really. The whole Excel Everest experience takes place inside a giant interactive Excel workbook (called Excel Everest) that brings users step-by-step through 41+ business-critical topics, 160+ interactive, auto-graded exercises, and there's a scoreboard to measure progress along the way.

If you'd like to give it a try ahead of purchasing the real course, test out our demos through this free course!

Who is Excel Everest for?

Your orgnization or employees may be a fit for Excel Everest if:

You need a comprehensive Excel training that covers all the essential business Excel skills, and with unlimited access and upgrades.
You need a training that covers all of your versioning needs, on both Mac & PC, including for Excel 2003, 2007, 2010, 2011, 2013, 2016
You realize that the best way to learn a complicated program like Excel is not by watching videos, but by going through exercises right there in an Excel document.
You'd like to use the same Excel training for your organization that companies like Google and Eventbrite use for their employees.
You want accountability, and a way to measure not if someone has watched a video, but if someone has completed the skill right there in Excel.

What is the concept behind Excel Everest?

The entire concept behind Excel Everest is that you can learn by doing. As you go through this course, you'll be guided on how to download the Excel Everest workbook. When you open it up, you'll see an index page with a set of 21 buttons that link you to the various areas of the workbook. And in each topic area, you'll:

Learn why a specific concept is important, especially for being successful in a corporation
Grasp the details on the topic through written explanations
Go through a set of interactive Excersies that are categorized according to difficulty (easy, medium, and hard)

Best of all, as you complete these exercises, they're graded, so you can easily keep track of your progress through the course, see which topics you've made the most progress on, and earn badgeds for certain milestones.

What are the outcomes you should expect?

As a user, if you go through Excel Everest, you'll be able to go from knowing nothing (for those who need it, we cover the absolute basics), to a deep understanding of all of the business critical aspects of Excel. In no time, you'll have your colleagues asking you to teach them how to do a VLookup or set up a Pivot Table on their behalf.

As a training manager, you'll finally have a training system that provides interactivity, accountability, and a bit of fun along the way. Even small Excel errors can cost organizations an enormous amount of time, and even worse, inaccurate data can get reported up the chain and used for key business decisions. If you have limited training dollars to spend, you should put them toward Excel. An error in PowerPoint or Word doesn't result in catestrophic business outcomes. Excel Everest will help train on what matters most.

Keywords: Excel, microsoft excel, Excel 2003, excel 2007, Excel 2010, Excel 2011, Excel 2016, microsoft office, Excel Training

The full version of Excel Everest includes the content below. Try our Free Demo Course to get a subset!

1. Instructions and Introduction
.
.
2. The Essential Excel Basics
.
— a. A quick history of Excel
——— The Excel founders
——— The evolution of Excel
——— Other innovative work done in Excel
— b. Cells and some of their properties
——— Number types
——— How to move and autofill cells
——— Absolute vs. relative references
— c. The power of paste special
——— Paste options
——— Transpose function
— d. Basic to advanced formatting
———Colors and borders
———Text formatting
———Conditional formatting
— e. Sorting and auto-filters
———Sorting data
———Using auto filters
— f. Text to columns and find and replace
——— Text to columns
——— Find and replace
——— Combining these functions
— g. Hiding, adding, moving, and deleting rows and columns
——— Adding, moving, and deleting
——— Hiding and resizing
——— Grouping
— h. Shapes, objects, and pictures
——— Ordering, grouping, and selecting objects
——— Shapes, pictures, and object properties
.
.
3. Playing with formulas
.
— a. Text formulas
——— Quotes (“ “) and ampersand (&)
——— Right, left, and trim
— b. Basic math formulas
——— Sum, Count, and Average
——— Percentrank, Percentile
——— Rand and randbetween
— c. Vlookup
——— Overview of the Vlookup
——— Vlookup formula details
——— Key Vlookup mistakes
— d. If statement (logic formulas)
——— Overview of the IF statement
——— Nesting IF statements
——— Key utility in IF statements
— e. Statistical formulas
——— Average, median, mode, max, min
——— Correl, Stdev
.
.
4. Answering questions about numbers
.
— a. Charts and sparkles
——— Building your chart
——— Key charting use cases
——— Formatting your chart
— b. Pivot tables
——— Overview of Pivot tables
——— Key Pivot table use cases
.
.
5. Tips to make your Excel life Easier
.
— a. Email list, multiple tabs, F5 key
——— Making an email list
——— Working with multiple tabs
——— The F5 key
— b. Getting rid of duplicates
— c. The joy of keyboard shortcuts
——— Tab / Enter, and Navigation
——— Paste special
——— Cmd-Y for repeats
——— Cmd-T for reference type changes
— e. Basic macros
——— The concept of a macro
——— How to record and utilize basic macros
— f. Printing from Excel
.
.
6. Excel library of other resources
.
.
7. Scoreboard