Excel 2007

5 Sessions –

15 Hours of Interactive Training

Office applications evolve to fit new challenges and add innovative features for ease of use and convenience. If you’re a spreadsheet novice or an experienced professional, the Excel 2007 course from LearnKey can help you master spreadsheets. LearnKey expert Michael Meskers uses practical examples to show you Excel fundamentals before moving step-by-step into more advanced topics like graphs, charts, formulas and macros. At the conclusion of this course, you’ll feel confident in your ability to use Excel 2007 for robust business applications.

Benefits

Learn skills in one of the most powerful spreadsheet programs.

Produce impressive business documents easily and quickly.

Enhance your personal productivity and promotional value.

About The Author

With a B.A., two Masters Degrees and fluency in six languages, Michael Meskers is highly adept at helping students understand the complexities of applications in many languages. As the author of “The Learning Line: Windows Vista” and with 19 years of management experience, he brings real-world experience to his instruction. Some of his clients include William H. Mercer Inc., Sanford Bernstein Inc. and Digi-Com Group.

Session 1

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

Session 2

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

Session 3

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

Excel 2007

Excel 2007

Excel 2007 continued