Excel Fundamentals for Data Analysis

This course offered by Macquire University on Coursera teaches the basics of excel for data analysis. It discusses data preparations and cleaning using various ways. It helps us form strong fundamentals that are built upon in further courses of the specialization. Click here to read.

I.  Introduction

    - Functions for combining text values

    - Functions to split text data

    - Combining text functions

    - Cleaning data and changing case

    - Removing and replacing text characters

II. Working with numbers and dates

    - Converting data with value and text

    - Understanding dates and basic date functions

    - Calculations with dates and using days, network days and workday

    - More sophisticated date calculations with EOMonth and EDate

III. Defined names for working more effectively with data

    - Cell referencing and naming

    - Defined names and create from selection

    - Managing names

    - Calculations with named ranges

    - Automating data validation with named ranges

IV. Tables for automating data manipulating  

    - Introduction to tables

    - Customizing tables

    - Sorting and filtering tables

    - Table calculations and structuring references

    - Automation with tables

V. Logical and lookup functions

    - Apply logical functions using IF

    - Nested IF, AND, OR

    - Categorising data with VLOOKUP

    - Matching data with VLOOKUP and XLOOKUP

    - Power lookups with INDEX and MATCH