Excel 2016 - Level 2- Advanced Formulas and Analysis
- Dates: March 09 to March 16
- Time: 8:30am - 3:30pm
Realistic 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. Prerequisites: Excel 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.
2018W BSCM 512V 002
Mar 9, 14, 16 (3 sessions)
Camosun College School of Business is now running Continuing Educations classes at the Camosun Coastal Centre. To register for this course please do so by clicking on the url below. Registration for this courses will take place directly through Camosun College rather than through this site. Register now and take part in this great learning opportunity!
8:30am - 3:30pm January 23, 2018
8:00am - 4:00pm January 26, 2018
6:00pm - 9:00pm April 24, 2018