|
| |
Microsoft Excel 2007 Outlines
Excel 2007 New Features
Excel 2007 Introduction
Excel 2007 Intermediate
Classes are available in Microsoft Office 97, 2000, 2002,
2003, and 2007.
Lesson 1: Exploring the Excel Environment
- Explore the User Interface
- Work with the Ribbon
- Work with Contextual Tabs
- Use the Excel Galleries
- Customize the Excel Interface
Lesson 2: Organizing Data
- Explore the Enhancements in Excel 2007 Spreadsheets
- Insert Tables
- Format Tables
Lesson 3: Analyzing Data
- Apply Conditional Formatting
- Sort Data in a Spreadsheet
- Filter Data in a Spreadsheet
- Apply a Formula
Lesson 4: Presenting Data
- Create Charts
- Format Charts
- Work with Illustrations
- Create PivotTables and PivotCharts
- Share Excel Charts
- Save Data in Presentable Formats
Lesson 1: Exploring the Excel Environment
- Explore the User Interface
- Explore the Ribbon
- Obtain Help
- Customize the Quick Access Toolbar
Lesson 2: Working with an Excel Worksheet
- Navigate in Excel
- Select and Enter Data
- Save a Workbook
Lesson 3: Modifying a Worksheet
- Manipulate Data
- Insert and Delete Cells, Columns, Rows
- Search for Data in a Worksheet
- Spell Check a Worksheet
Lesson 4: Performing Calculations
- Create Basic Formulas
- Calculate with Functions
- Copy Formulas and Functions
- Create a Mixed Reference
Lesson 5: Formatting a Worksheet
- Convert Text to Columns
- Modify Fonts
- Add Borders and Color to Cells
- Change Column Width and Row Height
- Merge Cells
- Apply Number Formats
- Align Cell Contents
- Find and Replace Formats
- Apply AutoFormat
- Apply Cell Styles
- Apply Themes
Lesson 6: Developing a Workbook
- Format Worksheet Tabs
- Reposition Worksheets in a Workbook
- Insert and Delete Worksheets
- Copy and Paste Worksheets
Lesson 7: Printing Workbook Contents
- Set Print Titles
- Create a Header and a Footer
- Set Page Margins
- Change Page Orientation
- Set Page Breaks
- Print a Range
Lesson 8: Customizing Layout
- Split a Worksheet
- Arrange Windows
- Freeze/Unfreeze Rows and Columns
- Hide and Unhide Worksheets
Lesson 1: Enhancing Workbooks
- Customize the Excel Environment
- Customize an Excel Worksheet
- Enhance Worksheets Using Themes
- Work with Comments
- Access External Resources Using Hyperlinks
- Use Web-Based Research Tools
Lesson 2: Creating Workbooks Using Templates
- Create a Workbook from a Template
- Create a Custom Template
Lesson 3: Organizing Data Using Tables
- Create Tables
- Modify Tables
- Format Tables
Lesson 4: Presenting Data Using Charts
- Create a Chart
- Modify Charts
- Format Charts
- Create a Chart Template
- Share Excel Charts
Lesson 5: Analyzing Data Using PivotTables and
PivotCharts
- Create a PivotTable
- Perform Calculations Using PivotTables
- Analyze Data Using PivotCharts
Lesson 6: Enhancing Visual Appeal Using Graphic Objects
- Insert Graphics
- Modify Graphic Objects
- Emphasize an Area of a Worksheet
- Illustrate Workflow Using SmartArt Graphics
- Format Graphic Objects
- Change the Order of Layered Graphic Objects
- Group Graphic Objects
- Organize Graphic Objects
Lesson 7: Calculating Data with Advanced Formulas
- Refer to a Range of Cells
- Calculate Data Across Worksheets
- Perform Date and Time Calculations
- Format Text Using Formulas
- Perform Numeric Calculations
- Calculate Data with Lookup & Reference Functions
- Perform Logical Analysis
- Print Formulas
Lesson 8: Sorting and Filtering Data
- Sort Data in a Spreadsheet
- Filter Data in a Spreadsheet
- Calculate Large Volumes of Data
- Add Subtotals to a Worksheet
|
