You will learn
Learn the basic operations and formulas of excel.
Learn the different functions of excel: text, mathematical, statistical functions, and financial functions.
Learn the importance of charts and its different types.
Learn sorting, filtering and creating pivot tables.
What do you get
Placement TrainingGet complimentary access to placement training to ace your internship/job hunt.
Industrial ProjectMake a sales plan for an insurance company 'ABC Pvt. Ltd.' using various input metrics and assumptions (rules)
Hands On ExercisesYour training is packed with assignments, assessment tests, code challenges, quizzes and exercises
Certified TrainingAt the end of your training program you will be awarded with certificate of completion.
Live chat supportInteract with teaching expert over 1 hour daily live chat.
Forum supportPost your queries on forum and get it answered within 24 hours.
Frequently Asked Questions
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, 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?
(Valid till )
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.