Career Training >> Business Skills Training >> Microsoft Office Training >> Microsoft Excel Training >> Excel 2007 Crash Course: Learn Excel in Two Days! Training Seminar
Course ID: 20029 | Course Duration: 2 Days | CEUs: 16 CPE hours
Course Dates: 
 
Career Training
 

Excel 2007 Crash Course: Learn Excel in Two Days! Training Class

Course ID: 20029 		 
 
Course Snapshot View Dates Add To My Courses Get More Information About This Course Register Online Register By Fax On-Site Training View Printer Friendly Version
 
     
 

Excel 2007 Crash Course: Learn Excel in Two Days! Training Seminar

Take this course if you are a a self-taught Excel User and want to learn the new features, as well as the many powerful features of the new Excel 2007.  This course is designed to teach students the most often used features of Excel and runs at a quick pace.  This is fast-paced and appeals to users who have been exposed to Excel previously and understand the basics of the worksheet environment. 		 
     
     
  Course Details  
     
     
  Comments  
  Course Content

Lesson 1: Getting Started

Starting Out

About Workbooks

Exploring your Workbook

Getting Help in Excel 2007

 

Lesson 2: The New Interface

The Quick Access Toolbar

The Home Ribbon

The Insert Ribbon

The Page Layout Ribbon

The Formulas Ribbon

The Data Ribbon

The Review Ribbon

 

Lesson 3: Excel Basics

Working With Excel

Basic Excel Features

Moving your Data

Smart Tags and Options Buttons

Editing Tools

 

Lesson 4: Editing Your Workbook

Modifying Cells and Data

Cell Formatting

Enhancing a Worksheet's Appearance

Working with Charts, Part 1

Working with Charts, Part 2

 

Lesson 5: Printing and Viewing your Workbook

Using the View Ribbon

Managing a Single Window

Managing Multiple Windows

Printing your Workbook

 

Lesson 6: Advanced File Tasks  

Using My Computer within Excel

Saving your Files       

Using Templates

 

Lesson 7: Working with Functions and Formulas

Using Formulas in Excel

Exploring Excel Functions

Using Functions in Excel       

Working with Names and Ranges

Working with Array Formulas

 

         

Lesson 8: Managing Tables

Working with Tables

Working with Records and Fields

Working with Tables and Filters        

Using Excel as a Database 

 

Lesson 9: Enhancing your Workbook   

Customizing your Workbook 

Working with Text Boxes      

WordArt        

ClipArt           

Using Objects

 

Lesson 10: Finalizing Your Workbook    

Protecting your Workbook    

Finishing Your Workbook     

 

Lesson 11: Getting the Most from your Data

Getting the Most From Your Data

PivotTables

More About PivotTables

Exploring Scenarios

What If Analysis

Getting Data from the Internet

 

Lesson 12: Advanced Excel Tasks

Creating and Using Shared Workbooks

Using Custom AutoFill Lists

Using the VLOOKUP Function

Linking, Consolidating, and Combining Workbooks

  
     
     
 
On-Site Training Bring this Excel 2007 Crash Course: Learn Excel in Two Days! training class in-house at your facility. Request More Information Request More Information On Excel 2007 Crash Course: Learn Excel in Two Days!
 
Career Training
 
 
Career Training
  Excel 2007 Crash Course: Learn Excel in Two Days! Training Course Dates and Locations  
     
  Course ID: 20029 | Course Duration: 2 Days  
     
  Locations:  
     
  User Incentive For Registering on TrainUp.com! Gift card when you register today!  
     
 
Start Date Price      Location/Event Details Register Online Request
More Info		   Print/Fax
Register
09/27/2010 US$ 495.00    Raleigh, NC Register Online For The 09/27/2010 Event Request More Information   Register By Fax For The 09/27/2010 Event
11/01/2010 US$ 495.00    Raleigh, NC Register Online For The 11/01/2010 Event Request More Information   Register By Fax For The 11/01/2010 Event
 
     
 
On-Site Training Bring this Excel 2007 Crash Course: Learn Excel in Two Days! training class in-house at your facility. Request More Information Request More Information On Excel 2007 Crash Course: Learn Excel in Two Days!
 
Career Training
 
 
Career Training
  Browse Our Catalog  
     
  Select a market segment to view more courses

  
     
  Or, select a category to view more Business Skills courses

  
     
  Browse By Category Browse By Category

Browse By Location Browse By Location

Browse New Courses Browse New Courses

  
     
Career Training
 
   
 
  
Career Training
   
Career Training
 
 
 
 


Site Map -- Top Training Courses -- Request On-Site Training

Find Jobs -- Degree Programs -- Training Providers -- Resource Center -- About Us -- Contact us

TrainUp.com Your Career Training Marketplace