Introduction to Microsoft Access 2016

Take control of your data! In this course, you'll learn how to harness the power of Microsoft Access 2016 to organize, store, edit, manage, and report on hundreds of thousands of records.

Intermediate Microsoft Access 2016

Do you want to take your Microsoft Access skills to the next level? In this course, you'll master more advanced techniques for this powerful database program and build an entire database project from scratch.

Series bundles are not eligible for partial drops or refunds. Transfers to other open sessions of the same course are available. Please refer to your school for additional details regarding drops, transfers, and refunds on Series bundles.

For more information or to register please click the link.

The Microsoft Access 2019 Series provides a comprehensive overview of Access 2019. You will first learn the basic functions of Access and then learn more advanced techniques that fully utilize this powerful software.

The Introductory course will teach you fundamental data management techniques, like creating forms and tables, efficient data entry, and editing. You will also learn how to use Access to develop queries that locate and isolate records and to design professional reports. By the time you have finished the course, you will know how to organize and assemble an effective database for any kind of information you need to store, document, and manage.

The Intermediate course builds on your previous Access skills. You will start by importing customer and order information from several Excel spreadsheets as tables in a new database. Once you have mastered proper table construction, you will learn how to create forms to manage table data. Then, you will discover how to construct crosstab and summary queries, and crunch numbers using query calculations. Finally, you will build a navigation form, so users can search your database.

Series bundles are not eligible for partial drops or refunds. Transfers to other open sessions of the same course are available. Please refer to your school for additional details regarding drops, transfers, and refunds on Series bundles.

For more information or to register please click the link.

Gain the skills and knowledge you need to start analyzing, tracking and managing data with Microsoft Excel 2019. You will learn how to use, collect, and apply data to real-life problems with charts, numbers and graphs.

Introduction to Microsoft Excel 2019

Learn to quickly and efficiently use Microsoft Excel 2019 as you discover dozens of shortcuts and tricks for setting up fully formatted worksheets. This course, taught by an experience Microsoft Excel instructor, provides in-depth knowledge for beginners that will have you using Excel like a pro.

Intermediate Microsoft Excel 2019

Master new skills and harness the power of Excel to become a power user. This hands-on course provides in-depth knowledge of charts, graphs, PivotTables, Slicers, Sparklines, AutoFilter, macros, and other advanced Microsoft Excel 2019 functions.

Advanced Microsoft Excel 2019

In this hands-on course, you will learn Microsoft Excel 2019's advanced functions and often-overlooked features, including data analysis tools, data tables and databases, custom controls, and PivotTables.

Introduction to Statistics

Improve your understanding of data and learn how to develop graphs and charts. With real-world applications and easy-to-understand examples drawn from business, health care, sports, education, and politics, this course provides the skills and knowledge you need to start analyzing data.

Suite bundles are not eligible for partial drops or refunds. Transfers to other open sessions of the same course are available. Please refer to your school for additional details regarding drops, transfers, and refunds on Suite bundles.

For more information or to register please click the link.

Introduction to Microsoft Excel 2019

This course focuses on the fundamentals of Excel 2019. You will first learn how to quickly and efficiently create fully formatted worksheets. You will then learn common formulas and functions, sorting and analyzing data, custom charts and graphs, and how to create three-dimensional workbooks. This course also introduces you to Quick Analysis, Flash Fill, and other powerful charting tools, which are further explored in the intermediate course.

Intermediate Microsoft Excel 2019

This course builds on the fundamental techniques you learned in the introductory Excel 2019 course. You will master charting and then learn more of Excel's time-saving features like PivotTables, Slicers, and Sparklines. You will learn how to harness the power of Excel's data analysis tools and AutoFilter commands to create macros that eliminate repetitive tasks. Set yourself apart from the casual Excel user by adding VLOOKUP, INDEX & MATCH, and Excel's other time-saving functions to your repertoire.

Advanced Microsoft Excel 2019

This course will help you make the most of your investment in Microsoft Excel 2019. You will master advanced features that most users don't even know exist, such as scenarios and data tables to perform what-if data analysis. You will learn advanced techniques for PivotTables, conditional formatting to highlight duplicate entries, and importing external data using Excel's built-in Power Query tool. By the time you finish this course, you will know all the possible features and function of Microsoft's powerful spreadsheet software.

Series bundles are not eligible for partial drops or refunds. Transfers to other open sessions of the same course are available. Please refer to your school for additional details regarding drops, transfers, and refunds on Series bundles.

For more information or to register please click the link.

Microsoft Excel 2019 and Microsoft Access 2019 are two of the most used programs to track and manage data sets. This course will teach you how use Microsoft Excel 2019 and Microsoft Access 2019.

Introduction to Microsoft Excel 2019

Learn to quickly and efficiently use Microsoft Excel 2019 as you discover dozens of shortcuts and tricks for setting up fully formatted worksheets. This course, taught by an experience Microsoft Excel instructor, provides in-depth knowledge for beginners that will have you using Excel like a pro.

Intermediate Microsoft Excel 2019

Master new skills and harness the power of Excel to become a power user. This hands-on course provides in-depth knowledge of charts, graphs, PivotTables, Slicers, Sparklines, AutoFilter, macros, and other advanced Microsoft Excel 2019 functions.

Introduction to Microsoft Access 2019

Build, edit, and maintain databases in Microsoft Access 2019 using tables, reports, forms, and queries to give you fast access to all your important information. This hands-on course for beginners provides the skills to create an effective database for any type of information at home or on the job.

Intermediate Microsoft Access 2019

