Chapter 1: Introduction to Excel 2007
- Lesson 1.1 : Microsoft Excel 2007
- Lesson 1.2 : Excel’s New Interface
- Lesson 1.3 : Excel’s New Feature
Chapter 2: Creating and Navigating a Worksheet
- Lesson 2.1 : Creating a Basic Worksheet
- Lesson 2.2 : Navigating and Editing Data in a Worksheet
- Lesson 2.3 : Saving and Opening a File
- Lesson 2.4 : Customizing Quick Access Toolbar
- Lesson 2.5 : Moving Data around Excel Worksheet
- Lesson 2.6 : Adding and Moving Columns or Rows
- Lesson 2.7 : Printing an Excel Sheet.
- Lesson 2.8 : Creating Headers and Footers
- Lesson 2.9 : Page Setup Options
Chapter 3: Managing and Formatting Worksheet
- Lesson 3.1 : Worksheets and Workbooks
- Lesson 3.2 : Find and Replace
- Lesson 3.3 : Spell Check
- Lesson 3.4 : Formatting Cell Values
- Lesson 3.5 : Formatting Font Appearances
- Lesson 3.6 : Formatting Alignments
- Lesson 3.7 : Borders and Fills
- Lesson 3.8 : The Format Painter
- Lesson 3.9 : Styles and Themes
- Lesson 3.10 : Controlling your Views
Chapter 4: Formulae and Functions
- Lesson 4.1 : Building Basic Formula
- Lesson 4.2 : Excel’s Functions
- Lesson 4.3 : Excel’s Function Library
- Lesson 4.4 : Using the Insert Function Button
- Lesson 4.5 : Copying Formulas
- Lesson 4.6 : Formula Auditing
Chapter 5: Organizing Worksheets
- Lesson 5.1 : Basics of Tables
- Lesson 5.2 : Selecting and Editing a Table
- Lesson 5.3 : Sorting a Table
- Lesson 5.4 : Filtering a Table
- Lesson 5.5 : Basic Data Grouping
- Lesson 5.6 : Automatic Subtotaling
- Lesson 5.7 : Understanding Templates
Chapter 6: Charts and Graphics
- Lesson 6.1 : Creating Basic Charts
- Lesson 6.2 : Adding Pictures to a Worksheet
- Lesson 6.3 : Excel's Clip Art Library and Shapes
- Lesson 6.4 : Drawing a Shape
- Lesson 6.5 : Inserting Smart-Art Graphics
Chapter 7: Formatting Charts
- Lesson 7.1 : Dealing with Duplicate Rows
- Lesson 7.2 : Formatting Chart Elements
- Lesson 7.3 : Texture, Picture Fills and Border Styles
- Lesson 7.4 : Gaps, Widths, and Overlays in a Column Chart
- Lesson 7.5 : Controlling a Chart Scale
Chapter 8: Scenarios and Goal Seeking
- Lesson 8.1 : Introduction to Scenarios
- Lesson 8.2 : Managing Scenarios
- Lesson 8.3 : Using Goal Seek
- Lesson 8.4 : Solver
- Lesson 8.5 : Saving Solver Models
- Lesson 8.6 : Configuring Solver
Chapter 9: Advanced Data Analysis
- Lesson 9.1 : Data Tables
- Lesson 9.2 : Data Forms
- Lesson 9.3 : Pivot Tables
- Lesson 9.4 : Field Settings and Styles in Pivot Tables
- Lesson 9.5 : Pivot Charts
Chapter 10: Protecting Your Work book
- Lesson 10.1 : Data Validation
- Lesson 10.2 : Data Validation using Functions
- Lesson 10.3 : Data Validation with Lists
- Lesson 10.4 : Protecting a Worksheet
- Lesson 10.5 : Protecting the Entire Workbook
- Lesson 10.6 : Protecting Cell Ranges with More Passwords
- Lesson 10.7 : Preparing Your Workbook
Chapter 11: Worksheet Collaboration
- Lesson 11.1 : Adding Comments
- Lesson 11.2 : Fine-Tuning Comments
- Lesson 11.3 : Tracking Changes
- Lesson 11.4 : Examining the Change Log
- Lesson 11.5 : Accepting and Rejecting Changes
- Lesson 11.6 : Sharing Your Workbook
Chapter 12: Connection Worksheet to the Web
- Lesson 12.1 : Embedding and Linking Objects
- Lesson 12.2 : Putting Worksheets on the Web
- Lesson 12.3 : Performing Web Queries
- Lesson 12.4 : Creating a Web Query
- Lesson 12.5 : Using Hyperlinks
- Lesson 12.6 : Adding a Hyperlink to a Worksheet Location
Chapter 13: Working with Macros and XML
- Lesson 13.1 : Introduction to Macros
- Lesson 13.2 : Recording and Playing a Macro
- Lesson 13.3 : The Trust Center
- Lesson 13.4 : Excel and XML
- Lesson 13.5 : Mapping a Simple Document
|