Microsoft Excel 2007 : Level 1 Training


Untitled Document

Package Includes:
  • 1 DVD Featuring live instructor-led classroom sessions with full audio, video and demonstration components
  • Step-by-step hands-on-labs Try out one of our labs...
  • Focused on practical solutions to real-world development problems
  • Free 1 Year Upgrade Policy
OURexpertText
Sandra Batakis

Sandra Batakis - A+ Trainer, MCT, MCSE, CIW
Sandra is a Senior Microsoft Certified Instructor with over 15 years in the IT certification training and courseware development field. She has offered a wide variety of IT training and high level consulting projects for Fortune 500 companies. She possesses extensive hands-on IT experience including working with building computer networking infrastructure, configuring LAN, WAN and Internet security gateways, Implementing and migrating to Microsoft Exchange 5, 2000, 2003, 2007 and the new Exchange 2010. She has delivered numerous Microsoft, CompTIA and Adobe classroom-based as well as online Boot Camps and Seminars across the United States.

Course Features:

Explore our Training Features

Click on a Feature for more information! (popups must be enabled)
Course Outline TXT
Lesson 1 - Exploring the Excel Environment
Exploring the Excel Environment

Spreadsheets
Microsoft Office Excel 2007
The Excel Application Window
Worksheets
Workbooks
The Microsoft Office Button
Demo - Explore User Interface
Lab - Explore User Interface
The Ribbon
Demo - Ribbon
Lab - Exploring the Ribbon
The Quick Access Toolbar
Demo - Quick Access Toolbar
The Microsoft Office Window Frame
The Home Tab
The Insert Tab
The Page Layout Tab
The Formulas Tab
The Data Tab
The Review Tab
The View Tab
Dialog Box Launchers
The Excel Help Window
Demo - Help
Lab - Obtaining Help
The Excel Help Toolbar
Customization Options
Lab - Customizing the Quick Access Toolbar
Lesson 1 Review
Lesson 2 - Working with an Excel Worksheet
Working with an Excel Worksheet
Mouse Navigation Options
Demo - Navigation
Lab - Navigation in Excel
The New Workbook Dialog Box
The Mini Toolbar
Demo - Enter Data
Lab - Selecting an Entering Data
File Formats
Demo - Saving
Lab - Saving a Workbook
Lab - Converting an XLS Workbook to an XLSX Workbook
Lab - Saving a Workbook in XLS Format
Lesson 2 Review
Lesson 3 - Modify a Worksheet
Modify a Worksheet
Undo and Redo
Demo - Editing
Auto Fill
Demo - Auto Fill
The Find Command
The Replace Command
Demo - Find and Replace
Lab - Searching for Data in a Worksheet
Cell References
Cell Names
Demo - Insert cells
The Go To Command
Lab - Locating a Cell in a Worksheet
The Spelling Dialog Box
Demo - Spell Check
Lab - Spell Checking a Worksheet
Lesson 3 Review
Lesson 4 - Performing Calculations
Performing Calculations
Excel Formulas
The Formula Bar
Demo - Formula
Lab - Creating Basic Formulas
The Order of Operations
Functions
Formula AutoComplete
Demo - Functions Lab - Calculating with other Basic Functions
Relative References
Demo - Coping Formulas and Functions
Lab - Coping Formulas and Functions
Absolute Reference
Demo - Absolute
Lab - Creating an Absolute Reference
Mixed References
Lab - Creating a Mixed Reference
Lesson 4 Review
Lesson 5 - Formatting a Worksheet
Formatting a Worksheet
Fonts
Demo - Text to Column
Lab - Converting Text to Columns
Demo - Fonts
Lab - Modifying Fonts
The Format Cells Dialog Box
Lab - Adding Borders and Colors to Cells
Lab - Transposing Data While Pasting Content
Demo - Column Widths and Row Height
Lab - Changing Column Width and Row Height
Live Preview
Number Formats
Lab - Applying Number Formats
Lab - Aligning Cell Contents
Demo - Merge and Split Cells
Lab - Merging Cells
Demo - Format Number
Demo - Find and Replace Formats
Lab - Replacing Formats
Autoformats
Lab - Applying an AutoFormat
Cell Styles
Demo - Styles
Lab - Applying Cell Styles
Themes
Lab - Applying Themes
Lesson 5 Review
Lesson 6 - Developing a Workbook
Developing a Workbook
Worksheet Tabs
Demo - Format Worksheet Tabs
Lab - Formatting Worksheet Tabs
Insert and Delete Worksheets
Demo - Insert and Delete Sheets
Lab - Inserting and Deleting Worksheets
Lab - Copying and Pasting Worksheet
Lesson 6 Review
Lesson 7 - Printing Workbook Contents
Printing Workbook Contents
Headers
Demo - Print Titles
Footers
Demo - Headers and Footers

Lab - Creating a Header and Footer Header Dialog Box
Page Margins
Lab - Setting Page Margins
Page Orientation
Demo - Margins Orientation
Lab - Changing Page Orientation
Page Breaks
Demo - Page Breaks
Lab - Setting Page Breaks
Lesson 7 Review
Lesson 8 - Customizing Layout
Customizing Layout
Split Worksheet
Demo - Window Split
Lab - Splitting a Worksheet
Freeze and Unfreeze
Lab - Freezing and Unfreezing Rows and Columns
Demo - Arrange
Lab - Arranging Worksheets in New Windows
Lab - Hiding and Unhiding Worksheet
Lesson 8 Review
Closure



Price: $79.00
Buy Product Online | Visit Store Home
   


 Other Items from Office Users

  Office 2003 MOUS Training - 
  Microsoft Publisher 2003 Training - 
  Microsoft FrontPage 2003 Training - 
  Microsoft Word 2007 : Level 1 Training - 
  Microsoft Word 2007 : Level 2 Training - 
  Microsoft Excel 2007 : Level 1 Training - 
  Microsoft Excel 2007 : Level 2 Training - 
  Microsoft Word 2007 Training - 
  Microsoft Excel 2007 Training - 
  Microsoft Access 2007 : Level 1 Training - 
  Microsoft Access 2007 : Level 2 Training - 

 

  Return To MCSE Training MCITP A+ Certification CCNA CEH Training IT Computer Training, Online, eLearning, Videos and CBT

 

 

ecommerce solutions
Shopping cart powered by MonsterCommerce e-commerce solutions.