Course DescriptionRealistic examples will be used to demonstrate ways to build on your basic knowledge of Excel to increase your productivity. Use powerful logic functions such as “IF” to identify conditions met or not met for specific criteria. Determine if you can afford a loan with financial payment functions. Use conditional formatting tools to easily identify key indicators for your business such as top 10, or highest average, based on your unique criteria. Link and group worksheets, use named ranges to quickly locate data, and use powerful database techniques that include data validation, sorting and filtering and many more Excel topics. You must be familiar with AutoSum, AutoFill, how to create a basic chart and understand the difference between relative and absolute referencing.
PrerequisitesExcel Level 1 or equivalent skills plus strong file management skills. Word Level 1 or equivalent skills recommended. Electronic course manual (pdf) included. See course outline for detailed list of topics.
Testimonials"Caroline was amazing! She was funny, informative and a pleasure to have as an instructor! Very easy learning pace, tons of help given so you're never lost." V.E.
Applies Towards the Following Certificates
- MS Office : Required