21
September 2015

Microsoft Excel Expert Training for Engineers and Geoscientists

Please Note
Laptop and authorized Microsoft manual will be provided for you during the course.
Status: Advanced registration is now closed. Please email Jennifer Chan at [email protected] for waiting list inquiries.
Date: Monday, September 21, 2015
Time:
8:00 AM-8:30 AM: Registration 
8:30 AM-4:30 PM: Microsoft Excel Expert Training
Location: Best Western Chateau Granville Hotel (Burrard Room), 1100 Granville St Vancouver, BC
Presenter: Frank Byl, President & Owner, PowerConcepts
Credit: 7 Formal Professional Development Hours (PDH)
Cost: Early Bird Price Engineers and Geoscientists BC Member: $399.00 + GST = $418.95 until Sept 7, 2015

Engineers and Geoscientists BC Member and EIT/GIT Regular Price: $499.00 + GST = $523.95

Non-Member Price: $499.00 + GST = $523.95

Student Member Price: $249.50 + GST = $261.98
Please Note: *A minimum number of registrations are needed by September 07, 2015 to proceed with this seminar. Please register early to avoid cancellation.
**All prices are subject to applicable taxes.
Contact: Jennifer Chan | Professional Development Coordinator
Direct: 604.412.4861
Toll Free: 1.888.430.8035 ext.4861
Fax: 604.639.8180
Email: [email protected]
Learn to manage data through databases and pivot tables that will simplify complex reporting and tracking requirements for projects. Also learn advance functions and tools like Goal Seek and creating Scenarios useful for providing variations on quotes. This course maps to the Microsoft MOS Expert Exam. After reviewing all topics in the manual, participants will be prepared to successfully write the Microsoft Office Specialist Expert Exam.

Basic Skills Checklist 
 
The following list summarizes skills that students will be comfortable with after this course.
  • Use advanced functions such as
    • Information
    • Lookup and reference
    • Conditional logic
    • Conditional summary
  • Add data validation, including using pick lists
  • Remove duplicate data; circle invalid data
  • Create, modify or remove a hyperlink
  • Work with shared workbooks
  • Add protection to workbooks and worksheets
  • Track changes
  • Use data analysis tools
  • Create and modify PivotTables or PivotCharts
  • Use slicers with PivotTables
  • Create and run Macros
  • Add form controls
 


View the full listing of events sponsored and organized by other groups.
Contact Professional Development
Email: [email protected]
Phone: 604.430.8035
Toll-free: 1.888.430.8035
View our career listings or place an employment ad.
Presentations for Post-Secondary Students
Andrea Michaud
Email: [email protected]
Phone: 604.412.4860
 
Presentations for High School Students
Chelsea Smith
Email: [email protected]
Phone: 604.412.4892
See the various opportunities to volunteer with Engineers and Geoscientists BC and in your community.