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 - 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 – 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 - 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
Microsoft Office Excel - Data Analysis with Power Pivot
Students taking this course are experienced Excel users who are seeking to advance their data-analysis capabilities by using Power Pivot.
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 Power Pivot along with Excel to analyze data from a variety of sources.
You will:
- Get Started with Power Pivot
- Visualize Power Pivot data
- Work with advanced functionality in Power Pivot
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
