Skip to main content
COVID-19 information and screening Learn how we’re keeping our campus community safe, healthy and engaged during our gradual return to campus.
Note: The university’s mandatory vaccine directive is now in effect. Learn more about vaccine requirements.
Ontario Tech acknowledges the lands and people of the Mississaugas of Scugog Island First Nation.

We are thankful to be welcome on these lands in friendship. The lands we are situated on are covered by the Williams Treaties and are the traditional territory of the Mississaugas, a branch of the greater Anishinaabeg Nation, including Algonquin, Ojibway, Odawa and Pottawatomi. These lands remain home to many Indigenous nations and peoples.

We acknowledge this land out of respect for the Indigenous nations who have cared for Turtle Island, also called North America, from before the arrival of settler peoples until this day. Most importantly, we acknowledge that the history of these lands has been tainted by poor treatment and a lack of friendship with the First Nations who call them home.

This history is something we are all affected by because we are all treaty people in Canada. We all have a shared history to reflect on, and each of us is affected by this history in different ways. Our past defines our present, but if we move forward as friends and allies, then it does not have to define our future.

Learn more about Indigenous Education and Cultural Services

Excel Essentials for Managers

Overview:

This one-day hands-on course is designed for those with a basic knowledge of Excel, who need to use key Excel features to manage, customize and automate workbooks. Participants will gain knowledge and skills to increase productivity and discover timesaving techniques, shortcuts and tips.

Participants should possess a basic knowledge of Excel.

Simone Lee Hubers, B.A. (Hons.), University of Toronto, has been a computer trainer and consultant for over 30 years. Simone is an engaging and talented instructor, experienced in teaching computer software from introductory to advanced levels.  She is passionate about sharing her knowledge and focuses on helping her students to build efficiencies in their work.

Please contact us if you are interested in arranging this as a customized program.

Who should attend?

You may use the knowledge and skills developed through this course to build and enhance your productivity through the use of spreadsheets and workbooks, such as:

  • Project managers and data users;
  • Entrepreneurs and small business owners;
  • Those who build and share reports;
  • Anyone looking to build their data entry, storage and tracking skills.

What you'll learn

In the course, you will learn about:

  • Using keyboard shortcuts
  • Setting up custom views
  • Creating outlines
  • Working with range names
  • Applying conditional formatting
  • Working with functions and formulas
  • Using formula auditing tools
  • Protecting and validating data
  • Handling multiple sheets and workbooks
  • Sorting and filtering data
  • Subtotaling data
  • Working with Excel tables
  • Using slicers
  • Creating charts
  • Creating basic pivot table reports

 Registration Status
Closed

Location
Online*

*All Continuous Learning sessions are being offered online until further notice. Online participation instructions will be emailed to registered learners before the start of their courses/workshops. Thank you for your flexibility and understanding.

 Date
To be determined

Credential
Course completion

 Fees
To  be determined

Contact Information: continuouslearning@ontariotechu.ca