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

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.

Microsoft Office Word 2016: Part 1

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.

Microsoft Office Word 2019: Part 1

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.

Microsoft Office Word 2019: Part 2

TOTAL DAYS: 1 | TOTAL HOURS: 6.5

Microsoft Office Word 2019: Part 2

After you master the basics of creating, editing, and printing Microsoft® Word documents, you’re ready to move on to tackling the more advanced features. In this course, you will work with features such as formats, styles, and templates to create professional documents with a consistent look and feel. You will add visual interest to your documents by using the tables and charts features. Quick Parts and templates provide efficiency and consistency when adding content, and long complex documents can be simplified and managed in Master Documents. Finally, you will use the mail merge feature to automate sending individual letters to customers.

Creating professional-looking documents can give you and your organization a competitive edge. Implementing time-saving features such as document templates and automated mailings can help reduce expenses. Mastering these techniques will make you a valued employee in your organization.

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 second part of a three-course series that covers the skills needed to gain a foundational understanding of Word.
– Microsoft Office Word 2019: Part 1
– Microsoft Office Word 2019: Part 2 (this course)
– Microsoft Office Word 2019: Part 3

Completion of this course will earn 0.6 CEUs.

Microsoft Office Word 2019: Part 3

TOTAL DAYS: 1 | TOTAL HOURS: 6.5

Microsoft Office Word 2019: Part 3

Microsoft® Word enables you to do far more than simple word processing. Word includes advanced image manipulation tools, collaboration features, cross-referencing and linking tools, entry forms and data collection, security features, and tools to automate document production.

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 third part of a three-course series that covers the skills needed to gain a foundational understanding of Word.
– Microsoft Office Word 2019: Part 1
– Microsoft Office Word 2019: Part 2
– Microsoft Office Word 2019: Part 3 (this course)

Completion of this course will earn 0.6 CEUs.

Microsoft OneNote for Windows 10

TOTAL DAYS: 1 | TOTAL HOURS: 6.5

In our fast-paced digital world, the need to capture ideas, meeting notes, and to-do items is ever present. Microsoft® OneNote® for Windows® 10 provides a way for you to efficiently create and collect your notes in an electronic notebook. This course will introduce you to using OneNote notebooks to store a wide variety of content in an organized structure, access the content from anywhere, and also share it with others.

Completion of this course will earn 0.575 CEUs.

Microsoft Teams

TOTAL DAYS: 1 | TOTAL HOURS: 3

Microsoft Teams

This course is an introduction to Microsoft Teams. Users can easily communicate and collaborate together through Microsoft Teams messaging and meeting functionality.

Completion of this course will earn 0.275 CEUs.

Microsoft Teams (Desktop and Browser)

TOTAL DAYS: 1 | TOTAL HOURS: 3

Microsoft Teams (Desktop and Browser)

This 1/2 day course is designed to help you master Microsoft® Teams®, the key communications tool in the suite of Microsoft 365 productivity apps. Microsoft Teams enables individuals and organizations to chat, share ideas, collaborate on files, and essentially, work together. You can use Teams to have a quick chat with a colleague, participate in a virtual meeting, make an online call, and share files and resources. The Microsoft Teams app is available in three versions: a desktop app, a web app, or a mobile app. Once you are familiar with the Teams desktop app, you can easily transfer that knowledge and work in the web and mobile apps to take advantage of connecting through Teams wherever your work takes you.

Microsoft Teams for Business Users

TOTAL DAYS: 1 | TOTAL HOURS: 6.5

This course is designed to help you master Microsoft® Teams®, the key communications tool in the suite of Microsoft® 365® productivity apps. Microsoft Teams enables individuals and organizations to chat, share ideas, collaborate on files, and essentially, work together. You can use Teams to have a quick chat with a colleague, participate in a virtual meeting, make an online call, and share files and resources. The Microsoft Teams app is available in three versions: a desktop app, a web app, and a mobile app. Once you are familiar with the Teams desktop app, you can easily transfer that knowledge and work in the web and mobile apps to take advantage of connecting through Teams wherever your work takes you.

Completion of this course will earn 0.6 CEUs.

Microsoft Windows 10: Transition from Windows 7

TOTAL DAYS: 1 | TOTAL HOURS: 6.5

Microsoft Windows 10: Transition from Windows 7

Mobile devices are becoming increasingly popular. As a result, many business professionals find themselves regularly performing a greater number of work-related tasks from a variety of devices. You may find yourself included in this group of multiple-device users. But you still perform a majority, or at least a large part, of your work from a desktop or a laptop computer.

With the release of Microsoft® Windows® 10, Microsoft has made strides in bridging the gap between your laptop or desktop PC and a variety of mobile devices. Developing an understanding of how to accomplish your day-to-day work tasks in this new environment will push you one step closer to being able to comfortably work from a number of platforms, and a number of devices, nearly anywhere you go. Once you’ve gained a foundational understanding of how to operate within the Windows 10 environment from your PC, you’ll be able to take full advantage of the many sharing, storing, and multi-platform benefits inherent in the Windows 10 operating system.

Completion of this course will earn 0.6 CEUs.