OFFICE PRODUCTIVITY

Online Training Catalog

Vector Solutions’ comprehensive Office Productivity Training catalog offers organizations the ability to develop employees’ abilities and maximize operations. Easily deliver Adobe, Google, Intuit and Microsoft Office training online to enhance professional skills and build a foundation for career growth. With nearly 100 courses on the most frequently utilized tools in the industry, employees can gain the knowledge they need to be successful.

Download Vector Solutions’ Online Course Catalog for
PRISM Members

Download Catalog


ACCOUNTING

QuickBooks Essentials 2013

Discover the simple and powerful features and functions that can save you hours of work with QuickBooks. In this course learn how to best gather and input data into QuickBooks. Be able to solve problems faster with these time-saving lessons that can change the way you think about how to process the question.

Course Duration: 6 Hour(s)

Mastering QuickBooks Online

QuickBooks Online brings traditional QuickBooks accounting to a cloud-based solution, and while it’s winning rave reviews for its’ convenience and easy interface, it’s VERY different from the desktop version of QuickBooks. In this course understand the differences between QuickBooks Online and QuickBooks Pro and how to utilize Quickbooks.

Course Duration: 1 Hour(s)


DATABASE

Intro to SharePoint

Microsoft SharePoint has been called one of the most powerful tools for business collaboration. In this Introductory course noted SharePoint author and Microsoft MVP Robert Crane shares his insights into this powerful solution that will help you improve the way you work with and share documents, pictures, calendars, and more.

Course Duration: 1 Hour(s)


DESKTOP APPLICATIONS

OneDrive Essentials (2016)

OneDrive and OneDrive for Business can radically improve your productivity. In this course we’ll show you how both OneDrive (the free, personal version) and OneDrive for Business (the corporate version included in most Office 365 plans) lets you easily access your documents and files from any device, anytime, and securely share them with others.

Course Duration: 1.50 Hour(s)

Outlook Web Access Essentials (2016)

Sometimes you need a quick way to get to your ‘stuff’ no matter where you are. Be able to utilize and communicate anywhere with Outlook Online, also called the Outlook Web App (OWA), the web-based app for managing emails, calendars, and people from any web browser. Throughout this course you will learn the main features and benefits of using Outlook Online from Office 365.

Course Duration: 1.50 Hour(s)

Secrets of the Office Guru

What can savvy Microsoft Office users do to improve their skills – without having to comb through hours of information that they already know to find those few useful gems of knowledge? In this course, you will answer this question and gain practical, productivity-boosting tips, tricks, and skills that will turn experienced Microsoft Office users into gurus.

Course Duration: 4 Hour(s)


MICROSOFT

Access

MS Access 2013 01: Working with Databases

Study the characteristics and components of a database, while learning the capabilities provided by Access 2013 to build and implement databases. You will also find discussions on the distinction between queries and forms, on how to update and delete records, on the process of adding records to labels, and on the different filtering options that can be used to view data. In the relational database section, you will focus on the difference between flat and relational databases, the rules that apply to building relational databases, how to identify entities and attributes as well as use database diagrams. Learn these foundational topics so that you can deepen your understanding of how to create and work with databases in Access 2013. This is the first course in the Access 2013 (77-424) series

Course Duration: 1 Hour(s)

MS Access 2013 02: Creating, Modifying, and Managing Tables

Databases can save you time and energy. They are also useful for managing large quantities of data. In this training, you will observe how to create them as you go through discussions on generating databases from a template, the Wizard, the old format, and manually. You will also spend time taking a closer look at database components, particularly tables, table relationships, and fields. In the field section, you will learn about what to do with unique values, testing a field, setting primary key fields, field sizes, field data types, setting default values, and changing data formats. Learn about how to work with each of these database elements in Access 2013. This is the second course in the Access 2013 (77-424) series

Course Duration: 1 Hour(s)

MS Access 2013 03: Working with Forms

