Want to Connect with Live Sessions Click Here and Join
What will i learn?
- We will learn advanced excel on vast level to give us more opportunities for career building
- Learn the Data Analysis
- Learn how to import & consolidate the data
- Lean the Sort & Advance Filter Options
- Learn about Charts & Tables
- Learn the use of Pivot Tables & Chart
- Learn how to create Dashboards
- Learn about Form Controls
- Lean the VBA & Macros
Curriculum for this course
11 Lessons
04:24:00 Hours
Data Mining
2 Lessons
00:55:00 Hours
- Understanding all Pivot Table options 00:20:00
- Slicers, Timeline, Charts and Pivot Tables 00:35:00
Advanced Excel Functions & Formulas
9 Lessons
03:29:00 Hours
- MS Excel - Advanced Training 00:30:00
- IF/Nested IF function along with AND & OR 00:25:00
- CountIF-CountIFs and SumIF-SumIFs 00:18:00
- VLookup & HLookup 00:35:00
- Index and Match Functions 00:18:00
- Date Functions - Workday, Networkday, EoMonth, Edate, DateDiff etc. 00:33:00
- Time Functions along with INT and MOD 00:16:00
- Substitue,Replace,Choose,Rank Etc. 00:20:00
- Left, Right, Mid and Find Functions 00:14:00
Requirements
- Laptop or desktop along with the latest version of Microsoft Office installed
+ View more
Description
Our advanced excel training course is designed in such a way that it includes the content as per the current industry requirement. It will give us detailed training about multiple advanced excel features like pivots, slicers, timeline, charts, dashboards, data mining, 50+ functions & formulas
+ View more
Other related courses
About the instructor
- 89 Reviews
- 5030 Students
- 3 Courses
+ View more
Whiz at data analyst and data mining with more than 18 years of experience.
Student feedback
Reviews
Write a public review