The Data Analytics course introduces students to the practical use of Microsoft Excel for organizing, analyzing, and interpreting data. It begins with getting started with Excel, covering the Excel interface, workbooks, worksheets, cells, and basic formatting techniques. Students then learn formulas and functions, including mathematical, text, logical, financial, and lookup functions, to perform calculations and extract useful information from datasets. The course also covers essential data tools such as sorting, filtering, data validation, and conditional formatting, along with an introduction to data cleaning techniques for identifying and correcting inconsistencies, errors, and unwanted data. Overall, these topics provide students with a strong foundation in using Excel for data organization, data cleaning, analysis, and decision-making.
- Teacher: Sharad Mishra