Advance - MS Excel

In this course we will learn advance excel and content will including pivots, charts, dashboards, functions & formulas and a lot more.

Advanced 19 Students enrolled
Created by Rupendra Singh Updated course English
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
01:50:00 Hours
Updated Sun, 08-Jan-2023
3913 Free
04:45:57 Hours
Updated Wed, 10-May-2023
2 ₹499 ₹399
03:37:23 Hours
Updated Fri, 21-Apr-2023
0 ₹599 ₹299
03:05:57 Hours
Updated Thu, 07-Sep-2023
0 ₹699 ₹299
About the instructor
  • 67 Reviews
  • 3923 Students
  • 3 Courses
+ View more

I am an experienced professional carrying an experience of more than 16 years with multinational companies. Currently working with a renowned multinational organisation as a Manager.

Student feedback
0
Average rating
  • 0%
  • 0%
  • 0%
  • 0%
  • 0%
Reviews
₹399 ₹699
Buy now
Includes:
  • 04:24:00 Hours On demand videos
  • 11 Lessons
  • Access on mobile and tv
  • Full lifetime access
  • Live sessions with instructor
  • Completion certificate
  • Practice sessions
  • Compare this course with other

"