If you are experienced in Excel but need to start building more complex calculations and sequential operations, then join us for this advance Excel course to learn how to assemble complex operations simply, one step at a time. Also, learn to manage multiple sheets or multiple books and to apply protection, navigation, and form controls.
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
- 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 Bio
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.