Save Rs. 2,500/- as First Time User discount. Offer ends

ONLINE Summer TRAINING ON Advance Excel

Powered by

Details

Rs. 3999/- 1499/-   (Valid only for today)
Advance Excel Training Project.png

No Batches Available.

Training Details


The Internshala Online Summer Training Program on Microsoft Excel is a 4 weeks training program covering the Basic and Advanced modules of MS-Excel. Following are the details of this training:

Content

  • Introduction
  • Getting Started
  • Excel Formatting
  • Excel Operations
  • Sheet Operations
  • Formulas
  • Paste Special And Format
  • Challenge
  • Text Functions
  • Mathematical Functions
  • Error Handling and Logical
  • Statistical Functions
  • Date and Time Functions
  • Financial Functions
  • Look-Up Operations
  • Assignment 1
  • Assignment 2
  • Importance of Charts
  • Components
  • Types of Charts
  • Selection and Formatting
  • Sparkline
  • Advanced Charts
  • Project
  • Sorting & Filtering
  • Advanced Filter
  • Conditional Formatting
  • Pivot Table I
  • Pivot Table II
  • Pivot Table III
  • Hyperlinks
  • Tables
  • Validation
  • Protection and Print
  • Analysis Tools

Project

The aim of this project is to make students understand the usefulness & applications of excel using a real life case study.

At the end of this training, students will make a sales plan for an insurance company "ABC Pvt. Ltd." using various input metrics and assumptions (rules). Input metrics will be in raw data form. You will be required to group and link information available in the table, generate inferences, making it more meaningful, adding visual elements with the help of pivot, formulas and data visualization techniques. You will be also required to automate this tool i.e. addition and deletion of raw data or assumptions, which should have direct impact on output, transforming it in a dynamic system.

Students will be provided with data sets and assumptions to generate sales plan. Detailed solution for the project will also be provided.

Delivery

Advance Excel Training Delivery.png

If you have any queries or require any additional assistance, please write to us at vtc-support@internshala.com or call us on +91 85860 80747.

FAQs


What is this training program about?

This is an online summer training program in the field of Analytics. Students will be trained in the basics of Excel Basics, Functions, Data Visualization and Advanced Excel concepts.

What would be course content? Who would be my instructor?

The course will cover the basics of Excel, Charts and Tables, Statistics, and Pivot Table. The course content has been developed in joint collaboration with Analytics Vidhya - India's leading Analytics Knowledge Portal. Analytics Vidhya team will also be the one clearing your doubts through live chat and answering your queries on the forum.

What are the benefits of joining this training program?

Microsoft Excel has the basic features of all spreadsheets,[2] using a grid of cells arranged in numbered rows and letter-named columns to organize data manipulations like arithmetic operations. It has a battery of supplied functions to answer statistical, engineering and financial needs. In addition, it can display data as line graphs, histograms and charts, and with a very limited three-dimensional graphical display. It allows sectioning of data to view its dependencies on various factors for different perspectives (using pivot tables and the scenario manager).

What are the timings of this training program?

As this is a purely online training program, students can choose to learn at any time of the day. We will recommend a pace to be followed throughout the program, but the actual timings can be decided by students according to their convenience.

Will there be a certificate provided at the end of the training?

Yes, a certificate will be provided by Internshala upon completion of the training. Students may download a soft copy of the certificate through our portal.

Who can join?

Anyone with an interest in Analytics (College students (every stream and year) & Working Professionals) are eligible to join this program. Please note that this is a beginner level training.

How will the training be imparted?

Training will be delivered using state of the art online tutorials and interactive exercises provided. Experts from Analytics Vidhya will be available to clear your doubts through live chat and will be answering your queries on the Q&A forum. Please note this is NOT an instructor led training.

How would you solve my doubts and queries?

We shall have an online doubt clearing system (live chat + forum) in place to address your doubts.

What is the duration of this training?

This is a 4 weeks training.

How much would it cost?

Rs. 1499/-   (Valid only for today)
Rs. 3999/- regular fees.

Will there be any project that I will get to work on?

Yes. At the end of this training, students will make a sales plan for an insurance company "ABC Pvt. Ltd." using various input metrics and assumptions (rules). he problem statement and solutions for this will be provided.

I am a beginner/advanced user, is this training program for me?

This program would be better suited to beginners who have no prior knowledge of analytics.

Are there any pre-requisites for joining this program?

This program is for beginners. There are no pre-requisites.

Will I be able to download the course content?

Yes, you can download entire course content towards the end of your training. The download link will be available on your home page 18 days after start of your training till the end of your training.

Can the material be used by a group of students?

No. These trainings are meant for individual users. Multiple users will not be allowed to access the portal using the same account.

If you have any queries or require any additional assistance, please write to us at vtc-support@internshala.com or call us on +91 85860 80747.

Sample certificate


Students undergoing the Internshala VTC online Summer training on Advance Excel will be certified by Internshala. Following is a sample certificate that will be issued to students.

Advance Excel Training Certificate.png
Advance Excel
Aarti Gandhi

from D.A.V Institute of Engineering and Technology has successfully undergone a four weeks online Summer training on Advance Excel. The training program consisted of Excel Basics, Excel Functions, Data Visualization and Advanced Concepts and lasted for four weeks from 23rd March, 2017 to 22nd April, 2017.
In the final assessment at the completion of the training program, Aarti scored 90% marks.
We wish Aarti all the best for future endeavours.

Placement Preparation Module


Along with this course, you will also get complementary (free of cost) access to the Internshala placement preparation module, which is a package to help you ace your placements/ internships hunt. You will learn how to write your resume, cover letter and how to prepare for your interviews. This module is only available exclusively to Internshala VTC users.

Click here to view details.