TOTAL DAYS: 2 | TOTAL HOURS: 13

Data Analysis & Visualization with Microsoft Excel (D.A.V.E.)

Technology and the data that it both collects and makes accessible is now interwoven with businesses and lives. The era of “big data” has exploded due to the rise of cloud computing, which provides an abundance of computational power and storage, allowing organizations of all sorts to capture and store data. Leveraging that data effectively can provide timely insights and competitive advantage.

Analyzing data to find issues, insights, and opportunities is now a critical part of many job roles. Beyond the analysis, data analysts in all job roles must be able to effectively present and communicate their findings in visually compelling ways.

Microsoft® Excel® is designed for this purpose. Excel can connect to a wide range of data sources, perform robust data analysis, and create diverse and robust data-backed visualizations to show insights and trends, and create reports. These capabilities enable people who use Excel for data analysis to turn data into thoughtful action.

Completion of this course will earn 1.2 CEUs.

TOTAL DAYS: 2 | TOTAL HOURS: 13

This course covers features that are in QuickBooks Pro and Premier 2022.
QuickBooks software is sold separately.

Prerequisites: You can successfully complete this course without any prior software knowledge or computer experience. A basic understanding of the computer operating system you are using is recommended.
Benefits: First-time QuickBooks users will learn the basic features of the software. Experienced QuickBooks users will quickly learn the new features and functionality of QuickBooks 2022.

Completion of this course will earn 1.2 CEUs.

TOTAL DAYS: 2 | TOTAL HOURS: 13

Get Started with QuickBooks Online 2021-2022

In this textbook, learners will be introduced to Intuit’s cloud accounting software program, QuickBooks Online (QBO). Using a fictitious company called Luxury Lodging, Inc, students will learn how to navigate the QBO interface. We cover basic accounting, how to set up a new company, how to customize the chart of accounts and products and services list. In addition, students will learn how to give other users, such as accountants access to their data. In the sales center chapter, students will learn how to invoice customers and stay on top of accounts receivable balances. In the vendor center chapter, students will learn how to
enter bills and expenses from vendors as well as stay on top of the accounts payable balances. The final chapter in the textbook is a final project that encompasses the key topics covered in this course. Refer to the table of contents below for a detailed list of topics covered in this textbook.

Completion of this course will earn 1.2 CEUs.

TOTAL DAYS: 2 | TOTAL HOURS: 14

MB-300T00 Microsoft Dynamics 365: Core Finance and Operations

This course covers the following core features in Dynamics 365: core common features, core configuration, data migration, and preparing to go live.

TOTAL DAYS: 1 | TOTAL HOURS: 6.5

Microsoft Office PowerPoint 2016: Part 1

It’s hard to imagine a day going by without people passing along large amounts of information. Messages are everywhere, and the number of messages we receive seems to be increasing each day. Whether via phone, email, mass media, or personal interaction, we are subjected to a constant stream of information. With so much communication to contend with, it can be difficult to grab people’s attention. But, we are often called upon to do just that. So, how do you grab and maintain an audience’s focus when you’re asked to present important information? By being clear, organized, and engaging. And, that is exactly what Microsoft® Office PowerPoint® 2016 can help you do.

Gone are the days of flip charts or drawing on a white board to illustrate your point. Today’s audiences are tech savvy, accustomed to high-impact multimedia content, and stretched for time. By learning how to use the vast array of features and functionality contained within PowerPoint 2016, you will gain the ability to organize your content, enhance it with high-impact visuals, and deliver it with a punch. In this course, you will use PowerPoint 2016 to begin creating engaging, dynamic multimedia presentations.

You can also use the course to prepare for the Microsoft Office Specialist (MOS) Certification exam for Microsoft PowerPoint 2016.

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

Completion of this course will earn 0.6 CEUs.

TOTAL DAYS: 1 | TOTAL HOURS: 6.5

Microsoft Office PowerPoint 2016: Part 2

Meetings, instruction, training, pitches; these are all a part of our daily lives. We are often called upon to deliver presentations with little notice, at multiple venues, and with varying requirements. And, some of these presentations include sensitive information that needs to be guarded. Given all the variables, it may seem an overwhelming task to deliver your content, on time, to all audiences, and to only those who need to see it. Oh, and by the way, you need to make it interesting, informative, and memorable. So, how do you do it? Without the help of a robust set of tools, it would be nearly impossible. But Microsoft® Office PowerPoint® 2016 provides you with a variety of such tools that can help you deliver content in nearly any situation, while saving time and effort. By taking advantage of these tools, you will be creating presentations that not only stand out from the crowd, but also don’t consume all of your available time.

You can also use the course to prepare for the Microsoft Office Specialist (MOS) Certification exam for Microsoft PowerPoint 2016.

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

Completion of this course will earn 0.6 CEUs.

TOTAL DAYS: 1 | TOTAL HOURS: 6.5

Microsoft Office PowerPoint 2019: Part 1

It’s hard to imagine a day going by without people passing along large amounts of information. With so much communication to contend with, it can be difficult to grab people’s attention. But, we are often called upon to do just that. So, how do you grab and maintain an audience’s focus when you’re asked to present important information? By being clear, organized, and engaging. And, that is exactly what Microsoft® Office PowerPoint® 2019 can help you do.

Gone are the days of flip charts or drawing on a white board to illustrate your point. Today’s audiences are tech savvy, accustomed to high-impact multimedia content, and stretched for time. By learning how to use the vast array of features and functionality contained within PowerPoint 2019, you will gain the ability to organize your content, enhance it with high-impact visuals, and deliver it with a punch. In this course, you will use PowerPoint 2019 to begin creating engaging, dynamic multimedia presentations.

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

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

Completion of this course will earn 0.6 CEUs.

TOTAL DAYS: 1 | TOTAL HOURS: 6.5

Microsoft Office PowerPoint 2019: Part 2

Meetings, instruction, training, pitches; these are all a part of our daily lives. We are often called upon to deliver presentations with little notice, at multiple venues, and with varying requirements. And, some of these presentations include sensitive information that needs to be guarded. Given all the variables, it may seem an overwhelming task to deliver your content, on time, to all audiences, and to only those who need to see it. Oh, and by the way, you need to make it interesting, informative, and memorable. So, how do you do it? Without the help of a robust set of tools, it would be nearly impossible. But Microsoft® Office PowerPoint® 2019 provides you with a variety of such tools that can help you deliver content in nearly any situation, while saving time and effort. By taking advantage of these tools, you will be creating presentations that not only stand out from the crowd, but also don’t consume all of your available time.

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

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

Completion of this course will earn 0.6 CEUs.

TOTAL DAYS: 1 | TOTAL HOURS: 6.5

Microsoft Office Word 2016: Part 1

These days, most people take electronic word processing for granted. While we may still write out our grocery lists with pen and paper, we expect to use a computer to create the majority of our documents. It’s impossible to avoid word-processing software in many areas of the business world. Managers, lawyers, clerks, reporters, and editors rely on this software to do their jobs. Whether you are an executive secretary or a website designer, you’ll need to know the ins and outs of electronic word processing.

Microsoft® Word 2016 is designed to help you move smoothly through the task of creating professional-looking documents. Its rich features and powerful tools can make your work easy, and even fun. In this course, you’ll learn how to use Word 2016 to create and edit simple documents; format documents; add tables and lists; add design elements and layout options; and proof documents.

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

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

Completion of this course will earn 0.6 CEUs.

TOTAL DAYS: 1 | TOTAL HOURS: 6.5

Microsoft Office Word 2019: Part 1

Microsoft® Word 2019 is designed to help you move smoothly through the task of creating professional-looking documents. Its rich features and powerful tools can make your work easy, and even fun. In this course, you’ll learn how to use Word 2019 to create and edit simple documents; format documents; add tables and lists; add design elements and layout options; and proof documents.

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

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

Completion of this course will earn 0.6 CEUs.