Excel - Level 1 • BSCM 511V (12 hours)
Whether you manage your own finances, run a business or a large organization, this course will give you the skills you need to have Excel do your calculations. Each topic is designed to save you time and ensure the integrity of your data. Use AutoFill, number styles, relative and absolute cell referencing, and many more commands to reduce typing and increase accuracy. Know how and when to apply functions (e.g. average, sum, count, min, max) to calculate your data; simplify your formatting, and create charts to visually represent your numbers. An electronic course manual (pdf) is included.
Course Learning Outcomes
Upon completion of this course, learners will be better able to:
- Understand and navigate the Excel interface (workbooks vs. worksheets, ribbon, tabs, groups, help)
- Create, save, close, open, rename and delete workbooks and worksheets
- Select and modify cells (adjacent and non-adjacent) and define cell and range references
- Enter and edit text, values, dates, times, symbols, special characters and functions
- Use AutoFill and other fill commands
- Understand and apply the order of mathematical operations (BEDMAS)
- Manage worksheets:
- Insert, hide, delete and adjust rows and columns
- Switch between open workbooks
- Group worksheets
- Apply character, number and cell formatting, and understand how themes work
- Define number styles (accounting, comma, percent, date)
- Use Format Painter to copy formatting
- Apply page set up and printing layout options:
- Preview and print worksheets/workbooks
- Customize printing and add headers/footers
- Understand and use relative, absolute and mixed cell references in formulas:
- Describe when and how to use relative vs. absolute references
- Use introductory Excel functions (sum, average, count, max, min, round)
- Create and modify introductory charts (column, pie, line and other chart types)
- Document a workbook