Analytics With Excel

Course Structure

Course Objectives

This course has been designed to help you learn Microsoft Excel from very basic to advanced level. The course is packed with practice exercises that provides you hands-on learning and helps you become an expert in MS Excel. The course includes Excel functions, different types of charts, pivot tables along with excel macros.

Course duration: 42 hours
Mode: Classroom / Online Instructor Led through Virtual classroom

Key Features

  • 20 hours of instructor led live training on weekends
  • Hand-on practice on 5 case studies
  • Lifetime access to our Learning Management System
  • Personal attention from our faculties
  • Performance evaluation
  • 30 hours of self learning
  • Practice exercises, assignments and case studies
  • Faculties from IIT/IIMs with rich industry experience
  • Full access to video lectures for self paced learning
  • 100% moneyback guarantee
Fundamentals & Excel functions
Understanding quick access toolbar. Text functions. Logical & information functions. Lookup functions. Date & time functions. Math functions. Statistical functions
Pivot tables
Introduction. 4 areas of excel. Customizing pivot table reports. Pivot-Driven views. Adding interactivity with sliders
Mastering excel ranges & formulas
Introduction to ranges. Using range names. Building basic formulas. Creating advanced formulas
Recording macros. Running macros. Macro examples

Is this course for you?

You should take this course if you are a:

  • Student (UG/PG) and want to learn MS Excel
  • Enthusiast who wants to enhance their skills with MS Excel
  • Job seeker who wants to build career in data analysis using MS Excel

What are the pre-requisites of the course?

There are no pre-requisites to take this course

At the end of the course you will be entitled to Simplify Analytics "Microsoft Excel Training" certificate, provided you fulfil the following terms:

  • Completion and submission of all case studies
  • Attend all the sessions
  • Clear the final online test by minimum 60%
What is the mode of this training course?
Classroom & Online instructor led. Classroom sessions are held at multiple training centres located in Delhi-NCR region. Live online sessions are conducted through our "Virtual Classroom". This will allow you to attend the course remotely from anywhere through your desktop/laptop/tablet/smartphone. Video recording of each session is provided at the end of live session.
Do I need to have computer programming background to take the course?
No, you don’t need to have a programming background to learn analytics. The program has been designed in a way that it starts from scratch and makes it easier to learn for everyone.
What if I miss a class?
You can attend the missed session, in any other live batch. You can also use the video recording of the session you missed.
What kind of placement assistance is offered by Simplify Analytics?
We are committed to getting you placed. All our courses include - Real life projects + Internship + Certificate + Interview QnA + Resume building & sharing + Job search guidance + Interview call assistance.
What if I still have doubts after attending a live session?
You can retake a class as many times as you wish across multiple batches. Also, we conduct separate doubt clearing sessions to help our students. We make sure that you understand all the concepts and are able to build solutions.
What if I want to cancel my enrollment post registration? Will I get a refund?
Yes, we have a 100% money back policy which allows you to cancel your enrollment after the first two classes (before third class). If you are not satisfied from the program, all your money will be refunded back to you.
What are system requirements?
You will require a laptop or workstation with a minimum 2 GB RAM & i3 processor (or equivalent) to practice & submit assignments. No constraint on OS.
Thank you for choosing "Analytics With Excel" Training Program

Course reviews
  1. Simplify Analytics - Course reviews
    5.00 out of 5

    Vaibhav Nellore

    Very knowledgeable!! Asks stimulating questions..Jaydeep is too good at explaining ideas; well designed course with great content.

  2. Simplify Analytics - Course reviews
    5.00 out of 5

    Rohit Kumar

    Great teaching techniques help you dwell into the field of analytics. would really recommend to anyone looking for a career in analytics