I.Microsoft Office 2007 Basics

A. Introduction to Office 2007

• About Business Technology
• About Microsoft Office 2007
• Use the Mouse
• Use the Keyboard
• Start and Exit Microsoft Office Programs
• Identify Common Screen Elements
• Conventions Used in This Book

B. Executing Commands   

• 1.About Commands
• 2.About the Ribbon
• 3.Use the Ribbon
• 4.Use Access Keys
• 5.Use the Office Button
• 6.Use the Quick Access Toolbar
• 7.Use a Mini Toolbar
• 8.Use Shortcut Menus
• 9.Use Dialog Box Options
• 10.Use Task Panes

C. Navigating Excel

• 1.Zoom
• 2.Scroll
• 3.Use Multiple Windows

D. Excel Help

• 1.Use the Help Program
• 2.Search for Help
• 3.Use the Help Table of Contents
• 4.Recover a File

II.Excel Basic

A. The Excel Window

• 1.Start Excel
• 2.The Excel Window
• 3.Excel Interface
• 4.Navigate the Worksheet
• 5.Change between Worksheets
• 6.Worksheet Views
• 7.Exit Excel

B. Creating, Editing & Saving a New Workbook

• 1.Create a New (Blank) Workbook
• 2.Create a Workbook from a Template or Another Workbook
• 3.Enter Labels
• 4.Make Simple Corrections
• 5.Undo and Redo
• 6.Delete (Clear) Cell Contents
• 7.Save a Workbook
• 8.Close a Workbook

C. Editing Tools

• 1.AutoComplete
• 2.Pick From List
• 3.AutoCorrect
• 4.Spell Check

D. Data Entry

• 1.Enter Numeric Labels and Values
• 2.Enter Dates
• 3.Create a Series
• 4.Change Data Alignment
• 5.Change Column Width

E. Basic Formulas and Ranges

• 1.Enter a Formula
• 2.Edit a Formula
• 3.Copying Data, Formulas, and Formatting
• 4.Select Ranges
• 5.Range Entry Using Collapse Button

F. Basic Formatting

• 1.Choose a Theme
• 2.Apply Cell Styles (Quick Styles)
• 3.Apply Font Formats
• 4.Apply Number Formats

G. Editing a Worksheet.

• 1.Copy and Paste Data
• 2.Copy Formats
• 3.Insert and Delete Columns and Rows
• 4.Move Data (Cut/Paste)
• 5.Drag-and-drop Editing
• 6.Insert, Delete, Copy, Move, and Rename Worksheets
• 7.Change the Color of a Worksheet Tab
• 8.Hide Sheets
• 9.Group Sheets

H.References

• 1.Relative Reference
• 2.Absolute Reference

I.Printing a Worksheet

• 1.Preview and Print a Worksheet

III.Working with Function, Tables and Charts

A.Using Functions

• 1.Common Functions
• 2.Insert a Function
• 3.AutoCalculate

B.Excel Tables

C.Comments
D.Defining Ranges

• 1.Creating and Editing Ranges
• 2.Listing and PrintingRanges

E.Logical Functions

• 1.Understand IF Functions
• 2.Nested IF Functions
• 3.=SUMIF() and SUMIFS() Functions
• 4.=COUNTIF() and COUNTIFS() Functions

F.Charts

• 1.Chart Basics
• 2.Select Chart Data
• 3.Chart Elements
• 4.Create Charts
• 5.Change Chart Types
• 6.Select a Chart
• 7.Resize, Copy, Move, or Delete a Chart
• 8.Change Data Series Orientation
• 9.Format a Chart
• 10.Resize, Move, or Delete a Chart Object
• 11.Change Chart Text
• 12.Enhance Chart Background
• 13.Format Category and Value Axes

G.Worksheet Printing and Editing

• 1.Print a Workbook
• 2.Print Multiple Copies
• 3.Modify Page Setup
• 4.Insert Headers and Footers
• 5.Page Layout View
• 6.Insert Page Breaks
• 7.Page Break Preview
• 8.Set Print Area
• 9.Repeat Row and Column Labels
• 10.Other Sheet Tab Options

H.Using Paste Special

• 1.Copy and Paste Special
• 2.Transpose Date
• 3.Combine Data with Copy and Paste Special

I.Working with the Window Menu

• 1.Freeze Labels While Scrolling
• 2.Split a Worksheet into Panes
• 3.Duplicate Workbook Window

J.Working with Multiple Workbooks

• 1.Drag-and-Drop Data between Workbooks
• 2.Link Workbooks
• 3.3-D Formulas

IV.More on Entering Data, Saving, and Printing

A.Navigating in a Worksheet

• 1.Use Go To
• 2.Use Name Box

B.Entering Data and Editing a Worksheet

• 1.Enter Labels on Multiple Lines
• 2.Enter Fractions and Mixed Numbers
• 3.Smart Tags
• 4.Insert and Delete Selected Cells
• 5.Copy or Move Data with the Office Clipboard
• 6.Convert Text to Columns

C.Hyperlinks

• 1.Link Documents with Hyperlinks
• 2.Add a Hyperlink to a Worksheet

D.Changing a Worksheet View

• 1.Hide Data Temporarily
• 2.Hide Worksheet Gridlines
• 3.Hide Row and Column Headings
• 4.Custom Views

E.Worksheet Formatting