Take a closer look at forms as you focus on creating, enhancing, and formatting forms. In the form organization section, you will find presentations on tab modification, the way data sources are modified, and the steps to adding subforms. Some of the highlights from the formatting section include steps on applying themes and inserting images and backgrounds, how to sort records, and an overview of the printing layouts available. The navigation form section details the steps to creating navigation forms and how to format them. Overall, this course will introduce you to forms and teach you how to modify forms using Access 2013. This is the third course in the Access 2013 (77-424) series

Course Duration: 1 Hour(s)

MS Access 2013 04: Working with Queries

Learn the basics of queries as you look at the purpose of queries, how to add fields to queries, query modifications, working with multitable queries, and types of criteria in queries. There is also sections of this training dedicated to demonstrating how queries function. In the query calculation section, you will look at calculated fields, the Expression Builder, numeric and text calculation, and crosstab queries. The last section concentrates on action queries, which reviews how to use action queries, the steps to making table queries, how to update an action query, and append it. Take time to thoroughly explore queries so that you can use them to their fullest potential through Access 2013. This is the fourth course in the Access 2013 (77-424) series

Course Duration: 1 Hour(s)

MS Access 2013 05: Sharing and Protecting Your Data

Dive into making reports with Access 2013. They are the final piece to working with an Access database. There???s also a section containing different tips for taking the Microsoft’s Access exam. The Protection section talks about protecting, splitting, merging, and encrypting a database. In the end, you will have a better understanding of how to use Access 2013 to create, modify, and print reports, as well as protect and maintain databases. With these skills, you will be equipped to work with reports and properly maintain databases. The final section of this course provides you with tips to help you successfully pass Microsoft’s 77-424 exam. This is the final course in the Access 2013 (77-424) series

Course Duration: 1 Hour(s)

Excel

Mastering Excel 2016

The World Is Filled With Two Kinds Of People: A Handful Of People Who Are Masters Of Excel, And The Millions Of Others Who Wish They Were If you’ve mastered Microsoft Excel 2016 then you have one of the most practical and valuable skill sets in all of modern business. A spreadsheet guru can work wonders – from organizing lists, to creating multi-layered, interactive reports, to revealing answers to business-critical questions like ROI, budget allocations, tracking expenditures, and more. This course covers everything you need to know about Microsoft Excel 2016, from the very basics to the most advanced features and functions.

Course Duration: 10 Hour(s)

Mastering Excel 2019 - Basics

There are two kinds of people: Those who are masters at Excel, and those who wish they were When you master Excel, you have one of the most practical and valuable skillsets in modern business. A spreadsheet guru can work wonders–from organizing lists; to creating multi-layered, interactive reports; to answering critical business questions like ROI, budget allocations, expense tracking, and more. This course is your first step towards becoming an expert at using Excel 2019.

Course Duration: 4.5 Hour(s)

Outlook

MS Outlook 2013 01: Getting Started

Outlook is a program that enables you to track all your communication with contacts, meetings or appointments, notes, and to-do lists in one place. Microsoft has offered this resourceful program for years, but released this version update to provide users with a sleeker and more efficient tool. Explore in Outlook 2013 as you go over the basics. You???ll explore the interface, discover customization options for the layout of Outlook as well as customization options within your messages. Communication is key to success. Therefore, you???ll spend a portion of your time learning to work efficiently within the Mail section of Outlook. Overall, the topics covered will aid you in your preparations for Microsoft’s Outlook Exam 77-423

Course Duration: 1 Hour(s)

MS Outlook 2013 02: Message and Contact Management

Outlook is your go-to resource for all tasks and projects associated with communication. Part of communication is knowing the appropriate channel to reach a contact. As a result, you must understand how to use the People tab in Outlook for your benefit. Alongside the discussion on Contacts, you will also spend time on organizing your mail as you look over folder and configuration options. Prepare for your Microsoft Outlook Exam 77-423 by learning the tools Outlook provides for mail organization, the various save options, and contact categorization. Explore all of Outlook 2013 available features and tools for email and contact customizations

Course Duration: 1 Hour(s)

MS Outlook 2013 03: Time and Task Management

