Microsoft Office Training Materials – Excel 2010 Advanced Training Manuals
Microsoft Office 365 Training Materials, plus Office 2013 & Windows 10 Manuals Free SamplesMicrosoft Excel 2010 Advanced Training Materials
Courseware Training Materials
Training Course Outline
Excel 2010 Pivot Tables
- Using a Pivot Table.
- Filtering and Sorting Data
- Grouping Data
Excel 2010 Input Tables
- One-Input Data Tables.
- Two-Input Data Tables.
Charts within Excel 2010
- Combined Line and Column Chart.
- Adding a Secondary Axis.
- Changing the Chart Type For a Data Series.
- Adding a Data Series to a Chart.
- Removing a Data Series from a Chart.
- Modifying the Chart Title, Legend & Data Labels.
- Chart Axis Scales.
- Inserting Images Into Chart Columns.
- Formatting the Chart Area
Excel 2010 Hyperlinks
- Inserting a Hyperlink.
- Editing a Hyperlink
- Removing a Hyperlink
Linking & Embedding
- Linking Data within a Worksheet.
- Linking Cells between Worksheets within a Workbook.
- Linking Data between Workbooks.
- Linking Data from Excel to a Word Document.
- Linking an Excel Chart to a Word Document.
- Updating, Locking and Breaking Links.
Importing Text Files
- Importing a Delimited Text File.
Sorting and Filtering Data
- Sorting Data by Multiple Columns
- Custom Sorts
- Customized List
- AutoFilter.
- Top 10 AutoFilter.
- Advanced Filter Criteria.
- Sub-Totalling.
- Removing Subtotals.
- Expanding and Collapsing Outline Detail.
Tracking and Reviewing Changes
- Enabling or Disabling ‘Track Changes’.
- Sharing, Comparing and Merging Worksheets.
Scenarios
- Scenario Manager.
- Scenario Summary Reports.
Validating
- Whole Number.
- Decimal Number.
- List.
- Date.
- Time.
- Text Length.
- Validation Input Message and Error Alert.
- Removing Data Validation.
Auditing
- Tracing Precedent Cells.
- Tracing Dependent Cells.
- Identifying Cells With Missing Dependents.
- Showing All Formulas In a Worksheet.
- Comments..
Macros
- Using Macros
- Assigning a Macro to a Button on the Quick Access Toolbar.
- Deleting Macros.
Passwords & Security Issues
- Password Protection.
- Password Protecting Cells and Worksheets.
- Hiding Formulas.
- Un-Hiding Formulas.
Other Microsoft Office Training Materials
Word 2010 Foundation
Word 2010 Intermediate
Word 2010 Advanced
Excel 2010 Foundation
Excel 2010 Intermediate
Excel 2010 Advanced
Access 2010 Foundation
Access 2010 Intermediate
Access 2010 Advanced
Outlook 2010 Foundation
PowerPoint 2010 Foundation
PowerPoint 2010 Intermediate
PowerPoint 2010 Advanced