Autoplay
Autocomplete
Previous Lesson
Complete and Continue
PI BootCamp - Excel to PowerPoint
Introduction
A Basic Overview of Essential Excel Tricks (9:12)
One of Excel's Best Tricks - Flash Fill - Basic to Intermediate (6:27)
Project Work: Electricity Consumption Log Book (10:28)
Introduction - Quiz
001 Ninja Shortcuts
What is faster than the regular Copy and Paste shortcuts? (3:23)
What is the shortcut to automatically fill selected cells? (1:16)
6 Essential [data selection and navigating] shortcuts (4:34)
6 Essential [rows and column] shortcuts (3:07)
7 Essential [formatting] shortcuts (4:39)
Ninja Shortcuts - Quiz
002 Formatting Tricks
Learn 2 fastest tricks to copy-paste cell formats 3-5x times faster (1:56)
How to create a basic drop down list? (2:37)
Four tricks to color cells with Errors, Specific Values, Duplicates and Blank (5:03)
Formatting Tricks - Quiz
003 Formula Pre-Requisite
What is "locking" the cell reference - Basics of using $ (3:02)
Learn the two advanced cases of using $ while locking the cell reference (3:20)
Formula Pre-Requisite - Quiz
004 Sort & Filter
How to analyse the data using Shortcuts after applying Filter? (2:52)
Why you should never apply SUM or AVERAGE function on a Filtered list? (5:06)
Sort & Filter - Quiz
005 Data Cleaning
Learn one of the best Data Cleaning Tricks - Go To (5:01)
Learn to use Find & Replace effectively (4:50)
How to keep the zeroes when applying Text to Column on data with preceeding zeroes? (4:06)
How to rectify incorrectly formatted date such as 24.05.2007 using Text to Column? (3:24)
How to rectify incorrectly formatted date such as 20080109 using Text to Column? (3:18)
How is MID more powerful than LEFT and RIGHT functions? (3:42)
Data Cleaning - Quiz
006 Working with Dates
Do you know how Excel stores a Date value to avoid MDY vs DMY confusion? (3:16)
How to get the day name of a date - Sun, Mon etc. (3:06)
4 Tricks of Current Date and Time for Excel Modeling (1:29)
How to calculate 5th of next month? (3:41)
How to calculate expiry date for agreements and warranty period? (3:55)
Working with Dates - Quiz
007 Pivot Table
Top 7 Pivot Table Tricks (11:20)
Understanding the 4 grids of a Pivot Table report (3:21)
Pivot Table Project for Practice - Inventory Analysis - Part 1 of 1 (7:01)
Pivot Table - Quiz
008 Lookup & Conditional Calculations
Use Slabs based Lookup to avoid complex Nested IF statements (6:41)
Learn the basics of VLOOKUP's best friend - MATCH function (3:38)
What is 2D Lookup and how can it avoid complex Nested IF statements? (5:54)
Lookup & Conditional Calculations - Quiz 01
009 Lookup & Conditional Calculations
What is "reverse" lookup, and why VLOOKUP fails you sometimes? (3:27)
How to write a "reverse" lookup using INDEX with MATCH? (8:12)
"Reverse" Lookup Project for Practice - using INDEX with MATCH (6:07)
Lookup & Conditional Calculations - Quiz 02
010 Lookup & Conditional Calculations
How is VLOOKUP different from SUMIFS? (4:28)
How can you add multiple criteria while writing SUMIFS? (4:12)
Three most important tricks of writing COUNTIFS function (6:10)
Lookup & Conditional Calculations - Quiz 03
011 Logical Formula
The two must under-used logical formulas - AND & OR (5:15)
How to combine IF with AND & OR formulas to make the logic 5x times powerful? (3:35)
Logical Formula - Quiz
012 What-If Analysis
How to add Spin buttons to make your financial model interactive? (5:06)
How to do Sensitivity Analysis of Loan EMI using Data Tables? (5:20)
Part 1: How to do use Data Tables with more than one output variable? (Hint: INDIRECT) (2:38)
Part 2: How to do use Data Tables with more than one output variable? (Hint: INDIRECT) (10:06)
What-If Analysis - Quiz
013 Array Formula
Basics of Array Formula (Ctrl Shift Enter) - Example 1 (3:16)
Basics of Array Formula (Ctrl Shift Enter) - Example 2 (1:21)
Building MAX IF and MIN IF with one condition - Example 1 (6:31)
Building MAX IF and MIN IF with one condition - Example 2 (5:32)
Array Formula - Quiz
014 Macros
Excel Macros for Non-Programmers (11:12)
015 Excel Course Wrap Up
Post Training Recap for Excel (15:49)
PowerPoint - Speed Shortcuts and Tricks
Advanced PowerPoint Tricks - Best 5 Tricks (7:25)
Rotate Shortcut (4:03)
Converting Bullet Point Text in SmartArt (2:40)
De Assembling SmartArt (3:30)
Slide Master - Introduction (4:47)
PowerPoint - Speed Shortcuts and Tricks - Quiz
Course Feedback & Final Assessment
Final Excel Assessment Quiz
Final PowerPoint Project
Bonus: Working with Financial Statements
Working with Financial statements - Part 1 (6:02)
Working with Financial statements - Part 2 (1:49)
FINANCE for NON FINANCE
Course Feedback
What is 2D Lookup and how can it avoid complex Nested IF statements?
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock