Excel for Data Analysis

The second course in Data Analysis for Business ExpertTrack builds upon the basics and shows you how to organize your data and create databases that will enhance your business analytics. Learn how to apply critical thinking skills to data. Excel will be used to perform data analysis. You'll learn the most commonly used formulas and functions to combine and crunch data. This course will help you transform your knowledge into powerful techniques and tools for analysis.

Tidying data is the process of tying your data back to its original meaning. This includes matching rows, columns and tables with your variables and types. Tidy data is easier to use formulas and visualisations, and it tells a better story. As part of the creation process, you will need to explain how functions impact form. How easily data can be used will depend on how well the database is organized. SQLite will allow you to import tables and make adjustments according to your requirements. You can preview some of the steps in this course before you sign up.