Loading...

Course Description

Microsoft Excel Level 3 teaches the information worker how to work with different types of documents using a variety of core and intermediate features to create and edit professional-looking spreadsheets for a variety of purposes and situations.

Students will look at productivity tools to increase data entry, features to enable collaboration with others, and use various commands to analyze large numerical reports.


Course Details

Instructional Delivery

  • Face-to-face in a computer lab

Registration

  • Registrations within 24 hours of course start time must be made by phone (403-220-2866)

Top of Page


Course Content

Course Level Learning Outcomes

Upon completion of this course, you will be able to:

  • Use advanced formatting features
  • Use table names
  • Use advanced functions in Excel
  • Check for errors in formulas
  • Use the data validation feature
  • Use pivot tables and pivot charts
  • Use Power Pivot to extend pivot tables and charts into databases
  • Enable workbooks to work with other workbooks and users
  • Protect worksheets and workbooks from changes
  • Use advanced features with charts and functions
  • Use advanced functions
  • Perform a What-If analysis
  • Used structured references
  • Use advanced Excel features to filter data
  • Extend a data series by filling
  • Use form controls
  • Record and copy macros

Topics of Instruction

  • Manage and Share Workbooks
  • Tracking Changes to a Workbook
  • Adding Comments to a Workbook
  • Apply Custom Formats and Layouts
  • Create Advanced Formulas
  • Using Formulas to Look Up Data in a Workbook
  • Advanced Charts and Tables
  • Create and manage PivotTables and Pivot Charts
  • Saving Work with Macros
  • Recording a Basic Macro

Top of Page


Notes

Required Tools

  • Online and in class students need access to Microsoft Excel 2016 outside of lab/class time to work on assignments, projects, or other course work. This software may be downloaded from Microsoft.

Textbooks

Attendance

It is strongly recommended that students attend every class. It is the responsibility of the student to communicate potential absenteeism to the instructor.

Top of Page


 

Proficiencies

  • Students must be familiar with the personal computer, keyboard and mouse.
  • Students must have Microsoft Windows skills and knowledge, and be able to perform the following tasks:
    • start and run Windows
    • use the taskbar, Start button and Help feature
    • use Minimize, Maximize, Restore Down/Up and Close
    • use the left and right mouse buttons appropriately
    • understand file management techniques
    • navigate between files, folders, or drives

Top of Page


 

Applies Towards the Following Certificate(s)

Loading...

Enrol Now - Select a section to enrol in

Type
Class
Days
M
Time
8:30AM to 4:30PM
Dates
Jun 10, 2019 to Jun 17, 2019
Schedule and Location
Hours
14.0
Delivery Options
Course Fees
Flat Fee non-credit $575.00
Reading List / Textbook

Title: Microsoft Excel 2016 Expert Certification Guide
Edition: 2016
Publisher: CCI Learning
ISBN:  978-1-55332-499-7

Visit the UCalgary Bookstore at www.calgarybookstore.ca.

Section Notes

Due to the intensive nature of this course, it is recommended that you familiarize yourself with course materials before your first class.

Assignments and group work will be required throughout the course duration and a final assignment may be due after the course has ended.

This course uses Desire2Learn (D2L), an online learning management system. The instructor will post your course outline and other materials in D2L one week prior to the course start date. For more information about D2L, please visit our Online Learning Resources.

Students are expected to attend all sessions.

A $25 fee applies for course withdrawals and transfers. Unless otherwise stated, notice of a withdrawal or transfer from a course must be received at least ten calendar days prior to the start date of the course.

Type
Class
Days
M, W
Time
6:00PM to 9:00PM
Dates
Dec 02, 2019 to Dec 16, 2019
Schedule and Location
Hours
14.0
Delivery Options
Course Fees
Flat Fee non-credit $575.00
Reading List / Textbook

Title: Microsoft Excel 2016 Expert Certification Guide
Edition: 2016
Publisher: CCI Learning
ISBN:  978-1-55332-499-7

Visit the UCalgary Bookstore at www.calgarybookstore.ca.

Section Notes

This course uses Desire2Learn (D2L), an online learning management system. The instructor will post your course outline and other materials in D2L. For more information about D2L, please visit our Online Learning Resources.

Unless otherwise stated, notice of withdrawal or transfer from a course must be received at least ten calendar days prior to the start date of the course.

Type
Class
Days
M
Time
8:30AM to 4:30PM
Dates
Jun 01, 2020 to Jun 08, 2020
Schedule and Location
Hours
14.0
Delivery Options
Course Fees
Flat Fee non-credit $575.00
Reading List / Textbook

Title: Microsoft Excel 2016 Expert Certification Guide
Edition: 2016
Publisher: CCI Learning
ISBN:  978-1-55332-499-7

Visit the UCalgary Bookstore at www.calgarybookstore.ca.

Section Notes

This course uses Desire2Learn (D2L), an online learning management system. The instructor will post your course outline and other materials in D2L. For more information about D2L, please visit our Online Learning Resources.

Unless otherwise stated, notice of withdrawal or transfer from a course must be received at least ten calendar days prior to the start date of the course.

Required fields are indicated by .