Dates: Sept 22 & 23
Time: 8:30-12:30
Investment in your skill set: $189
COURSE OUTLINE
Exploring Excel 2007
◦Exploring the Excel Program Window
◦Navigating in a Worksheet
◦Working with Tabs and Ribbons
◦The Office Button
◦The Quick Access Toolbar
◦Entering Data in Excel
◦Working with Numbers
◦Understanding Save Concepts
Editing, Viewing, and Printing Worksheets
◦Editing Entries
◦Excel Ranges
◦Using Auto Features
◦Working with AutoFill
◦Exploring the Many Views of Excel
◦Printing Worksheets
Working with Formulas and Functions
◦Working with Formulas and Functions
◦Cell and Range References
◦Please Excuse My Dear Aunt Sally
◦Using Cell References in Formulas
◦Relative Cell References
◦Absolute Cell References
◦Mixed References
◦What-If Analysis
Formatting the Contents of Cells
◦Formatting Entries with the Ribbon
◦Using the Mini Toolbar
◦Live Preview
◦Merging and Splitting Cells
◦Wrapping Text
◦Formatting with Themes
◦Inserting Date Functions and Formatting
Changing the Appearance of Worksheets
◦Modifying Columns and Rows
◦Column Widths and Row Heights
◦Inserting and Deleting Rows and Columns
◦Hiding Columns and Rows
◦Changing Vertical Alignment and Rotating Text
◦Using Excel’s Help Feature
◦Using Excel’s Proofing Tools
BONUS: Discovering the Magic of Excel Charting
(Due to time constraints in classroom, this bonus module is available online)
◦Managing Worksheets
◦Creating Charts in Excel
◦Introducing OfficeArt
◦Exploring Other Chart Types
◦Applying Styles to Charts
