Current Status:

Not Enrolled

Price:

$500

Get Started:

Book Your Live Class

Price: $500

You are not yet enrolled in this course.

Course Description:

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.

• 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

Section 1: Creating, Opening and Saving Workbooks
Section 2: Exploring the User Interface
Section 3: Working with Data
Section 4: Performing Calculations
Section 5: Using Time Saving Tools
Section 6: Formatting A Workbook
Section 7: Managing Large Workbooks
Section 8: Printing and Viewing A Workbook
Section 9: Working with Range Names
Section 10: Using Specialized Functions
Section 11: Analyzing Data with Logical and Lookup Functions 
Section 12: Using Financial Functions
Section 13: Use Date Functions
Section 14: Auditing Worksheets
Section 15: Organizing Worksheet Data with Tables
Section 16: Sorting and Filtering Data
Section 17: Using Subtotal and Database Functions to Calculate Data
Section 18: Visualizing Data with Charts
Section 19: Managing Themes
Section 20: Adding Trendlines
Section 21: Create Sparklines

Enroll Now