Back To Shop

Excel Everest: Interactive, Comprehensive Excel Training

Author: Excel Everest

Excel Everest: Interactive, Comprehensive Excel Training

 

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. Oh, and what Excel training would be complete without a dancing bear? (click "the fun button" once you're in Excel Everest). If helpful, watch a video overview of Excel Everest. 

 

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

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

Related Courses

Excel Everest: Free Demo Course

by Excel Everest

Visited 988 times

Free

Excel Everest: Interactive, Comprehensive Excel Training

Excel Everest - Interactive Excel Training

Buy This Course

Price :

$159.00 ( Per License )

Visited: 1634 Times

Difficulty: Normal

# Licenses Discounted Price
1 $159.00
20 $135.15
50 $127.20
100 $119.25
250 $111.30
500 $103.35
800 $95.40

Resold modules appear on your website. You earn syndication share from each purchase. Contact Coggno to learn more on how to embed your own Portable Webshop in your website.

Syndication FAQs