Learning objectives - Video Tutorials & Practice Problems
Video duration:
1m
Play a video:
<v ->In this lesson, we will look at other mechanisms in Excel</v> that can be used to enhance the decision-making and management process. As you've seen to this point, step one analysis is first organizing your data into tables. Once your data is organized into tables, we can then use their features to help drive insights. These are the use of filtering, sorting, the totals row, and conditional format. In this lesson, we will look at different means to aggregate and summarize data. And then we will look at using visualizations to help tell stories, that are designed to enable users to digest massive quantities of information quickly. These are questions such as who was our best customer, who consistently pays on time, what are our payroll costs over time, and can we determine if current payroll seems reasonable by comparing it to other periods? For this we will look at using pivot tables, which are often considered the gold standard for measuring Excel knowledge. A pivot table is a powerful tool to calculate, summarize, and analyze data that lets you see comparisons, patterns and trends in your data. In addition to that, Excel offers other functionality to enhance the data analysis capabilities. And here we will look at using pivot charts. In this lesson, we will cover the use of pivot tables, we'll review chart types, and we'll take a deeper look into pivot charts. Let's begin.