DATA ANALYSIS AND SPREEDSHEET PROFICIENCY

IN THIS COURSE, LEARNERS SHOULD LOOK OUT FOR THE FOLLOWING IN DETAIL:

Chapter 1 -  Introduction to Data Analysis & Spreadsheets
Lesson 1: What is data analysis
Lesson 2: Why we learn spreadsheets
Lesson 3: Application of data analysis in real life
Lesson 4: Spreadsheet Software

Chapter 2: Set up and installation
Lesson 1: How to install micrsoft excel
Lesson 2: Creating a free Microsoft account for excel online
Lesson 3: Installing and using google sheet via google drive
Lesson 4: How to install libreoffice calc

Chapter 3: Spreadsheet basis
Lesson 1: Opening and saving workbooks in excel
Lesson 2: Excel basic

Chapter 4: Working with Formulas and Functions
Lesson 1: What are the formulas in excel
Lesson 2: Common arithmetic formulas in spreadsheet
Lesson 3: Introduction to function (SUM, AVERAGE,MIN,MAX)
Lesson 4: Using autofil in spreadsheet.
Lesson 5: Cell referending (Relative vs absolute)

Chapter 5: Data Management tool
Lesson 1:Sorting and filtering datain spreadsheet
Lesson 2: Conditioning formatting in spreadsheets
Lesson 3: Data validation and dropdown list in spreadsheet
Lesson 4: Freeze panes and split windows in spreadsheet.
Lesson 5: Find and replace in spreadsheets.

Chapter 6: Charts and Visualization
Lesson 1:Types of charts in spreadsheets
Lesson 2: Creating basic charts in spreadsheets
Lesson 3: Chart layout and style in spreadsheets
Lesson 4: Using sparklines in excel
Lesson 5: Tips for data visualization

Chapter 7: Intermediate Formulas and Functions
Lesson 1: Count, counta, countif.
Lesson 2: If, and, or logical functions.
Lesson 3: Text, functions (Left, right, mid,Len, concatenate)
Lesson 4: Date and time functions
Lesson 5: Lookup functions (VLOOKUP,HLOOKUP,XLOOKUP in excel)

Chapter 8: Data Cleaning & Analysis
Lesson 1: Removing duplicates in excel
Lesson 2: Trimming and splitting data in excel
Lesson 3: Handling missing values in excel
Lesson 4: Sorting large datasets
Lesson 5: Basic statistical analysis

Chapter 9: Pivot Tables and Dash boarding (Excel & Sheets)
Lesson 1: What is pivot table
Lesson 2: Creating pivot tables
Lesson 3: Analyzing data with pivot table in excel
Lesson 4: Building interactive dashboards in excel
Lesson 5: Using slicers and charts in dashboard.
Chapter 10: Importing and Exporting Data
Lesson 1: Importing data from CSV, Excel or web 
Lesson 2: Expressing spreadsheets to PDF or CSV in excel
Lesson 3: Connecting googlesheet to google forms
Lesson 4: Using excel power query  (Basic Query)

Chapter 11: Practical Projects & Case Studies
Lesson 1: Excel project: Budget tracker