Introduction to Microsoft Access (ACC101)

2 days

The Introduction to Access course provides a comprehensive foundation for students looking to learn about the Access database management system. This course covers the basics of Access, including its user interface, fundamentals, tables, queries, forms, and reports. Students will also gain insights into databases, Access terms, and relational databases. By the end of this course, students will have a solid understanding of Access and be prepared to use it effectively for managing and organizing data in various applications.

Access Version: This course primarily targets Access 2019; however, it can be used to teach Access 365 as well as earlier …

Introduction to Microsoft Word Training (WRD365.1)

1 day

This Introduction to Word course is designed for beginners who want to develop a solid foundation in using Microsoft Word. The course covers essential topics such as Microsoft Office basics, creating and managing Word documents, navigating the Ribbon and Backstage View, working with the Quick Access Toolbar, formatting and editing documents, and finalizing your work. Through a series of hands-on exercises and practical examples, students will learn how to create, edit, and format professional documents using Microsoft Word's powerful tools and features.

Word Version: This course primarily targets Word 365 and Word 2021; however, we draw attention to features …

Introduction to Microsoft PowerPoint Training (PPT365.1)

1 day

This Introduction to PowerPoint course is designed to help beginners and those new to Microsoft PowerPoint develop the essential skills needed to create, edit, format, and present compelling presentations. The course covers the basics of Microsoft Office, the Ribbon, Quick Access Toolbar, and Backstage View. It also delves into formatting presentations, working with images, tables, charts, and preparing and presenting your slides. Through practical exercises, students will learn the fundamental aspects of PowerPoint, empowering them to create visually appealing and engaging presentations.

PowerPoint Version: This course primarily targets PowerPoint 365 and PowerPoint 2021; however, we draw attention to features …

Introduction to Microsoft Outlook (OUT101)

1 day

This Introduction to Outlook course is designed for individuals who want to learn how to use Microsoft Outlook effectively for email communication, calendar management, and contact organization. The course covers key topics such as the Outlook interface, performing popular tasks, working with messages, managing the calendar, and organizing contacts. Through practical exercises and demonstrations, students will gain a solid understanding of Outlook's core features and learn how to streamline their day-to-day tasks, manage their schedules, and maintain an organized list of contacts.

Outlook Version: This course primarily targets Outlook 2019; however, it can be used to teach Outlook 365 …

Introduction to Microsoft Excel Training (EXC365.1)

1 day

The Introduction to Excel course is designed for beginners seeking to learn the fundamentals of Microsoft Excel. This comprehensive course covers various aspects of Excel, such as the Microsoft Office basics, creating and managing workbooks, using the Ribbon and Backstage View, customizing the Quick Access Toolbar, entering and formatting data, editing worksheets, working with rows and columns, using formulas, and finalizing worksheets for printing. By the end of this course, students will have a solid foundation in Excel, enabling them to efficiently manage and analyze data.

Excel Version: This course primarily targets Excel 365 and Excel 2021; however, we …

Microsoft 365 Super User (55283AC)

3 days

Introduction to Microsoft Excel 2019 (EXC2019.1)

1 day

This Introduction to Microsoft Excel 2019 course begins with the fundamentals of creating a workbook and gradually progresses to cover the program's most advanced features. The curriculum is designed to help you navigate Excel's interface, enter and format data efficiently, use formulas, edit your worksheets, and prepare your work for printing.

This is the updated version of 55271AC from the retired Microsoft Courseware Marketplace. Note that we have a newer version that covers Excel 2021 and 365.

Introduction to Microsoft Word 2019 (WRD2019.1)

1 day

This course provides an introduction to Microsoft Word 2019, focusing on the essential skills needed to create, format, and finalize documents. It begins by covering the basics of creating a document, saving, and importing files, and navigating the user interface including the status bar. It then delves into the functionalities of the Ribbon, explaining tabs, groups, and commands.

The course also introduces the Backstage View, also known as the File menu, teaching how to open documents, use templates, print documents, and manage document properties. Participants will also learn about the Quick Access Toolbar, including how to add and organize …

Introduction to Microsoft PowerPoint 2019 (PPT2019.1)

1 day

The Introduction to PowerPoint 2019 course offers an extensive exploration of the foundational and intermediate aspects of Microsoft's powerful presentation tool. It covers the creation of presentations, the functionality of the Ribbon, the Quick Access Toolbar, the Backstage View, text formatting, image handling, table/chart management, and finalization processes. This course enables participants to create, modify, and deliver professional presentations.

