off original price!

The coupon code was not applied because it has already been redeemed or expired. Please click on "My Courses" to see if the course is already on your account.

off original price!

The coupon code was not applied because it has already been redeemed or expired. Please click on "My Courses" to see if the course is already on your account.

Advanced Excel Crash Course

Online Advanced Excel Tutorials to make you a NINJA at work. Learn Everything in Excel from building Excel Models to creating Dynamic Dashboards

What's Inside

Course Curriculum

Downloadable Files

Excel Case Studies - Please Download
Start
eBook - Become an Excel Ninja.
Start

001 Handpicked Ninja Shortcuts

Introduction
Preview
0101 How to use this section? - 1:16
Start
0102 The "ONE" Universal shortcut & a faster Copy-Paste technique - 3:22
Start
0103 AutoFill selected cell(s) with pre-defined formula/text/no. - 1:15
Start
0104 Navigating across Worksheets; Data Table selection & manoeuvring - 4:32
Start
0105 Adding/Deleting/Selecting Rows/Columns - 3:06
Start
0106 For "Formula" One Speedstars - 6:18
Start
0107 Formatting cells - 4:36
Start
0108 Using Quick Access Toolbar (QAT) - 4:43
Start
Formula auditing magic - 4:51
Start
Excel Shortcut Quiz #1
Start

002 Formula Warm-Up

0201 MAX() in Financial Modeling - 2:43
Start
0202 LARGE() & SMALL() - for bidding/auction pricing strategies - 2:37
Start
0203 Advanced ROUND() Tricks with ROUNDUP() & ROUNDDOWN() - 1 of 2 - 3:42
Start
0204 Advanced ROUND() Tricks with ROUNDUP() & ROUNDDOWN() - 2 of 2 - 6:36
Start
0205 COUNT() vs. COUNTA() vs. COUNTBLANK() vs. COUNTIFS() - 3:19
Start
0206 SUMPRODUCT() for weighted average computation - 3:33
Start
0207 POWER() vs. Caret sign ( ^ ) - 2:38
Start
Excel Formula Warm-Up Quiz #2
Start

003 Formatting Tricks

0301 Formatting Tricks incl. Special Custom Formats - 5:16
Start
0302 Format Painter - "Uninterrupted Click-ability" - 1:55
Start
0303 Defining Cell Style - for "one-click" universal change - 4:00
Start
0304 Transferring (Merging) Cell Style from one workbook to another - 1:15
Start
0305 Cell drag-n-drop Auto Fill Options + Activation Setting - 1:19
Start
0306 Cell drag-n-drop Auto Fill Options - Yr-end, Month-end, AlphaNumeric, Fill - Justify - 2:46
Start
0307 Cell drag-n-drop Auto Fill Options vs. EOMONTH() - End of Year/Quarter/Month - 1:11
Start
0308 Paste Special - Transpose vs. TRANSPOSE() - 4:17
Start
Excel Formatting Tricks Quiz #3
Start

004 Cell Referencing ($) - Relative & Absolute

0401 Cell Referencing ($) - 1 of 2 - 3:01
Start
0402 Cell Referencing ($) - 2 of 2 - 3:19
Start
Cell Referencing using - Practice 1 - 4:22
Start
Cell Referencing using - Practice 2 - 4:34
Start
Cell Referencing using - Special Trick - 2:48
Start
Excel Cell Referencing Quiz #4
Start

005 Go To - Special "magic wand"

0501 Go To (Special) - Formulas with Errors - 2:39
Start
0502 Go To (Special) - Formulas without Errors - 2:01
Start
0503 Go To (Special) w. Ctrl+Enter - 2:07
Start
0504 Go To (Special) - Fill Intermittent Blank Cells - Case 1 - 5:58
Start
0505 Go To (Special) - Fill Intermittent Blank Cells - Case 2 - 2:03
Start
0506 Go To (Special) - Visible Cells w. Shortcut - 2:23
Start
Review our Course
Start
Short Excel Go To - Special Quiz #5
Start

006 Sort (Vertical, Horizontal, Custom), Filter & Advanced Filter

