# 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 - - -