The Complete 2022 Microsoft Office Master Class Bundle

The SharePoint Online course demonstrates how to make the most out of this web-based and collaborative storage platform. It begins with the basics, such as how to create a SharePoint site and access and navigate the interface. You’ll then learn how to build lists and libraries, which make up a lot of SharePoint content, so understanding how to create and manage these is an essential SharePoint skill. It walks you through how to expand your content by integrating with other Microsoft Office applications and automating workflows, such as document approval. More than just a document management system, this course shows you how you can use SharePoint as an intranet site by creating web pages that include app parts, web parts, and other types of content.

• Access 43 lectures & 4 hours of content 24/7
• Know what SharePoint is & why it's useful
• Navigate the SharePoint interface
• Create & manage lists and libraries
• Create a discussion board
• Create & manage workflows with Power Automate
• Create & manage web pages
• Use app parts and web parts
• Integrate SharePoint with other Microsoft applications
• Customize user roles and permissions
• Create a subsite
• Customize a site’s theme

"Excellent course, very thorough content in every aspect. I am watching at double speed so you are able to soak in the content if you have a little prior experience in SharePoint." - Jared

Microsoft Access remains a fantastic tool for when your data outgrows spreadsheets. Unlike many other database tools, it’s far more user-friendly and ideal if you’re not a developer. In this Microsoft Access beginners course, we start at the very beginning and assume you know nothing about MS Access. We take a project approach to this course, which means you build your project out as we go. By the end of this Access 2019 course, you will have built out your database with proper functionality. If you’ve used Excel in the past, that will help, but it’s not essential. This course is aimed at someone just starting in Access.

• Access 59 lectures & 7.5 hours of content 24/7
• Know where to start in Microsoft Access & whether to use a template or not
• Modify Access to suit your needs
• Learn all about importing data & the datasheet view
• Learn how tables work in Access & create relationships between them
• Create forms & sub-forms that feed data into your tables
• Run queries in Access
• Set up validations & calculations using expressions in Access
• Print from Access
• Start to use macros & Modal Dialog
• Know the basics of the Access web app
• Export & report in Access

"The instructions are very clear, lessons build logically and give a very solid induction into Access Database with a few more advanced items added into it. Instructor talks clearly and is easy to understand and follow.” - Othmar Roos

Microsoft Word remains one of the most popular business tools and rightly so. Businesses around the world continue to rely on Word as their go-to for word processing. Yet Microsoft Word training often takes a back seat. The big secret about Microsoft Word is that using it the right way can save you hours and help you produce more impactful documents and reports. It's likely you are currently using less than 20% of the functionality that Microsoft Word offers presently. Unlocking that 80% could have a significant impact on your productivity and career.

• Access 82 lectures & 7 hours of content 24/7
• Get started with Word 2019
• Learn Word 2019 basics including navigation, editing, & saving
• Learn character formatting in Word including Format Painter & AutoCorrect
• Properly work with bullets & numbering in Microsoft Word
• Know all about formatting paragraphs &managing lists
• Work with Tables in Word including formatting, converting data & formulas
• Play with page appearance including page-breaks, watermarks, & styles
• Learn all about Sectioning a document
• Insert graphics, pictures, shapes, icons & 3D models (new for 2019)
• Sork with envelopes & labels
• Learn all about mail-merge & operating Word at scale
• Create an Index or Contents page
• Reviewi & printing in Word and Page Setup
• Protect a Word document & basic macros in Word

“The course is very detailed and the instructors very clear. Although I don't think of myself as a beginner in MS Office, I learned a lot of very useful tips from this beginner's course. I highly recommend this course to both absolute beginners and intermediate users.” - Ivana Remkovaj

Microsoft PowerPoint remains one of the most popular business tools and rightly so. An excellent PowerPoint presentation can be the difference between a sale won and lost, investment gained or not, a new initiative launched, or pushed to the side-line. Microsoft PowerPoint includes so many tools and features to help in all these scenarios, yet so few people make full use of this fantastic tool. You don't need to be one of them. In this in-depth PowerPoint 2019 course, we not only teach you through the most business-relevant PowerPoint techniques, you then get to put into practice what you learn through exercises at the end of each chapter.

