Want to Connect with Live Sessions Click Here and Join
What will i learn?
- Fluency in advanced excel will help in 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
42 Lessons
04:45:57 Hours
Pivot Table, Slicer and Timeline
3 Lessons
00:48:00 Hours
- PIVOT TABLE 00:25:00
- SLICER and TIMELINE 00:15:00
- LARGE and SMALL 00:08:00
LOGICAL FUNCTIONS
5 Lessons
00:26:00 Hours
- IF FUNCTION 00:05:00
- AND & OR Functions 00:08:00
- COUNTIF and COUNTIFs Functions 00:05:00
- SUMIF and SUMIFs 00:05:00
- ISBLANK 00:03:00
CALCULATION FUNCTIONS
4 Lessons
00:18:00 Hours
- COUNT, COUNTA and COUNTBLANK 00:05:00
- SUM, LOWER, UPPER and PROPER 00:06:00
- MAX and MIN Functions 00:02:00
- MOD and INT Functions 00:05:00
LOOKUP FUNCTIONS
7 Lessons
01:10:57 Hours
- RANK Function 00:03:00
- CHOOSE and IFERROR 00:05:00
- HLOOKUP Function 00:03:00
- V Look UP 00:19:37
- Look UP Fuction 00:14:33
- INDEX AND MATCH Function 00:11:14
- X-LOOKUP Function 00:14:33
DATE FUNCTIONS
10 Lessons
00:31:00 Hours
- DATEDIF Function 00:07:00
- DATE, MONTH and YEAR 00:03:00
- TODAY and NOW Functions 00:02:00
- WEEKDAY Function 00:02:00
- EDATE 00:02:00
- EOMONTH 00:03:00
- WORKDAY 00:04:00
- WORKDAY.INTL 00:03:00
- NETWORKDAYS 00:03:00
- NETWORKDAYS.INTL 00:02:00
TIME FUNCTIONS
1 Lessons
00:05:00 Hours
- TIME CREATION and HOUR, MINUTE & SECOND 00:05:00
FINANCIAL FUNCTIONS
1 Lessons
00:04:00 Hours
- ROUND, ROUNDUP and ROUNDDOWN 00:04:00
TEXT FUNCTIONS
7 Lessons
00:31:00 Hours
- CONCATENATE, TRIM and LEN 00:10:00
- EXACT and DELTA 00:03:00
- TEXT Function 00:09:00
- CONVERT Function 00:02:00
- REPT 00:02:00
- FIND 00:03:00
- LEN Function 00:02:00
CHARTS & DASHBOARDS
4 Lessons
00:52:00 Hours
- Dashboard Introduction 00:25:00
- Option Button in Charts & Dashboards 00:17:00
- LINE CHARTS 00:05:00
- PIE CHARTS 00:05:00
Requirements
- Laptop or Desktop with 2010+ Microsoft Office Installed
+ View more
Description
This course provides flexibility for learning of more than 50 advanced functions and formulas, Pivot Table, Dashboard & Charts creation etc., a perfect platform to learn advanced excel with industry level examples.
+ View more
Other related courses
About the instructor
- 90 Reviews
- 5084 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