Loading ...

Course / Course Details

Masterclass of Advance Excel

  • Premchandra kumar image

    By - Premchandra kumar

  • 7 students
  • 35 Hours
  • (0)

Course Requirements

No prior Excel knowledge is required. Just bring a laptop with Excel (2016 or later), a stable internet connection, and a willingness to learn and explore advanced Excel tools step by step.

Course Description

Learn the world's most powerful reporting tool.

Microsoft Excel remains one of the most powerful and advanced business tools as it is widely used by individuals and corporate to manage and analyze their data. Microsoft Excel is everywhere in any professional & business environment, and advanced Excel skills are welcome almost everywhere.

LEARN CORE CAPABILITIES:

🟢 Data Consolidation

🟢 Create MIS reports

🟢 Data Analysis

🟢 Performance Dashboards

🟢 Report Automation

🟢 Decision-Making Tools

This course contains everything in Excel from basic to advanced. This course is highly beneficial for freshers to professionals who are looking for a great career in analytics. For aspirants who want to start with a great profile such as Reporting Analyst, Data Analyst, MIS Analyst, and Business Analyst as a fresher this course is highly recommended.

Course Outcomes

By the end of this Advanced Excel Masterclass, you will be able to use smart formulas, analyze data with PivotTables and charts, clean messy data, automate tasks, and build interactive dashboards. You’ll learn practical skills that help you work faster, smarter, and shine in any job that involves data.

Course Curriculum

  • 18 chapters
  • 34 lectures
  • 0 quizzes
  • 35 Hours total length
Toggle all chapters
1 Basic Shortcut
59 Min


1 Date & Time Formatting
48 Min


2 Number & Text Format
1 Hour 17 Min


1 Time Saving Utility-1
1 Hour 13 Min


2 Time Saving Utility-02
42 Min


1 Cell Referencing
51 Min


1 Formula & Functions -01
1 Hour 3 Min


2 Formula & Functions -02
1 Hour 8 Min


3 Formula & Functions -03
1 Hour 15 Min


4 Formula & Functions -04
1 Hour 9 Min


5 Formula & Functions -05
57 Min


1 Nested Formula -01
58 Min


2 Nested Formula -02
1 Hour 34 Min


3 Nested Formula -03
1 Hour 14 Min


4 Nested Formula -04
1 Hour 13 Min


1 Go To Special
53 Min


1 Conditional Formatting
1 Hour 7 Min


1 Name Manager
29 Min


1 Data Validation -01
26 Min


2 Data Validation -02
37 Min


1 Charts-01
56 Min


2 Charts-02
1 Hour 14 Min


3 Battery Chart- Bonus
38 Min


1 Pivot Table-01
1 Hour


2 Pivot Table-02
1 Hour 18 Min


3 Pivot Table-03
53 Min


1 Array Formula-01
47 Min


2 Array Formula -02
54 Min


1 Protection
1 Hour 1 Min


1 Advance Filter -01
59 Min


2 Advance Filter -02
1 Hour 11 Min


1 Data Consolidation
34 Min


1 What-if Analysis
1 Hour 4 Min


2 Solver
44 Min


Instructor

Premchandra kumar

I have over 7 years of corporate experience and I'm a Microsoft Certified Office Specialist in Excel and Power BI. I help professionals grow by teaching data and productivity skills in a simple, practical way. Through EduProSkills, I offer training and mentorship that helps people get 10X results by turning data into clear, smart actions.

0 Rating
0 Reviews
12 Students
3 Courses

Course Full Rating

0

Course Rating
(0)
(0)
(0)
(0)
(0)

No Review found

Sign In or Sign Up as student to post a review

Student Feedback

Course you might like

Beginner
Masterclass of Advance Excel
0 (0 Rating)
Learn the world's most powerful reporting tool.Microsoft Excel remains one of the most powerful and advanced business to...
Advance
Brainstorming Advance Excel Masterclass
0 (0 Rating)
No matter how many years you worked or how many reports you create, Excel has hundreds of pain areas where we are stuck...

You must be enrolled to ask a question

Students also bought

More Courses by Author

Discover Additional Learning Opportunities