Home About Us Contact Us Search Site Map
Microsoft Excel Level 1-3

 YourOfficeTutor.com

We meet all your Microsoft training needs.

 

Microsoft Excel 2003/2007/2010 Level 1

6 hour class content:

  • Introduction to Microsoft Excel
  • Excel file types
  • Excel environment and toolbars
  • Using the Office Assistant
  • Creating and opening Workbooks and worksheets
  • Working with cells
  • Entering and working with cell data
  • Formatting and customizing data
  • Formatting text and numbers
  • Formatting columns and rows
  • Editing spreadsheets
  • Using find and replace
  • Formulas and functions
  • Printing and Page Setup
  • Practical Exercises

Microsoft Excel 2003/2007/2010 Level 2

4 hour class content:

  • Viewing Worksheets
  • Displaying and customizing toolbars
  • Advanced formatting techniques
  • Using Styles and Format Painting
  • Hiding and displaying cells
  • Advanced formulas and functions
  • Using the Function Wizard
  • Correcting formulas and error checking
  • using the Formula Auditing Toolbar
  • Database and list management
  • Crating and modifying charts and graphs
  • Drawing and picture objects
  • Converting files and copying from other applications
  • Embedding and linking objects
  • Creating and managing links

Microsoft Excel 2003/2007/2010 Level 3

4 hour class content:

  • Importing data from external sources
  • Querying data from the web
  • Using templates and styles
  • Analyzing data to goal seek and "what if?"
  • Using Scenario Manager
  • Macros and custom controls
  • Protecting files and security issues
  • Working with digital signatures
  • Using data validation
  • Customizing Excel XP
  • Collaboration and consolidation of files
  • Practical Exercises

Visit the Microsoft Excel website!

 

Microsoft Excel

Calendar
Classes
Microsoft Access
Microsoft Excel
Internet/E-mail
Microsoft Outlook
Microsoft PowerPoint
Microsoft Publisher
Windows XP Basics
Microsoft Word

©2012 Your Office Tutor, Rob Norgon, Trainer
This site was last updated on February 02, 2012