- Understanding Excel
- Examining the Projects
- Examining the Excel Window
- Entering Text and Formulas
- Entering and Editing Data
- Working with Columns and Rows
- Understanding Formulas
- Understanding Functions
- Using Paste Function
- Entering More Formulas
- Moving and Copying Data
- Looking at the Office Clipboard
- Cutting, Copying and Pasting
- Moving Cells
- Using Fills
- Exploring Formula Construction
- Understanding Cell References
- Using Relative/Absolute References
- Using More Functions
- Formatting Worksheet Appearance
- Adjusting Rows and Columns
- Formatting Numbers
- Aligning/Formatting Text
- Applying Borders and Shading
- Working with and Understanding Charts
- Creating/Modifying Charts
- Printing Worksheets
- Adjusting Page Setup
- Setting Up Headers and Footers
- Setting Print Titles and Options
- Setting Print Areas
- Using Help - Appendix
- Using the Help Window
- Using the Contents Card
|
- Renaming Worksheets
- Moving Worksheets
- Using Lists
- Working with Databases
- Sorting Lists
- Using AutoCorrect
- Understanding Paste Function
- Using Logical Functions
- Using Financial Functions
- Using Date Functions
- AutoFormatting Worksheets
- Formatting Worksheets
- Using Page Breaks
- Working with Objects
- Using 3-D References
- Understanding 3-D Workbooks
- Linking Worksheets
- Showing Formulas and References
- Using Excel and the Web
- Understanding the Web
- Saving as Different File Types
- Working with Web Pages
- Using Templates
- Customizing Templates
- Entering Data
- Using Microsoft Map
- Working with Data Maps
- Adding Data to Data Map Objects
- Reconfiguring Data Maps
|
- Using Templates
- Working with Records and Ranges
- Using Data Forms
- Using Named Ranges
- Formatting Numbers
- Using Custom and Conditional Formatting
- Sorting Lists
- Using Macros
- Using Grouping and Outlines
- Applying Data Filters
- Understanding Advanced Filters
- Understanding Importing
- Importing from Text Files
- Querying Databases
- Importing from HTML Files
- Exporting to Other Applications
- Creating PivotTables
- Adjusting PivotTables
- Showing and Hiding Information
- Using PivotTable Pages
- Using PivotTables and the Web
- Creating PivotCharts
- Using Data Analysis Tools
- Using Solver
- Understanding Scenarios
- Understanding Goal Seek
- Auditing a Worksheet
- Protecting and Sharing Workbooks
- Applying Protection and Sharing
- Setting File Passwords and Properties
- Using Data Validation
- Using Comments
- Tracking Changes
- Merging/Linking Workbooks
- Printing Worksheets and Reports
|