Through these discussions, you are preparing for Microsoft’s Outlook Exam 77-423. To be successful in this exam, as well as in the professional world, it is crucial that you know how to properly manage your time. Overall, the topics covered will aid in learning how to use Outlook tools to help with time management. The tools emphasized are those associated with the calendar, notes, journal, and tasks tab. In the end, you’ll be able to share calendars, work with the scheduling assistant, forward calendar items, share meeting notes, and update to-do lists

Course Duration: 1 Hour(s)

Office 365

Office 365 Essentials

Office 365 is far more than classic Microsoft Office. Easy, collaborative online tools combine with traditional Microsoft apps to form a powerful productivity-boosting tool. In this course, we’ll show you the basics of everything Office 365 has to offer. Be able to organize and maintain your virtual office using Microsoft 365.

Course Duration: 4.50 Hour(s)

Mastering Office 365

Learn To Organize And Maintain Your Virtual Office Using Microsoft 365: The Powerful, Everything-You-Need-In-One-Easy-Bundle Online Suite. Office 365 is far more than classic Microsoft Office. Easy, collaborative online tools combine with traditional Microsoft apps to form a powerful productivity-boosting tool – and in this course we’ll show you the basics of everything Office 365 has to offer!

Course Duration: 8 Hour(s)

PowerPoint

Power-Up Your PowerPoint Presentation

Almost anyone can piece together a PowerPoint presentation. This course offers a great way to learn how to ‘amp up’ your presentations and deliver your message with the power and authority required to communicate effectively.

Course Duration: 2.50 Hour(s)

Mastering PowerPoint 2016 Basics

Knowing how to create a PowerPoint slide is one thing. Knowing how to create an effective slide is something altogether different! In this course discover and experience how creating effective slides will improve your presentations.

Course Duration: 4.75 Hour(s)

Mastering PowerPoint 2016 Advanced

Microsoft Word is hands-down the most powerful document creation tool on the planet and in this advanced course produced by Microsoft Certified Trainer Christina Tankersley, builds upon your pre-existing skills to the next level in getting the most out of your Microsoft Word documents.

Course Duration: 4.75 Hour(s)

MS PowerPoint 2013 01: The Basics of PowerPoint

Get an overview of all the features contained in PowerPoint 2013 available to create professional, high-quality presentations. You will go on a tour of the interface covering different menu and toolbar items, and learn how to customize your slide, graphics, and text. For text customization, you will find demonstrations for tools such as text Styles and Word Art. Through these discussions, you will be preparing for Microsoft’s PowerPoint Exam 77-422

Course Duration: 1 Hour(s)

MS PowerPoint 2013 03: Customizing Presentations

Craft presentations that are consistent in style and grammatically correct through PowerPoint 2013’s tools. You will start your exploration of presentation customization by working with slide masters. Topics covered with slide masters include creating custom layouts, inserting master layout backgrounds, and creating slide masters. You will also gain an understanding of the setup options on the backend of PowerPoint, as in AutoCorrect options, save options, and advanced options. Alongside these settings, you will also go over details on the activities involved in the process of finalizing a presentation. You will observe how to save your presentations, proof it for corrections, prepare it for print, merge multiple presentations, and restrict permissions on the file. Furthermore, the topics covered will aid you in your preparations for Microsoft’s PowerPoint Exam 77-422

Course Duration: 1 Hour(s)

Mastering PowerPoint 2019 Basics

Making PowerPoint 2019 Easy & Effective Using PowerPoint effectively is a crucial skill for any business professional. Whether it’s designing a presentation for a meeting, creating a handout, or even creating and exporting a custom video, PowerPoint 2019 is a tool that everyone should feel comfortable using. In this Bigger Brains course, our PowerPoint guru Kelly Vandever walks you through the basics of getting started with PowerPoint 2019.

Course Duration: 4.75 Hour(s)

Word

Mastering Word 2016

