fbpx

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:

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

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.

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

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.

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.