Excel Advanced Formulas & Features
5.0
(1)
11 learners
What you'll learn
This course includes
- 7.5 hours of video
- Certificate of completion
- Access on mobile and TV
Course content
1 modules • 45 lessons • 7.5 hours of video
Excel Advanced Formulas & Features
45 lessons
• 7.5 hours
Excel Advanced Formulas & Features
45 lessons
• 7.5 hours
- How to use Excel Index Match (the right way) 11:32
- Excel OFFSET Function for Dynamic Calculations - Explained in Simple Steps 14:15
- How to Use SUMPRODUCT in Excel 14:56
- Excel Dynamic YTD Calculations: OFFSET, SUMPRODUCT & SUM 13:15
- Excel Goal Seek Explained in Simple Steps 05:55
- Excel Solver - Example and Step-By-Step Explanation 09:57
- How to Remove Hidden Data and Personal Information from Excel Workbooks 10:01
- How to Easily Import External Data into Excel & Import Data from the Web 11:16
- Excel SUMIFS: Sum Alternate Columns based on Criteria and Header 10:54
- Excel: How to debug your Excel formulas and keep your eyes on certain cells 08:42
- Excel Conditional Formatting with Symbols and Icons (for better reports) 10:01
- How to Reset Week Number Every Month in Excel - (WEEKDAY & WEEKNUM Functions Explained) 17:26
- How to Conditional Formatting the Lookup Result in Excel Data Table (Index Match) 09:25
- Return Multiple Match Results in Excel (2 methods) 14:13
- Excel MOD Function - Easy Explanation & Practical Examples of MOD for Work 19:30
- Excel Complex VLOOKUP to Create Description: Excel COUNTA, INDEX & MATCH for Blank Cells 16:55
- Excel SUMIFS Date Range Formula | Sum between dates & sum with multiple criteria 08:44
- How to Change the Number Format of a Cell Based on a Condition in Excel 07:02
- How to Use SUMIFS with Partial Match and Wildcards in Excel 08:37
- How to Count a Specific Day of the Week Between Two Dates | How many Fridays? 06:27
- How to Fix VLOOKUP Not Working | Convert Text to Date? (Excel Text to Columns) 04:55
- How to Rank Duplicate Values in Excel without Skipping Numbers (Top 3 Report with Duplicates) 13:18
- How to Change HORIZONTAL Data to VERTICAL in Excel (NO Transpose Function needed) 05:33
- Convert NUMBERS to WORDS in Excel | No VBA (free file included) 09:23
- Excel IF Function with PARTIAL Text Match (IF with Wildcards) 06:37
- Excel MAX or MIN with CONDITIONS (MAXIFS & AGGREGATE Method) 08:07
- Send Fully Dynamic Emails from Excel with a SINGLE FORMULA | No VBA Required! 08:53
- Excel 3D Formulas Explained (Sum Across Multiple Sheets) 09:12
- TRIM Isn’t Working? How to Remove "Invisible" Spaces in Excel (FAST) 07:49
- Calculating Returns On a Rental Property (ROI with Excel Template) 15:44
- Why You NEED to know the Time Value of Money Formula (Excel NPV function) 13:49
- How to Count Cells With Text in Excel (Mysterious Formula as NEVER Seen Before) 06:36
- Find Multiple Match Results in Excel (Easier Solution For ALL Excel versions) 12:51
- How to Use Power Automate to Send Emails from Excel with PERSONAL Attachments 11:14
- How to Create Random Numbers in Excel (including no repeats) 07:12
- How to Calculate Working Days in Excel & Exclude ANY Days you WANT (weekends too) 07:25
- How to SUMIFS With Multiple Criteria In the SAME Column in Excel 04:25
- Properly Calculate Percentile and Percentile RANK in Excel (INC vs EXC) 06:54
- How to Calculate YTD (Year to Date) Values in Excel using the SCAN function 08:26
- Forecasting in Excel Made SIMPLE (include seasonality & make predictions) 05:42
- Excel LOOKUP Function Only PROS Use (simple to complex examples) 11:49
- Excel What-If Analysis Data Table | Easy to Use Once you Learn This☝️ 08:42
- You Won't Believe These Crazy PIVOT TABLE Hacks! 11:30
- Introducing REGEX Excel Functions - Extract, Clean, and Format Data Easily! (NEW!) 19:22
- Stop Using COUNTIF! The Better Way to Count in Excel 12:18
Take this course with you
Download the app to continue lessons from your phone anytime.
