Learn to manipulate complex data and derive insights through various visualization techniques by using the most popular tool and functions of Excel.
Course is not enrollable
Weeks
hrs/day
Students
COURSE OVERVIEW
Excel
Data Analysis
Data Manipulation
Business Sense
Data Modeling
Data Mining
Advanced Level
No coding experience required
Excel: Beginner - Advanced Preview Video
COURSE HIGHLIGHT
Automate your daily stuff using the most used tool in corporate world.
Learn how to play with data to come up with amazing insights
Create interactive and beautiful dashboards to present the data to large audience
THE ADVANTAGES
Learn skills that matter in the real world with a curriculum made for the needs of the industry
Solve real life case studies, learn by applying core concepts to real problems
Share your certificate and tell the world about your skills. Get certified!
Course is not enrollable
SYLLABUS
CHAPTER 1
Kick Start Microsoft Excel
120 mins
10 Video
1 Reading
7 Quiz
CHAPTER 2
Working with formula
50 mins
5 Video
1 Reading
4 Quiz
CHAPTER 3
Formatting
70 mins
6 Video
1 Reading
4 Quiz
CHAPTER 4
Modifying workbooks and worksheets
80 mins
6 Video
1 Reading
5 Quiz
CHAPTER 5
Text and Date functions
40 mins
4 Video
1 Reading
2 Quiz
CHAPTER 6
Exploring charts
60 mins
3 Video
1 Reading
2 Quiz
CHAPTER 7
Named Ranges
40 mins
4 Video
3 Quiz
CHAPTER 8
Conditional functions
80 mins
6 Video
1 Reading
4 Quiz
CHAPTER 9
Operators
40 mins
3 Video
1 Reading
3 Quiz
CHAPTER 10
Pivot tables
110 mins
5 Video
1 Reading
5 Quiz
CHAPTER 11
Data validation
60 mins
4 Video
1 Reading
4 Quiz
CHAPTER 12
Lookup functions
90 mins
5 Video
4 Quiz
CHAPTER 13
Auditing a workbook
80 mins
6 Video
4 Quiz
CHAPTER 14
Design Principles and building Interactive dashboard
180 mins
7 Video
3 Quiz
CHAPTER 15
Macros
80 mins
3 Video
2 Quiz
CHAPTER 16
Power Pivots
80 mins
4 Video
3 Quiz
CHAPTER 17
Data modeling
45 mins
3 Video
3 Quiz
CHAPTER 18
Data cleaning techniques
90 mins
3 Video
1 Quiz
CHAPTER 19
Understanding Business Funnels
60 mins
3 Video
1 Quiz
CHAPTER 20
Advanced Lookup Functions
120 mins
4 Video
3 Quiz
CHAPTER 21
Printing Workbooks
60 mins
3 Video
2 Quiz
CHAPTER 22
Building Professional Dashboard
90 mins
3 Video
1 Quiz
Book a session, ask your doubts away
CERTIFICATION
Certification recognized in 300+ companies
Prove that your skills are certified to employers
Be a recruiter-magnet in LinkedIn with your certifications
Course is not enrollable
TESTIMONIALS
FREQUENTLY ASKED QUESTIONS
Start your journey here