Database application for PC 12 H 54 M

Access is the database application within the Microsoft Office suite. Many businesses, large and small, use Access to store large amounts of information. Just like building a strong house, you must have a solid foundation. We start from the very beginning discussing how to plan a database, introducing basic terminology and key concepts of relational database design, and exploring the Access Interface. Then we dive more in depth into each object in an Access databases – tables, queries, forms, and reports. This series is targeted for users who want to get started in Access or users that want a refresher on Access essentials. Access is a Windows only product and only available as a local installation. 

Excel 2016 is the powerful spreadsheet application in the Office suite. It seems every organization, large and small, uses Excel to organize and analyze data. However, many users are intimidated by Excel and confused by how it behaves as an application. The Excel 2016 Essentials for Mac series strives to empower users by learning the foundations to conquer this program. We begin with basic skills such as navigating the interface, identifying items in a spreadsheet, selecting cells, and inputting data. The series also covers formatting text and numbers, modifying a worksheet layout, printing and page layout, and managing worksheets in a workbook. While this series is designed for beginner users, it has lots of great tips and tricks for experienced users as well.

Spreadsheet application for PC 9 H 11 M 

Excel 2016 Advanced explores ways to enhance Excel workbooks with topics in analyzing data, collaborating and workbook security, and adding graphical elements. This series covers important Excel functionality such as format as table, conditional formatting, shared workbooks and tracked changes, and data validation. While Excel 2016 Advanced is a continuation from the Excel 2016 Essentials series, it can be viewed as a standalone show for users looking to excel to the next level of skills. This series is specifically for locally installed Excel 2016 on Windows operating system. 

Spreadsheet application for Mac 10 H 52 M

Excel 2016 Advanced for Mac explores ways to enhance Excel workbooks with topics in analyzing data, collaborating and workbook security, and adding graphical elements. This series covers important Excel functionality such as format as table, conditional formatting, shared workbooks and tracked changes, and data validation. While Excel 2016 Advanced for Mac is a continuation from the Excel 2016 Essentials for Mac series, it can be viewed as a standalone show for users looking to take their Excel skills to the next level. This series is specifically for locally installed Excel 2016 on Mac OS.

Excel Charts and Pivot Tables 3 H 28 M

In this training our trainer kick off the Excel Charts and Pivot tables series by building your foundational knowledge in regards to Charts. Here they will identify the parts of a Chart, define terms used, and look at the contextual tabs you’ll use when working with Charts.

MOS certification preparation 2 H 26 M

The Microsoft Office Specialist certification demonstrates proficiency in an Office application such as Word, Excel, PowerPoint, Access, and/or Outlook. This mini-series explains the certification, how to prepare for the exams, how to register for the exam, the exam format, and how to display your success.

Digital notebook application in Office 2016 suite for PC 13 H 40 M

Microsoft’s OneNote is the helpful note taking application in the Office suite to keep you organized for any project. Whether is it for working on a large project with co-workers to tracking recipes for dinner, OneNote is a great answer for keeping everything in one place. In this series, you will learn how to create and organize notebooks, add different types of content and stay on task with tags, use helpful features such as Linked Notes and the OneNote Web Clipper, share notebooks with others, and how OneNote interacts with other Office applications. The series specifically covers the OneNote 2016 application in the locally installed Office suite for the Windows operating system.

Digital notebook application in the Windows OS 8 H 9 M

Microsoft’s OneNote for Windows 10 is the helpful note taking application to keep you organized for any project. Whether is it for working on a large project with co-workers to tracking recipes for dinner, OneNote is a great answer for keeping everything in one place. In this series, you will learn how to create and organize notebooks, add different types of content, stay on task with tags, use helpful features such as the OneNote Web Clipper, and share notebooks with others. This series specifically covers the OneNote application that is part of the Windows 10 operating system.

Personal information management application for PC 13 H 37 M

Whether using for personal email or work email as large business organization, this course covers everything one needs to become a skilled and informed user of Microsoft Outlook 2016. Our hosts start with explaining the basic terminology and setup of email accounts and continue on to all areas of Outlook including managing email, contacts, calendars, and tasks. This series is specifically for locally installed Outlook 2016 on Windows operating system.

Presentation application for on-screen slide shows for PC 14 H 45 M

PowerPoint 2016 is the popular application within the Office suite to create on-screen presentations. This series starts at the very beginning by exploring the PowerPoint environment, how to add slides to a presentation, insert text and images into slides, and create tables and charts. The series continues by enhancing a presentation with design themes, animation, and transitions, then concludes with preparing  presentation. This series is specifically for the Windows operating system with PowerPoint 2016 locally installed.

Presentation application for on-screen slide shows for Mac 14 H 2 M

PowerPoint 2016 is the popular application within the Office suite for Mac to create on-screen presentations. This series starts at the very beginning by exploring the PowerPoint environment, how to add slides to a presentation, insert text and images into slides, and create tables and charts. The series continues by enhancing a presentation with design themes, animation, and transitions, then concludes with preparing presentation. This series is specifically for locally installed PowerPoint 2016 on Mac OS.

Presentation application for on-screen slide shows for PC 9 H 6 M

 All trainer  look at file metadata and other advanced file properties. They discuss adding tags and categories to help find a file. They also look at accessibility options, inspect a presentation, and how to protect a presentation with passwords to open and/or modify a file.

Database design principles 12 H 11 M

