Microsoft Excel Expert: Functions, Forms, and Data

Skill 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
• Create, modify or remove a hyperlink
• Work with shared workbooks
• Add protection to workbooks and worksheets
• Track changes
• Consolidate data
• Create and run macros
• Add form controls

Instructor

David Poitras

Microsoft Master Instructor, PowerConcepts

David was born and raised in Kelowna. He graduated from Okanagan College in 1992 with a diploma in Computer Informative Systems. Afterwards he worked in information technology as a programmer for Okanagan College for 5 years and taught various Microsoft programs in Continuing Studies at Okanagan College. He also had his own software development company for 25 years. He built custom Microsoft software solutions for small to midsized companies in the Okanagan and Lower Mainland. He has been teaching at PowerConcepts for many years and has expert knowledge in all Microsoft Applications.