Excel Everest: Interactive, Comprehensive Excel Training

Description

Excel Everest is a different way to learn Excel: the entire experience takes place inside one giant interactive Excel workbook that guides you step by step and grades your work as you go.

What this course covers:

• More than 41 business-critical Excel topics taught through learning by doing
• Over 160 interactive, auto-graded exercises sorted by difficulty
• A built-in scoreboard and badges to track your progress and milestones
• Coverage for both Mac and PC across many Excel versions
• Core skills like VLOOKUP and Pivot Tables that matter most at work

Suited to individuals building essential skills and to training managers who want accountability and measurable results.

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

See System Requirements in the Coggno Knowledge Base

Author

Excel Everest

2 Courses

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.