Microsoft Excel 365 Level 3

We’re Manitoba’s largest institute of applied learning and research, and take pride in preparing our students to become leaders in their fields.

First, students will create tables to give structure to data and use sorting and filtering to analyze data and use Total row option for summary function calculations. Then, students will use the Quick Analysis Tool for direct access to a collection of features as an alternative to tabs. Students will then create basic macros to change manual repetitive tasks into automated tasks. Next, students will create templates as a predesigned basis for new workbooks using frequently used content to save time and to ensure consistency. Finally, students will learn how to protect worksheets and cells from unauthorized access or editing.

Total course hours and credit hours: 15 course hours and non-credit course.

Knowledge and Skills Demonstrated:

This badge certifies that the student can demonstrate the following knowledge and skills:

1. Create tables and analyze data,
2. Access formatting, charts, totals, tables and sparklines,
3. Create macros to automate repetitive tasks when using spreadsheets- record, edit and run macros,
4. Save all macros in a single workbook,
5. Create templates with text, numbers, and formulas,
6. Use templates to create new workbook,
7. Protect cells and worksheets from edit.

Evidence/Criteria for Success:

The student has successfully met the course criteria by achieving the minimum performance requirement (of 50%) on each of the three assignments below:

Assignment 1: Create Tables

Evaluation of outcomes #1 and #2

Create tables and analyze data. Access formatting, charts, totals, tables, and sparklines.

Assignment 2: Macros and Templates

Evaluation of outcomes #3, #4, #5, #6

Create macros to automate repetitive tasks when using spreadsheets. Create templates as the basis of new workbooks to save time and to ensure consistency when using spreadsheets.

Assignment 3: Protection Workbooks, Worksheets, and Cells.

Evaluation of outcome #7

Protect cells and worksheets from edits.