Data Analysis with Excel for complete Beginners

#excel #dataanalytics #dataanalysis #datavisualization

Register & start doing Exams & Earn a Certificate

In this class we shall introduce ourselves to Microsoft Excel and understand why we need Excel for Data Analysis and why its the most widely used Data Analysis tool in the world. We shall start by introducing ourselves to the tool and later cover everything we need to know including the following in the timestamps.
00:00 Introduction to Excel for Data Analytics
00:27 What is Microsoft Excel made of
03:08 How specific data types behave in Excel cells
05:26 What does Excel do?
06:18 Why do we need to setup proper raw datasets before analysis in excel
07:08 Characteristics of a Proper Raw Dataset in Excel
08:54 Difference between Data and Information
10:42 Characteristics of Proper Datasets used in Excel for Analysis
11:59 Why are Excel Tables Important in Excel
17:44 How to create an Excel Table
26:23 How to analyze data using both formulas and pivot tables in excel
31:56 How to build a Pivot Table report in Excel

Thank you for watching! If you would like to contact me for training your team. My WhatsApp number: is [phone]