• Access 76 lectures & 7 hours of content 24/7
• Navigate around PowerPoint
• Learn presentation dos & don'ts
• Know text & bullet edition options
• Use graphics, images, objects, & shapes
• Use SmartArt
• Work with Charts & Graphs
• Utilize Master Slides & just how much time this could save you
• Add audio & video to a presentation
• Learn all about transitions between slides
• Learn animation, the animation pane, & motion paths
• Set your slideshow options
• Learn presentation preparation & delivery
• Master the backstage area of PowerPoint including printing a presentation

“Great course. Speaks clearly and covers everything. I have been using Excel for years and now I know how much I missed out on.” - Larry

Ever tried learning Excel on a Mac with a course designed for a PC? It looks completely different. Luckily, we’ve got you covered. In this comprehensive Beginners Excel for Mac course, we take you from zero knowledge to a confident Excel Mac user. If you’ve used Excel before but never on a Mac, then this course is for you. If you’re brand new to Excel and you’re using the Mac version, then this course is definitely for you. This course was built using Excel for Mac 2019, but much of what is taught is still relevant if you’re using a different version.

• Access 57 lectures & 5 hours of content 24/7
• Create, open, & save new workbooks in Excel Mac
• Learn the basics of how Excel for Mac works, including relative references & order of operations
• Set up your workbooks & print the right thing in Excel
• Use freeze panes & split screens
• Move data around in Excel for Mac
• Learn basic formulas & functions work in Excel for Mac
• Format your spreadsheets correctly
• Create some fantastic looking charts & graphs
• Sort & filter your data in Excel

"I really love the way you describe all the things. the language of the instructions was really simple. I really gain new knowledge and understanding from this course. I am really looking forward to applying this all to my work. Thank you." - Cavin Macwan

Get beyond the basics and supercharge your current skill level in Excel. With this 9-hour, expert-led video training course, you'll gain an in-depth understanding of more advanced Excel features that delve into high-level consolidation, analysis, and reporting of financial information.

• Access 57 lectures & 8 hours of content 24/7
• Learn what’s new/different in Excel 2019
• Understand advanced charting & graphing in Excel
• Discover how to use detailed formatting tools
• Discuss financial functions including calculating interest & depreciation
• Connect to other workbooks & datasets outside of Excel
• Create awesome visualizations using sparklines & data bars

"This is an excellently pieced together information. Beautifully explained with lots of examples and external resource areas for the nerds. I highly recommend this course for anyone whose intention is to learn Excel.” - Frank Uchegbu

This 7-hour Microsoft Excel 2019 course is perfect for those brand new to Excel and who are using Excel 2019 or Excel 365 editions. In this course, your expert author gives you a solid grounding in the basics of Excel and guides you towards becoming more confident with spreadsheets.

• Access 95 lectures & 7.5 hours of content 24/7
• Learn what's new in Excel 2019
• Create workbooks
• Enter text, numbers & working with dates
• Navigate workbooks
• Learn page setup & print options
• Work with rows, columns, & cells
• Cut, Copy & Paste
• Get an introduction to Functions & Formulas
• Format in Excel, including formatting cells & numbers
• Create charts & graphs
• Sort & filter
• Learn about PivotTables
• Learn the basics of logical & lookup formulas

“I was able to learn a lot from this course and to do so at my own pace. I was able to review areas where I needed more time than someone more advanced than I. For the monetary investment, this is a great course for beginners.” - David F. Wilson

Microsoft Outlook can do so much more than send emails. Whether you are new to Outlook or have been using it for years, it’s a tool that Microsoft keeps improving, and they’ve added even more features into Outlook 2019. If you’re spending a lot of your day performing the same tasks in Outlook (move to folder, archive, delete, add an item to calendar), then there is probably a way to automate a LOT of this. Stop wasting your time and learn to put this essential Office tool to work for you. This course takes you from the basics of email and calendar, through to working with contacts, auto-replies, recalling messages (yes, you can do that), tasks, notes and so much more.

