Microsoft Excel Expert Training for Professionals

Skills Inventory

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
• Add data validation, including using pick lists
• Remove duplicate data; circle invalid data
• Work with shared workbooks
• Add protection to workbooks and worksheets
• Track changes
• Use data analysis tools
• Create and modify Pivot Tables or Pivot Charts
• Use slicers with Pivot Tables
• PowerQuery
• Add form controls

Instructor

Frank Byl

President and Owner, PowerConcepts

Frank grew up in Burnaby, BC, in a Dutch immigrant family. After graduating from Simon Fraser University, he taught high school and volunteered in Hawaii and the Philippines before permanently settling in Kelowna. He founded PowerConcepts in 1998 at the height of the Y2K scare. Since then, Frank has obtained his Microsoft Master Instructor certification and helped thousands of clients to hone their computer skills. In his spare time, he plays rugby with the Kelowna Vicars and enjoys almost every outdoor activity from sailing to hiking.