Skip to main content

Data Analytics Using Excel

Data Analytics Using Excel Image

ABOUT THIS COURSE

This is a foundation course on Microsoft Excel. Microsoft Excel is a software program developed by Microsoft that allows users to organize, format, calculate and visualize data using spreadsheets and charts with the help of a large body of formulas and tools. It is part of the Microsoft Office suite and is compatible with other applications in the Office suite.

Today, good knowledge and skill in Microsoft Excel is considered as must-have, for any technical, business and financial job as well as for pursuing any higher education course. Most employers expect that freshers and entry-level candidates will have a high degree of familiarity and competency in Microsoft Excel. Strong in-depth knowledge and skill in Microsoft Excel can differentiate a candidate in a large pool of job applicants.

Excel is a very powerful application with thousands of features and hundreds of ribbon (menu) commands. Without any structured guidance, it is very easy to get lost once you open Excel. Therefore, we have designed this course with the objective of making you familiar with the fundamentals of Excel in an easy to follow and fun format, to help you to become a proficient user and be able to figure out the right tool for analyzing or solving a particular problem. We expect candidates to compete this course in 3-weeks.

Excel is a very powerful application with thousands of features and hundreds of ribbon (menu) commands. Without any structured guidance, it is very easy to get lost once you open Excel. Therefore, we have designed this course with the objective of making you familiar with the fundamentals of Excel in an easy to follow and fun format, to help you to become a proficient user and be able to figure out the right tool for analyzing or solving a particular problem. We expect candidates to compete this course in 3-weeks.

After successfully completing this course, you may further enhance your Excel data analysis and modeling skills by enrolling in our advanced courses on Microsoft Excel.

TOPICS YOU'LL LEARN AND PRACTICE

Basics of MS Excel, Calculate Average In Excel, Count The Cells Containing Numbers In Excel, Join Content Of Multiple Cells In One Cell In Excel, Calculate Percentage In Excel, Countblank Cells In Excel, IF Formula In Excel, CountIF Formula In Excel, Vlookup Formula In Excel, Sumif Formula In Excel, Hlookup Formula In Excel, sverageif Formula In Excel, Pivot Table In Excel, Insert Comment In Excel, Wrap Text In Excel, Chapter 27 Merge Cells In Excel, Number Formatting In Excel, Paste Special In Excel, Sort In Excel, Convert Columns To Rows In Excel, Conditional Formatting Cells Rules In Excel, Conditional Formatting Top Bottom In Excel, Excel Bar Graph, Excel Column Graph, Create Pie Chart In Excel, Use Hyperlink In Excel,Data Validation With List, Remove Duplicates In Excel, Add Password To Excel File, Or Function In Excel

WHO CAN TAKE THIS COURSE

Middle and High School students (Grade 8 to 12)Students from 1st to final year of graduation in any field (BE, B.Tech, B.Sc., B.Com., BA, BBA, MBA, MCA etc.)

Anyone who wants to learn Microsoft Excel No prior knowledge of Excel is required.