• Access 59 lectures & 6.5 hours of content 24/7
• Get set up in Outlook
• Learn some useful Outlook keyboard shortcuts
• Know all about sending & receiving emails
• Customize your mailbox & view
• Search in Outlook
• Organize and manage your mail including ignoring, flagging, & conditional formatting
• Effectively deal with Junk Mail
• Attach files, photos, & graphics in Outlook
• Learn about recalling a message
• Use signatures & voting buttons
• Best use, add to, & manage contacts
• Work with the Outlook Calendar, including creating meetings & appointments
• Share Calendars with colleagues
• Use Tasks in Outlook
• Create Notes & link Outlook to OneNote
• Print the right thing in Outlook

"This course is showing me some amazing tools that I didn't realize was available." - Brian Bailey

Microsoft Teams is quickly becoming the new way to communicate. In this comprehensive Microsoft Teams Online Course, we show you how to get started with Teams and make the most of this business-essential software. There is so much more to Microsoft Teams than chat. Use it correctly, and you can dramatically improve productivity across your business. In this course, we assume no prior knowledge and start at the very beginning. We cover both the online and desktop versions of Teams and highlight the differences between them.

• Access 50 lectures & 5 hours of content 24/7
• Access, download & set up Teams
• Create your first team & manage members and channels
• Learn all about posting & receiving public and private messages
• Use announcements, tags, & message extensions
• Schedule an audio or video call
• Use the audio & video calling options including recording calls
• Use the meeting notes function
• Create a wiki
• Learn all about using apps, bots, & connectors
• Adjust admin & user settings
• Use Teams on your mobile device

"I was already using Teams as part of my daily work but I was curious to discover all the potential of the tool via this course and I was not disappointed. The course is well structured and the explanations are very clear. I could certainly recommend it not only for beginners but also for people like me that would like to improve their knowledge of the tool." - Edelmiro

This course teaches you how to create your first Macros and edit them using the Excel programming language, VBA (Visual Basic for Applications). It starts by giving an overview of Marcos. After that, you'll move on to some VBA basics and how to edit and debug Macros. Finally, you'll look at creating a Macro from scratch using VBA and how to create a custom Macro ribbon. This course includes follow-along instructor files so you can immediately practice what you learn. This is an advanced level Excel course, an intermediate knowledge of Excel is required to get the most from this course.

• Access 15 lectures & 2 hours of content 24/7
• See examples of Excel Macros
• Know what is VBA
• Record your first macro
• Record a macro using relative references
• Record a complex, multi-step macro, & assign it to a button
• Set up the VBA Editor
• Learn all about VBA Code
• Edit Macros in the VBA Editor
• Fix issues with macros using debugging tools
• Write your own macro from scratch
• Create a custom Macro ribbon & add all the Macros you've created

"For someone who is a beginner in VBA for Excel, this course is the right thing. Both structure and the presenter were great and I will recommend this course to everyone who needs VBA programming in Excel." - Darko Vlajkovic

You’re probably using a fraction of the functionality available in Microsoft Word. In this Advanced Word course, we take a deep dive into Microsoft Word’s advanced functions. This course will teach you how to automate tasks in Word, how to make Word documents simpler to navigate and use, how to protect Word documents, how to break up documents, how to use different views, how to track changes, how to use Footnotes and Endnotes and so much more. If you are spending a lot of time in Word, this could be the course that saves you hours each week.

• Access 126 lectures & 15.5 hours of content 24/7
• Find & replace special characters
• Learn all about spelling, grammar, & autocorrect options
• Work with different views in Word
• Syle & use formulas in Tables in Word
• Learn best practice for images including compressing images, captions, 3D models, & icons
• Make use of Text Boxes in Word
• Use section, page, & column breaks
• Learn all about Master & Subdocuments
• Utilize hyperlinks
• Use Word Templates
• Modify document properties
• Use Themes & Custom Themes
• Protect documents with passwords, read-only, & digital signatures
• Mark up & track changes in a Word document
• Compare & combine versions in Word
• Know all about using Citations, Tables of Authority, & Bibliographies
• Create & insert a working Form in Word
• Use Macros to automate basic tasks
• Share documents with others/li>

