55215 SharePoint Online Power User

TOTAL DAYS: 4 | TOTAL HOURS: 28

55215 SharePoint Online Power User

This course delivers the complete site owner story from start to finish in an engaging and practical way to ensure you have the confidence to plan and create new sites or manage your existing sites in SharePoint Online. Your goal is to learn how to make SharePoint online relevant to your team by using a sites functionality to help you share information and collaborate with your colleagues. During the class, you will also learn best practices and ‘what not to do’ as you watch live, interactive demonstrations and put theory into practice with hands on exercises in SharePoint Online.

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.15 CEUs.

Excel 2013/2016 Programming with VBA

TOTAL DAYS: 3 | TOTAL HOURS: 19.5

Excel 2013/2016 Programming with VBA

Prerequisite

Proficient knowledge of Microsoft Excel. Knowledge of PivotTables helpful but not required.

Completion of this course will earn 1.725 CEUs.

Integrated Project Management 2016

TOTAL DAYS: 3 | TOTAL HOURS: 19.5

Integrated Project Management 2016

Completion of this course will earn 1.725 CEUs.

Microsoft Access for Office 365: Part 1

TOTAL DAYS: 1 | TOTAL HOURS: 6.5

Microsoft Access for Office 365: Part 1

Data is everywhere. Most job roles today involve some form of data management. Virtually everyone is affected in some way by the need to manage data. A relational database application such as Microsoft® Access® can help you and your organization with this task. This course is the first part of a three-course series that covers the skills needed to perform database design and development in Access.

Microsoft® Access® for Office 365™: Part 1 (this course): Focuses on the design and construction of an Access database —viewing, navigating, searching, and entering data in a database, as well as basic relational database design and creating simple tables, queries, forms, and reports.
Microsoft® Access® for Office 365™: Part 2 : Focuses on optimization of an Access database, including optimizing performance and normalizing data, data validation, usability, and advanced queries, forms, and reports.
Microsoft® Access® for Office 365™: Part 3 : Focuses on managing the database and supporting complex database designs , including import and export of data, using action queries to manage data, creating complex forms and reports, macros and VBA, and tools and strategies to manage, distribute, and secure a database.

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

Completion of this course will earn 0.575 CEUs.

Microsoft Access for Office 365: Part 2

TOTAL DAYS: 1 | TOTAL HOURS: 6.5

Microsoft Access for Office 365: Part 2

Your training and experience using Microsoft® Access® has given you basic database management skills, such as creating tables, designing forms and reports, and building queries. In this course, you will expand your knowledge of relational database design; promote quality input from users; improve database efficiency and promote data integrity; and implement advanced features in tables, queries, forms, and reports. Extending your knowledge of Access will result in a robust, functional database for your users.

This course is the second part of a three-course series that covers the skills needed to perform database design and development in Microsoft Access.

Microsoft® Access® for Office 365™: Part 1 : Focuses on the design and construction of an Access database —viewing, navigating, searching, and entering data in a database, as well as basic relational database design and creating simple tables, queries, forms, and reports.
Microsoft® Access® for Office 365™: Part 2 (this course): Focuses on optimization of an Access database, including optimizing performance and normalizing data; data validation; usability; and advanced queries, forms, and reports.
Microsoft® Access® for Office 365™: Part 3 : Focuses on managing the database and supporting complex database designs , including import and export of data; using action queries to manage data; creating complex forms and reports; macros and Visual Basic for Applications (VBA); and tools and strategies to manage, distribute, and secure a database.
This course covers Microsoft Office Specialist Program exam objectives to help you prepare for the Access Expert (Office 365 and Office 2019): Exam MO-500 certification.

Completion of this course will earn 0.575 CEUs.

Microsoft Access for Office 365: Part 3

TOTAL DAYS: 1 | TOTAL HOURS: 6.5

Microsoft Access for Office 365: Part 3

You’ve covered many of the basic functions of Microsoft® Access®, and now you’re ready to learn advanced Access features such as database management, advanced form design, packaging a database, encrypting a database, preparing a database for multiple-user access, and more. Knowledge of these features separate database professionals from the casual database users or occasional designers.

This course is the third part of a three-course series that covers the skills needed to perform basic database design and development in Microsoft Access.

Microsoft® Access® for Office 365™: Part 1 : Focuses on the design and construction of an Access database —viewing, navigating, searching, and entering data in a database, as well as basic relational database design and creating simple tables, queries, forms, and reports.
Microsoft® Access® for Office 365™: Part 2 : Focuses on optimization of an Access database, including optimizing performance and normalizing data; data validation; usability; and advanced queries, forms, and reports.
Microsoft® Access® for Office 365™: Part 3 (this course): Focuses on managing the database and supporting complex database designs , including import and export of data; using action queries to manage data; creating complex forms and reports; macros and Visual Basic for Applications (VBA); and tools and strategies to manage, distribute, and secure a database.

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

Completion of this course will earn 0.575 CEUs.

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

TOTAL DAYS: 1 | TOTAL HOURS: 6.5

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

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.

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 Excel for 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 is the first part of a three-course series that covers the skills needed to gain a foundational understanding of Excel.
– Microsoft Excel for Office 365 (Desktop or Online): Part 1 (this course)
– Microsoft Excel for Office 365 (Desktop or Online): Part 2
– Microsoft Excel for Office 365 (Desktop or Online): Part 3

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.

Completion of this course will earn 0.575 CEUs.

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

TOTAL DAYS: 1 | TOTAL HOURS: 6.5

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

Whether you need to crunch numbers for sales, inventory, information technology, human resources, or other organizational purposes and departments, the ability to get the right information to the right people at the right time can create a powerful competitive advantage. After all, the world runs on data more than ever before and that’s a trend not likely to change, or even slow down, any time soon. But with so much data available and being created on a nearly constant basis, the ability to make sense of that data becomes more critical and challenging with every passing day. You already know how to get Microsoft® Excel® to perform simple calculations and how to modify your workbooks and worksheets to make them easier to read, interpret, and present to others. But, Excel is capable of doing so much more. 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. And that’s exactly what this course aims to help you do.

This course builds upon the foundational knowledge presented in the Microsoft® Excel® for Office 365™ (Desktop or Online): 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.

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

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.

Completion of this course will earn 0.575 CEUs.

Microsoft Excel for Office 365 (Desktop or Online): Part 3

TOTAL DAYS: 1 | TOTAL HOURS: 6.5

Microsoft Excel for Office 365 (Desktop or Online): Part 3

Clearly, you use Microsoft® Excel® a lot in your role. Otherwise, you wouldn’t be taking this course. By now, you’re already familiar with Excel, its functions and formulas, a lot of its features and functionality, and its powerful data analysis tools. You are likely called upon to analyze and report on data frequently, work in collaboration with others to deliver actionable organizational intelligence, and keep and maintain workbooks for all manner of purposes. At this level of use and collaboration, you have also likely encountered your fair share of issues and challenges. You’re too busy, though, to waste time scouring over workbooks to resolve issues or to perform repetitive, monotonous tasks. You need to know how to get Excel to do more for you so you can focus on what’s really important: staying ahead of the competition. That’s exactly what this course aims to help you do.

This course builds upon the foundational and intermediate knowledge presented in the Microsoft® Excel® for Office 365™ (Desktop or Online): Part 1 and Microsoft® Excel® for Office 365™ (Desktop or Online): 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.

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

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.

Completion of this course will earn 0.575 CEUs.