Excel for Data Analysis
Course Description
Excel is one of the most powerful tools for data analysts in this technological era. In this tutorial, we would be exposing you to various components and forms that you can use in Excel as a data Analyst
Course Curriculum
<span>Excel is one of the most used skills in the data world. In this series we will be walking through all of the most important topics that Data Analysts need to know in order to be proficient in Excel. <br><br>Bike Sales Data Set:&nbsp;<a target="_blank" rel="nofollow" href="https://www.kaggle.com/datasets/sadiqshah/bike-sales-in-europe/">https://www.kaggle.com/datasets/sadiqshah/bike-sales-in-europe/</a><br></span>
In this tutorial, we will be diving into Formulas used in Excel for basic Data Analysis.&nbsp;<br><br>The link to the dataset is given below<br><br><span><a target="_blank" rel="nofollow" href="https://docs.google.com/spreadsheets/d/1lw_nfFvczptyUl4oC0NM6quUilBL7ZrQ/edit?usp=drive_link&amp;ouid=109414768761368849563&amp;rtpof=true&amp;sd=true">https://docs.google.com/spreadsheets/d/1lw_nfFvczptyUl4oC0NM6quUilBL7ZrQ/edit?usp=drive_link&amp;ouid=109414768761368849563&amp;rtpof=true&amp;sd=true</a> </span> <br>
The If and Ifs formula are all conditional statements and are used for comparing Values in Excel
Explore the Datetotext, TRIM and Concatenate Formular in Excel
Explore the LEN, Left and Right Formulas in Excel
Exploring the SUM, SUMIF, SUMIFS and SUBSTITUTE Formulas in Excel
Exploring the Count, Countif, Countifs function in Excel for Data Analysis, and also the DAYS and NETWROKDAY functions
In this tutorial, we would explore the Formula INDEX and how it can be used as an alternative to XLOOKUP. This is because XLOOKUP is only available on Excel2021 and Excel 365 which requires a license that is not readily available to the public. We will use the same Dataset as the Formula to go through the tutorial.
We shall go further into the INDEX and MATCH formula and how it can be use to sort out data and make analsysis
We would be taking Index-Match further by applying Maximum, Minimum and Average Value to it
Certain Errors can occur during the running of the index formula and there are certain ways to avoid that, using the IFNA, IFERROR Function can help to evade such errors.
Conditional Formatting
