Skip to main content

Advanced Excel

Objectives

In this course, you will learn the basics of spreadsheets by working with rows, columns, addresses, and ranges. You will create your own formulas and learn how to use references.

About the Course

Duration of the Program (semester & hours): I Sem BCom/BBA & 30 hours

MS Excel software is one of the most popular and powerful tools in data analysis. Millions of people use tools like Google Sheets or Microsoft Excel on a daily basis. Even the most experienced data scientists often started their careers with spreadsheets and still use it to test assumptions or to look at data for the first time.

 

Syllabus

Spreadsheet Basics • Formulas and Macro Formulas • Data Analysis • Functions- LOOKUP, VLOOKUP, HLOOKUP, COUNTIF, SUMIF • Pivot Tables • Develop the Worksheet • Special Operations • Graphic Operations

Job Opportunities

Financial Analysts, Retail Store Managers, Project Managers, Business Analysts, Data Journalists, Accountants etc.,

Close Menu