Excel 2003 Advanced

Level 3 of Excel 2003. In this course, participants will be working with: multiple sheets; Excel fundamentals; charting including; database features; and much more.

Course Outline

Level 3 of Excel 2003...

• Streamlining with macros including:
  • What is a macro
  • Creating and editing a macro
  • Documenting, invoking and cancelling a macro
  • Useful everyday macros
  • Assigning macros to the toolbar
  • Assigning macros to buttons and quick keys
  • Saving your macros
• Advanced formula creation including:
  • Using the IF function
  • Using vertical and horizontal lookups
  • Working with date functions
  • Using auditing features
  • Testing for NA
• Customizing the work area including:
  • Customizing the toolbars
  • Creating your own toolbars
  • Creating styles
  • Creating templates
  • Protecting your worksheets
  • Using Data validation
  • Creating lookups
• Miscellaneous features including:
  • Creating pivot tables
  • Creating pivot table from multiple ranges
  • Modifying your pivot table
  • Creating scenarios
  • Using goal seek and solver
  • Tips and tricks
  • Excel and the Internet

Additional Details

Pre-Requisites

Excel 2003 Intermediate

Certificates offered

Included will all courses are course notes, a pad for note taking and telephone support following the class. Participants will receive a Certificate of completion

Cancellation Policy

Please note that CL Douglas requires 5 business days notice of your intent to postpone or cancel a course. A fee of not less than $50.00/course to a maximum of the full fee per course is due on the day of the scheduled course if the above condition is not met or if the registrant fails to notify CL Douglas that they will not be attending the course. If you cancel or postpone you will be issued a reference number. Fees for courses due to cancellation, postponement or for failure to notify may at the discretion of CL Douglas be applied to future courses providing enrollment is completed in a two month period from the date of the originally scheduled class.

Map & Reviews

C L Douglas
[ View Provider's Profile ]

Reviews

 

This course has not yet been rated by one of our members.

If you have taken a course through this vendor please log into your account and leave feedback for this vendor. You will be helping ensure our members get directed to the best training facilities.

Here are some reviews of the training vendor.

   

This was a great seminar and although the outside of the building was deceiving (needing a little work as an old house converted to this) the inside was warm and inviting. The special touches like baked goodies and fruit and full service kitchenette were

Reviewed by Kim C. 2009