Advance MS-Excel

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

Advanced 3 Students enrolled
Created by Rupendra Singh Updated course Hindi
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
01:50:00 Hours
Updated Fri, 08-Mar-2024
4268 Free
04:24:00 Hours
Updated Fri, 08-Mar-2024
21 ₹699 ₹399
About the instructor
  • 80 Reviews
  • 4279 Students
  • 4 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
Buy now
Includes:
  • 04:45:57 Hours On demand videos
  • 42 Lessons
  • Access on mobile and tv
  • Full lifetime access
  • Live sessions with instructor
  • Completion certificate
  • Practice sessions
  • Compare this course with other

"