Data Training Institute
Microsoft Excel Master Class (Full Course)
Live & online$500
About This Course
Become an Excel expert with our comprehensive Master Class, combining all levels from beginner to advanced. This course covers everything you need to know to excel in data management and analysis, making it perfect for professionals who want a complete Excel education.
What You'll Learn
- Master Excel from the basics to advanced techniques, covering all essential skills.
- Learn efficient data management practices for organizing and manipulating data.
- Develop advanced data analysis capabilities, including complex functions and formulas.
- Gain proficiency in creating professional reports and dashboards using Excel.
- Acquire the ability to automate repetitive tasks with macros, enhancing productivity.
Course Content
21 sections · taught live, step by step
1
Section 1: Creating, Opening and Saving Workbooks
2
Section 2: Exploring the User Interface
3
Section 3: Working with Data
4
Section 4: Performing Calculations
5
Section 5: Using Time Saving Tools
6
Section 6: Formatting A Workbook
7
Section 7: Managing Large Workbooks
8
Section 8: Printing and Viewing A Workbook
9
Section 9: Working with Range Names
10
Section 10: Using Specialized Functions
11
Section 11: Analyzing Data with Logical and Lookup Functions
12
Section 12: Using Financial Functions
13
Section 13: Use Date Functions
14
Section 14: Auditing Worksheets
15
Section 15: Organizing Worksheet Data with Tables
16
Section 16: Sorting and Filtering Data
17
Section 17: Using Subtotal and Database Functions to Calculate Data
18
Section 18: Visualizing Data with Charts
19
Section 19: Managing Themes
20
Section 20: Adding Trendlines
21
Section 21: Create Sparklines
Not sure this course is the right fit?
Tell us your goals and we'll recommend the right learning path — or build a custom corporate training for your team.
Talk To Us