Microsoft Excel
Microsoft Office Excel – Level I
Learn to create and edit basic Excel worksheets. This course is intended for participants who want to get up to speed with Microsoft Excel and gain a strong foundational understanding of Excel that is necessary to create and work with electronic spreadsheets. It is recommended that participants review the course outline.
Length: 1—day (8:30am – 4:00pm)
Course Cost: $310.00 + GST
Prerequisite: An introductory course to WIndows or a solid working knowledge of Windows
Objectives:
- Create a basic worksheet by using Excel.
- Perform calculations in an Excel worksheet.
- Modify an Excel worksheet.
- Modify the appearance of data within a worksheet.
- Manage Excel workbooks.
- Print the content of an Excel worksheet.
Microsoft Office Excel – Level II
This course is designed for students who already have a foundational knowledge and skills in Excel, who wish to begin taking advantage of some higher-level functionality in Excel to analyze and present data. It is recommended that participants review the course outline.
Prerequisities: Participants should have a basic working knowledge of formulas and functions, as well as being comfortable with the use of shortcuts, and is aware of the difference between a relative and an absolute reference.
Length: 1—day (8:30am – 4:00pm)
Course Cost: $310.00 + GST
Objectives:
- Work with functions and learn formula auditing
- Protect workbooks and create a template
- Work with lists
- Analyze data
- Visualize data with charts
Microsoft Office Excel – Level III
Automate some common Excel tasks, apply advanced analysis techniques to more complex data set, troubleshoot errors, collaborate on worksheets, and share Excel data with other applications.
Length: 1—day (8:30am – 4:00pm)
Course Cost: $310.00 + GST
Objectives:
- Work with multiple worksheels and workbooks
- Use Lookup functions
- Automate workbook functionality
- Forecast data
- Introduction to Pivot Tables and Pivot Charts
Microsoft Office Excel - Formulas & Functions
Participants are at an intermediate level and have a working knowledge of developing basic functions in Excel. A strong interest to improve one’s understanding of formulas and to learn more complex functions.
Length: 1—day (8:30am – 4:00pm)
Course Cost: $290.00 + GST
Objectives:
- Tips and tricks
- How to type formulas in Excel
- Introduction to Array formulas
- Deciding which cell reference is needed when copying a formula
- How to read and understand formulas; its simplicity and complexity
- Creating and understanding functions
Microsoft Office Excel - PivotTables & Dashboards
Participants are experienced Excel users who are seeking to advance their data analysis capabilities by using PivotTables
Length: 1—day (8:30am – 4:00pm)
Course Cost: $310.00 + GST
Objectives:
Upon successful completion of this course, you will be able to use Excel advanced PivotTable functionality to analyze your raw data. You will:
- Prepare data for PivotTable reporting and create PivotTables from various data sources
- Analyze data by using PivotTables
- Work with PivotCharts
- Design a Dashboard
Ready to Register?
If you are ready to register you may do so online by clicking the link the below, downloading the PDF application, or calling 306-244-6340.
Or
Corporate Training
- Corporate Training
- Corporate Training Testimonials
- Register for a Corporate Course
- Search by Calendar
- Make a Payment
- Customized Training Solutions
- Lab Rentals
- Microsoft Office
- Office 365 Licensing
- Windows 10
- Microsoft Technical
- Adobe Creative Cloud
- Accounting Software
- Professional Development
- Project Management
- Cyber Security
Find out more about our Corporate Training!
call now 1-800-679-7711
Validation that I am following proper procedures in meeting minute taking”
J. Kyplain
partnerships & accreditation
