Learn to work smarter, not harder with our Excel 2010 training videos. In this series of videos, Excel trainer Jason Pearson demonstrates how to quickly put into action its powerful tools and features. Learn how to easily create and work with dynamic formulas and functions, produce eye-catching charts and illustrations, analyze data in new ways, format and print worksheets, and more. The instructor's exercise files are included so you can follow along.
- 45 Excel 2010 training videos
- Review format and licensing Options
- Ideal for SharePoint, Intranet or LMS deployment
- Included with "Office 2010 Beyond the Basics Standard"
| Title | Description | Duration |
| Getting Started with Excel 2010 | ||
| Introducing Excel 2010 | What's New in Excel 2010 to help create more professional spreadsheets | 3:45 |
| Working with the Ribbon | Review the Ribbon's options/commands and customize it to your needs | 3:20 |
| The New Backstage View | Look Backstage to find common file management functions | 2:26 |
| New File Types | View the selection of file formats including the new .xlsx file type | 2:28 |
| Using Templates | Don't start from scratch ... search for and grab a cool, new Excel template | 2:31 |
| Working with Formulas and Functions | ||
| All About Formulas | How to set up and use the SUM, AVERAGE, MAX, MIN, and COUNT functions | 4:16 |
| Working with IF Statements | Review the differences between IF, Nested IF, and IF OR/AND Statements | 4:05 |
| Using Lookups | Easily locate specific data with LOOKUP and VLOOKUP functions | 4:33 |
| The Subtotal Function | Create dynamic formulas using the SUBTOTAL function | 2:54 |
| Formula Auditing | Evaluate and Watch formulas with Formula Auditing tools | 3:40 |
| Understanding Named Ranges | Make formulas more efficient by using Named ranges | 3:44 |
| Data Validation | Control how and what type of data is entered into a cell | 3:04 |
| Function IF Statements | Try the functions SUMIFS, COUNTIFS, and AVERAGEIFS for more flexibility | 3:40 |
| Array Formulas | Watch how these super-charged formulas multiply large ranges of data | 2:45 |
| Concatenating Data | Join two or more words or text strings together with this handy function | 3:22 |
| PMT Function | Calculate payments for a loan or the future value of an investment | 2:41 |
| Left, Right, Mid Functions | Extract characters starting from the left, right, or middle of a cell | 2:58 |
| Creating a Multi-tier List | Create conditions where choices in a drop-down list are based on another | 3:26 |
| Data Visualization Tools | ||
| Sorting Data | Organize data using Quick Sort, Custom Sort, Color or by custom list | 4:32 |
| Filtering Data | Quickly filter data using common drop-down lists or customize your own | 3:24 |
| Advanced Filtering | Use the powerful Advanced Filtering tool for complex filtering | 2:42 |
| Conditional Formatting | Emphasize your data with Icons Sets, Data Bars, Color Scales, and more | 3:40 |
| Sparklines | Visualize and reveal trends in your data with the new Sparklines feature | 2:34 |
| Creating Charts | Explore the many options available to customize and add flair to your chart | 4:28 |
| Illustrating Excel | Enhance worksheets with new SmartArt graphics, shapes, and images | 3:06 |
| Summarizing, Consolidating, and Outlining Data | ||
| Restricting Duplicate Data | Learn to find and restrict duplicate data in your worksheet | 2:32 |
| Grouping and Outlining Data | Refine how worksheet data is displayed using Group and Outline tools | 3:39 |
| Using the SubTotal Tool | Extract and group data from a sorted list with the handy Subtotal tool | 4:16 |
| Data Consolidation | Summarize results into a master worksheet by consolidating data | 4:25 |
| Linking Worksheets | Review three techniques to link cells from different worksheets | 3:54 |
| Linking Workbooks | Create a master sheet to display changes across linked workbooks | 2:39 |
| Working with Tables and PivotTables | ||
| Interactive Tables | Quickly format your data by selecting a design from the Table Styles gallery | 3:12 |
| Remove Duplicates from a Table | Filter for unique values and remove duplicate records from tables | 3:04 |
| PivotTable Features | Design flexible reports by summarizing data with a custom PivotTable | 4:03 |
| Filtering PivotTables | Further organize and display your data by applying filters | 2:58 |
| Formatting PivotTables | Create easy-to-read PivotTables with options found on the Layout tab | 2:52 |
| Filtering with Slicers | Dynamically segment and filter data to display precisely what you need | 3:03 |
| Preparing to Print | ||
| Adding Formatting and Styles | Spruce up your worksheets using various formatting and custom styles | 2:50 |
| Adding Headers and Footers | The new "click zones" make it easier than ever to add consistency to pages | 2:48 |
| Working in Page Layout View | Select from options on the Page Layout tab for more precise printing | 2:57 |
| Working with Page Breaks | Control and adjust your page breaks with the Page Break Preview | 3:41 |
| Using Excel on a Global Level | ||
| Protecting Cells | Build a better form by enabling cell protection | 3:24 |
| Security and Privacy | Protect your workbooks with passwords and Protect Sheet options | 3:16 |
| Sharing Workbooks | Review the options for sharing worksheets based on the receiver's view | 2:32 |
| Working with Macros | Record your steps and create a macro to apply automation to a workbook | 4:06 |