This topic will familiarize students with implementing date functions using different formats in Excel. This topic will make students familiar with implementing essential arithmetic functions to create more complex formulas that will unlock the power of Excel for data analysis needs. This topic will teach students how to implement tables in Excel to organize data and make it easy to view and understand.
This topic will teach students the process of cell referencing, a powerful feature in Excel that allows them to link data from multiple sheets and workbooks. In this, students will learn how to add functionality to a workbook and make working with data easier using tools, ribbons, and commands available in Excel. Here, students will learn how to use CSV for exchanging data between different applications. Here, students will learn why Excel is a powerful spreadsheet application for analyzing and manipulating data and the advantages of using Excel for business and personal use.ĬSV files can be used with almost any spreadsheet program, such as Microsoft Excel, Apache Openoffice Calc, or Google Sheets. Why Excel? What are the advantages of Excel?.Students will learn data analysis essentials using Excel to create and format spreadsheets, along with CSV, tables, formulae, sorting, filtering, and much more.
The first module of this data analytics course for beginners will cover the basics of Microsoft Excel.
