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