In this course, students will learn how to use the features of Microsoft Office, including Word, Excel, PowerPoint, and Outlook. This course is geared toward users/employees who are looking to enhance their MS office software skills in the workplace and can be customized to student needs in the classroom. Students will explore Word, where they will get experience using tabs, templates, and ribbon commands. Students will master new features in graphics and tables as well as the new Reviewing features and Office apps, and learn how to work with PDFs in Word. In Excel, students will learn to speed up their work using the Quick Analysis tool, Flash Fill, and some great new chart features. In PowerPoint, students will discover new ways to make your presentations look better than ever, including themes, graphics, shapes, colors, and animation. Students will also learn how to use the new Presenter view and commenting features, and how to present your slide show in an online meeting.

This course is offered in a remote learning capacity. Zoom guidance and instructions will be provided prior to the start of the course. 

This course covers Microsoft Office Specialist exam objectives to help students prepare for the Excel 2016/2019 Exam and the Excel 2016/2019 Expert Exam.

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

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

Course Prerequisites: To ensure success, you need to be familiar with using personal computers and should have experience using a keyboard and mouse. You should also be comfortable working in the Windows environment.

Excel Versions That Can Attend: Excel 2019, 365, 2016, & 2013 (Microsoft Windows PC)

Course Taught With: Excel version 2019 (Microsoft Windows PC) Software

Not Appropriate For: Macintosh versions of Excel

This course is offered in a remote learning capacity. Zoom guidance and instructions will be provided in advance of the first session. 

In this course you'll learn create advanced workbooks and worksheets that can help deepen your understanding of organizational intelligence. The ability to analyze massive amounts of data, extractactionable information from it, and present that information to decision makers is at the foundation of a successful organization that is able to compete at a high level.

To gain a truly competitive edge, you need to be able to extract actionable organizational intelligence from your raw data. In other words, when you have questions about your data, you need to know how to get Excel to provide the answers for you.

Target Student: This course is designed for those, who already have foundational knowledge and skills in Excel 2016and who wish to begin taking advantage of some of the higher-level functionality in Excel to analyze and present data.

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

This course covers Microsoft Office Specialist exam objectives to help students prepare for the Excel2016/2019 Exam and the Excel 2016/2019 Expert Exam.

Course Prerequisites: This course builds upon the foundational knowledge presented in the Microsoft Office Excel 2016 Expert Exam.

Excel Versions That Can Attend: Excel 2019, 365, 2016, & 2013 (Microsoft Windows PC)

Course Taught With: Excel version 2019 (Microsoft Windows PC) Software 

Not Appropriate For: Macintosh versions of Excel

This course is offered in a remote learning capacity. Zoom guidance and instructions will be provided in advance of the first session.