Save Rs. 3,000/- as First Time User discount. Offer ends in 21h: 57m: 33s. Enroll Now!

Training Highlights

Learn from home

Stay safe indoors

Certificate of Training

From Internshala Trainings

Placement assistance

To build your career

75 video tutorials

Learn anytime, anywhere

4 assignments & 1 project

For hands-on practice

Doubt clearing

Through Q&A forum

Beginner friendly

No prior knowledge required

4 weeks access

To the platform

Downloadable content

With lifetime access

How will you get your certificate?

Take the final exam online to complete the Advanced Excel Training after which you will be able to download your certificate from Internshala Trainings

search_plus

What placement assistance will you receive?

Free Placement Preparation Training

Access to curated Internships & Jobs

Top performers will be highlighted in their internship & job applications on Internshala

Why learn Advanced Excel?

Love for analysis

If you love organizing, analyzing, and visualizing data, Excel is the most fundamental tool you must know.

Jack of all trades

Whether you are an engineer, a data scientist, a marketer, an analyst, a researcher, or a chartered accountant - everyone needs Excel.

Valued by businesses

Excel is used by almost every business in the world and being good at it will take you far in your career.

How will your training work?

1

Watch the videos to learn various concepts

2

Test your knowledge through quizzes & module tests

3

Get hands on practice by a project

4

Take the final exam to get certified in Advanced Excel

What will be the training syllabus?

Getting Started with Excel

9 Topics
Introduction to Excel
Why Should we Learn Excel?
Orientation/Tour
Interface & Terminology
Excel Worksheets
Excel Ribbon
Backstage View
Quick Access Toolbar
Keyboard Shortcuts
Introduction-Food2Go
Cell Basics
Modifying Cells/Rows/Columns
Basic Cell Formatting
Cell Number Formats
Cut, Copy & Paste
Format Painter
Personalizing Worksheets
Multiple Worksheets
Find & Replace
Sheet Protection
Printing & Page Layout
Introduction
Basic Formulas
Advanced Formulas
Cell References
Excel Functions
Date/Time Functions
Text Functions
Financial Functions
Logical Functions
Lookup Functions-1
Lookup Functions-2
Data Validation
Troubleshooting
Working with data
Freezing Options
Data Sorting
Data Filtering
Tables
Charts
Conditional Formatting
What-If Analysis
Pivot Tables
The End

What project will you build?

How will your doubts get solved?

You can post your doubts on the Q&A forum which will be answered by the teachers within 24 hours.

Who will be your teacher?

Reviews from students

Commonly Asked Questions

There are no prerequisites for this training as it is of beginner level. Everything that you need to know about Advanced Excel would be taught to you from scratch.

Here are a couple of ways that you can get Microsoft Excel -

  • Microsft office offers a free subscription for 1 month on its official website
  • Speak to your college and see if they provide Microsoft Excel software to students
  • Speak to your friends or seniors to check if they have the software and they can lend it to you

You can watch the videos and take quizzes & tests on any device including mobile. However, for assignments and practice, use of desktop or laptop is required.

To do this training, you would need a computer with 4 GB ram (recommended) and Windows 7 or later (64 bit).

You can choose your preferred batch date while signing up for the training program and start accordingly.

As this is a purely online training program, you can choose to learn at any time of the day and for as much time as you want. We will recommend a pace to be followed throughout the program, but the actual timings and learning hours are in your hands.

From your batch start date, you will have access to training’s content (videos, quizzes, tests, assignments, projects etc.) in the platform for 4 weeks with-in which you should be able to complete your training.

As this is a purely online training program, you can choose to spend as much time as you want per day and the more time you spend, sooner you would be able to complete the training. However, on an average, spending 1-2 hours per day should be sufficient for you to complete the training in 4 weeks. Some students also choose to devote more time on the weekends in case they are not able to give time on the weekdays.

Don’t worry! If for some reason, you are not able to complete the training in 4 weeks; we would extend your access to the platform for sufficient duration (maximum upto another 4 weeks) so that you can complete it.

Having 4 weeks access ensures you have a deadline to work with and are able to complete the training. It also helps you beat procrastination and maintain continuity in your studies which is why Internshala Trainings students have some of the best training completion rates in the industry.

If you have completed the training, you would be able to download the training content and have lifetime access to it for future reference.
If you are not able to complete the training in given 4 weeks, we would extend your access to the platform for sufficient duration (maximum upto another 4 weeks) so that you can complete it.

Yes, you would be able to download the training content and have lifetime access to it for future reference.

No, you will be only getting a soft copy of the certificate which you can download and print out if required.

  • You will receive free access to Placement Preparation Training on the platform which covers resume writing, cover letter writing, how to search and apply for internships and jobs on Internshala, and interview preparation. This training comes with a lifetime access meaning you can use it later also if you are not applying for internships or jobs right now.
  • Access to curated internships & jobs related to the training - after completing the training, you would receive a list of handpicked internships or jobs every week that you can apply to as per your preference.
  • If you are a top performer, a badge of achievement will be added to your Internshala resume and shown to the employers when you apply to internships or jobs on Internshala.

When you score >= 90% in the final test, you will be a top performer and you will get highlighted in your internship and job applications.

While many of our students have found their desired internships or jobs after completing their training, Internshala Trainings does not guarantee an internship or job. However, if you study sincerely (including doing exercises, assignments, and projects) and make good use of our placement assistance feature, it will become easier for you to get a placement using the skills learned in the training.

More than 100,000 companies use Internshala to hire interns and employees and hence they will recognise a certificate from Internshala when they see one on your resume. However, please note that more than the certificate, companies hire candidates based on their skills and their performance in the interview so we hope you do a good job of learning the skill in the training and preparing for the interview using our placement assistance feature.

You could try making the payment from a different card or account (of a friend or family). Otherwise, you can follow the instructions on how to make an offline payment here.

Just let us know your registered email id along with the screenshot of the payment receipt or transaction history. You can submit your request using the option available in the last section below. Once verified, the additional amount you paid will be refunded.

The amount deducted will come back to your account within 7-10 working days. This is the normal duration your bank will take to credit the amount back into your account.

At times, there may be a slight delay in your payment reflecting on your Internshala Trainings dashboard. However, if your payment is not reflecting even after 30 minutes, please let us know your registered email id along with the screenshot of the payment receipt or transaction history. You can submit your request using the option available in the last section below. Once verified, we will update your payment status from the backend.

Certificate Placement Syllabus Projects Teachers Reviews

4499/-

1499/-

Valid till 30th Sep