You are here: Courses : Microsoft Office Courses : Microsoft Office 2007 : Excel 2007
Shopping cart is empty.
This catalog has no sub-catalogs.

E7L1 - Microsoft Excel 2007 Essentials for Creating Financial Documents - Sydney

  • $375.00
  • Booking Dates
Overview:
The skills and knowledge covered in this one-day instructor-led course are sufficient for real-world applications such as budgeting, analysing sales, producing reports, creating charts and graphs and managing small lists.
Key Topics:

Getting started
• Spreadsheet terminology
• Exploring the Excel window
• Getting help
• Navigating workbooks

Entering and editing data
• Entering and editing text and values
• Entering and editing formulas
• Working with pictures
• Saving and updating workbooks

Modifying a worksheet
• Moving and copying data
• Moving and copying formulas
• Absolute and relative references
• Inserting and deleting ranges, rows, and columns

Using functions
• Entering functions
• AutoSum
• Other useful functions

Formatting worksheets
• Formatting text
• Formatting rows and columns
• Formatting numbers
• Conditional formatting
• Copying formats and applying table formats

Printing
• Preparing to print
• Page Setup options
• Printing worksheets

Creating charts
• Chart basics
• Modifying charts
• Printing charts

Managing large workbooks
• Viewing large worksheets
• Printing large worksheets
• Using multiple worksheet

IT Certification Testing

Microsoft Office SpecialistCEO is an Authorised Certiport Testing Centre for Microsoft Office Certifications and Microsoft Business Certifications.

Prometric Testing Centre

Prometric Training

CEO is an Authorised Prometric Testing Centre with on-site booking and testing facilities.

PEARSON Testing Centre

Pearsons Training

CEO is an Authorised Pearson VUE Testing Centre providing clients with on-site booking and testing facilities.

To set-up a Prometric Testing ID or Pearson VUE Testing ID please click on the Prometric or Pearson VUE logos above.