This is the 55277AC course from the retired Microsoft Courseware Marketplace. Note that we have an updated version that covers PowerPoint 2021 and 365.

Introduction to Microsoft Word 2016 (WRD2016.1)

1 day

In this course, students learn to create professional documents using Word 2016. By the end of this class, they will be comfortable editing, formatting and printing documents in Microsoft Word.

Target Audience: Students who have little or no familiarity with Word 2016 or more experienced Word users who want to review the basics.

This is the 55173AC course from the retired Microsoft Courseware Marketplace. Note that we have newer versions: one that covers Word 2019 and one that covers Word 2021 and 365.

Introduction to Microsoft PowerPoint 2016 (PPT2016.1)

1 day

This Introduction to Microsoft PowerPoint 2016 course takes students step-by-step through the process of creating, formatting, and finalizing a presentation, with plenty of opportunities to practice and consolidate their learning along the way.

This is the 55176AC course from the retired Microsoft Courseware Marketplace. Note that we have updated versions: one that covers PowerPoint 2019 and one that covers PowerPoint 2021 and 365.

Introduction to Microsoft Excel 2016 (EXC2016.1)

1 day

In this Introduction to Microsoft Excel 2016 course, you'll start from the very basics of creating a workbook, and gradually work your way up to using advanced features introduced in Excel 2013 and 2016. The course covers how to work with the ribbon, understand the Backstage View, and customize the Quick Access Toolbar. You'll learn how to efficiently enter and format data, use formulas, and edit your worksheets. The course concludes with preparing your worksheets for printing and exploring new features in the latest Excel versions.

This is the updated version of 55165AC from the retired Microsoft Courseware Marketplace. …

iSpring Suite 11: The Essentials (ISPRING11)

1 day

iSpring Suite 11 is an eLearning authoring toolkit that allows developers to create mobile-friendly eLearning courses.

Step-by-step instructions guide you through the process of creating new iSpring Suite eLearning projects from PowerPoint presentations.

You’ll learn how to import images, videos, and how to both record and edit voiceover audio.

Record video demonstrations of just about anything you can do on your computer complete with editable annotations. 

Create role-play scenarios using supplied iSpring Studio assets including background images, icons, and characters.

Add Learner Interactions and Quizzes to make your eLearning projects as engaging as possible.

…

Excel 2019 Formulas (0200-240-19-W)

1 day

In this course, you will cover how to: name cells and ranges, use those names in formulas, use Logical and Lookup function formulas, use the IF and IFS formulas, Data Validation, use Match and Indexing formulas, work with Date and Time formulas, and use the formula auditing tools to trouble shoot problems in formulas.

In this course, you will cover how to: name cells and ranges, use those names in formulas, use Logical and Lookup function formulas, use the IF and IFS formulas, Data Validation, use Match and Indexing formulas, work with Date and Time formulas, and use the …

Excel 2019 Pivot Tables (0200-500-19-W)

1 day

In this course you will learn how to create and modify PivotTables and PivotCharts, as well as how to filter and modify fields to format and group data. In addition, you will learn to use the advanced features of PivotTables, such as consolidating multiple workbooks as well as creating and using page fields. Finally, you will learn how to generate PivotTables using imported data from external data sources. This information could be in Access, SQL Tables, the Internet, or other database programs. Understanding how to work with PivotTables and PivotCharts to achieve the results you want is one of the …

Intermediate Microsoft Word Training (WRD365.2)

1 day

The Intermediate Microsoft Word course is designed for users who are familiar with basic Word features and are looking to enhance their skills. The course covers advanced topics such as advanced formatting, working with tables, working with images, page layout, working with illustrations, and viewing your documents. Through practical exercises and real-world examples, students will develop a deeper understanding of Microsoft Word's capabilities and learn how to use the software more efficiently to create professional and visually appealing documents.

Word Version: This course primarily targets Word 365 and Word 2021; however, we draw attention to features that are not …

Intermediate Microsoft Excel Training (EXC365.2)

1 day

This Intermediate Excel course builds upon the foundational skills acquired in the Introduction to Excel course, offering a deeper understanding of Excel's capabilities. The course covers common functions like IF, COUNTIF, and TEXTJOIN, as well as working with lists, tables, and advanced formatting. It also provides an introduction to visualizing data through charts, sparklines, and SmartArt. Throughout the course, students will learn how to apply these concepts to real-world scenarios, improving their ability to manage and analyze data effectively.

