Office 365 Web Apps & Transitions Course Outlines

Office 365 Web Apps

This course is an introduction to the Microsoft® Office 365™ (with Skype for Business) in a cloud-based environment.  It can be used as an orientation to the full suite of Office 365 cloud-based tools.  Using Office 365, users can easily communicate with each other through Microsoft Outlook mail and Skype for Business instant messaging and online meetings.  Additionally, the Microsoft SharePoint Team Site provides a central location for accessing and modifying shared documents.  The Office Web Apps enable users to perform basic tasks, such as opening, editing, printing, and saving documents without requiring an installation of the full desktop version of Microsoft® Office 2016 on the local computer. 

Prerequisites:  Students should have significant experience using previous versions of MS Office (preferably 2007 to 2013).

 

SharePoint Online- Site User

 Microsoft® SharePoint® 2016 is a platform specifically designed to facilitate collaboration, allowing people to use familiar applications and Web-based tools to create, access, store, and track documents and data in a central location. In this course, you will learn about and use a SharePoint Team Site to access, store, and share information and documents. You will be able to use resources on a typical SharePoint Team Site in the course of performing normal business tasks, including: Interact with SharePoint Team Sites, work with documents, content, and libraries, interact in SharePoint, work with Lists, and integrate SharePoint with Microsoft Office.. 

Prerequisites:  To ensure your success in this course, you should have basic end-user skills with Microsoft Windows 7 or later, and any or all of the Microsoft Office 2013 or 2016 suite components, plus basic competence with Internet browsing.

 

SharePoint Online- Site Owner

Microsoft® SharePoint® 2016 is a platform specifically designed to facilitate collaboration, such, SharePoint has many distinct features that must be enabled and configured, and many content structures that can be selected, added, and configured. In this course, you will learn how to create, configure, and manage a SharePoint team site so that your team or organization can share information and collaborate effectively. Upon successful completion of this course, you will be able to create a SharePoint team site and perform basic content management tasks on a single SharePoint site, including; Create and configure new sites, add and configure document libraries, add and configure lists, create custom lists and forms, assign permissions and access rights, and extend SharePoint functionality with web parts.

Prerequisites:  To ensure your success in this course, you will need basic SharePoint site user skills such as the ability to access and use lists, libraries, and documents on a typical SharePoint team site 

 

OneNote Essentials (Half-day class)

In our fast-paced digital world, the need to capture ideas, meeting notes, and to-do items is ever present. Microsoft® Office OneNote® 2016 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. Additionally, learning how OneNote and the other applications in the suite are integrated increases your productivity with Microsoft Office. In this course, you will develop digital note-taking skills by creating, modifying, and managing OneNote notebooks that work with other Microsoft Office programs. Topics include: Navigate and customize the OneNote interface and environment, add and format text, images, audio, links, and drawing objects to a notebook, embed Excel spreadsheets and attach other files to a notebook, categorize, organize, and search notebook content, use Outlook and OneDrive to send and share notebook content, and export content. 

Prerequisites:  Students should have significant experience using previous versions of MS Office (preferably 2007 to 2013).

 

Office 2016 Transition

This course covers those features of Microsoft Office 2016 that are new to the Office system, with dedicated units for the new features of each application. Students will learn about changes to Backstage View and the Ribbon, including more general overview of using and customizing the Ribbon for those more familiar with Office versions previous to 2010. They will also learn Office 2016's new online features, including account sign-in, cloud storage, and online services. In Word they will use new tools to navigate and review documents, reply to comments, format a document, align graphics, work with tables, and open PDF files in Word. In Excel they will format data with the Flash Fill and Quick Analysis tools, insert charts and PivotTables using recommendations, and format a chart with the new tool buttons. In PowerPoint they will apply theme variants, match colors with the Eyedropper, create custom shapes, and rehearse a presentation in Presenter view. Finally, in Outlook they will use new interface and message elements, explore the new People View, and compose inline replies.

Prerequisites:  Students should have significant experience using previous versions of MS Office (preferably 2007 to 2013).  This course is intended to offer an overview of the most (but not all) changes to the Office programs.


Microsoft Power BI Interactive Data Visualizations (Two-day class)

Microsoft Power BI transforms your company data into rich visuals (Dashboards) that facilitate innovative ways of thinking about and organizing your data, so that you can focus on what is important to achieving your goals. This course covers both Power BI Online and Power BI desktop.  Topics include:  Power BI, Power BI Desktop, working with CSV, TXT, and Excel worksheets, connecting to databases, and merging, grouping, summarizing, calculating and reporting data.

Prerequisites: To ensure your success in this course, you should have experience working with Excel and working with tables/lists of organized data.  Prior experience creating and analyzing basic PivotTables will be helpful.

Microsoft Power BI Interactive Data Visualizations (pdf)

Download

Office 365 Web Apps (pdf)

Download

Office 2016 Transition (pdf)

Download

OneNote Essentials (pdf)

Download

SharePoint Online Site Owner (pdf)

Download

SharePoint Online Site User (pdf)

Download

Back to Schedule and Course List

Back to Schedule