This course covers advanced MS-Excel Learning in a quick way with very effective and easy to understand examples

Created by Rupendra Singh Updated course Hindi
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
• 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
01:50:00 Hours
Updated Fri, 08-Mar-2024
4841 Free
04:24:00 Hours
Updated Fri, 08-Mar-2024
21 ₹699 ₹399
• 87 Reviews
• 4853 Students
• 3 Courses
+ View more

Whiz at data analyst and data mining with more than 18 years of experience.

Student feedback
0
Average rating
• 0%
• 0%
• 0%
• 0%
• 0%
Reviews
₹399 ₹499
Includes:
• 04:45:57 Hours On demand videos
• 42 Lessons
• Access on mobile and tv