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.
Spreadsheet Basics • Formulas and Macro Formulas • Data Analysis • Functions- LOOKUP, VLOOKUP, HLOOKUP, COUNTIF, SUMIF • Pivot Tables • Develop the Worksheet • Special Operations • Graphic Operations
Financial Analysts, Retail Store Managers, Project Managers, Business Analysts, Data Journalists, Accountants etc.,