Course: How to Use Microsoft Excel for Data Analysis

In the previous section, you learned about using treemaps and sunburst charts to report and visualise hierarchical data. In the final video step of this course, you’ll discover how to …

In previous activities, we looked at pivot tables and used them to create dashboards. We even used pivot tables to compare and summarise our data. What we haven’t considered yet …

Now that you’re familiar with the comparison of data using the pivot table, let’s look at the SUMIFS function in Excel and how it can be used to compare year-over-year …

In the previous section, we experimented with calculated columns and conditional formatting as a way to analyse and find anomalies in the data. Although the pivot table is a useful …

So far, we’ve explored ways to use Excel to present data. Excel is also a useful tool for analysing data. When using calculated fields in pivot tables and conditional formatting, …

Now that you have the basics covered of how to manage your data using pivot tables, it’s time to kick it up a notch and explore some of the advanced …

Last week, we discovered how to organise our data in dashboards. In this step, we return to dashboards and explore additional features for building dashboards. Filtering Dashboards At times, you …

In the previous step, you experimented with pivot tables by summarising data from your Excel table, and you’ve learned that pivot tables are great for summarising large quantities of data. …

In the previous Knowledge Check and CloudSwyft Hands-On Lab, you dealt with an Excel table with more than 100 000 rows. When you’re dealing with a large quantity of data …

In the previous section, you learned about the different chart types available in Microsoft Excel and what each chart type is best used for. In the following step, you’ll explore …

Microsoft Excel has a vast number of features and is a valuable spreadsheet programme for many businesses. Microsoft Excel is a powerful reporting tool that allows you to do mass …