Elearning - Microsoft Excel 2007 short course

Section A: Introduction

• What You Will Learn
• Excel 2007 Interface
• Ribbon and Tabs
• Document Windows
• Navigation Tips

Section B: Creating and Manipulating Data

• Entering Data
• AutoFill a Series
• Fill Non-Adjacent Cells
• AutoFill on Multiple Sheets
• Creating Custom Lists
• Series Formatting

Section C: Managing Worksheets

• Copying Worksheets
• Inserting and Deleting Worksheets
• Hiding Worksheets

Section D: Data Integrity

• Validation Criteria
• Character Validation
• Drop-Down Lists

Section E: Modifying Cell Content

• Cut, Copy, Paste
• Transposing Data
• Copy Cell Format Only
• Removing Duplicates
• Data Validation

Section F: Changing Views

• Zoom Features
• Workbook Views
• Page Layout View
• Repeating Cell Content
• Freeze Panes
• Split Windows
• Viewing Multiple Windows
• Saving Hot Links
• Hiding the Ribbon

Section A: Formatting Data

• Formatting Worksheets
• Worksheet Backgrounds
• Watermarks

Section B: Modifying Rows and Columns

• Inserting Rows
• Inserting Columns
• Cutting and Inserting Columns
• Modifying Cell Width/Height
• Inserting Multiple Rows and Columns
• Inserting and Deleting Cells
• Formatting Rows and Columns
• Hiding/Unhiding Rows and Columns

Section C: Formatting Numbers

• Currency Format
• Format Painter
• Formatting Dates
• Special Formats
• Cell Styles

Section D: Formatting Text and Tables

• Fonts, Fills, and Alignment
• Comments
• Merging and Splitting Cells
• Inserting Hyperlinks
• Formatting as a Table
• Summary Function

Section E: Understanding Formulas

• Using Operations
• Creating Formulas
• AutoSum
• Common Functions
• Searching for Functions
• Copying Formulas
• Absolute Cell References

Section A: Referencing Formulas

• Dependent References
• Multiple Sheet References
• Consolidating Data
• Consolidating with Links

Section B: Ranges and Dates

• AutoSum
• Cell Names
• Formulas with Cell Names
• COUNT
• COUNTA
• Date Formulas

Section C: Subtotals

• Overview
• Subtotal Options
• Selecting Visible Data

Section D: Lookups

• Lookups Purpose
• VLOOKUP
• VLOOKUP Exact Match
• HLOOKUP
• HLOOKUP Exact Match

Section E: Conditional Logic

• IF Syntax
• IF Statement
• Nested IF
• Nested IF Syntax

Section F: More Conditional Logic

• AND
• OR
• NOT
• IFERROR
• SUMIF
• AVERAGEIF
• COUNTIF
• SUMIFS
• AVERAGEIFS
• COUNTIFS