Your browser is not supported. Please download Mozilla Firefox or Google Chrome browser.

coggno-logo2
Course Information arrow

Price Discounts

  • Qty

    Price

  • 1

    $159.00

  • 20

    $135.15

  • 50

    $127.20

  • 100

    $119.25

  • 500

    $103.35

  • 800

    $95.40

Syndication Option

Resell Course
Resold modules appear on your website. You earn syndication share from each purchase.


Create Custom Widget
Select a display format that best suits your website, then add courses and customize your widget. We'll provide the HTML for you to use on your site.

Similar Courses arrow
excel-everest-free-demo-course Excel Everest: Free Demo Course
Tuesday Oct 24 2017

structured-scenario-selection-1 Structured Scenario Selection
Tuesday Oct 24 2017

fast-financial-modelling-level-1-certification FAST Financial Modelling: Level 1 Certification
Tuesday Oct 24 2017

excel-2007-vba-course Excel 2007 VBA Course
Tuesday Oct 24 2017

excel-2010-introduction-course Excel 2010 Introduction Course
Tuesday Oct 24 2017

excel-2007-intermediate-course Excel 2007 Intermediate Course
Tuesday Oct 24 2017

Preview-button-95px

Excel Everest: Interactive, Comprehensive Excel Training

Author: Excel Everest

Category: Online Software Training > Microsoft Office

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+ busine...

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

Read More
Buy this course
$159.00

Per License

Enter no. of units to buy
Total Payment Required$159.00 Add to Cart
Discounted Price $159.0 $135.15 $127.2 $119.25 $111.3 $103.35 $95.4
# Licenses 1 20 50 100 250 500 800
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

Hardware and Software 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

Included Modules:
  • 98613

    Excel Everest - Interactive Excel Training