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...