Created by Excel Everest
Category Software > Microsoft Office
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!
Your orgnization or employees may be a fit for Excel Everest if:
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
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
English
Or
Get this course, plus 1,230+ of our top-rated courses, with Coggno Prime
""
Excel Everest: Free Demo Course
If you'd like to give it a try ahead of purchasing the real course, test out our demos! First, watch the video by "starting" this course, and then download the appropriate demo workbook here: https://exceleverest.com/try-excel-tutorial-free/
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.
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: