Basics of Data Analytics using Spreadsheet Laboratory
Subject Overview
The practical companion to Basics of Data Analytics using Spreadsheet, building Excel skills from basic functions and data import/cleaning through descriptive statistics, advanced functions (lookup, aggregation), data visualization (charts, pivot tables) and interactive dashboard creation. A 1-credit elective lab paper.
Unit-wise Syllabus
2 units — click WhatsApp below to get the full notes for each
Unit 1: Understanding and describing data
Excel basics — workbook/worksheet/cells/ranges, data entry and formatting, SUM/AVERAGE/MIN/MAX/ROUND, cell referencing; importing data from CSV/text/web, data cleaning and transformation, Find & Replace and text functions; descriptive statistics — mean/median/mode, range/variance/standard deviation, frequency distributions and the Data Analysis Toolpak
Unit 2: Visualizing and communicating data
Logical functions (IF, AND, OR, IFERROR), lookup/reference functions (VLOOKUP, HLOOKUP, INDEX, MATCH), aggregation functions (SUMIFS, COUNTIFS, AVERAGEIFS), text functions; chart types and advanced charting, PivotTables and Pivot Charts; dashboard concepts, conditional formatting and interactive dashboards with slicers and timelines