Blog
Log In
Sign Up
Join as Author
3 Days Live Training on Advanced Excel and Dashboard for Data Analysis
Advanced Excel and Dashboard for Graduates and Engineers
-
Training TypeLive Training
-
CategoryMS Excel
-
Duration15 Hours
-
Rating4.8/5


Course Introduction
About the Course
Spreadsheet software is one of the most demanding software used in workplaces around the world.
Excel is the spreadsheet market leader.
You learn to apply your skills and techniques to automate Repetitive Task
You will clean and prepare data for analysis,
Working on various formulas and functions
Creating Charts, pivot tables and Dashboard
Course Objective
Learn how to use Excel for analytics
You will clean and prepare data for analysis,
Working on various formulas and functions
Creating Charts, pivot tables and Dashboard
Apply techniques for Daily and Repetitive Task
Who is the Target Audience?
Who are looking to efficiently analyse large data sets and create dynamic dashboard reports
Basic Knowledge:
Have some working knowledge of Microsoft Excel
Related Virtual Classroom
Available Batches
Request a Batch That Is Most Convenient For You
Pricing
Live
Single Attendee
249
416
Live Session
Recorded
Single Attendee
299
499
6 month Access for Rec
Live+Recorded
Single Attendee
349
583
6 month Access for Rec
Group Offer
Single Attendee 40% Off -
Upto 9 Attendee 45% Off -
10 or More Attendee 50% Off
Curriculum
Total Duration : 15 Hours
Table of Contents
-
Introduction & Overview
-
Get Started
-
Working On Excel Sheets
-
Formula Basics
-
Formula and Function Tools
-
IF and Related Functions
-
Lookup and Reference Functions
-
Power Functions
-
Math, Date, Time and Statistical Functions
-
Array , Reference ,Text and Informal function
-
Pivot Tables -conditional formatting & charts
-
Macros and filtering in pivot tables
-
Data Validation - numeric, date/ time, DDList
-
Specialized Custom Formula Controls
-
Charts, types, tabs , Analysis and Formatting
-
Building Dynamic Charts
-
Revision & QnA