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 Steps14:15
- How to Use SUMPRODUCT in Excel14:56
- Excel Dynamic YTD Calculations: OFFSET, SUMPRODUCT & SUM13:15
- Excel Goal Seek Explained in Simple Steps05:55
- Excel Solver - Example and Step-By-Step Explanation09:57
- How to Remove Hidden Data and Personal Information from Excel Workbooks10:01
- How to Easily Import External Data into Excel & Import Data from the Web11:16
- Excel SUMIFS: Sum Alternate Columns based on Criteria and Header10:54
- Excel: How to debug your Excel formulas and keep your eyes on certain cells08: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 Work19:30
- Excel Complex VLOOKUP to Create Description: Excel COUNTA, INDEX & MATCH for Blank Cells16:55
- Excel SUMIFS Date Range Formula | Sum between dates & sum with multiple criteria08:44
- How to Change the Number Format of a Cell Based on a Condition in Excel07:02
- How to Use SUMIFS with Partial Match and Wildcards in Excel08: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 Attachments11: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 Excel04: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 function08: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 Excel12:18
![Curso de Inversión en Bolsa desde CERO 💰 [Paso a Paso]](https://i.ytimg.com/vi/8-q2F2L64yk/hqdefault.jpg)
