Computer Training
Course Objectives: Introduction to Microsoft Excel 2007
Compare your skills and experiences to these objectives to see if this course would be appropriate for you to take.
- The Fundamentals
- Creating a New Workbook
- Opening a Workbook
- Navigating a Worksheet
- Entering Labels
- Enter Values
- Selecting a Cell Range
- Overview of Formulas and Using AutoSum
- Entering Formulas
- Using AutoFill
- Understanding Absolute and Relative Cell References
- Using Undo, Redo and Repeat
- Saving Workbook
- Previewing and Printing a Worksheet
- Closing a Workbook
- Editing Cell Contents
- Cutting, Copying and Pasting Cells
- Moving and copying Cells Using the Mouse
- Using the Office Clipboard
- Using the Paste Special Command
- Checking Your Spelling
- Inserting Cells, Rows and Columns
- Deleting Cells, Rows and Columns
- Using Find and Replace
- Using Cell Comments
- Tracking Changes
- Formatting Labels
- Formatting Values
- Adjusting Row Height and Column Width
- Working with Cell Alignment
- Adding Cell Borders, Background Colors and Patterns
- Using the Format Painter
- Using Cell Styles
- Using Document Themes
- Applying Conditional Formatting
- Creating and Managing Condition Formatting Rules
- Finding and Replacing Formatting
- Customizing Access Toolbar
- Using and Customizing AutoCorrect
- Changing Excel’s Default Options
- Recovering Your Documents
- Using Microsoft Office Diagnostics
- Viewing Document Properties and Finding a File
- Saving a Document as PDF or XPS
- Adding a Digital Signature to a Workbook
- Preparing Documents for Publishing and Distribution
- Publishing a Workbook to a Document Workspace
- Creating a Custom AutoFill List
- Creating a Custom Number Format
- Using Logical Functions (IF)
- Using Financial Functions (PMT)
- Using Database Functions (DSUM)
- Using Lookup Functions (VLOOKUP)
- Financial Functions
- Date & Time Functions
- Math & Trig Functions
- Statistical Functions
- Lookup & Reference Functions
- Database Functions
- Text Functions
- Logical Functions