There is a strong focus on practice and applied learning in this course. By performing these tasks throughout the course, it will give you an understanding of how spreadsheets can be used as a data analysis tool and understand its limitations. With this introduction you will then learn to perform some basic level data wrangling and cleansing tasks and continue to expand your knowledge of analyzing data through the use of filtering, sorting, and using pivot tables within the spreadsheet. This course starts with an introduction to spreadsheets like Microsoft Excel and Google Sheets and loading data from multiple formats. You will gain valuable experience in cleansing and wrangling data using functions and then analyze your data using techniques like filtering, sorting and creating pivot tables. This course is suitable for those aspiring to take up Data Analysis or Data Science as a profession, as well as those who just want to use Excel for data analysis in their own domains. It includes plenty of videos, demos, and examples for you to learn, followed by step-by-step instructions for you to apply and practice on a live spreadsheet.Įxcel is an essential tool for working with data - whether for business, marketing, data analytics, or research. It covers some of the first steps for working with spreadsheets and their usage in the process of analyzing data. You can see it has defects, so which is why the Product result when you multiply them together is 1.This course is designed to provide you with basic working knowledge for using Excel spreadsheets for Data Analysis. Now try double-clicking on Ice Cubes during the month of March 2013:
You can see that in the data breakdown for September 2014, there are no defects! This is why the Product result is 0. We love the ones that show zero because that means there are no defects! For example, would be for Bottles during the month of September 2014. Double click on it to see more details! So if any row for that specific duration has a 1, then the result in this Pivot Table is a 1 as well. STEP 3: Now what Excel has done is for that specific duration, it has multiplied all the Defect values. Click on the arrow and select Value Field Settings STEP 2: It will default as Sum of DEFECTS. This will be crucial once we use the Product function later. If there is a defect that day, we simply mark it as 1. Notice that I have added a Defects column.
0 kommentar(er)
