This course helps in 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-driven visualizations to show insights and trends, as well as create reports. These capabilities enable people who use Excel for data analysis to turn data into thoughtful action
This version of Excel incorporates some new features and connectivity options in an effort to make collaboration and production as easy as possible. 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 analyse 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.
The training delivery is based on the desktop application and not on the online/browser version of the application. Clearly, you use Microsoft Excel a lot in your role.
Advances in technology have made it possible to store ever-increasing amounts of data. Along with this, the need to analyze data and gain actionable insight is greater than ever. You already have experience working with Microsof Excel and creating basic PivotTables to summarize data. But Excel is capable of doing much more. Being able to harness the power of advanced PivotTable features and create PivotCharts will help you to gain a competitive edge. You will not only be able to summarize data for you to analyze, but also organize the data in a way that can be meaningfully presented to others. This leads to data-driven business decisions that have a better chance for success for everyone involved.
This course is intended to help users of Office 365 understand how to complete basic and advanced tasks using its various apps and services. This manual will also help more experienced users who have little to no experience with Office Online, and Microsoft Teams. Topics will also include file storage and collaboration with OneDrive and SharePoint; using cloud-exclusive tools such as Delve and Planner.
This new version of Outlook incorporates some new features that will help make managing your email and personal information easier than ever. This course is intended to help all novice computer users get up to speed with Outlook quickly. 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®.
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.
In this course, you will use PowerPoint to begin creating engaging, dynamic multimedia presentations. Note: Most Office 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 Microsoft 365 subscription. This includes brief coverage of key skills for using PowerPoint for the Web and OneDrive.
Microsoft® PowerPoint® 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. The course material will also enable you to access and effectively utilize many web-based resources provided with your Microsoft 365™ subscription.
