Drop us a line!

Data Analytics with Excel

Advanced Formulas, Conditions, Filters, Conditional Formating, Pivoting, Lookups, Securing Excel File, VBA Macros. 2 Months (Weekend Batches)
10,000 (Inclusive of Taxes)
Online as well as Classroom Trainings are available

Modules Included

Relevance in industry & need of the hour
Types of analytics – Marketing, Risk, Operations, etc
Business & Technology drivers for analytics
Future of analytics & critical requirement
Types of problems and business objectives in various industries
Different phases of Analytics Project
Introduction to Excel
Working with Formulas and functions
Formating & Conditional Formating
Filtering, sorting, paste special etc
Functions (Logical & Text, Mathematical, Statistical etc)
Data Manipulation & Data Aggregation
Data Analysis using functions
Analyzing Data using Pivots
Descriptive Statistics
Creating Charts & Graphics
Data analytics tool (What -if analysis, Goal seek, Data Table, Solver)
Protecting Workbooks, worksheets and formulas
Working with VBE (Visual Basic Editor)
Introduction to Excel Object Model
Understanding of Sub and Function Procedures
Key Component of Programming Language
Understanding of If, Select Case, With End With Statements
Looping with VBA
User Defined Function
Some Commonly Used Macro Examples
Error Handling
Object and Memory Management in VBA
User Form Controls
ActiveX Controls
Communicating with Database MS Access through ADO - Exporting /Importing Data

What You Get?

Learn from our comprehensive collection of project case-studies, hand-picked by industry experts, to give you an in-depth understanding of how data science moves industries like telecom, transportation, e-commerce & more.
  1. Global Sales Store Data Analytics - WallMart
  2. Service Calls & Engineers Utilization Data Analytics – HCL Services
  3. Clinical Data Analytics of Cancer Patients Diagnosis & Medication – Global Health Care
  4. Data Analytics of Training & Development Program of Defense Forces – Indian Navy ...many more...
You will be having the opportunity of 10-15 Hrs e-learning exercises along with instructor-led-training which enable candidates to get the maximum out of the subjects and empowering them to build logics to hand any new requirement.
This program has been designed in collaboration with some of the most influential analytics leader and top academician in data science.

Final Outcome

Thanks to the digital revolution that is sweeping the world and India in particular, data scientists are now the most sought-after professionals by big corporations as well as startups. And companies across industries are rewarding good data analysts and scientists with desirable career growth and salaries.