MS Excel Complete Course

About Course

Our Microsoft Excel Foundation training course gives you the most comprehensive insight into the most widely used spreadsheet, MS Excel. This course would help you learn Excel workbook, tables, cells, creating dashboard, interactive components, charting, filtering, sorting, PIVOT Table and data processing with real-world data sets.

Why Join this Course

comScore.com

Microsoft Excel has leading market share with over 750 million users worldwide

Forbes

Deep Excel expertise is a much sought-after skill around the world

View More
Course Fee FREE

Key Features

  • 15 Hours of Self Paced Learning
  • Quiz and Assignment for Quality Learning
  • Lifetime Access
  • All of the above FREE!

Course Curriculum

Introduction to Excel spreadsheet, learning to enter data, filling of series and custom fill list, editing and deleting fields.

Learning about relative and absolute referencing, the concept of relative formulae, the issues in relative formulae, creating of absolute and mixed references and various other formulae.

Creating names range, using names in new formulae, working with the name box, selecting range, names from a selection, pasting names in formulae, selecting names and working with Name Manager.

Various logical functions in Excel, the If function for calculating values and displaying text, nested If functions, VLookUp and IFError functions.

Learning about conditional formatting, the options for formatting cells, various operations with icon sets, data bars and color scales, creating and modifying Sparklines.

Introduction to dynamic table in Excel, data conversion, table conversion, tables for charts and VLOOKUP.

Sorting in Excel, various types of sorting including, alphabetical, numerical, row, multiple column, working with paste special, hyperlinking and using subtotal.

The concept of data filtering, understanding compound filter and its creation, removing of filter, using custom filter and multiple value filters, working with wildcards.

Creation of Charts in Excel, performing operations in embedded chart, modifying, resizing, and dragging of chart.

Introduction to the various types of charting techniques, creating titles for charts, axes, learning about data labels, displaying data tables, modifying axes, displaying gridlines and inserting trendlines, textbox insertion in a chart, creating a 2-axis chart, creating combination chart.

The concept of Pivot tables in Excel, report filtering, shell creation, working with Pivot for calculations, formatting of reports, dynamic range assigning, the slicers and creating of slicers.

Data and file security in Excel, protecting row, column, and cell, the different safeguarding techniques.

Learning about VBA macros in Excel, executing macros in Excel, the macro shortcuts, applications, the concept of relative reference in macros.

Learning how the If condition works and knowing how to apply it in various scenarios, working with multiple Ifs in Macro.

Learning to create Dashboards, the various rules to follow while creating Dashboards, creation of dynamic dashboards, knowing what is data layout, introduction to thermometer chart and its creation, how to use alerts in the Dashboard setup.

Understanding data quality issues in Excel, linking of data, consolidating and merging data, working with dashboards for Excel Pivot Tables.

Free Career Counselling

Career Services

Intellipaat career services are a part of our paid program that gives you an extra edge for employability.

Mock interviews

Will be arranged by our dedicated career support team in collaboration with the industry experts.

Aptitude and Soft skills training

Intellipaat’s technical team will provide one day workshop for all the student.

Resume Preparation

Students will be taught how to create an effective resume.

3 assured interview calls

Intellipaat will arrange interviews with top MNCs and startups.

Dedicated Learning Manager

Intellipaat will arrange interviews with top MNCs and startups.

24*7 Support for Doubt Clearance

Intellipaat will arrange interviews with top MNCs and startups.

Testimonials

121710409023 KODURU MANOJKUMAR

121710409023 KODURU MANOJKUMAR

It is a good platform to learn the concepts easily.

121710403050 VEDALA MOSES RUPAK RAJ

121710403050 VEDALA MOSES RUPAK RAJ

Good course. Delivered as expected.

jaideep.rjs

jaideep.rjs

This course provided immense learning, I'm grateful I enrolled for this course on Intellipaat. Also the faculty is amazing.

mohammedthoufiq.a.2017.bme

mohammedthoufiq.a.2017.bme

It's very useful and I learnt from it.thank you

ashokreddyrajolkar

ashokreddyrajolkar

