This MS Excel course will help you acquire a comprehensive understanding of MS Excel as a tool and explore its numerous features and functions like sort, filter, import, etc. You will be able to make use of MS Excel for the tracking and management of data-driven projects, which is essential in the IT industry.
Various Techniques of Charting
Pivot Tables in Excel
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.
Sr. Consultant - Projects | India
Post this training, I received recognition from my organization, KPMG, and was able to get promoted from Consultant to Senior Consultant. Mainly, practical learning has helped me alot in my current role.
Sr. Consultant - Projects
Program Manager | Pune
Thanks to Intellipaat, I was able to switch to the role of a Program Manager from a Microsoft Dynamics Consultant. Gaining knowledge in the latest technologies as per industry standards helped me the most.
Microsoft Dynamics Consultant
SCM Procurement Functional Excellence | USA
This training helped me transform into an SCM professional from a Project Trainee. The expert instructors impart a deep understanding of the important concepts and techniques in the domain.
SCM Procurement Functional Excellence
Project Lead | Pune
With this training, I was able to shift from a Senior Software Engineer to a Project Lead at LTI. I would highly recommend this training to anyone willing to get into the field of project management.
Senior Software Engineer
Sr. Software Engineer | Hyderabad
Even after being from a non-tech field, I attained the necessary skills to become a Senior Software Engineer through this program. The major concepts were taught with ease and in lucid language, along with real-life projects.
Sr. Software Engineer
45% Average Salary Hike
$1,10,000 Highest Salary
1200+ Career Transitions
400+ Hiring Partners
An excellent institution that teaches the students starting with the basics and helps them to excel in what they learn. I would say it is value for money. The support team is also excellent in responding with solutions.
I never knew the faculty would be so great. The trainer also guided me what kind of questions may come, how to tackle them, etc. The course fee was very low and on top of that, I got a discount.
It is a great platform to learn and enhance your skills.
I loved my experience with Intellipaat and would highly recommend it to everyone. The course content was very good and well-structured, and the instructors were very knowledgeable and helpful.
I had a really good experience while doing my course from Intellipaat. The trainers have adequate knowledge and experience. I would recommend Intellipaat to anybody for e-learning.
I am from a nontechnical background and wanted to switch careers. Intellipaat helped me make this transition. Their syllabus is extremely good and they provide very good support. They resolve all queries then and there.
Great learning here Thakyou LinkedIn.
Great learning course.
Great learning course. Would recommend everyone to take part in this and improve your excel skills.
Thank you for such elaborated course.
Here is why you should consider signing up for this self-paced Excel training:
Microsoft Excel is being used by almost all companies today. By taking this training course, you will be able to work effortlessly with data related to finance, accounting, statistics, or sales and marketing. You will be able to process data and gain valuable insights using various formulae, functions, graphs, and charts. Learning Excel skills can be an added advantage and help you receive better job opportunities.
There are no prerequisites to sign up for this online MS Excel course. All you need is a good internet connection, and you are good to go!
Anyone who wants to start off in the domain of spreadsheets, primarily Excel can apply for this course. This course will help you quickly familiarize yourself with the fundamentals of MS Excel.
After going through this Excel course, you will understand: