Complete Data Analysis Project in Excel | Cleaning & Transformation | Functions | Pivot | Dashboard

Data Tutorials:

Data Analysis Project - Excel
---------------------------------------------
In this video you will be able to see complete Data Analysis project from start to end.
First, we will be investigating our data, understanding our dataset.
After we complete that step, we will start working on cleaning our data, using different functions to transform data, insert new columns.
Next step is using our transformed data in pivot tables in order to understand it better.
Last step is to create dashboard that will provide us insights from our data.
Software used for this project is Excel.

To download dataset, visit this link:

Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android and iOS. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications (VBA). It has been a very widely applied spreadsheet for these platforms, especially since version 5 in 1993, and it has replaced Lotus 1-2-3 as the industry standard for spreadsheets. Excel forms part of the Microsoft Office suite of software.

#dashboard #Excel #dataanalysis #data #Column #Table #Columns #Rows