Microsoft Office Training

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 simultaneously.
• Share and protect workbooks.
• Automate workbook functionality.
• Apply conditional logic.
• Audit worksheets.
• Use automated analysis tools.
• Present your data visually.

Target Trainee:

This course is intended for trainees who are experienced Excel 2013/2016 users and have a desire or need to advance their skills in working with some of the more advanced Excel features. Trainees 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.

In this course, you will create and manage an Access 2016 database.

You will:

• Navigate within the Microsoft Access application environment, create a simple database, and customize Access configuration options.
• Organize and manage data stored within Access tables.
• Use queries to join, sort, and filter data from different tables.
• Use forms to make it easier to view, access, and input data.
• Create and format custom reports.

Target Trainee:

This course is designed for trainees who wish to establish a foundational understanding of Microsoft Office Access 2016, including the skills necessary to create a new database, construct data tables, design forms and reports, and create queries.