Course: A Beginner’s Guide to Data Handling and Management in Excel

In this video, you’ll be introduced to pivot tables. You will learn more about: pivot table examples creating pivot tables scenarios where pivot tables can be used field settings.

In this video, you’ll explore handy shortcuts in Excel. You will learn more about: creating multiple sheets at the same time how to quickly turn a range of cells into …

In this video, you’ll be introduced to vertical lookups. You will learn more about: what a VLOOKUP is how VLOOKUPs work finding exact and closest matches.

In this video, you’ll be introduced to charts in Excel. You will learn more about: how to create a basic column chart for one selection how to create a basic …

In this video, you’ll explore the different ways you can filter your data. You will learn more about: applying filters clearing filters number filters between functions selecting blanks.

In this video, you’ll investigate the option in Excel that will let you freeze columns or rows. You will learn more about: freezing rows freezing columns unfreezing rows and columns.

In this video, you’ll be introduced to creating formulas using functions. You will learn more about: what a function is the different types of functions including sum, average and maximum …

In this video, you’ll explore how three dimensional formulas come into play. You will learn more about: what three dimensional formulas are how to set up three dimensional formulas how …

In this video, you’ll learn how to create your workbooks from scratch. You will learn more about: how to type in text how to type in numbers how to get …