 |
     |
      |
 |
| Excel 2007 Training Outlines | ||||
 Excel 2007 Training: Beginning
1.1 Launching Excel 2007 1.2 Touring the Excel Window 1.3 Using the Office Menu 1.4 Using the Quick Access Toolbar 1.5 Save vs. Save As 1.6 File and Folder Management 1.7 Opening and Closing Files 1.8 Getting Help 2.1 Navigation and Selection Techniques 2.2 Data Entry Techniques 2.3 AutoFill 2.4 AutoComplete 2.5 Undo and Redo 2.6 Exiting Excel 3.1 Inserting Rows, Columns and Cells 3.2 Deleting Rows, Columns and Cells 3.3 Adjusting Column Widths and Row Heights 3.4 Hiding Columns and Rows 3.5 Moving and Copying Data 3.6 Create, Modify and Delete Named Ranges 3.7 Go To, Find and Replace 4.1 Anatomy of a Formula 4.2 Using the Formula Tab 4.3 AutoSum 4.4 Basic Functions 4.5 Copying Formulas 5.1 Using the Home Tab 5.2 Using the Quick Format Mini Toolbar 5.3 Number Formats 5.4 Format as a Table 5.5 Merging and Splitting Cells 5.6 Applying Worksheet Backgrounds 6.1 Applying Themes 6.2 Creating Custom Themes 6.3 Applying Styles 6.4 Creating Custom Styles 7.1 Using the Page Layout Tab 7.2 Changing Margins and Page Orientation 7.3 Exploring Worksheet Views 7.4 Adding Headers and Footers 7.5 Adding Print Titles and a Print Area 7.6 Viewing and Setting Page Breaks 7.7 Printing 8.1 Using the Insert Tab 8.2 Creating a Chart 8.3 Using the Chart Contextual Tabs 8.4 Creating a Chart Sheet 8.5 Adding and Removing Chart Data 8.6 Format and Resize Charts Excel 2007 Training: Intermediate
1.1 Creating New Workbooks from a Template 1.2 Rename and Move Workbook Tabs 1.3 Insert and Delete Worksheets 1.4 Copy and Paste Worksheets 1.5 Using the View Tab 1.6 Splitting Your Worksheet View 1.7 Freezing and Unfreezing Your View 2.1 Table Guidelines 2.2 Using the Data Tab 2.3 Sorting 2.4 Grouping and Outlining Data 2.5 AutoFilter 2.6 Advanced Filter Using Single Criteria 2.7 Advanced Filter Using Multiple Criteria 2.8 Automatic Subtotals 3.1 Using Relative Cell References 3.2 Using Absolute Cell References 3.3 Using Mixed Cell References 4.1 About Auditing 4.2 Tracing Precedents 4.3 Tracing Dependents 4.4 Tracing Errors 5.1 Publishing a Web Page 5.2 Viewing Your Published Web Page 6.1 Importing Data to Excel 6.2 Exporting Data from Excel 6.3 About XML 7.1 Customizing the Quick Access Toolbar 7.2 Modifying Excel Options 8.1 Creating and Displaying Scenarios 8.2 Editing and Removing Scenarios 8.3 Summarizing Scenarios 8.4 Using the Watch Window 9.1 About PivotTables and PivotCharts 9.2 Creating a PivotTable 9.3 Modifying a PivotTable 9.4 Creating a PivotChart 9.5 Modifying a PivotChart Excel 2007 Training: Advanced
1.2 Inserting and Deleting Comments 1.3 Viewing and Printing Comments 1.4 Protecting Workbooks, Worksheets and Cells 1.5 Enabling Workbook Security 1.6 Sharing Workbooks 2.1 IF Functions 2.2 Nested IF Functions 2.3 Using the VLOOKUP Function 2.4 Using the HLOOKUP Function 2.5 Using the DSUM Function 3.1 About Data Consolidation 3.2 Three Dimensional Formulas 3.3 Data Consolidation by Position 3.4 Data Consolidation by Category 4.1 About SmartArt 4.2 Creating a List 4.3 Creating a Hierarchy 4.4 Creating a Pyramid 4.5 Editing SmartArt 5.1 Tracking Changes 5.2 Accepting and Rejecting Changes 6.1 Working with Data Validation Rules 6.2 Set Conditional Formatting 6.3 Use Expressions in Conditional Formatting 7.1 Using Excel Pre-Defined Templates 7.2 Creating and Modifying a Template 8.1 Create a Macro 8.2 Run a Macro 8.3 Edit a Macro
Excel 2007 Training Return Policy: You may open and view 1 DVD for "demo" purposes and still be able return the product within 15 days. Any Keystone Training Products that have more than 1 DVD opened or unsealed, are no longer covered under the 15 Day Money Back Guarantee Policy. DVD ROM'S: This Training set will only run on DVD ROM computer players only. These DVD's WILL NOT run on entertainment DVD players that are connected to TV's. An Internet connection is also required.
|
