Drop us a line!

Call Now
Enquiry

Understanding Basic Consept of Excel

Working with Advanced Analytics Formulas

Creating effective Dashboard

Creating VBA Macros to increase the productivity

Data Analytics With Excel

  • 20 + hrs. Live Mentoring
  • 30 + hrs. Coding Assignments
  • 2 + Real-Life Projects
  • 1 + Industry cases

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

  Future of analytics & critical requirement

 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)

 Understanding of Sub and Function Procedures

 Key Component of Programming Language

 Understanding of If, Select Case, With End With Statements

 User Defined Function

 Some Commonly Used Macro Examples

 Error Handling

 Object and Memory Management in VBA

 User Form Controls

 ActiveX Controls

 Looping with VBA

 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.


RAJINDER

 Professional with over 14 years of experience.
 Specialization : Big Data & Hadoop, SAS, R, Python, MS Excel
 Companies worked with : HCL, NIIT, IBM, Tata AIG, CSC, BHEL, AIR FORCE, INDIAN NAVY

MONICA

 Professional with over 17 years of experience.
 Specialization :MS Excel & VBA
 Companies worked with : HCL, NIIT, I.E.&T, Guwahati , Mahindra Comviva , Orange , AON

ANSHUMAN

 Professional with over 10 years of experience.
 Specialization :Python, PHP
 Companies worked with : IBM, Gurgaon, HCL - Noida, CDAC - Delhi

BINIT KUMAR

 Professional with over 10 years of experience.
 Specialization :IoT, Embedded Systems

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.

Contact Us

Your Name
Your Email
Subject
Massege

Still not sure what you will learn?


Mentorship by Leading Experts


Mr. Manoj Yadav Learning Head

"Appreciate the way trainer handle our induction batch, and level of knowledge of that faculty is really good and appreciable."




Mr. R. Senthil Kumar Assistant Director T (Trg)

"Our Participants are highly satisfied with the quality of training (on R and Python), course material (if applicable), and level of knowledge that the faculty has. We appreciate the way trainer handled our training batches."




Ms. Anuradha Singhal Sr. Faculty

"Thanks for such a wonderful training on Data Analytics with Python... thanks to trainer also.. look forward to future collaborations as well ..."




Krishan Kumar Participant,Corporate Training Program, VisionSping

"Excellent Training Delivery on Advanced Excel by Antrix Academy, "




Ankur Tiwari Candidate

"I am very much satisfied with the quality of education which i got from Antrix Academy, The trainer is very much helpful and is also very much educated enough to solve your queries..."




Neelam Rajput HRM College,

"Antrix Academy of Data Science in Best Training Company Sector_15 Noida "




Shubham Saraswat IIT Delhi

"Best place in terms of content delivery. Faculty is experienced and teases your mind to every angle in terms of a data scientist and makes you think like a data scientist. Fee is nominal too.Batch strength is upto their commitment..."




Blessy Varghese IIMT College

"Happy to be here in this academy. Able to understand the contents pretty well."




Anju Kushwaha Student

"its a good ...as am a beginner they help me from my basic ....thanks for every things."




A N Singh Student

"Antrix academy is very good institute for Data Science and Machine learning in noida"




Abhishek Chaudhary Student

"best platform to learn languages and Data-Analytics"




Anuj Vashistha Student

"Best academy to learn about data science"




Monika Narang Ramjas College,Delhi University

"Excellent for practical learning"




xServer Skks

"Nn"




N U

"U"








Upcoming Batches

Online

Invest Now in a Data Science Career

The field of data science is thriving as it is proving to be effective not just across industries but also across departments within organizations.

In-Demand Skills

6 out of 10 developers are gaining or looking to gain skills in machine learning and deep learning.


Antrix Academy

High Salaries

Data scientists make around 75 Lakhs on average.



Antrix Academy

Shortage of Data Scientists

India alone will need around 2,00,000 data scientists by 2020



Speak to Our Course Advisor If You Have Queries

 

Our Participants are highly satisfied with the quality of training (on R and Python), course material (if applicable), and level of knowledge that the faculty has. We appreciate the way