Learn: in:
» back to Search Results

Course rating of 4 Vendor rating of 4


Level 3 of Excel 2007. 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 2007...
  • 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

Prerequisites & Certificates
Pre-Requisites

Excel 2007 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
 

We have not received any reviews specific to this course as yet, however here are some reviews of the training vendor.

disappointed that Pivot tables were not taught - this topic was I believe , supposed to be covered
Reviewed by 2013
Great.
Reviewed by 2013
I thought it was a great introductory course and will suit my user needs perfectly.
Reviewed by 2012
The course could have benefitted from two full 8 hour days. Haven't received textbooks yet - they were on backorder.
Reviewed by 2012
Great course!
Reviewed by 2012
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 2009
need-to-train-a-group-banner

This course currently does not have any dates scheduled. Please call 1-877-313-8881 to enquire about future dates or scheduling a private, in house course for your team.

This page has been viewed 1454 times.