Get Your Free Compliance Audit Today

Book a Demo
Price $159.00/ license

Online Courses > Software > Microsoft Office > Excel Everest: Interactive, Comprehensive Excel Training

Excel Everest: Interactive, Comprehensive Excel Training

5.0
$159.00

Created by   Excel Everest

Category   Software   >   Microsoft Office

Back To Shopping
Duration 60 minutes
Audience Employees

Description

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.
 

Table of Contents

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

System Requirements

Either a Mac or a Windows version of Excel is required to go through Excel Everest. We're able to supply versions of Excel Everest for all versions of Excel: Excel 2003, Excel 2007, Excel 2010, Excel 2011, and Excel 2016

Languages

English

Skills you'll gain

Excel microsoft excel Excel 2003 excel 2007 Excel 2010 Excel 2011 Excel 2016 microsoft office Excel Training

Details to know

Certificate
Bookmark

Excel Everest: Interactive, Comprehensive Excel Training

Excel Everest - Interactive Excel Training
Excel Everest - Interactive Excel Training

Excel Everest

Who is Excel Everest? 

 

Excel Everest was founded with one key principle in mind: Corporate Excel training was broken. All too often, trainers would run expensive in-person classes, or simply rely on videos. The reality is that Excel is learning by DOING. We've solved this by creating Excel Everest, an entirely new way to learn Excel: right from INSIDE a massive, interactive Excel workbook. This workbook is complete with 41 topics and 160+ self-graded exercises, all tuned toward the key areas of business impact. With Excel Everest, employees ramp more quickly, training groups are better able to demonstrate their impact, and businesses get more efficient from their employees having a better handle on the most important business software of all time.

Price per license
$159.00
No. of licenses
Total
$159.00
Get Bulk Pricing
30-Day Money Back Guarantee Full Lifetime Access

Or

Get Coggno Prime Now
to be added

Courses Handpicked for you

Accounting/Finance

Structured Scenario Selection

Free

2051 views

by Financial Mechanics

Start Now Subscribe to Prime

Business

How to "Visualize" Reports to Better Understand, Predict and Manage (3 month license)

$12.00

2674 views

by Dan Strongin, ASQ CMQ/OE

Subscribe to Prime

Business

How to "Visualize" Reports to Better Understand, Predict and Manage (Full 12 month license)

$24.00

2537 views

by Dan Strongin, ASQ CMQ/OE

Subscribe to Prime