GOOD REALLY HELPFUL

abhijitgp143

abhijitgp143

Good learning course

Sumit Nagpal

Sumit Nagpal

Great Learning

Uppada Deepak reddy

Uppada Deepak reddy

This course has helped me in learning the tricks in the excel and how to save time using shortcuts. This course also gave detailed explanation how to use other functions.

rj rocks

rj rocks

very knowledefull

EZEKIEL ISAIAH ANTHONY

EZEKIEL ISAIAH ANTHONY

I want to say a big thank you to Intellipaat academy for such a nice opportunity like this. It has been awesome all the way, acquiring new skills and updating my Excel Performance. Thank so much.

thakur.manish2932002

thakur.manish2932002

Nice structured course.

Vasishtha Wanve

Vasishtha Wanve

hi, course is very good but by mistakenly the quiz was submitted. Please help me in this issues as soon as possible

priyanshu.btech.ec17

priyanshu.btech.ec17

I ENJOYED LEARNING THIS COURSE VERY WELL EXPLAINED AND IN EASY WAY ALSO

mahadevboss1998

mahadevboss1998

Now i feel confident using Excel with that course.

miglani.dipesh

miglani.dipesh

Do I get certificate for this course?

naveen.modi

naveen.modi

dfghfdghfdghfgh

ravisharma982605

ravisharma982605

πŸ‘ŒπŸ‘ŒπŸ‘ŒπŸ‘πŸ‘πŸ‘

Atika gupta

Atika gupta

This is a very nice course to increase knowledge of excel

rahulprasad2823

rahulprasad2823

Privileged, to learn from this platform, gaining good skills and aquiring great knowledge from this platform. many more courses to go..... Thank You IntelliPaat.......

rahilkotadiya11

rahilkotadiya11

THE teaching skills needed for excel learning were indeed very good

Ngondzana Tikum Michael

Ngondzana Tikum Michael

I enjoyed the course. it has permitted me to deepen my knowledge in Excel particularly on function s and VBA and Macros.

Course Advisor

Niraj Kumar

Co-founder & CTO, DataMetica

Niraj has over 12 years of experience in the field of IT. He deals with everything from designing various architectures, developing methodologies in Machine Learning, AI, and Full Stack Development to handling Big Data and many more for top Fortune 500 companies.

Diwakar Chittora

Co-founder & CEO, Intellipaat

He has more than 11 years of experience in developing large-scale BI products for Fortune 500 companies and has great experience in doing data analytics on large-scale data. He has worked in companies like Amex, Mercedes Benz Research, Pentaho, and Wipro in the past.

Muthusamy Manigandan

Head Engg., Amazon India

Mani comes with great experience working on algorithms, Data Science, Big Data, and AI. He has worked on multiple research projects in the past on Data Science, AI,and ML for display advertising, recommendation and classification systems,etc. He comes with 16+ years of experience with building large-scale AI products for top MNCs.

Our alumni work at

Our Alumni

FAQ's

  • Microsoft Excel has leading market share with over 750 million users worldwide – comScore.com
  • Excel is used by Finance, Sales, Marketing, HR and other departments
  • Deep Excel expertise is a much sought-after skill around the world

Microsoft Excel is being used by almost all companies today. By taking this training course, you will be able to work effortlessly with data, be it financial, accounting, statistical or other data related to sales and marketing. You will be able to process data and gain valuable insights using various formulae, functions, graphs and charts. This will help you get a good job in a company of your choice for a competitive pay scale.

A zeal to learn and a working internet connection! There are no pre-requisites to this free course πŸ™‚

Anyone who wants to start off in the domain of Spreadsheets, primarily Excel. This course should help you skip the initial steps of researching and learning about Excel

After going through this Excel Free Course you will understand:

  • Introduction to Excel
  • Referencing in Formulas
  • Formatting
  • Sorting and Filtering
  • Charts
  • Ensuring Security
  • Pivot Tables
  • Functions
  • VBA Macros
  • Dashboard

Talk to us

Attend ExpertClasses From Top Industry Experts and Master New Skills !