MOST-READ ARTICLES

CAREERS & INDUSTRIES

TECHNICAL SKILLS

Visit the Excel Ninja Blog
Add to cart $199
LEARN MORE
ADD TO CART

Course Objective

The objective of this course is NOT to just teach you Excel functionality but rather to go one step further and make you a master of the SHORTCUTS that surround Excel functionality. This will allow you to efficiently navigate the spreadsheet and build powerful models in record time.

What You’ll Learn

Excel Functionality

Learn how to use the wealth of functions in Excel which include conditional formatting, data tables, what-if analysis, databases, filters and macro-based tools.

Excel Formulas

The Excel Ninja program covers an extensive set of formulas that range from basic mathematical calculations and stats all the way to finance related and scenario formulas.

Excel Shortcuts

Master the use of shortcuts through the Excel Ninja program which provides the MOST extensive set of real world exercises (over 100 sets) reinforcing the skills taught.

Build Dynamic Spreadsheets From Scratch

The Excel Ninja program teaches you the fundamentals of Excel and then explains step-by-step how those elements make up complex dynamic spreadsheets.

Apply Training to Real World Applications

The program provides step-by-step guidance on how to build beautiful models ranging from public company financials to startup investment and return models.

Create Your Own Shortcuts, Databases, Tables, & Analytics

Whether you want to build something on your own or are starting a new finance / banking job, this program will equip you to build anything.

How We Are Different

Focused on Shortcuts

Unlike other Excel courses and guidebooks, The Complete Guide to Becoming an Excel Ninja is completely designed to ingrain Excel SHORTCUTS so that using a mouse in a spreadsheet becomes unnecessary and inefficient.

Designed for Anyone

Comparable Excel learning programs are rooted in training individuals for financial modeling – we DO NOT. Our Guidebook does not require you to be in finance, consulting, or an analyst although anyone in those fields would benefit a great deal from this guidebook.

How We Are Different

Unlike other Excel courses and guidebooks, The Complete Guide to Becoming an Excel Ninja is completely designed to ingrain Excel SHORTCUTS so that using a mouse in a spreadsheet becomes unnecessary and inefficient.

Comparable Excel learning programs are rooted in training individuals for financial modeling – we DO NOT. Our Guidebook does not require you to be in finance, consulting, or an analyst although anyone in those fields would benefit a great deal from this guidebook.

Complete Package Covers These Topics:

Section 1: Excel Foundations

  • Introduction
  • Excel Interface Overview
  • Excel Navigation
  • General Purpose Shorcuts
  • Find and Replace
  • Referencing
  • Auditing
  • Copy and Paste
  • Autofill
  • Trace Precedents and Trace Dependents
  • Named Cell Ranges

Section 2: Sheet Options, Settings, and Formatting

  • Excel Options
  • Suggested Excel Settings
  • Sheet Formatting
  • Customizing Rows and Columns
  • Grouping Rows and Columns
  • Hiding Rows and Columns
  • Add & Remove Rows and Columns

Section 3: Customizing Worksheets and Fonts

  • Customizing Worksheets
  • Grouping and Ordering Worksheets
  • Adding & Removing Worksheets
  • Customizing Borders
  • Font Manipulation
  • Text Alignment and Center Across Selection
  • Paste Special
  • Cell Comments
  • Conditional Formatting Overview and Options

Section 4: Cell Comments and Conditional Formatting

  • Cell Comments
  • Conditional Formatting Overview and Options

Section 5: Page and Print Setup

  • Set Print Area
  • Split & Freeze Panes
  • Page Setup
  • Margins
  • Header & Footer

Section 6: Filters and Sorting

  • Applying Filters and Sorting
  • Filtering Options
  • Sorting Options
  • Multiple Levels of Sorting

Section 6: Filters and Sorting

  • Applying Filters and Sorting
  • Filtering Options
  • Sorting Options
  • Multiple Levels of Sorting

Section 7: Advanced Custom Formatting

  • Advanced Custom Formatting
  • Custom Number Formatting
  • The Format “Code”
  • Custom Text Formatting
  • Custom Date Formatting
  • General Formatting

Section 8: Data Validation and What-If Analysis

  • Data Validation Settings
  • Data Validation Options
  • Goal Seek
  • One Dimensional Data Tables
  • Two Dimensional Data Tables

Section 9: Excel Sheet Development

  • Excel Sheet Development
  • Find and Replace
  • Auto Fill
  • Columns and Row Formatting
  • Borders
  • Conditional Formatting
  • Page Setup
  • Custom Formatting
  • Filters and Sorting
  • Data Validation
  • Data Tables

Section 10: Pivot Table

  • Pivot Table Overview
  • Creating a Pivot Table
  • Pivot Table Fields
  • Pivot Table Areas
  • Pivot Table Sorting and Filtering
  • Pivot Table Reports

Section 11: Macros and Developer Tools

  • Recording Macros
  • Running and Storing Macros
  • Developer Tools

Section 12: Excel Tips and Tricks

  • Tips and Tricks
  • Password Protect
  • Go To Special

Section 13: Mathematical, Statistical, and Financial Formulas

  • Mathematical Formulas
  • Subtotal Formulas
  • Sumproduct
  • Ceiling, Floor, ABS Formulas
  • Count Formulas
  • Present Value and Future Value
  • NPV & IRR Formulas

Section 14: Conditional Formulas

  • IF Formulas
  • AND/OR Formulas
  • SUMIF & SUMIFS
  • AVERAGEIF & AVERAGEIFS
  • ISNUMBER & ISTEXT Formulas
  • IFERROR

