Gain the Microsoft Office Excel skills through training

Learn Microsoft Office Excel 2019 organize, calculate, analyze, revise, update, and present your data in ways that will help the decision makers in your organization steer you in the direction.

EXF: Excel 2019 Foundation

Learn Microsoft Office Excel 2019 organize, calculate, analyze, revise, update, and present your data in ways that will help the decision makers in your organization steer you in the right direction. This course builds upon the foundational knowledge presented in the Microsoft Office Excel 2019.

What you'll learn:

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 2019.
• Perform calculations.
• Modify a worksheet.
• Format a worksheet.
• Print workbooks.

This course is for:

This course is intended for students who wish to gain the foundational understanding of Microsoft Office Excel 2019 that is necessary to create and work with electronic spreadsheets.

EXI: Excel 2019 Intermediate

The Excel 2019 builds upon the foundational knowledge presented in Microsoft Office Excel 2019 Foundation course and will help start you down the road to creating advanced workbooks and worksheets that can help deepen your understanding of organizational intelligence.

What you'll learn:

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

This course is for:

This course is designed for students who already have foundational knowledge and skills in Excel 2019 and who wish to begin taking advantage of some of the higher-level functionality in Excel to analyze and present data. 

EXA: Excel 2019 Advanced

What you'll learn:

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.
• Share and protect workbooks.
• Automate workbook functionality.
• Use Lookup functions and formula auditing. 
• Forecast data.

This course is for:

This course is intended for students who are experienced Excel 2019 users and have a desire or need to advance their skills in working with some of the more advanced Excel features. Students will likely need to troubleshoot large, complex workbooks, automate repetitive tasks, engage in collaborative partnerships involving workbook data, construct complex Excel functions, and use those functions to perform rigorous analysis of extensive, complex datasets.