Are you looking to learn excel skills employers crave?

Then this comprehensive step-by-step excel tutorial is for you! All presented in a simple, easy- yet laid-back style.

In this full course you'll learn the essentials of how to use Microsoft Excel, starting with the fundamentals like entering content, understanding how excel calculates math, and simple formatting. From there, you'll learn about financial ratios, excel functions applicable to practically any business, time and date calculations, how to work with large data sets, pivot tables, and so much more!!

By the end of this video, you'll have a strong understanding of how to use Excel like a pro!

IMPORTANT: This course is a compilation of another Excel course and all the material has been put into one comprehensive video so people don't have to jump through a massive playlist. There is a link to the play below in case you want to only watch certain topics.

Thanks!
-Dave
AKA- Professor Cubs ;)-


⌚* TIMESTAMPS*

MODULE 1 EXCEL FOUNDATION
0:00 Course Intro
0:51 What is excel
6:23 Working with sheets
7:37 Basic math in excel
10:58 Practice Time
11:40 Financial Ratios
20:21 Misc. topics

MODULE 2 CORE EXCEL FUNCTIONS
26:55 SUM Function
30:23 AVERAGE Function
31:04 MAX/ MIN Function
31:41 COUNT/ COUNTA Function
32:57 Absolute Reference
34:30 Named Ranges

MODULE 3 FORMATTING
36:36 Formatting
46:42 Conditional Formatting

MODULE 4 MORE FUNCTIONS
52:47 IF, IF and/ or, NESTED IF
1:01:06 MATCH and INDEX
1:08:09 VLOOKUP
1:12:34 XLOOKUP
1:17:11 SUMIF and SUMIFs
1:20:27 AVERAGEIF
1:22:22 COUNTIF and COUNTIFS
1:23:38 LARGE
1:26:45 SUMPRODUCT
1:29:40 RANK
1:30:28 VSTACK
1:32:33 OFFSET
1:37:31 IFERROR

MODULE 5 TEXT FUNCTIONS
1:39:02 LEFT, RIGHT, SEARCH LEN
1:45:59 Text to columns
1:48:24 Concatenation
1:49:35 UPPER, LOWER, PROPER
1:51:20 TRIM
1:52:09 TEXTBEFORE, TEXTAFTER, TEXTSPLIT
1:54:21 FLASH FILL
1:57:19 Cleaning Data

MODULE 6 TIME AND DATE CALCULATIONS
2:05:19 Intro to Times and Dates in Excel
2:09:36 Adding time
2:10:48 Text with dates
2:11:58 EDATE and DATE Function
2:14:23 DATEDIF
2:15:55 Calculate work hours minus lunch
2:18:33 CEILING and MROUND

MODULE 7 WORKING WITH DATA SETS
2:21:15 Freeze Panes
2:23:24 Basic Sorts
2:27:53 Custom Sorts
2:28:41 Sort by color and Helper Columns
2:30:17 Basic Filters
2:34:16 Advanced Filters
2:40:36 Subtotals
2:45:19 SORT, FILTER and UNIQUE Functions
2:48:38 Intro to Tables

MODULE 8 INTRO TO PIVOT TABLES
2:55:14 What is a pivot table
3:00:19 Adding multiple fields to a pivot table
3:02:22 Filters and Slicers
3:06:19 Changing calculations in pivot table
3:08:06 Pivot Charts
3:10:16 Pivot Table Wrap up

MODULE 9 FINACIAL MODELING INTRO
3:12:06 Financial Modeling Overview
3:13:12 PMT Function
3:14:45 Compound Interest
3:16:12 FV PV and NPER
3:19:58 NPV
3:23:48 IRR
3:25:56 AGGREGATE Function

MODULE 10
3:28:44 Creating Charts
3:33:14 Line graphs, Pie charts and Tree maps
3:36:41 Sparklines

MODULE 11 PRINTING
3:38:03 Printing

If you want to want to follow along you can download a copy of the practice file using this link.

💾 CLASS FILE
https://1drv.ms/x/s!AgnhzVKiTqWmch8Ec...

📄 FREE RESOURCES
Mega Excel Keyboard Shortcut List
https://view.flodesk.com/pages/63bf31...

Quick Reference Guide
https://view.flodesk.com/pages/63bf2f...

📢 ORIGINAL PLAYLIST
   • Lesson 0 : START HERE | Excel Trainin...  

☕ * BUY ME A COFFEE? *
https://www.buymeacoffee.com/professo...