0601 Vertical Sort - 1-level & 2-level - 2:23
Start
0602 Custom Sort - 5:16
Start
0603 Sort Trick - add alternate blank rows in-between existing rows - 2:57
Start
0604 Horizontal Sorting (Left to Right) - auto-realigning 100s of columns - 3:28
Start
0605 Filter - Basics - 3:36
Start
0606 Filter - Choosing the dataset correctly - 1:25
Start
0607 Filter analysis w. shortcuts - 2:51
Start
0608 Filter - SUBTOTAL() for calculations - 5:04
Start
0609 Filter - SUBTOTAL() 9 vs. 109 series - 2:39
Start
0610 Filter - Applying 2 or more Filters simultaneously on the same sheet - 2:18
Start
0611 Filter - Color Filter & Text Filter - 1:12
Start
0612 Advanced Filter - Basics - 4:28
Start
0613 Advanced Filter - Differential Criteria - 4:09
Start
0614 Advanced Filter - More parameters - 3:08
Start
Excel Sort, Filter & Advanced Filter Quiz #6
Start

007 Working with Dates

0701 Dates - Important Concepts 1 of 2 - 3:15
Start
0702 Dates - Important Concepts 2 of 2 - 4:04
Start
0703 Date Formulas - DAY(), MONTH(), YEAR(), DATE() - 2:14
Start
0704 Date Formulas - TEXT() - 3:05
Start
0705 Date Formulas - WEEKDAY(), WORKDAY(), NETWORKDAYS() - 3:51
Start
0706 Date Formulas - WORKDAY.INTL() for deadline/due date calculations w. custom weekends/holidays - 4:51
Start
0707 Date Formulas - NETWORKDAY.INTL() for no. of business days calculations w. custom weekends/holidays - 1:43
Start
Excel Date Quiz #7_1
Start
0708 Date Formulas - TODAY() and NOW() w. Shortcut - 1:29
Start
0709 Date Formulas - EOMONTH() for Financial Modeling, Budgets, Due Dates - 3:40
Start
0710 Date Formulas - EDATE() for Financial Modeling, Budgets, Due Dates - 3:54
Start
Excel Date Quiz #7_2
Start

008 Data (Cell Input) Validation

0801 Data Validation - Drop Down List using hard coded text & pre-defined range - 2:36
Start
0802 Data Validation - Drop Down List using named range - 3:50
Start
0803 Data Validation - Numbers w. Error Alert and Input Message - 1:36
Start
0804 Data Validation - Dates w. Error Alert and Circle Invalid Data - 3:51
Start
0805 Data Validation - Text Length w. Error Alert - 1:35
Start
0806 Data Validation - Custom w. formula logic - 2:00
Start
Excel Data Validation Quiz #8
Start

009 Setting up work area view

0901 Grouping/UnGrouping Columns and Rows - 1 of 2 - 2:57
Start
0902 Grouping/UnGrouping Columns and Rows - 2 of 2
Start
0903 Grouping Trick: Changing placement of Grouping Button
Start
0904 Cell Gridlines: Turning On/Off - 0:49
Start
0905 Trick - Hide/Unhide Rows and Columns - 5:31
Start
Excel View (Freeze Panes) Quiz #9
Start
Review our Course
Start

010 Pivot Table

1001 Pivot Table - Why should you learn? - 3:57
Start
1002 Pivot Table - Pre-requisites - 2:24
Start
1003 Pivot Table - How to create one? - 2:39
Start
1004 Pivot Table - Exploring Pivot Table grid (Fields) - 3:20
Start
1005 Pivot Table - Value Field Settings - "Summarize Values By" - Sum, Average, Count, Max etc. - 5:04
Start
1006 Pivot Table - Value Field Settings - "Show Values As" - Percentage (%) of Grand Total - 2:21
Start
1007 Pivot Table - Value Field Settings - "Show Values As" - Percentage (%) of Column/Row Total - 4:48
Start
Excel Pivot Table Quiz #10_2
Start
Excel Pivot Table Quiz #10_1
Start
1008 Pivot Table - Grouping - Numbers - 3:37
Start
1009 Pivot Table - Grouping - Dates [Years, Months etc.] - 4:07
Start
1011 Pivot Table - Refresh vs. Refresh All, Change Data Source and creating Dynamic Table Data Source - 6:17
Start
1012 Pivot Table - Auto Refresh - 0:40
Start
1013 Pivot Table - Pivot Chart Shortcut and Sparklines - 2:11
Start
1014 Pivot Table - Drill Down option - 0:59
Start
1015 Pivot Table - Report Filter - Generating 100s of reports in few seconds - 3:38
Start
1016 Pivot Table - Slicer vs. Report Filter - 2:32
Start
1017 Pivot Table - Practice - Sales Data Analysis - 1 of 2I (%, Grouping, Chart, Report Filter Pages) - 7:57
Start
1018 Pivot Table - Practice - Sales Data Analysis - 2 of 2 (Slicer) - 3:08
Start
1019 Pivot Table - Practice - Closing Stock Analysis - 6:58
Start
Excel Pivot Table Quiz #10_4
Start

011 Lookups (1D, 2D, 3D, Reverse) & Conditional Calculations (Sum, Average, Count, Special Running T

1106 MATCH() match_type: -1 vs. 0 vs. 1 - 3:45
Start
1107 2-D Lookup (Vertical + Horizontal) - VLOOKUP w. MATCH - 5:51
Start
1108 2-D Lookup - VLOOKUP w. MATCH - Framework - 1:18
Start
1109 2-D Lookup - VLOOKUP w. MATCH - Common Mistake #1 - 3:47
Start
1110 2-D Lookup - VLOOKUP w. MATCH - Common Mistake #2 - 2:19
Start
1111 2-D Lookup - VLOOKUP w. MATCH - Practice Exercise - 6:11
Start
1112 2-D Lookup (Horizontal + Vertical) - HLOOKUP w. MATCH - 6:47
Start
1113 INDIRECT() - Basics - 4:17
Start
1114 INDIRECT() w. Range Naming - Applications - 5:59
Start
1115 3-D Lookup - VLOOKUP() w. MATCH() w. INDIRECT() - Question - 4:17
Start
1116 3-D Lookup - VLOOKUP() w. MATCH() w. INDIRECT() - Answer - 7:09
Start
1117 Reverse Lookup - Question - 3:26
Start
1118 Reverse Lookup - INDEX() w. MATCH() - 1 of 2 - 8:12
Start
1119 Reverse Lookup - INDEX() w. MATCH() - 2 of 2 - 6:05
Start
1120 SUMIFS(): Conditional Summation (1 criteria) - 5:02
Start
1121 SUMIFS(): Conditional Summation (2 criteria) - 4:15
Start
1122 SUMIFS(): Conditional Summation (3 criteria) w. date range - 5:58
Start
1123 SUMIFS(): Condition based Selective Cumulative Running Total - 5:40
Start
1124 COUNTIFS() - Single/Multiple Criteria: Duplicate Count, Instance No. - 6:08
Start
1125 AVERAGEIFS() - to be updated - 1:23
Start
OFFSET() with MATCH() - 15:08
Start
Excel Lookup Quiz #11_1
Start
Excel Lookup Quiz #11_2
Start
Excel Lookup Quiz #11_3
Start
Excel Lookup Quiz #11_4
Start
Excel Lookup Quiz #11_5
Start
Excel Lookup Quiz #11_6
Start
Excel Lookup Quiz #11_7
Start
New Lecture
Start
Review our Course
Start
New Lecture
Start
Fuzzy Lookup
Start

012 Data Cleaning / "Sanitizing" & Text Formulas

1205 Text Formulas – REPT() for artifical Column Chart in a Cell - 1:14
Start
1206 Text Formulas – REPT() & LEN() for adding leading zeroes before incomplete Cheque Nos. - 4:28
Start
1207 Joining data strings using CONCATENATE, & - to be updated - 4:55
Start
1208 Find & Replace – Using Wildcard character ( * ) - 3:07
Start
1209 Find & Replace – Using Wildcard character ( ? ) - 2:22
Start
1210 Find & Replace – Neutralising Wildcard characters to remove them from data - 2:37
Start
1211 Find & Replace – Word vs. Excel - 6:04
Start
1212 Find & Replace – Cell Format - 4:29
Start
1215 Text to Columns – Cleaning up numbers w. trailing minus sign - 2:32
Start
1216 Text to Columns – Cleaning up numbers w. leading "Dr/Cr" text - 2:01
Start
1217 Text to Columns – Correcting invalid Dates (DMY) - 3:23
Start
1218 Text to Columns – Correcting invalid Dates (YMD) - 3:17
Start
1219 Text Formulas – LEFT(), RIGHT() & SEARCH() - 1 of 2 - 4:17
Start
1220 Text Formulas – LEFT(), RIGHT() & SEARCH() - 2 of 2 - 2:25
Start
1221 Text Formulas – MID() & LEN() - 3:41
Start
1222 Text Formulas – REPLACE() & SUBSTITUTE()
Start
1223 FlashFill for Data Cleaning in Excel
Start
Excel Data Cleaning Quiz #12_1
Start
Excel Data Cleaning Quiz #12_2
Start
Excel Data Cleaning Quiz #12_3
Start
Excel Data Cleaning Quiz #12_4
Start
Excel Data Cleaning Quiz #12_5
Start

014 Conditional Formatting

1405 Conditional Formatting: Formula based (Colored rows based in user input) - 4:10
Start
1406 Conditional Formatting: Formula based w. AND() - 2-way input Coloring - 5:20
Start
1407 Conditional Formatting: Formula based w. COUNTIFS() - Highlighting inputs if from restricted list - 4:12
Start
Excel Conditional Formatting Quiz #14_1
Start
Excel Conditional Formatting Quiz #14_2
Start

015 What-If Analysis

1501 What IF Analysis – Using Form Control Buttons from Developer Tab (Spin Bar, Scroll Bar) - 5:06
Start
1502 What IF Analysis – Limitations of Spin Bar, Scroll Bar - 4:01
Start
Excel What-If Analysis Quiz #15_1
Start
1503 What IF Analysis – Scenario Managers - to be updated
Start
1504 What IF Analysis – Goal Seek - 4:31
Start
Excel What-If Analysis Quiz #15_2
Start
1505 What IF Analysis – Data Tables Basics (Sensitivity Analysis) - 2 Inputs & 1 Output - 8:20
Start
1506 What IF Analysis – Data Tables Basics (Sensitivity Analysis) - with PMT for Loan EMI - 5:20
Start
1507 What IF Analysis – Data Tables Basics (Sensitivity Analysis) - 2 Inputs & multiple Output - Question - 2:38
Start
1508 What IF Analysis – Data Tables Basics (Sensitivity Analysis) - 2 Inputs & multiple Output - Answer - 10:06
Start

off original price!

The coupon code was not applied because it has already been redeemed or expired. Please click on "My Courses" to see if the course is already on your account.

This course is closed for enrollment.

Certificate Available

1258+ Students

175 Lectures

8+ Hours of Video

Lifetime Access

24/7 Support

Instructor Rating

Zaid Ahmed

⮞ Completed all Three Levels of the CFA Program

⮞ Worked in the Financial Advisory unit of a top-tier consulting firm serving buy-side and sell-side firms

⮞ Performed due diligence in multiple investment/M&A deals ranging from $2mn to $100mn

⮞ Taught Classroom and Online Financial Modelling in Big 4 firms and B-Schools

⮞ Designed and Built Financial Model Templates for Digital Entrepreneurs (UptickGo)

Popular Bundles

StackSkills Unlimited
Evan Kimbrell's Business Launching Bundle
Essential JavaScript Coding Bundle
Ultimate Web Developer Bundle
World Travel Hacker Bundle

off original price!

The coupon code was not applied because it has already been redeemed or expired. Please click on "My Courses" to see if the course is already on your account.

Just In

The 2020 Learn to Code Bundle

Hot Bundle

Master Photoshop & The Entire Creative Cloud

Unlimited Learning

Expand Your Mind with StackSkills Unlimited

Course Categories

Advanced Excel Crash Course

Online Advanced Excel Tutorials to make you a NINJA at work. Learn Everything in Excel from building Excel Models to creating Dynamic Dashboards

What's Inside

Course Curriculum

This course is closed for enrollment.

Zaid Ahmed