You'll master Pivot Tables, a powerful tool for interactive data summarization.

Discover how to consolidate data from various sources with Mark's expert guidance.

Learn methods to identify and remove duplicates, keeping your data pristine.

Dive into an exercise to apply your new skills, grouping and subtotaling sales data like a pro.

Mark will guide you through using subtotals to create compelling summaries.

Explore how to group data by categories, turning clutter into meaningful segments.

Get hands-on! You'll master sorting and filtering through a sample dataset.

Join Mark as he demonstrates how to filter data, uncovering the secrets you seek.

You will learn to sort data by various criteria, turning chaos into elegant order.

Welcome aboard! You'll embark on a data-driven journey through Excel, learning the ropes and discovering what's ahead.

In this video, you will learn how to choose the correct chart type.

In this video, you will learn how to combine files.

In this video, you will learn how to enter and edit data.

In this video, we will summarize the learnings from this section.

In this video, you will learn how to create a custom macro ribbon.

In this video, you will learn how to use forecast sheets.

In this video, you will learn how to add confidence levels.

In this video, you will learn how to create a sales forecast with seasonality.

In this video, you will learn how to create a linear sales forecast.

In this video, you will learn how to get forecast data with FRED.

In this video, we will focus on Exercise 09 of this section, where we will use split and trim functions.

In this video, you will learn how to load files into Excel.

In this video, we will explore the power query editor.

In this video, you will learn how to import data using Get and Transform.