Master Excel Formulas & Functions: Data Analysis Pro 2024
Focused View
2:14:56
1 -Getting Started with Excel Formulas and Functions.mp4
12:17
1 -Text Functions.mp4
15:31
2 -Logical Function.xlsx
2 -Logical Functions.mp4
17:05
3 -Lookup and Reference Functions.mp4
11:29
1 -Basic Mathematical Functions.mp4
11:50
2 -Statistical Analysis in Excel.mp4
11:42
3 -Exercise 1.mp4
02:11
3 -Exercise 1.xlsx
3 -Solutions.xlsx
1 -Working with Dates and Times.mp4
07:00
2 -Date and Time Manipulation.mp4
18:14
1 -Conditional Functions.xlsx
1 -Conditional and Array Functions.mp4
14:44
2 -Error Handling Functions.mp4
12:53
More details
Course Overview
Transform from beginner to advanced Excel user by mastering essential formulas and functions for powerful data analysis and workplace productivity.
What You'll Learn
- Master 50+ essential Excel functions for data analysis
- Apply statistical methods and advanced lookup formulas
- Handle complex date/time calculations and error checking
Who This Is For
- Aspiring data analysts building Excel skills
- Office professionals wanting to boost productivity
- Anyone needing to analyze data in Excel
Key Benefits
- No prior Excel experience required
- Hands-on exercises with real-world applications
- Immediately applicable workplace skills
Curriculum Highlights
- Core functions for text, logic and lookups
- Statistical analysis and math functions
- Advanced conditional and array formulas
Focused display
- language english
- Training sessions 11
- duration 2:14:56
- Release Date 2025/04/26