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.

Objectives:

Upon successful completion of this course, you will be able to create and develop Excel worksheets and workbooks in order to work with and analyze the data that is critical to the success of your organization.

You will:

Get started with Microsoft Office Excel 2016.
Perform calculations.
Modify a worksheet.
Format a worksheet.
Print workbooks.
Manage workbooks.

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.

Duration: 1 - day (8:30am – 4:30pm) - Check calendar for availability.
Course Cost: $310.00 + applicable taxes
Prerequisites: 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.

Objectives:

Upon successful completion of this course, you will be able to leverage the power of data analysis and presentation in order to make informed, intelligent organizational decisions.

You will:

Work with functions.
Work with lists.
Analyze data.
Visualize data with charts.
Use PivotTables and PivotCharts.

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.

Objectives:

Upon successful completion of this course, you will be able to perform advanced data analysis, collaborate on workbooks with other users, and automate workbook functionality.

You will:

Work with multiple worksheets and workbooks.
Use Lookup functions and formula auditing
Share and protect workbooks.
Automate workbook functionality.
Create sparklines and map data.
Forecast data.

Microsoft Office Excel - PivotTables & Dashboards

Participants are experienced Excel users who are seeking to advance their data analysis capabilities by using PivotTables

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 - 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.

Objectives:

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.

Corporate Training

Microsoft Excel

Microsoft Office Excel – Level I

Objectives:

Microsoft Office Excel – Level II

Objectives:

Microsoft Office Excel – Level III

Objectives:

Microsoft Office Excel - PivotTables & Dashboards

Objectives:

Microsoft Office Excel - Excel Data Analysis with Power Pivot

Objectives:

Ready to Register?

Fill out this form to contact us

Fill out this form to contact us

Sign up for the sbc newsletter