Excel Version: This course primarily targets Excel 365 and Excel 2021; however, we draw attention to features that are not …

Advanced Microsoft PowerPoint Training (PPT365.2)

1 day

The Advanced PowerPoint course focuses on elevating the skills of experienced PowerPoint users, providing them with a deeper understanding of the software's capabilities. This course covers a wide range of topics, such as customizing presentations, working with Presentation Masters, incorporating special effects, utilizing SmartArt, integrating multimedia elements, setting up slide shows, managing outlines and slides, handling multiple presentations, and finalizing presentations. Through a combination of practical exercises and expert instruction, students will learn how to create engaging, sophisticated presentations using advanced PowerPoint features and techniques.

PowerPoint Version: This course primarily targets PowerPoint 365 and PowerPoint 2021; however, we draw …

Advanced Microsoft Excel Training (EXC365.3)

1 day

The Advanced Excel course is designed for experienced users looking to leverage Excel's powerful features to streamline their work and enhance their data analysis capabilities. The course delves into topics such as PivotTables, advanced functions, auditing workbooks, and data tools. Students will also explore importing and consolidating data, What-If analysis, recording and using macros, and collaborating with others. Through hands-on exercises and real-world examples, students will master advanced Excel techniques, equipping them with the skills needed to tackle complex data analysis tasks efficiently.

Excel Version: This course primarily targets Excel 365 and Excel 2021; however, we draw attention to …

Advanced Microsoft Word Training (WRD365.3)

1 day

The Advanced Microsoft Word course is designed for experienced Word users who want to master the software's most powerful features. The course covers topics such as working with long documents, reviewing and collaborating on documents, comparing and combining documents, creating forms, managing mailings, protecting documents, and using macros. Through hands-on exercises and practical examples, students will learn how to utilize Word's advanced tools and functionalities to create professional and polished documents with ease.

Word Version: This course primarily targets Word 365 and Word 2021; however, we draw attention to features that are not supported in earlier versions of Word, …

Intermediate Microsoft Excel 2019 (EXC2019.2)

1 day

This Intermediate Microsoft Excel 2019 course is designed to deepen your understanding of Excel's powerful features, with a focus on formulas, list management, illustrations, data visualization, table manipulation, and advanced formatting. Each topic is accompanied by practical exercises to reinforce your learning.

This is the same course as 55269AC from the retired Microsoft Courseware Marketplace. Note that we have a newer version that covers Microsoft Excel 2021 and 365.

Intermediate Microsoft Word 2019 (WRD2019.2)

1 day

This course provides in-depth training on advanced formatting techniques in Microsoft Word. It teaches students how to use shading and borders, set line and paragraph spacing, change styles, use paragraph marks and other formatting symbols, and edit PDF documents in Word.

The course also covers working with tables, including inserting, styling, and formatting tables. Students will also learn how to work with images in Word, which includes inserting, sizing, and placing images, wrapping text around images, adjusting images, and adding borders and effects to images.

The page layout section of the course covers orientation and paper size, using …

Intermediate Microsoft Excel 2016 (EXC2016.2)

1 day

This Intermediate Microsoft Excel 2016 will take your Excel skills to the next level. Learn how to use advanced formulas, work with lists, illustrations, and tables, and visualize your data with sophisticated charting techniques. Understand how to apply advanced formatting such as conditional formatting and styles, and even get familiar with new features in Excel 2013 and Excel 2016. Throughout the course, you'll get hands-on experience with exercises designed to reinforce what you've learned and build real-world skills.

This is the updated version of 55166AC from the retired Microsoft Courseware Marketplace. Note that we have newer versions: one that …

Intermediate Microsoft Word 2016 (WRD2016.2)

1 day

Ready to take your Microsoft Word skills to the next level? In this class, you will learn to use advanced formatting, drawing tools, tables, column layouts, custom fields and more!

Target Audience: Students who have basic Microsoft Words skills and are ready to create more professional document using sophisticated design features.

This is the updated version of 55174AC from the retired Microsoft Courseware Marketplace. Note that we have newer versions: one that covers Word 2019 and one that covers Word 2021 and 365.

Advanced Microsoft Access (ACC201)

2 days

The Advanced Access course builds upon the foundational skills acquired in the Introduction to Access course, diving deeper into topics such as relationships, queries, table functions, advanced forms, reports, macros, and completing a desktop application. This course equips students with the skills and knowledge to handle more complex Access tasks, further enhancing their data management capabilities and proficiency with the software.

