BSCM 512V - Excel - Level 2 - Advanced Formulas and Analysis
Course Description
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” (and related functions such as countif, sumif, averageif) to identify conditions met or not met for specific criteria. 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 to reduce your workload and ensure the accuracy of the data between worksheets, use tables and use powerful database techniques that include data validation, sorting and filtering, Pivot Tables and an introduction to Power Query. You must be familiar with AutoSum, AutoFill, how to create a basic chart and understand the difference between relative and absolute referencing.
Course Outline
What to expect from this online course:
- You will have live classes via video live-stream, with a chat feature that your instructor will monitor and answer.
- Students will be emailed the course materials and instructions on how to log-in online before the course start date.
Prerequisites
Excel Level 1 or equivalent skills plus strong file management skills. Word Level 1 or equivalent skills recommended. Students should ensure they have a Microsoft Office 365 account and be able to login to this account from a browser (ie. Chrome, Edge).
Recommendations
To take this course online you will need a computer with a reliable internet connection (ideally hard wired in, or located close to your main router), plus a camera and microphone. In addition, it is recommended to use Chrome as your internet browser. You may also find it easier to navigate this on-line course using two computer monitors, however a single large monitor is still fine, you can set up your desktop view as a split screen feature.
We are especially grateful to live, work, and play on the traditional territories of the Lekwungen (Songhees, Kosapsum), Malahat, Pacheedaht, Scia'new, T'Sou-ke, and WSÁNEĆ (Pauquachin, Tsartlip, Tsawout, Tseycum) peoples. We acknowledge their welcome and graciousness to the students who seek knowledge here.
