TOTAL DAYS: 1 | TOTAL HOURS: 6.5

Microsoft Office Excel 2019: Part 1

Organizations the world over rely on information to make sound decisions regarding all manner of affairs. But with the amount of available data growing on a daily basis, the ability to make sense of all of that data is becoming more and more challenging. Fortunately, this is where the power of Microsoft® Office Excel® 2019 can help. Excel can help you 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. It will also make these tasks much easier for you to accomplish, and in much less time, than if you used traditional pen-and-paper methods or non-specialized software. This course aims to provide you with a foundation for Excel knowledge and skills, which you can build upon to eventually become an expert in data manipulation.

This course covers Microsoft Office Specialist Program exam objectives to help you prepare for the Excel Associate (Office 365 and Office 2019): Exam MO-200 and Excel Expert (Office 365 and Office 2019): Exam MO-201 certifications.

This course is the first part of a three-course series that covers the skills needed to gain a foundational understanding of Excel.
– Microsoft Office Excel 2019: Part 1 (this course)
– Microsoft Office Excel 2019: Part 2
– Microsoft Office Excel 2019: Part 3

Completion of this course will earn 0.6 CEUs.

TOTAL DAYS: 1 | TOTAL HOURS: 6.5

Microsoft Office Excel 2019: Part 2

This course builds upon the foundational knowledge presented in the Microsoft® Office Excel® 2019: Part 1 course and will help start you down the road to creating advanced workbooks and worksheets that can help deepen your understanding of organizational intelligence. The ability to analyze massive amounts of data, extract actionable 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.

This course covers Microsoft Office Specialist Program exam objectives to help you prepare for the Excel Associate (Office 365 and Office 2019): Exam MO-200 and Excel Expert (Office 365 and Office 2019): Exam MO-201 certifications.

This course is the second part of a three-course series that covers the skills needed to gain a foundational understanding of Excel.
– Microsoft Office Excel 2019: Part 1
– Microsoft Office Excel 2019: Part 2 (this course)
– Microsoft Office Excel 2019: Part 3

Completion of this course will earn 0.6 CEUs.

TOTAL DAYS: 1 | TOTAL HOURS: 6.5

Microsoft Office Excel 2019: Part 3

This course builds upon the foundational and intermediate knowledge presented in the Microsoft® Office Excel® 2019: Part 1 and Microsoft® Office Excel® 2019: Part 2 courses to help you get the most of your Excel experience. The ability to collaborate with colleagues, automate complex or repetitive tasks, and use conditional logic to construct and apply elaborate formulas and functions will put the full power of Excel right at your fingertips. The more you learn about how to get Excel to do the hard work for you, the more you’ll be able to focus on getting the answers you need from the vast amounts of data your organization generates.

This course covers Microsoft Office Specialist Program exam objectives to help you prepare for the Excel Associate (Office 365 and Office 2019): Exam MO-200 and Excel Expert (Office 365 and Office 2019): Exam MO-201 certifications.

This course is the third part of a three-course series that covers the skills needed to gain a foundational understanding of Excel.
– Microsoft Office Excel 2019: Part 1
– Microsoft Office Excel 2019: Part 2
– Microsoft Office Excel 2019: Part 3 (this course)

Completion of this course will earn 0.6 CEUs.

TOTAL DAYS: 1 | TOTAL HOURS: 6.5

Microsoft Office Excel 2021: Part 1

Organizations the world over rely on information to make sound decisions regarding all manner of affairs. But with the amount of available data growing on a daily basis, the ability to make sense of all of that data is becoming more and more challenging. Fortunately, this is where the power of Microsoft® Office Excel® 2021 can help. Excel can help you 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. It will also make these tasks much easier for you to accomplish, and in much less time, than if you used traditional pen-and-paper methods or non-specialized software. This course aims to provide you with a foundation for Excel knowledge and skills, which you can build upon to eventually become an expert in data manipulation.

This course covers Microsoft Office Specialist Program exam objectives to help you prepare for the Excel Associate (Office 365 and Office 2021): Exam MO-200 and Excel Expert (Office 365 and Office 2021): Exam MO-201 certifications.

This course is the first part of a three-course series that covers the skills needed to gain a foundational understanding of Excel.
– Microsoft Office Excel 2021: Part 1 (this course)
– Microsoft Office Excel 2021: Part 2
– Microsoft Office Excel 2021: Part 3

Completion of this course will earn 0.6 CEUs.

TOTAL DAYS: 1 | TOTAL HOURS: 6.5

Microsoft Office Outlook 2016: Part 1

Email has become one of the most widely used methods of communication, whether for personal or business communications. In most organizations, large or small, email is the preferred form of communicating information amongst employees. As email grows in popularity and use, most organizations have found the need to implement a corporate mail management system such as Microsoft® Office Outlook® to handle the messages and meeting invitations sent among employees.

In this course, you will use Outlook to send, receive, and manage email messages, manage your contact information, schedule appointments and meetings, create tasks and notes for yourself, and customize the Outlook interface to suit your working style.

This course is the first in a series of two Microsoft® Office Outlook® 2016 courses. It will provide you with the basic skills you need to start using Outlook 2016 to manage your email communications, contact information, calendar events, tasks, and notes.

