audit excel spreadsheet auditing
audit excel spreadsheet auditing
audit excel spreadsheet auditing audit excel spreadsheet auditing audit excel spreadsheet auditing
audit excel spreadsheet auditing audit excel spreadsheet auditing audit excel spreadsheet auditing audit excel spreadsheet auditing audit excel spreadsheet auditing audit excel spreadsheet auditing audit excel spreadsheet auditing audit excel spreadsheet auditing audit excel spreadsheet auditing
audit excel spreadsheet auditing
 

Online Training

Home Page

Contact Details

info@AuditExcel.co.za

Other training available

- Excel 2003

- Excel 2007

- Excel 2007 Advanced

- Access 2007

- Access 2007 Advanced

MS Excel 2007 Training Series

For pricing see our e commerce site at www.AuditExcel.com

Summary

The Excel 2007 series provides a basic introduction to Excel 2007 including key skills such as entering cell data, editing and formatting cells/ worksheets, and selecting cell ranges. The series also covers printing worksheets, adding comments, creating charts and completing basic calculations and formulas. A particular emphasis is the new Ribbon interface used in Microsoft Excel 2007.

Audience

The Excel 2007 course is for anyone wanting to learn about Excel or requiring a refresher Excel course.
Excel 2007: Getting Started- 2 hrs

  • What can Excel 2007 do?
  • Finding your place
  • Using the new Excel Ribbon
  • Using the formula and status bars
  • Navigating your worksheet
  • Adding / renaming worksheets

Excel 2007: Creating a Worksheet-  3 hrs

  • Entering data as text
  • Entering cell values
  • Entering formulas into cells
  • Correcting spreadsheet errors
  • Using AutoFill, AutoComplete, and Formula AutoComplete
  • Using the AutoSum and SUM function
  • Editing cells

Excel 2007: Formatting Data- 1 hr

  • Choosing cells
  • Formatting the layout of a cell
  • Formatting the size of a cell
  • Formatting data in a cell

Excel 2007: Editing and Printing Worksheets- 1 hr

  • Different Worksheet views
  • Editing and Formula tools
  • Hiding, Inserting and Deleting
  • Printing and Page Layout

Excel 2007: Managing Worksheets- 2 hrs

  • Setting the Panes
  • Ranges and Naming cells
  • Finding Data in a Worksheet
  • Multiple Workbooks
  • Adding Web Links
  • Protecting and Sharing Workbooks
  • Commenting in cells

Excel 2007: Using Charts and Objects- 2hrs

  • Creating Excel 2007 charts
  • Formatting and Modifying Excel charts
  • Shapes and text boxes
  • Smartart
  • Pictures and clip art

Purchase this course from our e commerce site at www.AuditExcel.com


 

Downloads and Free Trial

See how it works with our free Excel 2003 beginner course.

OR

audit excel spreadsheet auditing

Convince you manager to pay for your education

OR

audit excel spreadsheet auditing

More about the training material and how it works

 

 

Looking for something else? Search the site

 

 

Home | Contact Us | Site Map | Training | Sarbanes Oxley | Articles | Links | Blog