Home > Course Catalog > Discover Excel 2007 Part I
Discover Excel 2007 Part I

Discover Excel 2007 is an interactive e-learning tool for users of Microsoft Office Excel 2007. The Discover products combine audio, animation, and software simulation to make the “discovery” of computer programs both effective and entertaining. The products are also designed to help you learn at your own pace, allowing you to repeat topics or jump to anywhere in the course.

The following topics are covered in this course:

Excel 2007 Basics
  • 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.
Work With Cells & Worksheets
  • 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.
Calculate Your Data
  • 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 Your Workbook
  • 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.


Download now!