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
How to keep the zeroes when applying Text to Column on data with preceeding zeroes?
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock