Microsoft Office 2007

Introduction to Microsoft Office 2007

How to Get Started with Microsoft Word

*The "Blinking Line"
*"Auto-Return" Demo
*How to "Force" a line break
*How to Move the "Blinking Line"
*How to correct typing mistakes.
*How to save your documents (keyboard shortcut)
*How to save your documents (using the mouse)
*The "save as" box
*How to open a document
*How to open a document (using the "open" window)
*How to select text with the keyboard.
*The "Select All" keyboard shortcut
*How to select text with the mouse
*How to cut text
*How to cut and past text
*How to copy & paste text
*How to add text
*How to edit text
*How to insert text
*How to create bulleted lists
*The "undo" command
*How to change your document's font (or "typeface")
*How to format text (bold, underline, italic)
*Text size, text color & text centering
*How to spell check your documents
*How to spell check your entire documents
*How to insert a picture into your document
*How to resize a picture
*How to "format" a photo
*How to "word wrap" a photo
*How to "move" a photo
*How to captaon a photo
*Microsoft word help demo
*How to print
*Footers and page numbers

* Word processing tips:

1)Plain text first
2)Don't adjust the margins
3)Print preview
4)Use default tab stops
5)Spell check
6)Use grammar books
7)Save your work often
8)Back up your documents
9)Use keyboard shortcuts
10)Focus on content

How to Get Started with Microsoft Excel:

GETTING STARTED
*Spreadsheets
*Microsoft office button
*The Ribbon

WORKING WITH A WORKBOOK
*Create a workbook
*Replace template "placeholder" data
*Save a workbook
*Open a workbook
*Entering data
*Entering data in another spreadsheet

MANIPULATING DATA
*Select data
*Select a row or column
*Cut and paste
*Undo and redo
*Auto fill
*Auto fill series of data
*Date format
*Edit data

MODIFYING A WORKSHEET
*Insert columns
*Insert rows
*Clear column data
*Delete columns and rows
*Find and replace
*Go to command
*Spell check


PERFORMING CALCULATIONS
*Excel formulas :
-references
-operators
-constants
-functions
*Formula example
*Change a formula
*Any valid math equation
*Calculate with functions
*Formula bar demo
*Relative references
*View a formula
*Absolute references


SORT AND FILTER
*Basic sorts
*Custom sorts
*Filtering


STUDENT SPREADSHEET DEMO
*Data entry
*Sum column
*Quick format

CHECKBOOK DEMO

PAGE PROPERTIES AND PRINTING
*Set print titles
*Create a header or footer
*Set page margins & orientation
*Set page breaks