Scenario-based tutorials
With a focus on results - not features
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.
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.
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.
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.
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.
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.
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.