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 21 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 Fri, 08-Mar-2024
4957 Free
04:45:57 Hours
Updated Fri, 08-Mar-2024
4 ₹499 ₹399
About the instructor
  • 88 Reviews
  • 4969 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 ₹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

"