You can also use this course to prepare for the Microsoft Office Specialist (MOS) Certification exams for Microsoft Outlook 2016.

This course is the first part of a two-course series that covers the skills needed to gain a foundational understanding of Outlook.
– Microsoft Office Outlook 2016: Part 1 (this course)
– Microsoft Office Outlook 2016: Part 2

Completion of this course will earn 0.6 CEUs.

TOTAL DAYS: 1 | TOTAL HOURS: 6.5

Microsoft Office Outlook 2019/2021: Part 1

In this course, you will use Outlook to send, receive, and manage email messages, manage your contact information, schedule appointments and meetings, create tasks and notes for yourself, and customize the Outlook interface to suit your working style.

This material will benefit users of any current Office version. The classroom environment setup is based on Office 2019.

This course is the first in a series of two Microsoft® Office Outlook® 2019/2021 courses. It will provide you with the basic skills you need to start using Outlook 2019/2021 to manage your email communications, contact information, calendar events, tasks, and notes.

This course covers Microsoft Office Specialist Program exam objectives to help you prepare for the Outlook Associate (Office 365 and Office 2019): Exam MO-400 certification.

This course is the first part of a two-course series that covers the skills needed to gain a foundational understanding of Outlook.
– Microsoft Office Outlook 2019/2021: Part 1 (this course)
– Microsoft Office Outlook 2019/2021: Part 2

Completion of this course will earn 0.6 CEUs.

TOTAL DAYS: 1 | TOTAL HOURS: 6.5

Microsoft Office Outlook 2019/2021: Part 2

In this course, you will customize command sets, configure mail accounts, set global options, perform advanced searches, apply filters to intercept mail and control spam, create rules to automate mail management tasks, work with calendars and contacts, manage tasks, preserve data with archives and data files, as well as share and delegate access to your Outlook items. In short, you’ll work with a wide range of features and options and, in so doing, understand why Outlook is a leading personal management system.

This material will benefit users of any current Office version. The classroom environment setup is based on Office 2019.

This course builds upon the foundational knowledge presented in the Microsoft ® Office Outlook® 2019/2021: Part 1 course and will help you customize a communication system well-suited to your work style.

This course covers Microsoft Office Specialist Program exam objectives to help you prepare for the Outlook Associate (Office 365 and Office 2019): Exam MO-400 certification.

This course is the second part of a two-course series that covers the skills needed to gain a foundational understanding of Outlook.
– Microsoft Office Outlook 2019/2021: Part 1
– Microsoft Office Outlook 2019/2021: Part 2 (this course)

Completion of this course will earn 0.6 CEUs.

TOTAL DAYS: 1 | TOTAL HOURS: 6.5

Microsoft Outlook for Office 365 (Desktop or Online): Part 1

In this course, you will use Outlook to send, receive, and manage email messages; manage your contact information; schedule appointments and meetings; create tasks and notes for yourself; and customize the Outlook interface to suit your working style.

Note: Most Office 365™ users perform the majority of their daily tasks using the desktop version of the Office software, so that is the focus of this training. The course material will also enable you to access and effectively utilize many web-based resources provided with your Office 365 subscription. This includes brief coverage of key skills for using Outlook on the Web and OneDrive®. Helpful notes throughout the material alert you to cases where the online version of the application may function differently from the primary, desktop version.

This course may be a useful component in your preparation for the Microsoft Outlook (Microsoft 365 Apps and Office 2019): Exam MO-400 certification exam.

This course is the first part of a two-course series that covers the skills needed to gain a foundational understanding of Outlook.
– Microsoft Outlook for Office 365 (Desktop or Online): Part 1 (this course)
– Microsoft Outlook for Office 365 (Desktop or Online): Part 2

Completion of this course will earn 0.6 CEUs.

TOTAL DAYS: 1 | TOTAL HOURS: 6.5

Microsoft Outlook for Office 365 (Desktop or Online): Part 2

In this course, you will customize command sets, configure mail accounts, set global options, perform advanced searches, apply filters to intercept mail and control spam, create rules to automate mail management tasks, work with calendars and contacts, manage tasks, preserve data with archives and data files, as well as share and delegate access to your Outlook items. In short, you’ll work with a wide range of features and options and, in so doing, understand why Outlook is a leading personal management system.

Note : Most Office 365™ users perform the majority of their daily tasks using the desktop version of the Office software, so that is the focus of this training. The course material will also include helpful notes throughout the material to alert you to cases where the online version of the application may function differently from the primary, desktop version.

This course builds upon the foundational knowledge presented in the Microsoft® Outlook® for Office 365™ (Desktop or Online): Part 1 course and will help you customize a communication system well-suited to your work style.

This course may be a useful component in your preparation for the Microsoft Outlook (Microsoft 365 Apps and Office 2019): Exam MO-400 certification exam.

This course is the second part of a two-course series that covers the skills needed to gain a foundational understanding of Outlook.
– Microsoft Outlook for Office 365 (Desktop or Online): Part 1
– Microsoft Outlook for Office 365 (Desktop or Online): Part 2 (this course)

Completion of this course will earn 0.6 CEUs.

TOTAL DAYS: 1 | TOTAL HOURS: 2

PivotTables

This is a 2-hour virtual class, and in celebration of our 30th Anniversary, it will be held for $30!