Section 15: Text, Date, and Concatenation Formulas

  • Text Formulas
  • Year, Month, Day Formula
  • Date Formula
  • Concatenation Formula

Section 16: Scenario Formulas

  • Scenario Formulas Overview
  • Choose
  • Offset
  • Index

Section 17: Scenario Formulas

  • Vlookup
  • Hlookup
  • Match Formulas
Basic Excel Shortcuts, Navigation & Editing
  • The Excel Ribbon & Settings
  • Formatting in Excel
  • Navigation Within Excel
  • Entering and Editing Data in Excel
  • Paste Special
  • Ctrl and Alt Shortcuts
  • Naming Cells and Ranges
  • Anchoring Cells
  • Naming Worksheets
  • Grouping & Hiding Columns & Rows
  • Grouping Workbooks
  • Formula Auditing
Logical, Date & Concatenation Functions
  • SUM & Average
  • #Ref, #Div/0! & Other Excel Errors
  • Simple & Nested IF Statements
  • IFERROR & Concatenation
  • Date Functions EOMONTH & EDATE
  • ISNUMBER, ISTEXT & Combining with IF to Create Overrides
  • More Date Functions  YEARFRAC, DAY, MONTH, YEAR & DATE
  • AND & OR Functions
Lookup Functions & Data Tables
  • Combining INDIRECT with &
  • HLOOKUP, VLOOKUP, CHOOSE, OFFSET & INDEX Functions
  • Common Errors with HLOOKUP, VLOOKUP, CHOOSE, OFFSET & INDEX
  • The MATCH Function
  • Combining H/VLOOKUP, OFFSET, INDEX, CHOOSE with MATCH
  • Creating Drop Down Menus with Data Validation
  • Combining INDIRECT with MATCH
  • Using COLUMN and ROW Functions as Counters in Complex Formulas
  • Data Tables
Math functions
  • The SUMPRODUCT Function
  • Advanced SUMPRODUCT:  Adding Criteria & Booleans in Excel
  • SUMIF/S & AVERAGEIF/S
  • CEILING, FLOOR & ABS Functions
  • ROUND, ROUNDUP, ROUNDDOWN & COMBIN Function
  • The MIN & MAX Functions
  • COUNT/A & COUNTIF/S Functions
  • Present Value & Future Value Functions
  • NPV & XNPV Functions
  • IRR & XIRR Functions
Text Functions
  • Text Functions (LEN, LEFT, RIGHT, MID, REPLACE, etc.)
  • Using Text Functions to Solve Data Extraction Challenges
  • Flash Fill (Excel 2013 Only)
  • Cell Alignment & Center Across Selection
Sorting, Filters, and Pivot Tables
  • Sort & Subtotal
  • Autofilter
  • Pivot Tables

Course Content

Basic Excel Shortcuts, Navigation & Editing
  • The Excel Ribbon & Settings
  • Formatting in Excel
  • Navigation Within Excel
  • Entering and Editing Data in Excel
  • Paste Special
  • Ctrl and Alt Shortcuts
  • Naming Cells and Ranges
  • Anchoring Cells
  • Naming Worksheets
  • Grouping & Hiding Columns & Rows
  • Grouping Workbooks
  • Formula Auditing
Logical, Date & Concatenation Functions
  • SUM & Average
  • #Ref, #Div/0! & Other Excel Errors
  • Simple & Nested IF Statements
  • IFERROR & Concatenation
  • Date Functions EOMONTH & EDATE
  • ISNUMBER, ISTEXT & Combining with IF to Create Overrides
  • More Date Functions  YEARFRAC, DAY, MONTH, YEAR & DATE
  • AND & OR Functions
Lookup Functions & Data Tables
  • Combining INDIRECT with &
  • HLOOKUP, VLOOKUP, CHOOSE, OFFSET & INDEX Functions
  • Common Errors with HLOOKUP, VLOOKUP, CHOOSE, OFFSET & INDEX
  • The MATCH Function
  • Combining H/VLOOKUP, OFFSET, INDEX, CHOOSE with MATCH
  • Creating Drop Down Menus with Data Validation
  • Combining INDIRECT with MATCH
  • Using COLUMN and ROW Functions as Counters in Complex Formulas
  • Data Tables
Math functions
  • The SUMPRODUCT Function
  • Advanced SUMPRODUCT:  Adding Criteria & Booleans in Excel
  • SUMIF/S & AVERAGEIF/S
  • CEILING, FLOOR & ABS Functions
  • ROUND, ROUNDUP, ROUNDDOWN & COMBIN Function
  • The MIN & MAX Functions
  • COUNT/A & COUNTIF/S Functions
  • Present Value & Future Value Functions
  • NPV & XNPV Functions
  • IRR & XIRR Functions
Text Functions
  • Text Functions (LEN, LEFT, RIGHT, MID, REPLACE, etc.)
  • Using Text Functions to Solve Data Extraction Challenges
  • Flash Fill (Excel 2013 Only)
  • Cell Alignment & Center Across Selection
Sorting, Filters, and Pivot Tables
  • Sort & Subtotal
  • Autofilter
  • Pivot Tables
VBA, Recording Macros & Custom Formatting
  • Recording Macros in Excel
  • Conditional Formatting
  • Go To Special
  • Creating Dynamic Headers, Custom Formatting & the TEXT Function

Download Sample Chapter

You have been Successfully Subscribed

Top Companies and Institutions use the Complete Guide to Becoming an Excel Ninja

Top Companies and Institutions use the Complete Guide to Becoming an Excel Ninja

Corporate Training Program
Add to Cart
Academic Training Program