• 1.More Alignment Options
• 2.Format Dates and Times
• 3.Create Custom Number Formats
• 4.Adjust Row Height
• 5.Delete (Clear) a Cell’s Formats
• 6.Change Cell Borders
• 7.Fill Cells with Pattern
• 8.Modify and Save a Theme
• 9.Conditional Formatting
• 10.Add a Watermark
• 11.Format Worksheet Background
• 12.Save a Workbook in a Different Format
• 13.Use Compatibility Checker

F.Working with Folders, Macros and Templates

• 1.Create a New Folder for Saving Workbooks
• 2.Enable Macros in a Workbook
• 3.Create Original Templates

G.Email a Worksheet and Print Formulas

• 1.E-mail a File
• 2.Display and Print Formulas

V.Advance Chart Techniques

• 1.Print a Chart
• 2.Publish Chart to the Internet/Intranet
• 3.Paste a Picture of a Chart
• 4.Link a Chart
• 5.Embed a Chart into a Word Document
• 6.Edit a linked or Embedded Chart
• 7.Create Organization Charts
• 8.Create SmartArt

VI.Advanced Functions, PivotCharts, and PivotTables

• 1.Create Predictions and Estimations
• 2.Use FORECAST
• 3.Use TREND
• 4.Use GROWTH
• 5.Use the PMT Function
• 6.Create What-IF Data Tables
• 7.Solve a Problem with a Goal Seek
• 8.Use Solver to Resolve Problems
• 9.Create Lookup Functions
• 10.Create PivotTables and PivotCharts
• 11.Use the PivotTable Field list

VII.Web Pages and Integration

• 1.Save a Worksheet as a Web Page
• 2.Copy Data from a Web Page
• 3.Create a Web Query
• 4.Link and Embed Excel Data
• 5.Paste a Picture
• 6.Link Data
• 7.Edit Linked Data
• 8.Embed Data
• 9.Edit Embedded Data

VIII.Working with Formulas and Graphics

A.Conditional Wizards and Conditional Formatting

• 1.Conditional Sum Wizard
• 2.Conditionally Summarize Data with AVERAGEIF and AVERAGEIFS
• 3.Format Text with Formulas
• 4.Replace Text

B.Auditing

• 1.Formula Error Checking
• 2.Error Messages
• 3.Audit Formulas
• 4.Use the Watch Window
• 5.Evaluate a Formula
• 6.Suppress Errors While Printing

C.Graphics

• 1.Draw Shapes
• 2.Resize, Group, Align, and Arrange Shapes
• 3.Format Shapes
• 4.Add Shapes Effects
• 5.Add Text to a Text Box, Callout, or Other Shape
• 6.Add 3-D Effects
• 7.Rotate Shapes
• 8.Insert WordArt
• 9.Insert Clips
• 10.Insert Pictures
• 11.Format Graphics

IX.Performing Analyses – Working with Databases

A.Filtering Data

• 1.Filter the Items in a Table
• 2.Filter Items without Creating a Table
• 3.Sum, Average, and Count the Items in a Filtered Table
• 4.Advanced Filtering
• 5.Guidelines for Entering Criteria
• 6.Examples of Advanced Criteria
• 7.Remove an In-place Advanced Filter
• 8.Edit Extracted Records

B.Sorting Data

• 1.Sort Excel Items
• 2.Rules for Sorting
• 3.Undo a Sort
• 4.Restore Original Record Order

C.Subtotals

• 1.Add Subtotals
• 2.Create Nested Subtotals
• 3.Remove a Subtotal
• 4.Hide/Display Details
• 5.Manually Outline and Add Subtotals

D.Database Functions

• 1.Use Database Functions
• 2.Excel’s Database Functions
• 3. Finding Exact Matches with VLOOKUP and HLOOKUP

E.Finding Data

• 1.Find and Replace
• 2.Find Cells That Match Particular Criteria

F.Scenarios

• 1.Create Scenarios

G.Consolidating Data

• 1.Data Consolidation
• 2.Create Consolidation Tables

X.Protect and Share Worksheets and Create Special Charts

A.Working with Chart Objects

• 1.Add or Remove Data in a Chart
• 2.Set Data Label Options
• 3.Set Data Table Options
• 4.Format a Data Series
• 5.Create a Stock Chart
• 6.Add a Secondary Value Axis to a Chart
• 7.Change Data Marker Format
• 8.Create an Exploded Pie Chart
• 9.Size the Plot Area or Legend in a Chart
• 10.Create a Stacked Area Chart
• 11.Create a 3-D Chart
• 12.Change the View of a 3-D Chart
• 13.Display or Hide Chart Gridlines

B.Worksheet Protection

• 1.Lock/Unlock Cells in a Worksheet
• 2.Protect a Range
• 3.Protect a Worksheet
• 4.Protect Workbooks

C.Sharing and Merging Workbooks

• 1.Share Workbooks
• 2.Work with a Shared Workbook
• 3.Track Changes
• 4.Merge Changes

D.Data Validation

• 1.Control Data Entry
• 2.Copy and Paste Validation Rules
• 3.Circle Invalid Data
• 4.Remove Duplicate Data

E.Workbook Protection

• 1.Use Document Inspector to Remove Private Information from Workbooks
• 2.Restrict Access to Workbooks with IRM
  3.Identify Workbooks Using Keywords
  4.Add Digital Signatures
  5.Mark Workbooks as Final

Signups closed for this Course