Scenario-based tutorials

With a focus on results - not features

►

Visualize your data with charts (11:08)

In this video you will learn -how to visualize data with bar charts, how to use the Quick Analysis Tool and you will learn how to use the updated charting tools to make your graphs really stand out.

►

Use formulas to fill out a budget (10:40)

In this video you will learn how to use basic calculations to fill out a marketing budget template, how to quickly fill your spreadsheet with numbers, how to use “AutoSum” to calculate totals and how to use absolute and relative references.

►

Sort and filter data to find answers (11:13)

In this video you’ll learn how to sort and filter data using Excel 2013 to find answers to specific questions. You’ll learn how to sort data by multiple columns, how to sort by color and how to filter using different data types.

►

Rearrange and clean up your data (10:20)

In this video you will learn will learn how to re-arrange data, how to spot and remove duplicates and how to change data types for easier analysis.

►

Modify data with Flash Fill (11:03)

In this video you will learn how to use Flash fill to modify data, how to split a column into two using Flash Fill, how to combine data from multiple columns into one and you will learn how to modify data using simple functions. By knowing how to use these tools effectively you will be able to save a lot of time when modifying your data.

►

Easily navigate a spreadsheet (11:11)

In this video you will learn how to effectively navigate a spreadsheet in Excel 2013, how to freeze rows and columns, how to navigate between different workbooks and how to compare worksheets side by side.

►

Automate calculations using Lookups (10:25)

In this video you will learn how to use lookup formulas in Microsoft Excel 2013

►

Analyze data in a PivotTable (11:11)

In this video you will learn how to use a PivotTable to analyze data, how to summarize and present your data in an easy way, how to sort and filter your data, and how you can move data around to see it from different perspectives.

How to Excel is a collection of scenario-based tutorials produced by Business Productivity. Visit our website to learn more.

Other How To Sites
  • How to Word
  • How to PowerPoint
  • How to Outlook
  • How to OneNote
Learn More
  • Business Productivity
  • Storyals
Connect

Business Productivity FZ LLC
Headquarters Location
Dubai Marina
PO Box 357 516
Dubai, UAE

T. +971 55 452 4557
E. info@businessproductivity.com

© 2022 Storyals - Business Productivity. All Rights Reserved | Privacy Policy