In this series of videos, we will cover key concepts and best practices for designing a relational database. Many problems that arise in using databases can be traced back to poor initial design. We will walk through the entire design process, from initial concept, through the design phase, ending with a fully functional database. This course is not platform specific; however, some concepts are demonstrated with Access on Windows operating system.

Best security practices for the end user 3 H 4 M

In this training our trainer examine the characteristics that make up a high quality password. They identify weaknesses found in many passwords and demonstrate how attackers can take advantage of weak passwords. They then help the viewers by suggesting a few methods to easily create memorable, yet secure, passwords.

Collaboration tool for real-time input for PC 12 H 54 M

Skype for Business is the popular communications platform from Microsoft that can do so much more than just instant message. This course covers everything from installing Skype for Business to running an online, collaborative meeting. Other topics include managing contacts, conducting video and audio calls, placing phone calls and managing phone settings, and using collaboration tools such as screen sharing, whiteboards, and polls. This course is specifically for locally installed Skype for Business 2016 client on a Windows operating system.

Document and word processing application for PC 9H 58 M

As one of the cornerstones of the Office suite, Word 2016 is a powerful word processor that allows users to create both simple and sophisticated documents. This series explores the essentials to getting started with Word 2016. We begin with basic skills such as navigating a document, selecting text, inputting basic text, and document proofing. The series also explores all aspects of character and paragraph formatting as well as page formatting and layout. While this series is designed for beginner users, it has lots of great tips and tricks experienced users as well. This series is specifically for locally installed Word 2016 on Windows operating system.

Document and word processing application for Mac10 H 51 M

As one of the cornerstones of the Office suite, Word 2016 for Mac is a powerful word processor that allows users to create both simple and sophisticated documents. This series explores the essentials to getting started with Word 2016 for Mac. We begin with basic skills such as navigating a document, selecting text, inputting basic text, and proofing a document. The series also explores all aspects of character and paragraph formatting as well as page formatting and layout. While this series is designed for beginner users, it has lots of great tips and tricks for experienced users as well. This series is specifically for locally installed Word 2016 on Mac OS.

Document and word processing application for PC 8 H 56 M

Word 2016 advanced explores ways to enhance Word documents with graphical elements that include images, shapes, tables, and charts. The series also demonstrates different techniques for users to automate tasks by using QuickParts, templates, macros, and mail merge. While Word 2016 Advanced is a continuation from the Word 2016 Essentials series, it can be viewed as a standalone show for users looking to go beyond just adding and formatting text. This series is specifically for locally installed Word 2016 on Windows operating system.

Document and word processing application for Mac 9 H 30 M

Word 2016 Advanced for Mac explores ways to enhance Word documents with graphical elements that include images, shapes, tables, and charts. The series also demonstrates different techniques for users to automate tasks by using templates, macros, and mail merge. While Word 2016 Advanced for Mac is a continuation from the Word 2016 Essentials for Mac series, it can be viewed as a standalone course for users looking to go beyond just adding and formatting text. This series is specifically for locally installed Word 2016 on Mac OS.

Document and word processing application for PC 6 H 28 M

Word 2016 Expert explores how to enhance long documents with episodes that include: creating a table of contents, generating an index, adding footnotes and endnotes, inserting bookmarks and cross references, labeling figures with captions, and citing references for a bibliography. Also covered is how to create a master document and add sub documents for large projects. Other topics in this series include how to collaborate in Word and through Office 365 online, secure your documents, and add or edit document properties. While Word 2016 Expert is a continuation from the Word 2016 Advanced and Essentials series, episodes can be viewed individually for specific topics or enjoyed in sequence. This series is specifically for locally installed Word 2016 on Windows operating system.

Document and word processing application for Mac 6 H 24 M

Word 2016 Expert for Mac explores how to enhance long documents with episodes that include: creating a table of contents, generating an index, adding footnotes and endnotes, inserting bookmarks and cross references, labeling figures with captions, and citing references for a bibliography. Also covered is how to create a master document and add sub documents for large projects. Other topics in this series include how to collaborate in Word and through Office 365 online, secure your documents, and add or edit document properties. While Word 2016 Expert for Mac is a continuation from the Word 2016 Advanced and Essentials for Mac series, episodes can be viewed individually for specific topics or enjoyed in sequence. This series is specifically for locally installed Word 2016 on Mac OS.

Comprehensive series on mail merge in Word for PC 7 H 10 M

This course takes a deep dive into mail merge within Word 2016. Mail merge is a powerful function to batch process personalized letters or emails as well as create mailing labels and envelopes. The hosts take extra time to explain the different types of data sources that can be used, how to create letters and emails, how to add images to envelopes and labels, and apply rules to extend the capabilities of the mail merge process. This series is specifically for locally installed Word 2016 on Windows operating system.

Managing Projects with Microsoft Project 2013 9 H 40 M

Microsoft Project 2013 is the latest offering by Microsoft into the software realm of PMIS (Project Management Information Systems).  This type of tool is used to help a project manager consolidate the number of tools they may use (e.g.  Calendar systems, email, contacts and some budgeting software and reporting software) into a single software tool for initiating, planning, executing, monitoring and controlling and even closing a project.  Within a single tool, a project manager can manage a project’s triple constraints:  Cost, Scope and Time.  This series covers every exam objective to help a viewer to prepare for the Microsoft exam 74-343 —Managing Projects with Microsoft Project 2013.

Increasing a new-hire’s onboarding IT security awareness  39 M