Microsoft Excel
Microsoft Office Excel – Level I
Learn to create and edit basic Excel worksheets. This course is designed for students who desire to gain the necessary skills to create, edit, format and print basic Excel worksheets.
Length: 1—day (8:30am – 4:00pm)
Course Cost: $310.00 + GST
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
Use advanced formulas and work with various tools to analyze data in spreadsheets. You will also organize table data, present data as charts, and enhance the look and appeal of workbooks by adding graphical objects.
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