Access Version: This course primarily targets Access 2019; however, it can be used to teach Access 365 as well as earlier versions of Access. We draw attention to features that are not supported in earlier versions of Access, …

Advanced Microsoft Outlook (OUT201)

1 day

The Advanced Outlook course is tailored for individuals who are familiar with Microsoft Outlook and want to enhance their skills in managing tasks, notes, inbox, and multiple email accounts. The course delves into advanced features such as using signatures and themes, inbox management, and working with multiple email accounts. Students will participate in hands-on exercises that enable them to become proficient in these advanced Outlook functionalities, leading to increased productivity and improved email management in their professional lives.

Outlook Version: This course primarily targets Outlook 2019; however, it can be used to teach Outlook 365 as well as earlier …

Advanced Microsoft Word 2019 (WRD2019.3)

1 day

This course offers in-depth knowledge on managing long documents in Microsoft Word. It covers the creation, updating, and management of elements such as Tables of Contents, Footnotes, Endnotes, Citations, Bibliographies, and Indexes. It also includes instructions on how to create outlines and handle Tables of Figures and Tables of Authorities.

The course also focuses on collaborative features, like adding, tracking, and reviewing comments, and making changes in documents. There's a section on comparing and combining documents for efficient version management. A unit on "Managing Mailings" covers creating envelopes and labels, and using the Mail Merge feature.

The course …

Advanced Microsoft PowerPoint 2019 (PPT2019.2)

1 day

This advanced PowerPoint 2019 course is designed to provide a comprehensive understanding of the higher-level functionalities of the software. It covers topics such as the innovative features introduced in the 2013 and 2016 versions of PowerPoint, presentation customization, working with Presentation Masters and SmartArt, multimedia handling, setting up slide shows, exporting outlines and slides, managing multiple presentations, and presentation sharing and security. In addition, it includes practical exercises for hands-on experience.

This is the 55276AC course from the retired Microsoft Courseware Marketplace. Note that we have an updated version that covers PowerPoint 2021 and 365.

Advanced Microsoft Excel 2019 (EXC2019.3)

1 day

This Advanced Microsoft Excel 2019 course will take you through the key functionalities of Microsoft Excel, from creating Pivot Tables, auditing worksheets, using various data tools, to recording and using macros. You will also learn how to work collaboratively and effectively with others, explore various random useful features, and understand how to harness the power of the cloud. Each module is accompanied by practical exercises to help consolidate your learning.

This is the updated version of 55270AC from the retired Microsoft Courseware Marketplace. Note that we a newer version that covers Excel 2021 and 365.

Advanced Microsoft Excel 2016 (EXC2016.3)

1 day

This Advanced Microsoft Excel 2016 equips you with essential Excel skills for data manipulation and analysis, workbook auditing, and collaborative work. Master the art of creating and working with pivot tables, and learn how to audit worksheets for data dependencies and precedents. Further, delve into various data tools such as text-to-columns conversion, data validation, and goal seeking. Enhance your collaborative work efficiency with workbook and worksheet protection methods, and empower your Excel proficiency with macro recording and editing. Learn to use and customize sparklines, prepare your workbook for internationalization and accessibility, and understand how to import and export data. The …

Advanced Microsoft PowerPoint 2016 (PPT2016.2)

1 day

The Advanced Microsoft PowerPoint 2016 course is designed to help participants further enhance their PowerPoint skills. It covers advanced features of the application, from customizing presentations and working with slide masters, to managing multiple presentations and securing them. The course also covers features new to PowerPoint 2013 and 2016 versions.

This is the 55177AC course from the retired Microsoft Courseware Marketplace. Note that we have updated versions: one that covers PowerPoint 2019 and one that covers PowerPoint 2021 and 365.

Advanced Microsoft Word 2016 (WRD2016.3)

1 day

In this Advanced Microsoft Word class, you will learn about document collaboration, security, navigation, and more. You will practice adding a table of contents, footnotes, endnotes, and comments. You will gain experience tracking changes, comparing and combining documents, creating envelopes and labels, using Mail Merge, and protecting documents. This class is for Word on Windows.

Target Audience:Students who have intermediate Microsoft Word skills and are ready to learn advanced tools and features.

This is the updated version of 55175AC from the retired Microsoft Courseware Marketplace. Note that we have newer versions: one that covers Word 2019 and  …