Microsoft Word is more than a Word Processor, used by millions of people each day, Microsoft Word is hands-down the most powerful document creation tool on the planet. By taking this extensive Word course produced by Microsoft Certified Trainer Christina Tankersley, we’ll show you everything you need to harness the power of Microsoft Word so you can ultimately be more productive, in less time, and be able to maximize your functionality.

Course Duration: 12.50 Hour(s)

Mastering Word 2016, Intermediate

Microsoft Word is hands-down the most powerful document creation tool on the planet and in this intermediate course produced by Microsoft Certified Trainer Christina Tankersley, be able to take your basic skills to the next level in formatting your Microsoft Word documents.

Course Duration: 3.80 Hour(s)

Mastering Word 2016 Advanced

Microsoft Word is hands-down the most powerful document creation tool on the planet and in this advanced course produced by Microsoft Certified Trainer Christina Tankersley, builds upon your pre-existing skills to the next level in getting the most out of your Microsoft Word documents.

Course Duration: 2.75 Hour(s)

MS Word 2013 01: The Basics

Prepare for the Microsoft Word 2013 Exam 77-418. You will go over the need-to-know skills to get started in Word. Review Word interface basics as you go over how to use the navigation pane and Quick Access toolbar. In addition to document creation, you will learn how to customize your document by inserting hyperlinks, a Quick Table, pictures, or Live Feeds. Explore new features like the show/hide paragraph feature and the split window tool. There’s also a portion of the course dedicated to macros to help you simplify those repeated tasks. As a wrap up, you’ll see how to prepare your document for print and protect it with a password. All of these features, tools, and capabilities introduce you to your options in Word 2013

Course Duration: 1 Hour(s)

MS Word 2013 02: Formatting

In LearnSmart’s Formatting in Word 2013 video training, some of the formatting options that you’ll cover include working with WordArt, inserting tabs and section breaks, preventing paragraph orphans, and adding title to sections. What would we do without tables? There are necessary for all quality documents because they allow users to organize the content and show relationships between the content. Delve into how to modify them to enhance your document, as well as numbered lists and bulleted lists. There’s no limit to how you can create quality, professional documents using Word 2013. Covering these topics will help you in your preparation for Microsoft’s Word 2013 Exam 77-418

Course Duration: 1 Hour(s)

MS Word 2013 03: Advanced Options

Explore the advanced options available in Word 2013 when working with special document types. Reference tool topics include inserting citations and a bibliography, and applying footnotes and endnotes. When working with shapes and images, you’ll see how to remove backgrounds, apply artistic effects, configure images so that text wraps around it, and add Quick Styles to images. Go through the process of creating and properly formatting a resume, a cover page, thank you letters, and a research paper. Within these lessons, you will also find demonstrations on how to save with SkyDrive and export documents as PDFs. Overall, you will gain skills and an understanding of core concepts that are included on Microsoft’s Word 2013 Exam 77-418

Course Duration: 1 Hour(s)

Mastering Word 2019 - Basics

Learn the Basics of Microsoft Word 2019–Delivered in Easily Searchable, Highly Informative Content Lessons Microsoft Word: Hands-down the most powerful document creation tool on the planet. Used by millions of people each day, very few know how to use it properly. In this basics course produced by Microsoft Certified Trainer, Barbara, Evers, we’ll show you everything you need to know to start harnessing the power of Microsoft Word.

Course Duration: 3.50 Hour(s)


OPERATING SYSTEMS

MS Windows 8: An Introduction

You will learn about Windows 8 features and tricks that you haven???t seen, as well as some features that are good to know to get started in Windows 8. Explore how user friendly the Windows 8 operating system is as you become accustomed to the interface and how things are designed to work. Once you learn the design, you will discover that there are other ways to interact with your devices and the programs on them. You???ll also spend time studying the difference between Windows 8 and other operating systems. One of the topics highlighted is the power of touch. To really enjoy and take advantage of the design and format of Windows 8, you have to know what it offers. Overall, you???ll spend time learning how Windows 8 is a step forward in the progression of technology, and the benefits it offers you in your day-to-day tasks

Course Duration: 1 Hour(s)