Master Excel Data Analysis: Functions & Techniques 2024
Focused View
49:43
1. Microsoft Excel Data Analysis Functions Techniques.mp4
00:37
2. Demo - The IF and IFS Logical Functions.mp4
04:03
3. Demo - The SUMIF and COUNTIF Functions.mp4
02:59
4. Demo - The Logical AND and OR Functions.mp4
02:48
01. Demo - VLOOKUP in a Single Sheet.mp4
02:23
02. Demo - VLOOKUP with Multiple Sheets and Named Ranges.mp4
03:23
03. Demo - HLOOKUP for Row-wise Lookups.mp4
01:47
04. Demo - Limitations of VLOOKUP.mp4
02:44
05. Demo - Lookup Cells with INDEX.mp4
01:50
06. Demo - Dynamic Lookup with INDEX and MATCH.mp4
02:04
07. Demo - Multicriteria INDEX and MATCH.mp4
02:23
08. Demo - Performing Lookups and Handling Errors with XLOOKUP.mp4
02:31
09. Demo - Partial Matches and Row-wise Lookups with XLOOKUP.mp4
02:22
10. Demo - Dynamic Multicriteria Lookups with Nested XLOOKUP.mp4
02:04
1. Demo - Goal Seek for Break Even Analysis.mp4
03:04
2. Demo - Using the Scenario Manager for What-if Analysis.mp4
04:20
3. Demo - Sensitivity Analysis with Data Table.mp4
02:57
1. Demo - Line and Column Sparklines.mp4
03:51
2. Demo - WinLoss Sparklines.mp4
01:33
More details
Course Overview
This comprehensive Excel course teaches you to analyze complex datasets using logical functions, lookup tools, what-if analysis, and sparkline visualizations to drive data-driven business decisions.
What You'll Learn
- Implement IF, IFS, SUMIF and nested functions for data categorization
- Master VLOOKUP, XLOOKUP, INDEX/MATCH for cross-sheet data analysis
- Perform what-if scenarios with Goal Seek and Data Tables
Who This Is For
- Business analysts needing advanced Excel skills
- Finance professionals evaluating investments/scenarios
- Managers making data-driven decisions
Key Benefits
- Transform raw data into actionable insights
- Automate complex analyses with lookup functions
- Visualize trends instantly with sparklines
Curriculum Highlights
- Logical Functions for Sales & Credit Analysis
- Advanced Lookup Techniques Across Sheets
- Scenario Planning with What-If Tools
Focused display
Category
- language english
- Training sessions 19
- duration 49:43
- level average
- English subtitles has
- Release Date 2025/06/08
