Introduction to Data Analysis Using Excel by Rice University (Coursera)
This is an introductory Excel course offered by Rice University as part of the Business Statistics and Analysis Specialization. It is intended for two types of learners: those with a basic functional understanding of Excel and those who use Excel on a daily basis and want to expand their expertise. This Excel training is divided into four chapters that progress you from fundamental operations (such as reading data into Excel using multiple data formats, editing and organizing data, and so on) to more complex capabilities (such as Pivot Tables, Charts and Graphs etc.).
Sharad Borle, the teacher, has designed the course really effectively and provides simple examples that help learners comprehend everything fast and apply it in real-life circumstances. The course has a number of exams and tasks that will require access to Windows Microsoft Excel 2010 or later to complete.
The following are the course modules' specifics:
1. Module 1: Spreadsheets — An introduction to Excel spreadsheets as well as fundamental data operations and formulae.
2. Module 2: Spreadsheet Functions for Data Organization — An introduction to Excel functions for data organization and queryings, such as IF, nested IF, VLOOKUP, HLOOKUP, and RANDBETWEEN.
3. Module 3: Filtering, Pivot Tables, and Charts — An introduction to Excel's data filtering features and Pivot Tables.
Module 4: Advanced Graphing and Charting — An introduction to advanced graphing and charting techniques in Excel.
Detailed information:
Cost: $99/month
Syllabus: Approx. 4 weeks, 1-2 hours / week
Link: https://www.coursera.org/learn/excel-data-analysis