Course / Course Details

Masterclass of Advance Excel

  • Premchandra Kumar image

    By - Premchandra Kumar

  • 7 students
  • 33 Hours
  • (0)

Course Requirements

✅ No prior knowledge of Excel is required.
✅ A laptop/PC with Microsoft Excel installed (2016 or above recommended).
✅ Willingness to learn and practice regularly.

Course Description

Microsoft Excel is one of the most widely used tools in the world of business and jobs. From small companies to big corporates, everyone uses Excel to manage, analyze, and present data. Having advanced Excel skills gives you an extra edge in almost every professional field.

What You’ll Learn in This Course:
🟢 Combine and organize data easily
🟢 Create professional MIS reports
🟢 Perform smart data analysis
🟢 Design performance dashboards
🟢 Automate reports to save time
🟢 Use Excel tools for better decision-making


Course Outcomes

This course covers everything from basics to advanced level Excel in a simple, practical way. It is perfect for beginners as well as working professionals who want to boost their career in analytics.

Course Curriculum

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

1 Date Time Formatting
48 Min

2 Number Text Formatting
1 Hour 17 Min

1 Time Saving Utility-01
1 Hour 13 Min

2 Time Saving Utility-02
42 Min

1 Cell Referencing
51 Min

1 Formula & Functions -01
1 Hour 4 Min

2 Formula & Functions -02
1 Hour 8 Min

3 Formula & Functions -03
1 Hour 5 Min

4 Formula & Functions -04
1 Hour 10 Min

5 Formula & Functions -05
56 Min

1 Nested Formula -01
58 Min

2 Nested Formula -02
1 Hour 35 Min

3 Nested Formula -003
1 Hour 15 Min

4 Nested Formula -04
1 Hour 13 Min

1 Go To Special
53 Min

1 Conditional Formatting
1 Hour 8 Min

1 Name Manager
30 Min

1 Data Validaion-01
26 Min

2 Data Validation -02
37 Min

1 Table
46 Min

1 Charts -01
56 Min

2 Charts -02
1 Hour 15 Min

1 Pivot Table -01
1 Hour

2 Pivot Table -02
1 Hour 19 Min

3 Pivot Table -03
54 Min

1 Array Formula -01
48 Min

2 Array Formula -02
54 Min

1 Protection
1 Hour 2 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

1. Assignments
2. Practice FIles

Instructor

Premchandra Kumar

0 Rating
0 Reviews
27 Students
4 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)
11 Students
Microsoft Excel is one of the most widely used tools in the world of business and jobs. From small companies to big corp...
₹5,999.00
Advance
Brainstorming Advance Excel Masterclass
0 (0 Rating)
6 Students
This course gives you a systematic learning path to overcome those pain areas. In Brainstorming Excel, we will go throug...
₹7,999.00

You must be enrolled to ask a question

Students also bought

Masterclass of Advance Excel
Beginner
  • 11 Lectures
  • 33 Hours
  • 0 (0 Rating)
  • 11 Students
  • ₹5,999.00
Brainstorming Advance Excel Masterclass
Advance
  • 2 Lectures
  • 33 Hours
  • 0 (0 Rating)
  • 6 Students
  • ₹7,999.00
Brainstorming Advance Excel Masterclass
Beginner
  • 0 Lectures
  • N/A
  • 0 (0 Rating)
  • 3 Students
  • ₹7,999.00

₹5,999.00

Add To Cart Buy Now

  • Duration 33 Hours

  • Lectures 34 lessons

  • Enrolled 7 students

  • Category: Excel Mastery

  • 0 Quizzes

  • Language: English

  • Skill Level Beginner

  • Certificate of Completion

  • 365 Days Access

Remove Coupon
Coupon Applied!

More Courses by Author

Discover Additional Learning Opportunities

View All
Static
Masterclass of Advance Excel
0 (0 Ratings)
7 Students
Microsoft Excel is one of the most widely used tools in the world of business and jobs. From small c...
₹5,999.00
Static
Masterclass of Advance Excel
0 (0 Ratings)
11 Students
Microsoft Excel is one of the most widely used tools in the world of business and jobs. From small c...
₹5,999.00
Static
Brainstorming Advance Excel Masterclass
0 (0 Ratings)
6 Students
This course gives you a systematic learning path to overcome those pain areas. In Brainstorming Exce...
₹7,999.00
Static
Brainstorming Advance Excel Masterclass
0 (0 Ratings)
3 Students
No matter how long you’ve been using Excel or how many reports you’ve made, we all get stuck with tr...
₹7,999.00

Shopping Cart

Loading...