Excel 2007 Beginner/Intermediate/Advanced Training

Excel 2007 Beginner/Intermediate/Advanced Training

Excel 2007 Beginner/Intermediate/Advanced Training

• 1.0 Getting Started
• 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.0 Entering Data
• 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.0 Changing Worksheet Layout
• 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.0 Entering Formulas
• 4.1 Anatomy of a Formula
• 4.2 Using the Formula Tab
• 4.3 AutoSum
• 4.4 Basic Functions
• 4.5 Copying Formulas

• 5.0 Formatting
• 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.0 Using Themes and Styles
• 6.1 Applying Themes
• 6.2 Creating Custom Themes
• 6.3 Applying Styles
• 6.4 Creating Custom Styles

• 7.0 Printing
• 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.0 Charts
• 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
   

• 1.0 Managing Workbooks
• 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.0 Tables and Data Management
• 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.0 Using Cell References
• 3.1 Using Relative Cell References
• 3.2 Using Absolute Cell References
• 3.3 Using Mixed Cell References

• 4.0 Auditing
• 4.1 About Auditing
• 4.2 Tracing Precedents
• 4.3 Tracing Dependents
• 4.4 Tracing Errors

• 5.0 Creating Web Pages from Workbooks
• 5.1 Publishing a Web Page
• 5.2 Viewing Your Published Web Page

• 6.0 Using Excel with Other Applications
• 6.1 Importing Data to Excel
• 6.2 Exporting Data from Excel
• 6.3 About XML

• 7.0 Customizing Excel
• 7.1 Customizing the Quick Access Toolbar
• 7.2 Modifying Excel Options

• 8.0 Using Scenarios and Watching Cells
• 8.1 Creating and Displaying Scenarios
• 8.2 Editing and Removing Scenarios
• 8.3 Summarizing Scenarios
• 8.4 Using the Watch Window

• 9.0 PivotTables and PivotCharts
• 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

• 1.0 Collaborating
• 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.0 Advanced Formulas and Functions
• 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.0 Data Consolidation
• 3.1 About Data Consolidation
• 3.2 Three Dimensional Formulas
• 3.3 Data Consolidation by Position
• 3.4 Data Consolidation by Category

• 4.0 SmartArt
• 4.1 About SmartArt
• 4.2 Creating a List
• 4.3 Creating a Hierarchy
• 4.4 Creating a Pyramid
• 4.5 Editing SmartArt

• 5.0 Track Revisions
• 5.1 Tracking Changes
• 5.2 Accepting and Rejecting Changes

• 6.0 Data Validation and Conditional Formatting
• 6.1 Working with Data Validation Rules
• 6.2 Set Conditional Formatting
• 6.3 Use Expressions in Conditional Formatting

• 7.0 Creating Templates
• 7.1 Using Excel Pre-Defined Templates
• 7.2 Creating and Modifying a Template

• 8.0 Macros
• 8.1 Create a Macro
• 8.2 Run a Macro
• 8.3 Edit a Macro