Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Introduction to Microsoft Excel
Welcome! Course Introduction
Welcome!
Excel Made Easy: A Beginner's Guide to Excel Spreadsheets (3:32)
Data Entry Techniques in Excel (3:00)
How to Make Your Spreadsheets Look Professional (5:49)
Inserting, Deleting, and Modifying Rows & Columns (1:44)
Excel Formulas for Beginners (2:54)
Excel Functions (3:41)
Work Efficiently by Using Cut, Copy, and Paste (2:10)
Format Cells (5:24)
Pasting Values, Formulas and Formats with Paste Special (1:16)
Microsoft Excel - Useful Tools & Tips
Inserting a Line Break with Alt + Enter (0:49)
Do More with Your Sales Data with Excel's Text to Columns Feature (1:52)
Create Easily Printable Excel Documents (1:11)
How to Wrap Text in Excel and Adjust a Cell's Size (0:44)
Insert Hyperlinks into Excel Spreadsheets (1:16)
Using Excel's Freeze Panes to Handle Large Datasets (1:12)
Find Excel Functionalities in a Quicker Way - Tell Me What You Want to Do (0:46)
A Quick Introduction to Excel's Pivot Tables (2:17)
Initial Formatting Is Key for Creating Professional-looking Spreadsheets (1:53)
Macros Are a Great Timesaver! Here's Why (2:59)
How to Use the Same Macro On Multiple Workbooks (1:34)
The Secret to Faster Scrolling in Excel (1:36)
Be even quicker: F5 + Enter (1:51)
Using Absolute and Relative Cell References (2:15)
Find and Select Cells That Meet Specific Conditions (1:30)
How to Create Dynamic Names in Excel Spreadsheets (1:22)
Using Named Ranges to Make Formulas More Readable (1:34)
How to Add a Drop-down List in Excel (1:49)
Using Custom-sort to Sort Multiple Columns Within a Table (1:23)
Saving Time in Excel and Doing Everything Faster by Using Excel Shortcuts (4:15)
Multiply by 1 (1:34)
Find and Replace - References (3:03)
Find and Replace - Formatting (1:53)
Green References (1:31)
Beauty Saving - The Professional Way of Saving Files (2:13)
The Power of F2 (1:50)
Conditional Formatting (5:40)
Introduction to Custom Cell Formatting (6:13)
Custom Formatting - An example (1:34)
Microsoft Excel - Beginner, Intermediate & Advanced Functions
Key Excel Functions: If (2:35)
Enlarge the formula bar (1:03)
Key Excel Functions: Sum, Sumif, Sumifs (4:20)
Key Excel Functions: Count, Counta, Countif, Countifs (3:58)
Key Excel Functions: Average & Averageif (1:54)
Key Excel Functions: Left, Right, Mid, Upper, Lower, Proper, Concatenate, & (4:25)
Working with text in Excel (2:40)
Find the Highest and Lowest Values in a Range: Max & Min (0:52)
= and + are interchangeable when you start typing a formula (0:44)
Use Round in Your Financial Models (1:01)
Excel's Lookup Functions: Vlookup & Hlookup Made Easy (7:42)
Index, Match, and Their Combination - The Perfect Substitute for Vlookup (7:27)
Using Excel's Iferror Function to Trap Spreadsheet Errors (1:43)
A Useful Tool for Financial Analysis - The Rank Function (2:36)
Create Flexible Financial Models with Choose (2:24)
Goal Seek Will Help You Find the Result You Are Looking For (2:17)
Perform Sensitivity Analysis with Excel's Data Tables Functionality (4:05)
Microsoft Excel - Practical Exercise "Build a P&L From Scratch"
Introduction to the Case Study (0:45)
What You Will See Next (1:06)
Understand Your Data Source Before You Start Working on It (2:42)
Ordering the Source Worksheet (2:16)
Create a Code: The Best Way to Organize Your Data and Work Efficiently with It (1:59)
Learn How to Create a Database (1:58)
Using Lookup Functions (Vlookup) to Fill the Database Sheet (5:29)
Use Sumif to Complete the Database Sheet (4:06)
Using Index & Match as a Substitute for Vlookup (3:51)
The Mapping Exercise (2:16)
Mapping the Rows in the Database Sheet (1:41)
Building the Structure of the P&L Sheet (2:21)
A Practical Example of Professional Formatting in Excel (3:17)
Populate the P&L Sheet with Sumif (2:47)
Learn How to Find Mistakes with Countif (2:14)
Calculating Growth Rates in Excel (3:08)
Microsoft Excel - Building Professional Charts in Excel
Introduction to Excel Charts (0:57)
Beginner's Guide to Inserting Charts in Excel (2:05)
Modifying Excel Charts - The Easy Way (2:24)
Making Your Excel Charts Sexier - Proven Tips (3:05)
Creating a Bridge Chart in Excel 2016 - As Easy as It Gets (1:37)
New Ways to Visualize Your Data - Treemap Charts (1:26)
How to Represent Trends with Sparklines (3:47)
Stacked Column Chart with a Secondary Axis (5:30)
Doughnut Chart (4:58)
Area Chart (3:33)
Bridge Chart (6:51)
Introduction to Pivot tables
Intro to Pivot tables (1:30)
Editing a Pivot table (3:43)
Formatting a Pivot table (2:09)
Adjusting a Pivot table (4:28)
GETPIVOTDATA (3:40)
Slicers (4:15)
A practical case study with Pivot Tables
Introduction to the case study (1:55)
Working with an SAP data extraction (3:18)
Preliminary mapping of the data extraction (2:05)
Creating an output structure of the FMCG model (2:24)
Improving the layout and appearance of the FMCG report (3:54)
Inserting formulas and automating calculations (2:26)
Creating a Master Pivot Table: The main data source for the FMCG report (1:50)
GetPivotData is great! Extracting data from the Master Pivot Table (5:40)
Combining Slicers and GetPivotData: The key to our success (3:15)
Getting fancy with Excel slicers (3:07)
This is how the report can be used in practice by high-level executives (3:54)
Do More with Your Sales Data with Excel's Text to Columns Feature
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock