Excel 2010 Training Intermediate
Expand All | Collapse All
| Chapters |
Courseware |
Online
Learning |
Skills Assessments |
5. Creating and Working with Charts
| Selecting Chart Source Data |
Demo |
Demo |
Demo |
| Choosing the Right Chart |
Demo |
Demo |
Demo |
| Inserting a Chart |
- |
- |
- |
| Editing, Adding, and Removing Chart Data |
- |
- |
- |
| Changing Chart Data |
- |
- |
- |
| Changing Chart Layout and Style |
- |
- |
- |
| Working with Chart Labels |
- |
- |
- |
| Changing the Chart Gridlines |
- |
- |
- |
| Emphasizing Data |
- |
- |
- |
| Using Chart Templates |
- |
- |
- |
| Changing the Scale |
- |
- |
- |
| Changing Chart Type |
- |
- |
- |
| Using Sparklines |
- |
- |
- |
6. Managing Workbooks
| Selecting and Switching Between Worksheets |
Demo |
Demo |
Demo |
| Inserting and Deleting Worksheets |
Demo |
Demo |
Demo |
| Renaming, Moving, and Copying Worksheets |
- |
- |
- |
| Viewing a Workbook |
- |
- |
- |
| Splitting and Freezing a Window |
- |
- |
- |
| Creating Headers and Footers |
- |
- |
- |
| Hiding Columns, Rows, Worksheets, and Windows |
- |
- |
- |
| Setting the Print Area |
- |
- |
- |
| Adjusting Page Margins and Orientation |
- |
- |
- |
| Adding Print Titles, Gridlines, and Row and Column Headings |
- |
- |
- |
| Adjusting Paper Size and Print Scale |
- |
- |
- |
| Printing Multiple Worksheets and Workbooks |
- |
- |
- |
| Working with Multiple Workbook Windows |
- |
- |
- |
| Creating a Template |
- |
- |
- |
7. More Functions and Formulas
| Formulas with Multiple Operators |
Demo |
Demo |
Demo |
| Inserting and Editing a Function |
Demo |
Demo |
Demo |
| AutoCalculate and Manual Calculation |
- |
- |
- |
| Defining Names |
- |
- |
- |
| Using and Managing Defined Names |
- |
- |
- |
| Displaying and Tracing Formulas |
- |
- |
- |
| Understanding Formula Errors |
- |
- |
- |
| Using Logical Functions (IF) |
- |
- |
- |
| Using Financial Functions (PMT) |
- |
- |
- |
| Using Database Functions (DSUM) |
- |
- |
- |
| Using Lookup Functions (VLOOKUP) |
- |
- |
- |
8. Working with Data Ranges
| Sorting by One Column |
Demo |
Demo |
Demo |
| Sorting by Colors or Icons |
Demo |
Demo |
Demo |
| Sorting by Multiple Columns |
- |
- |
- |
| Sorting by a Custom List |
- |
- |
- |
| Filtering Data |
- |
- |
- |
| Creating a Custom AutoFilter |
- |
- |
- |
| Using an Advanced Filter |
- |
- |
- |
9. Working with Tables
| Creating a Table |
Demo |
Demo |
Demo |
| Adding and Removing Data |
Demo |
Demo |
Demo |
| Working with the Total Row |
- |
- |
- |
| Sorting a Table |
- |
- |
- |
| Filtering a Table |
- |
- |
- |
| Removing Duplicate Rows of Data |
- |
- |
- |
| Formatting the Table |
- |
- |
- |
| Using Data Validation |
- |
- |
- |
| Summarizing a Table with a PivotTable |
- |
- |
- |
| Converting to a Range |
- |
- |
- |
