Course Highlights
- Quickly find old features within the new results-oriented user interface
and Ribbon.
- Learn to write advanced formulas and use functions such as IF, HLOOKUP
and DSUM.
- Collaborate with team members using Excel’s comments, security
and data validation options.
- Save time with Excel’s table and list management features, including
AutoFilter and Automatic Subtotals.
- Create and use interactive PivotTables to summarize and retrieve sets
of data on the fly.
About This Course
This Microsoft Office Excel 2007 Essentials Training Course contains
three levels of instruction to walk you through performing many time-saving
tasks in Excel, beginning with an introduction to the new results-oriented
interface. The course topics appeal to all Excel users – beginner
through advanced. You will learn everything from creating professional-looking
charts to sharing data with enhanced security and managing your spreadsheets
more effectively.
In this course, you’ll learn from a combination of quick tips and
detailed instruction on using Excel for team collaboration and creating
templates to work smarter, not harder. You will learn how to create professional-looking
spreadsheets through modifying the worksheet layout and formatting.
And, of course, you will learn about harnessing the power of Excel formulas
with an entire section devoted to the anatomy of formula. To really understand
formulas, there are additional lessons on advanced functions (such as
Nested IF Statements, HLOOKUP, VLOOKUP and DSUM) and data consolidation
using three dimensional formulas, position and category.
There are over 100 lessons in this Excel course – all designed
to increase your productivity.
Microsoft Excel 2007: Beginner
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
Microsoft Excel 2007: Intermediate
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
Microsoft Excel 2007: Advanced
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
| 
