DiscoverExcel 2007

• Introducing Excel 2007:Office 2007 Overview, Excel 2007 Overview.
• Screen Layout:The Ribbon, The Title Bar & Quick Access Toolbar, The Office Button.
• Create & Open A WorkBook:What Is A Workbook? Creating A New Workbook, Use A Template, Open An Existing Workbook.
• View A Workbook:What Is A View? Use Page Layout View, Page Break Preview, Custom Views, Show/Hide Options, Zoom Command, Splitting A Worksheet, Freeze Rows & Columns, View Workbooks Side By Side, More Window Display Commands.
• Save A Workbook:New Excel 2007 File Format, Use The Save & Save As Commands, Save A Workbook To Use In Earlier Versions Of Excel.
• File Compatibility:Check Compatibility Between Excel Versions, About File Converters.
• Print Workbooks:Print Worksheets & Workbooks, Modify Page Setup.
• Customize Excel [Expert]:Excel Options, Customize The Quick Access Toolbar, Change Excel Options.
• Help in Excel 2007:Microsoft Office Excel Help, Working In The Excel Help Window, Context Specific Help, Office Diagnostics.

• Cell Basics: What Is A Cell Reference? Select Cells, Navigating A Worksheet.
• Enter Data:Entering Data, What Is A Value? What Is A Label?
• Edit Data:Edit Worksheet Data, Find & Replace Data.
• Copy & Move Data:Copying & Moving Data, Copy & Move Data, Use The Office Clipboard.
• Insert & Delete Cells:Insert & Delete Cells.
• Modify A Worksheet:Insert/Delete Rows & Columns, About Resizing Rows & Columns, Resize Rows & Columns, Hide Rows & Columns.
• Modify A Workbook:Insert & Delete A Worksheet, Move/Copy A Worksheet To Another Workbook, Rename A Worksheet, Format Worksheet Tabs.

• Formulas:What Is A Formula? Create A Formula, Edit A Formula.
• Cell References:Types Of Cell References, Using Relative References, Mixed References.
• Functions:What Is A Function? Enter A Function Manually, Insert A Function, Use A Date Function, Financial Functions, Use A Financial Function, Logical Functions, Use A Logical Function.
• Work With Named Ranges:Using Named Ranges, Range Naming Rules, Define A Range Name Using Labels, Define Range Names For Data Without Labels, Use A Named Range In A Formula.
• Use Lookup Functions [Expert]:What Is A Lookup Function? The VLOOKUP Function, Use The VLOOKUP Function.
• Find & Correct Errors [Expert]:Auditing Worksheets, Trace Errors, Show Formulas, Evaluate A Formula, Use The Watch Window.

• Format Characters:Formatting Text & Numbers, Format Text, Formatting Numbers, Format Numbers, Use A Custom Number Format.
• Format Cells:Formatting Cells, Aligning Cell Content, Align Cell Content, Merge Cells, Apply Borders & Patterns, Apply Color, Format Painter, Clear Cell Formatting, Find & Replace Cell Formatting, Cell Styles.
• Themes [Expert]:Office 2007 Themes.
• Conditional Formatting [Expert]:Conditional Formatting, Apply Conditional Formatting.

• Work With Charts:Adding Charts, Create A Chart, Modify A Chart, Chart Templates, Analyzing Chart Data.
• Work With Graphics:Graphics In Excel 2007, Inserting Pictures, Insert Clip Art, Adding Shapes & Text Effects, Insert SmartArt.

• Share Excel Data:Overview.
• Distribute Workbooks:Proofing Your Workbook, Add Comments To A Worksheet, E-mailing Or Faxing A Workbook.
• Share Workbooks:Create A Shared Workbook, Resolve Conflicts, Track Changes.
• Workbook Protection:Protecting Your Workbook, Allowing Users To Edit Ranges.
• Publish A Workbook:Excel Services, Document Manager Server, Create A Document Workspace.

• Work With Tables:Tables In Excel 2007, Create & Modify A Table, Apply Table Styles.
• Filter & Sort Table Data:Filter Data, Advanced Filtering.
• PivotTable & PivotChart Reports:Using PivotTable & PivotChart Reports, Create A PivotTable, Modifying A PivotTable, Apply PivotTable Styles, Create A PivotChart Report, Modify A PivotChart Report.
• Outline A Worksheet:Using Outlines, Add & Remove An Outline, Outline A Worksheet Manually.
• Data Validation:Use Data Validation, Circle Invalid Data.
• What-If Analysis:Scenarios, Create & View Scenarios, Use Goal Seek, Use Data Tables, Solver, Use Solver.

• Link & Consolidate Data:Data Consolidation, Consolidate Data, Link Consolidated Data, Consolidate Data From Multiple Workbooks.
• Import Data:The Office Clipboard, Import Data From Access With Clipboard, Get External Data, Import Data From The Web, Import Data From Text Files, Import Data Using Microsoft Query.

• Use Macros:What Is A Macro? The Developer Tab, Macro Security, Record A Macro, Absolute Vs. Relative Recording, Edit A Macro, Stepping Into A Macro.
• Create Web Pages:Publish A Worksheet, Insert A Hyperlink.