"This course is definitely worth the time and money! Very informative and engaging. Provides actual demonstrations (not just slides) on how to operate functions in Word and provides exercises to practice with." - Carey Winter

OneNote is the digital note-taking tool from Microsoft. In this detailed set of OneNote tutorials, we look at how to get started using OneNote and how to make the most of this powerful productivity software. Microsoft OneNote is now available as a full, desktop version, or as a lightweight desktop app for Windows (OneNote for Windows 10). The full desktop version of OneNote packs an impressive feature list and that is the focus of this course. This course also includes tutorials in each section on OneNote for Windows 10, so regardless of which version you use, we have you covered. Your expert author not only teaches you how to use the tools available to you but also shows you some best practices wh

• Accses 71 lectures & 7.5 hours of content 24/7
• Get started using OneNote Desktop or OneNote Windows 10
• Add text, videos, images, clips, & links to OneNote
• Use the screen clipping tool in OneNote
• Format notes in OneNote
• Create a to-do list in OneNote
• Add tags in OneNote & search for content
• Link notes in OneNote
• Format pages in OneNote
• Use the pen tools in OneNote, including handwriting to text
• Lnk OneNote with Outlook
• Share notebooks in OneNote
• Collaborate using OneNote
• Customize your options in OneNote
• Use OneNote Online & the OneNote App

"Got my money's worth in the first lesson. Although I don't need to use all the features of One Note, this class is well worth it as compared to trying to find the information online through other sources." - Michael

Power Automate is a powerful application from Microsoft with a simple interface that can be used to automate tasks and business processes. It is an exhaustive tool that can be connected to almost any application and streamline any personal or business workflow without using code! Automated workflows can even be shared with others. This introductory course is aimed at beginner and intermediate users of Power Automate for Microsoft 365. The course uses the online version of Power Automate for demonstration and covers the basic and some intermediate features of Power Automate to get you started. Advanced features such as UI and Desktop flows are out of scope for this course.

New course!

• Access 36 lectures & 2.5 hours of content 24/7
• Navigate the Power Automate interface
• Know what Flow is & its types
• Create a Flow from a template
• Create an automated Flow
• Run, edit, & track a Flow
• Share Flows with other users
• Create a Flow from scratch
• Create Triggers & Actions
• Use Dynamic Content
• Create Expressions
• Know what Conditions are
• Create scheduled Flows
• Know what an approval Flow is
• Learn about Input Types
• Get an introduction to built-in functions
• Work with Loops
• Get an overview of Do Until
• Know what Switch statements are

Microsoft Access remains a fantastic tool for when your data outgrows spreadsheets. Unlike many other database tools, it's far more user-friendly and ideal if you're not a developer. In this Microsoft Access advanced course, we start where the beginner's course finishes and dives straight into more advanced Access features. This course assumes you know the basics of Access, including how to set up your database, how tables work, how to create forms, and how to run simple queries. In this advanced Access course, we look at using ODBC and SQL Server. We also take a deeper dive into using Macros and VBA in Access, splitting databases, and advanced form creation.

• Access 46 lectures & 7 hours of content 24/7
• Learn all about Primary Keys & Indexes in Access
• Customize & filter on the Datasheet View
• Link to other databases
• Know all about using ODBC & SQL Server
• Split an Access database into front & back-end
• Learn all about Macros in Access including AutoExec
• Do basic VBA in Access including code & error handling
• Learn more advanced techniques around creating forms in Access
• Learn advanced queries including "multiple where" criteria

“Yes. Being a novice to Access, I appreciate getting all the detailed basics under my belt as we gradually progress into this powerful database. I really enjoyed my journey through this Access course with my instructor. His presentation through all the modules was well explained and very in-depth with related examples and chances to practice what was taught.” - James Habersham