Course / Course Details

Masterclass of Advance Excel

  • Premchandra kumar image

    By - Premchandra kumar

  • 0 students
  • 35 Hours
  • (0)

Course Requirements

No prior Excel knowledge is needed. Just a laptop with Excel (2016 or later) and a willingness to learn. This course will help you work faster, analyze data, and automate tasks easily.

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 course, you will be able to use advanced Excel functions, create dynamic reports and dashboards, automate tasks with VBA, and handle large data sets efficiently—boosting your productivity and decision-making skills.

Course Curriculum

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


1 Data Consolidation
34 Min


1 Advance Filter
58 Min


2 Advance Filter-2
1 Hour 11 Min


1 Protection
1 Hour 10 Min


1 Array Formula-1
48 Min


2 Array Formula-2
54 Min


1 Pivot Table -1
1 Hour


2 Pivot Table-2
1 Hour 18 Min


3 Pivot Table-3
54 Min


1 Charts-1
56 Min


2 Charts-2
1 Hour 14 Min


1 Table
47 Min


1 Data Validation
26 Min


2 Data Validation
37 Min


1 Name Manager
30 Min


1 Conditional Formatting
1 Hour 7 Min


1 Go To Special
53 Min


1 Nested Formula-01
58 Min


2 Nested Formula-02
1 Hour 35 Min


3 Nested Formula-03
1 Hour 14 Min


4 Nested Formula-04
1 Hour 13 Min


1 Formula & Functions-01
1 Hour 3 Min


2 Formula & Functions-02
1 Hour 7 Min


3 Formula & Functions-03
1 Hour 15 Min


4 Formula & Functions-04
1 Hour 9 Min


5 Formula & Functions-05
57 Min


1 Cell Referencing
51 Min


1 Time Saving Utility-01
1 Hour 12 Min


2 Time Saving Utility-02
42 Min


1 Date & Time Formating
48 Min


2 Number & Text Formatting
1 Hour 17 Min


1 What if Analysis
1 Hour 4 Min


2 Solver
44 Min


Instructor

0 Rating
0 Reviews
4 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...

You must be enrolled to ask a question

Students also bought

More Courses by Author

Discover Additional Learning Opportunities