Develop a fully functional database in this hands-on Microsoft Access 2019 course. Master advanced techniques for presenting data, automating common tasks, and building navigation as you work to create a database project from scratch.

Suite bundles are not eligible for partial drops or refunds. Transfers to other open sessions of the same course are available. Please refer to your school for additional details regarding drops, transfers, and refunds on Suite bundles.

For more information or to register please click the link.

Many businesses rely on spreadsheets to manage budgets, schedules, and tracking. This course will teach you how use Microsoft Excel 2019 and Microsoft Project 2019.

Introduction to Microsoft Excel 2019

Learn to quickly and efficiently use Microsoft Excel 2019 as you discover dozens of shortcuts and tricks for setting up fully formatted worksheets. This course, taught by an experience Microsoft Excel instructor, provides in-depth knowledge for beginners that will have you using Excel like a pro.

Intermediate Microsoft Excel 2019

Master new skills and harness the power of Excel to become a power user. This hands-on course provides in-depth knowledge of charts, graphs, PivotTables, Slicers, Sparklines, AutoFilter, macros, and other advanced Microsoft Excel 2019 functions.

Advanced Microsoft Excel 2019

In this hands-on course, you will learn Microsoft Excel 2019's advanced functions and often-overlooked features, including data analysis tools, data tables and databases, custom controls, and PivotTables.

Introduction to Microsoft Project 2019/Office 365

Learn to effectively plan, implement, and control projects using Microsoft Project 2019/Office 365. This course will help you master the basics to create and share a project schedule, track costs and resources, produce reports, and resolve problems to keep your projects on track.

Suite bundles are not eligible for partial drops or refunds. Transfers to other open sessions of the same course are available. Please refer to your school for additional details regarding drops, transfers, and refunds on Suite bundles.

For more information or to register please click the link.

Each course within the Value Suite will introduce you to the features and functionality of Microsoft's latest software.

Introduction to Microsoft Word 2016

One of the most basic skills needed in any job is writing reports and letters using Microsoft Word (now available through Office 365). In this course, you'll gain the foundational skills you need to make the most of this powerful program to create professional-looking letters, reports, and documents. You'll learn how to type, edit, and format text, as well as dozens of ways to modify the appearance and content of your documents. You'll explore Word's features, such as spell and grammar checker and the thesaurus, to put a professional polish on your writing. By the time you're done with the step-by-step lessons and hands-on activities in this course, you'll be ready to use Word confidently at home or on the job.

Introduction to Microsoft Excel 2016

Do you work with numbers? Then you need to master Microsoft Excel 2016 (now available through Office 365)—and this is the place to do it. In this comprehensive online course, you'll discover dozens of shortcuts and tricks for setting up fully formatted worksheets quickly and efficiently. You'll learn the secrets behind writing powerful formulas, using functions, sorting and analyzing data, designing custom charts and graphs, creating three-dimensional workbooks, building links, and creating macros and custom toolbar buttons. This informative course covers Quick Analysis, Flash Fill, and powerful charting capabilities available in Excel 2016. By the time you're done, you'll be using Excel like a professional.

Introduction to Microsoft PowerPoint 2016

Take your PowerPoint presentations from ordinary to extraordinary! In these lessons, you'll learn how to use Microsoft PowerPoint 2016 (now available through Office 365) to create impressive slide presentations using a variety of slide and layout masters that make global changes to your presentation in a snap. You'll also see how to embellish your slides with color, text, pictures, shapes, WordArt, SmartArt, charts, animation, video, audio, and hyperlinks, and discover how to create a PowerPoint photo album with your digital pictures. In addition, you'll work with PowerPoint Online, the free online version of PowerPoint, and the new Tell Me and Smart Lookup features. Whether you're a beginner or an experienced user, this course will teach you how to turn simple slides into an exciting presentation that will grab and hold your audience's attention.

Suite bundles are not eligible for partial drops or refunds. Transfers to other open sessions of the same course are available. Please refer to your school for additional details regarding drops, transfers, and refunds on Suite bundles.

For more information or to register please click the link.

Each course within the Microsoft Office 2019 Value Suite will introduce you to the basic features and functionality of Microsoft's 2019 software.

Introduction to Microsoft Word 2019

Across all industries, the ability to create documents in a word processor is essential in day-to-day functions. The Introduction to Microsoft Word 2019 course will teach you the basics of Word, so you can create, format, and organize professional-looking documents. By the time you're done with this hands-on course, you will be able to confidently use this popular word processing software at home or on the job.

Introduction to Microsoft Excel 2019

Introduction to Microsoft Excel 2019 includes new text and images based on the Excel 2019 update. You will learn a number of basic time-saving functions, including how to write basic formulas, design custom charts and graphs, and create three-dimensional workbooks. You will also be introduced Excel 2019's powerful charting capabilities like Quick Analysis and Flash Fill. When you finish the course, you will feel at ease creating worksheets and utilizing Excel's many features.

Introduction to Microsoft PowerPoint 2019/ Office 365

The Introduction to Microsoft PowerPoint 2019/Office 365 course will teach you how to use PowerPoint to create engaging, dynamic presentations. Each lesson includes instructional content, supplementary material, learning assessments, and an assignment to practice your newly acquired skills. With millions of PowerPoint presentations conducted daily, knowing how to effectively use this software is perfect for adding value to your professional profile.

Suite bundles are not eligible for partial drops or refunds. Transfers to other open sessions of the same course are available. Please refer to your school for additional details regarding drops, transfers, and refunds on Suite bundles.

For more information or to register please click the link.