Ultimate Microsoft Office; Excel, Word, Powerpoint & Access (updated 11/2022)

Learn basic to advanced Microsoft Office skills in this 9-course bundle for Office 365 or Office 2019

What you'll learn

Learn the essential and advanced Microsoft Office Skills in Excel, Word, PowerPoint, Outlook, Teams and Access

HUGE Value Bundle - Eight Courses!

Learn practical methods to backup and recover your Excel spreadsheets and never lose data

Effectively use autofill and flashfill so you are more productive in Microsoft Excel.

Discover the essentials of using formulas and functions in Excel

Discover how to create stunning charts and graphs in Excel

Learn practical methods to sort and filter your data in Excel

Discover new features in PowerPoint 2019 including Icons and 3D Models

Learn how to insert shapes, graphics and pictures to add some "zing" to your PowerPoint

Add charts, graphs and tables to your PowerPoint presentation information in a non-text format

Wow your audience by adding animations, audio and video to PowerPoint

Discover practical tips to present your PowerPoint presentation to your audience

Learn time saving techniques including how to copy slides, and exporting your presentation

Master the most common uses of Microsoft Word

Learn Word tools including using columns, indents, footers, borders and watermarks.

How to create a mail merge in Microsoft Word

Learn how to correctly Print envelopes and labels in Word

Learn to protect your Word document from changes

Insert professional pictures and graphics in your Word document

Make your Word documents look amazing by inserting and editing tables

Sorting information and running queries in Access

Navigating the Access 2019 interface

Discover how to into import data from Excel in Access

Learn Queries, use validations, how to create and print reports in Access

How to compact, repair and backup your Access database

How to create a linked table in Access

How to get set up in Outlook

All about sending and receiving emails

How to customize your mailbox and view

How to organize and manage your mail including ignoring, flagging and conditional formatting

How to organize and manage your mail including ignoring, flagging and conditional formatting

Creating and managing tasks and reminders

How to use signatures and voting buttons

Adding, managing and searching contacts in the address book

Working with the Outlook Calendar, including creating meetings and appointments

How to create Notes and link Outlook to OneNote

Requirements

Excel, Word, PowerPoint, Access, Teams and Outlook installed on your machine. Preferably Office 2019 or Office 365

Description

**This course includes practice exercises and LIFETIME access**Learn Excel, PowerPoint, Access, Outlook, Teams, OneNote, and Word with this tremendous value 9-course bundle from Simon Sez IT.The Microsoft Office suite is used by millions worldwide. Unlocking its full potential could see you drastically improve your productivity.But you know all that because you’re on this page.Instead, you’re probably wondering whether we’re the right team to teach you Office.Simon Sez IT has been teaching MS Office for over 13 years, and we’ve got pretty good at it. Just take a look at our Udemy ratings if you don’t believe us.For this Ultimate Microsoft Office 2019 course, we’ve bundled together 9 of our best-selling titles into one huge value offering.You don’t just get access to beginner courses either. You get advanced training in Microsoft Excel and Microsoft Access and a comprehensive grounding in Microsoft PowerPoint, Microsoft Outlook, Microsoft Teams, Microsoft Word, and Microsoft OneNote.***UPDATED APRIL 2020 - Outlook 2019 Added******UPDATED May 2020 - Microsoft Teams Added******UPDATED 2021 - Microsoft OneNote Added**What's covered in each course?Microsoft Excel 2019What's new in Excel 2019Creating workbooksEntering text, numbers and working with datesNavigating workbooksPage setup and print optionsWorking with rows, columns, and cellsCut, Copy and PasteIntroduction to Functions and FormulasFormatting in Excel, including formatting cells and numbersCreating charts and graphsSorting and FilteringIntroduction to PivotTablesLogical and lookup formulas - the basicsAdvanced Microsoft Excel 2019What's new/different in Excel 2019Advanced charting and graphing in ExcelHow to use detailed formatting toolsLookup and advanced lookup functionsFinancial functions including calculating interest and depreciationStatistical functionsConnecting to other workbooks and datasets outside of Excel e.g. MS Access and the web.How to create awesome visualizations using sparklines and data barsMastery of PivotTables and Pivot ChartsScenario Manager, Goal Seek, and SolverAdvanced charts such as Surface, Radar, Bubble, and Stock ChartsMicrosoft PowerPoint 2019How to navigate around PowerPointPresentation dos and don'tsText and bullet edition optionsHow to use graphics, images, objects, and shapesUsing SmartArtWorking with Charts and GraphsHow to utilize Master Slides and just how much time this could save youHow to add audio and video to a presentationAll about transitions between slidesAnimation, the animation pane, and motion pathsSetting your slideshow optionsPresentation preparation and deliveryThe backstage area of PowerPoint including printing a presentationMicrosoft Word 2019How to get started with Word 2019Word 2019 basics including navigation, editing, and savingCharacter formatting in Word including Format Painter and AutoCorrectHow to properly work with bullets and numbering in Microsoft WordAll about formatting paragraphs and managing listsWorking with Tables in Word including formatting, converting data and formulasPage appearance including page-breaks, watermarks, and stylesAll about Sectioning a documentInserting graphics, pictures, shapes, icons, and 3d models (new for 2019)How to work with envelopes and labelsAll about mail-merge and operating Word at scaleHow to create an Index or Contents pageReviewing and Printing in Word and Page SetupProtecting a Word document and basic macros in WordMicrosoft Access 2019Where to start in Microsoft Access and whether to use a template or notHow to modify Access to suit your needsAll about importing data and the datasheet viewHow tables work in Access and how to create relationships between themCreating forms and sub-forms that feed data into your tablesHow to run queries in AccessSetting up validations and calculations using expressions in AccessPrinting from AccessTo start to use macros and Modal DialogThe basics of the Access web appExporting and reporting in AccessAdvanced Microsoft Access 2019About Primary Keys and Indexes in AccessAbout customizing and filtering on the Datasheet ViewHow to link to other databasesAll about using ODBC and SQL ServerHow to split an Access database into front and back-endAll about Macros in Access including AutoExecHow to do basic VBA in Access including code and error handlingMore advanced techniques around creating forms in AccessAdvanced queries including “multiple where” criteriaMicrosoft Outlook 2019How to get set up in OutlookSome useful Outlook keyboard shortcutsAll about sending and receiving emailsHow to customize your mailbox and viewHow to search in OutlookHow to organize and manage your mail including ignoring, flagging, and conditional formattingHow to effectively deal with Junk MailAttaching files, photos, and graphics in OutlookAbout recalling a messageHow to use signatures and voting buttonsHow to best use, add to, and manage contactsWorking with the Outlook Calendar, including creating meetings and appointmentsHow to share Calendars with colleaguesHow to use Tasks in OutlookHow to create Notes and link Outlook to OneNoteHow to print the right thing in OutlookMicrosoft TeamsHow to access, download and set up TeamsHow to create your first team and manage members and channelsAll about posting and receiving public and private messagesHow to do user announcements, tags, and message extensionsHow to schedule an audio or video callHow to use the audio and video calling options including recording callsHow to use the meeting notes functionHow to create a wikiAll about using apps, bots, and connectorsHow to adjust admin and user settingsHow to use Teams on your mobile deviceMicrosoft OneNoteHow to get started using OneNote Desktop or OneNote Windows 10How to add text, videos, images, clips, and links to OneNoteHow to use the screen clipping tool in OneNoteHow to format notes in OneNoteHow to create a to-do list in OneNoteHow to add tags in OneNote and search for contentHow to link notes in OneNoteHow to format pages in OneNoteHow to use the pen tools in OneNote, including handwriting to textHow to link OneNote with OutlookHow to share notebooks in OneNoteHow to collaborate using OneNoteHow to customize your options in OneNoteAbout using OneNote Online and the OneNote App***Exercise and demo files included***This bundle includes:68+ hours of video tutorials600+ individual video lecturesExercise files to practice what you learnedCertificate of completionNINE full-length Microsoft coursesThese courses were all recorded in the 2019 versions of MS Office but are still applicable if you’re working with Office 2013, 2016, or Office 365. Microsoft Teams and Microsoft OneNote were recorded using Office 365.Here’s what our students are saying…"I'm finding this course very helpful and the instructor is very easy to understand. I am learning so much more than I did from another course I tried to take and lost interest in. This course has really kept my interest."- Dianne Munizza"Loving the lessons. Easy to understand and can replay the lesson if I did not catch something the first time.."- Monica Yvette Disbrow"It's still early on in the course, but I love it. He's so very clear with each tiny thing he's teaching you. He sounds quite like a gentle and patient friend or mentor walking you through step by step. He also repeats things (not monotonously) which helps you retain what you're learning. When I first registered for this course, I thought 'oh my goodness, what have I done'… when you look at the 'your progress' dropdown at the upper right corner of your dashboard and see that you're on #21 of 518(!), it can seem a bit intimidating. But, no – I think with this particular instructor's gift of friendly teaching, we'll all do fantastically well!"- Celine Barton

Overview

Section 1: Excel 2019: Introduction

Lecture 1 Intro to Excel

Lecture 2 WATCH ME: Essential Information for a Successful Training Experience

Lecture 3 Course Exercise Files

Lecture 4 Downloadable Course Transcript

Lecture 5 What's New In Excel 2019

Lecture 6 Course Overview

Lecture 7 Overview of the Excel window

Lecture 8 Mouse-Features

Lecture 9 Back Stage View

Section 2: Excel 2019 Beginner: Creating Workbooks

Lecture 10 Entering Text and Numbers

Lecture 11 Creating Basic Formulas

Lecture 12 Relative References

Lecture 13 Order of Operations

Lecture 14 Working with Ranges

Lecture 15 Module 2 - Practice Exercise

Section 3: Excel 2019 Beginner: Saving Workbooks

Lecture 16 Working with the Save and Save As Commands

Lecture 17 File Extensions, Share, Export and Publish Files

Lecture 18 Module 3 - Practice Exercise

Section 4: Excel 2019 Beginner: Navigating Workbooks

Lecture 19 Opening a File

Lecture 20 Working with Larger Files

Lecture 21 Freeze Panes Option

Lecture 22 Split Screen Option

Lecture 23 Module 4 - Practice Exercise

Section 5: Excel 2019 Beginner: Page Setup & Print Options

Lecture 24 Headers and Footers

Lecture 25 Print Titles

Lecture 26 Comments

Lecture 27 Page Setup Options

Lecture 28 Fit to Print on One Page

Lecture 29 Printing Workbooks

Lecture 30 Module 5 - Practice Exercise

Section 6: Excel 2019 Beginners: Working with Rows, Columns and Cells

Lecture 31 Adding and deleting rows columns and cells

Lecture 32 Changing Column and-Row Widths

Lecture 33 Module 6 - Practice Exercise

Section 7: Excel 2019 Beginners: Moving Data

Lecture 34 Cut, Copy and Paste

Lecture 35 Copying Formulas

Lecture 36 Module 7 - Practice Exercise

Section 8: Excel 2019 Beginners: Formulas & Functions

Lecture 37 Overview of Formulas

Lecture 38 Create Formulas Using Functions Part 1

Lecture 39 Create Formulas Using Functions Part 2

Lecture 40 Absolute Values

Lecture 41 Module 8 - Practice Exercise

Section 9: Excel 2019 Beginner: Working with Sheets

Lecture 42 Adding Deleting and Renaming Sheets

Lecture 43 Additional Sheet Tab Options

Lecture 44 3 Dimensional Formulas

Lecture 45 Module 9 - Practice Exercise

Section 10: Excel 2019 Beginner: Formatting Worksheets

Lecture 46 Formatting Cells Part 1

Lecture 47 Formatting Cells Part 2

Lecture 48 Formatting Numbers

Lecture 49 Borders and Shading

Lecture 50 Format as Table

Lecture 51 Using Styles

Lecture 52 Using Format Painter

Lecture 53 Protecting Sheets

Lecture 54 Fill Handle and Custom Lists

Lecture 55 Module 10 - Practice Exercise

Section 11: Excel 2019 Beginner: Charts

Lecture 56 Creating Charts

Lecture 57 Types of Charts

Lecture 58 Editing Charts Part 1

Lecture 59 Editing Charts Part 2

Lecture 60 Using Graphics to Enhance Charts

Lecture 61 Linking Chart Titles

Lecture 62 Module 11 - Practice Exercise

Section 12: Excel 2019 Beginner: Working with Names

Lecture 63 Creating Range Names

Lecture 64 Managing Names

Lecture 65 Using Names in Formulas

Lecture 66 Module 12 - Practice Exercise

Section 13: Excel 2019 Beginner: Sorting and Filtering

Lecture 67 Remove Duplicates

Lecture 68 Sort Data

Lecture 69 Filter Data

Lecture 70 Advanced Filters

Lecture 71 Module 13 - Practice Exercise

Section 14: Excel 2019 Beginner: Outlining and Subtotaling

Lecture 72 Creating an Outline

Lecture 73 Subtotals

Lecture 74 Module 14 - Practice Exercise

Section 15: Excel 2019 Beginner: Working with Views

Lecture 75 Arranging Files

Lecture 76 New Window Option

Lecture 77 Custom Views

Lecture 78 Module 15 - Practice Exercise

Section 16: Excel 2019 Beginner: Linking Files

Lecture 79 Creating Formulas Between File

Lecture 80 Working with Links

Lecture 81 Consolidating Data

Lecture 82 Module 16 - Practice Exercise

Section 17: Excel 2019 Beginner: Advanced Formula Creation

Lecture 83 If Statements

Lecture 84 VLookups

Lecture 85 Data Validation

Lecture 86 Formula Auditing

Lecture 87 Module 17 - Practice Exercise

Section 18: Excel 2019 Beginner: Pivot Tables

Lecture 88 Pivot Tables

Lecture 89 Pivot Charts

Lecture 90 Module 18 - Practice Exercise

Section 19: Excel 2019 Beginner: Additional Excel Features

Lecture 91 Slicers

Lecture 92 Goal Seeker

Lecture 93 Text to Columns

Lecture 94 Watch Window

Lecture 95 Customizing Ribbons and Tabs

Lecture 96 Module 19 - Practice Exercise

Section 20: Excel 2019 Beginner: Shortcuts

Lecture 97 Excel Shortcuts Every User Should Know

Section 21: Excel 2019 Beginner: Closing

Lecture 98 Closing Video

Section 22: Excel 2019 Advanced: Intro to Advanced Course

Lecture 99 Introduction to the Course

Lecture 100 WATCH ME: Essential Information for a Successful Training Experience

Lecture 101 Excel 2019 Advanced Course Exercise Files

Lecture 102 Excel 2019 Advanced Course Demo Files

Lecture 103 Downloadable Course Transcripts

Lecture 104 Course Structure

Section 23: Excel 2019 Advanced: Functions

Lecture 105 Functions - Part 1

Lecture 106 Functions - Part 2

Lecture 107 Autosum

Section 24: Excel 2019 Advanced: Date and Time Functions

Lecture 108 How Date and Time Works

Lecture 109 Basic Date and Time Functions

Lecture 110 Complex Date and Time Functions

Section 25: Excel 2019 Advanced: Text Functions

Lecture 111 Using Text Functions - Part 1

Lecture 112 Using Text Functions - Part 2

Section 26: Excel 2019 Advanced: Logical Functions

Lecture 113 Logical Functions

Lecture 114 Exercise 01

Section 27: Excel 2019 Advanced: Lookup Functions

Lecture 115 Lookup Functions - Part 1

Lecture 116 Lookup Functions - Part 2

Lecture 117 Exercise 02

Section 28: Excel 2019 Advanced: Financial Functions

Lecture 118 Financial Functions and Terminology

Lecture 119 Personal Financial Functions

Lecture 120 Principal and Interest Payments

Lecture 121 Depreciation

Lecture 122 Exercise 03

Section 29: Excel 2019 Advanced: Statistical Functions

Lecture 123 Statistical Functions for Description - Part 1

Lecture 124 Statistical Functions for Description - Part 2

Lecture 125 Statistical Functions for Forecasting - Part 1

Lecture 126 Statistical Functions for Forecasting - Part 2

Lecture 127 Exercise 04

Lecture 128 One Click Forecasting

Lecture 129 Statistical Functions for Inference

Section 30: Excel 2019 Advanced: Connecting to External Data

Lecture 130 Connecting to Other workbooks

Lecture 131 Connecting to Access Databases

Lecture 132 Connecting Web Data Sources

Lecture 133 Get and Transform

Lecture 134 Exercise 05

Section 31: Excel 2019 Advanced: Tables

Lecture 135 Introduction to Tables

Lecture 136 Working with Tables

Lecture 137 Table References

Lecture 138 Table Styles

Lecture 139 Exercise 6

Section 32: Excel 2019 Advanced: Pivot Tables

Lecture 140 Introduction to Pivot Tables

Lecture 141 Working with Pivot Tables

Lecture 142 Filters and Slicers

Lecture 143 Pivot and Charts

Lecture 144 Exercise 07

Section 33: Excel 2019 Advanced: Data Analysis

Lecture 145 What If Analysis

Lecture 146 Scenario Manager

Lecture 147 Goal Seek

Lecture 148 Solver

Lecture 149 Exercise 08

Section 34: Excel 2019 Advanced: Graphs and Charts

Lecture 150 Area Charts

Lecture 151 Surface Charts

Lecture 152 Radar Charts

Lecture 153 Bubble Charts

Lecture 154 Sparklines

Lecture 155 Stock Charts

Lecture 156 Exercise 9

Section 35: Excel 2019 Advanced: Excel Web App

Lecture 157 Web App - Part 1

Lecture 158 Web App - Part 2

Section 36: Excel 2019 Advanced: Course Conclusion

Lecture 159 Close

Section 37: Word 2019: Introduction

Lecture 160 Welcome and Overview

Lecture 161 WATCH ME: Essential Information for a Successful Training Experience

Lecture 162 Course exercise files

Lecture 163 Downloadable Course Transcripts

Lecture 164 Overview of the MS Word Screen

Lecture 165 The Backstage View

Section 38: Word 2019: Getting Started with Word

Lecture 166 Creating a New Blank Document

Lecture 167 Working with Non-Printing Characters and Line Spacing

Lecture 168 Saving a Document

Lecture 169 Opening a Document

Lecture 170 Navigating a Document

Lecture 171 Go To, Find and Replace

Lecture 172 Editing a Document

Lecture 173 Practice Exercise

Section 39: Word 2019: Character Formatting

Lecture 174 AutoCorrect Options

Lecture 175 Selecting Text

Lecture 176 Cut, Copy and Paste

Lecture 177 Character Formatting Options

Lecture 178 Format Painter

Lecture 179 Working with Numbers

Lecture 180 Working with Bullets

Lecture 181 Creating an Outline

Lecture 182 Practice Exercise

Section 40: Word 2019: Paragraph Formatting

Lecture 183 Alignment Options

Lecture 184 Line Spacing Options

Lecture 185 Working with Indents

Lecture 186 Working with Tabs

Lecture 187 Practice Exercise

Section 41: Word 2019: Managing Lists

Lecture 188 Sorting a List

Section 42: Word 2019: Tables

Lecture 189 Working with Tables

Lecture 190 Creating a Table

Lecture 191 Adding Rows and Columns to a Table

Lecture 192 Formatting Table Data

Lecture 193 Borders and Shading

Lecture 194 Sorting in a Table

Lecture 195 Drawing in a Table

Lecture 196 Converting Existing Data to a Table

Lecture 197 Quick Tables

Lecture 198 Using Formulas in Tables

Lecture 199 Practice Exercise

Section 43: Word 2019: Styles

Lecture 200 Working with Styles

Lecture 201 Creating Styles

Lecture 202 Editing Styles

Lecture 203 Practice Exercise

Section 44: Word 2019: Controlling Page Appearance

Lecture 204 Working with Page Breaks

Lecture 205 Working with Columns

Lecture 206 Adding a Watermark

Lecture 207 Headers and Footers

Section 45: Word 2019: Sectioning

Lecture 208 What is Sectioning?

Lecture 209 Sectioning a document

Lecture 210 Odd and Even Sections

Lecture 211 Practice Exercise

Section 46: Word 2019: Graphics

Lecture 212 Inserting Pictures

Lecture 213 Inserting Pictures into Existing Documents

Lecture 214 Picture Options

Lecture 215 Working with Shapes

Lecture 216 Icons and 3D Models

Lecture 217 SmartArt, Charts and Screenshots

Lecture 218 Practice Exercise

Section 47: Word 2019: Envelopes and Labels

Lecture 219 Working with Envelopes

Lecture 220 Working with Labels

Section 48: Word 2019: Mail Merges

Lecture 221 What is Mail Merge?

Lecture 222 Creating a Mail Merge Document - Part 1

Lecture 223 Creating a Mail Merge Document - Part 2

Lecture 224 Merging a Document with an Existing Data Source

Lecture 225 Merging Envelopes and Labels

Lecture 226 Merging a Directory

Lecture 227 Practice Exercise

Section 49: Word 2019: Page Setup Options

Lecture 228 Building Blocks

Lecture 229 Auto Text

Lecture 230 Practice Exercise

Section 50: Word 2019: Indexing and Table of Contents

Lecture 231 Creating an Index

Lecture 232 Creating a Table of Contents

Lecture 233 Practice Exercise

Section 51: Word 2019: Review and Printing

Lecture 234 Using the Thesaurus and Spell Check

Lecture 235 Comments

Lecture 236 Page Setup Options

Lecture 237 Printing

Lecture 238 Practice Exercise

Section 52: Word 2019: Other Word Options

Lecture 239 Word Options

Lecture 240 Protecting a Document

Lecture 241 Macros

Section 53: Word 2019: Wrap Up

Lecture 242 Closing

Section 54: PowerPoint 2019: Course Introduction

Lecture 243 Welcome and Overview

Lecture 244 WATCH ME: Essential Information for a Successful Training Experience

Lecture 245 Course Exercise Files

Lecture 246 Downloadable Course Transcripts

Section 55: PowerPoint 2019: Overview

Lecture 247 Navigate a PowerPoint Presentation

Lecture 248 Overview of the Screen and Views

Lecture 249 Exercise 1

Section 56: PowerPoint 2019: Getting Started

Lecture 250 Presentation Tips and Guidelines

Lecture 251 Creating a New Presentation

Lecture 252 Working with Slides

Lecture 253 Saving a Presentation

Lecture 254 Exercise 02

Section 57: PowerPoint 2019: Text and Bullet Editing Options

Lecture 255 Formatting Text

Lecture 256 Working with Bullets and Numbered Lists

Lecture 257 Exercise 03

Section 58: PowerPoint 2019: Adding Graphics

Lecture 258 Inserting Shapes

Lecture 259 Inserting Graphics

Lecture 260 Inserting Icons and 3D Models

Lecture 261 Inserting Pictures

Lecture 262 Exercise 04

Section 59: PowerPoint 2019: Working with objects

Lecture 263 Selecting Objects

Lecture 264 Editing Objects

Lecture 265 Formatting Objects - Part 1

Lecture 266 Formatting Objects - Part 2

Lecture 267 Arranging Objects

Lecture 268 Grouping Objects

Lecture 269 Exercise 05

Section 60: PowerPoint 2019: Editing pictures

Lecture 270 Picture Options

Lecture 271 Cropping Pictures

Lecture 272 Formatting Pictures

Lecture 273 Things You Can Do with Pictures

Lecture 274 Exercise 06

Section 61: PowerPoint 2019: Working with SmartArt

Lecture 275 Creating SmartArt

Lecture 276 Modifying SmartArt

Lecture 277 Creating a Flowchart using SmartArt

Lecture 278 Exercise 07

Section 62: PowerPoint 2019: Working with Tables

Lecture 279 Creating Tables

Lecture 280 Formatting Tables

Lecture 281 Inserting Tables

Lecture 282 Exercise 08

Section 63: PowerPoint 2019: Working with Charts

Lecture 283 Adding Charts

Lecture 284 Formatting Charts

Lecture 285 Inserting Charts from Microsoft Excel

Lecture 286 Exercise 09

Section 64: PowerPoint 2019: Unlocking the Power of Masters

Lecture 287 Using Master Slides

Lecture 288 Modifying Master Slides

Lecture 289 Creating a New Master Design Template

Lecture 290 Exercise 10

Section 65: PowerPoint 2019: Adding Media

Lecture 291 Adding Video to a Presentation

Lecture 292 Adding Audio to a Presentation

Lecture 293 Exercise 11

Section 66: PowerPoint 2019: Working with Transitions

Lecture 294 Applying Transitions

Lecture 295 Transition Options

Lecture 296 Exercise 12

Section 67: PowerPoint 2019: Animation

Lecture 297 Animating an Object

Lecture 298 Effect Options

Lecture 299 Working with the Animation Pane

Lecture 300 Motion Paths

Lecture 301 Triggers

Lecture 302 Exercise 13

Section 68: PowerPoint 2019: Hyperlinks and Action Buttons

Lecture 303 Working with Action Buttons

Lecture 304 Working with Hyperllinks

Lecture 305 Exercise 14

Section 69: PowerPoint 2019: Slideshow Options

Lecture 306 Onscreen Presentation Options

Lecture 307 Hiding Slides

Lecture 308 Changing the order of slides

Lecture 309 Copying slides

Lecture 310 Slideshow Options

Lecture 311 Exercise 15

Section 70: PowerPoint 2019: Preparing a presentation for delivery

Lecture 312 Rehearse Timings

Lecture 313 Recording a Presentation

Lecture 314 Slide Show Settings

Lecture 315 Creating a Custom Slide Show

Lecture 316 Exercise 16

Section 71: PowerPoint 2019: Exploring the Backstage Area

Lecture 317 Exporting options

Lecture 318 The Backstage Area

Lecture 319 Printing a Presentation

Lecture 320 Exercise 17

Section 72: PowerPoint 2019: Course Close

Lecture 321 Conclusion

Section 73: Access 2019 Beginners: Introduction

Lecture 322 Introduction to Access 2019

Lecture 323 WATCH ME: Essential Information for a Successful Training Experience

Lecture 324 Course Exercise Files

Lecture 325 Course Demo Files

Lecture 326 Downloadable Course Transcripts

Lecture 327 Acquiring Access 2019

Lecture 328 Structure of the Course

Section 74: Access 2019 Beginners: Getting Started with Access 2019

Lecture 329 Using Database Templates

Lecture 330 Creating, Saving and Opening Databases

Lecture 331 The Access Workspace and Backstage

Lecture 332 Online Help and Tell Me What You Want To Do

Section 75: Access 2019 Beginners: The Ribbon and Toolbars

Lecture 333 Working with the Ribbon

Lecture 334 The Quick Access Toolbar

Lecture 335 Contextual Menus

Lecture 336 The Status Bar

Section 76: Access 2019 Beginners: Keyboard Shortcuts and Key Tip

Lecture 337 Keyboard Shortcuts

Lecture 338 Key Tips

Section 77: Access 2019 Beginners: Access Options

Lecture 339 Exploring Access Options

Section 78: Access 2019 Beginners: Tables

Lecture 340 Creating a Table and Fields

Lecture 341 Indexed Field

Lecture 342 Lookup Wizard

Lecture 343 Numeric Fields

Lecture 344 Practice Exercise 01

Section 79: Access 2019 Beginners: Importing Data

Lecture 345 Importing Data from Excel

Lecture 346 Practice Exercise 02

Section 80: Access 2019 Beginners: Backup, Restore and Repair

Lecture 347 Backing up your Database

Lecture 348 Compact and Repair

Section 81: Access 2019 Beginners: Datasheet View

Lecture 349 Design in the Datasheet View

Lecture 350 Sorting and Filtering in Datasheet View

Lecture 351 Entering and Modifying Data in Datasheet View

Section 82: Access 2019 Beginners: Relationships

Lecture 352 Creating a Link Table

Lecture 353 Setting up Relationships

Lecture 354 Exercise 03

Section 83: Access 2019 Beginners: Forms

Lecture 355 Creating a Form

Lecture 356 Modifying a Form

Lecture 357 Practice Exercise 04

Lecture 358 Forms in Layout View

Lecture 359 Forms in Design View

Lecture 360 Form Design

Lecture 361 Practice Exercise 05

Section 84: Access 2019 Beginners: Subforms

Lecture 362 Setting Up Subforms - Part 1

Lecture 363 Setting Up Subforms - Part 2

Lecture 364 Setting Up Subforms - Part 3

Lecture 365 Practice Exercise 06

Section 85: Access 2019 Beginners: Queries

Lecture 366 Creating a Query

Lecture 367 Joins

Lecture 368 Query Wizard

Lecture 369 Practice Exercise 07

Section 86: Access 2019 Beginners: Expressions

Lecture 370 Setting Up Validations

Lecture 371 Calculation using Expressions

Section 87: Access 2019 Beginners: Reports

Lecture 372 Basic Reports

Lecture 373 Report Design

Lecture 374 Complex Reports

Lecture 375 Practice Exercise 08

Section 88: Access 2019 Beginners: Printing

Lecture 376 Printing and Print Properties

Section 89: Access 2019 Beginners: More Data Types

Lecture 377 Yes/No, OLE Objects and Hyperlink Data Types

Section 90: Access 2019 Beginners: More About Forms

Lecture 378 Form Controls

Lecture 379 Form Themes

Lecture 380 Navigation Forms

Section 91: Access 2019 Beginners: Exporting

Lecture 381 Exporting an Access Database

Section 92: Access 2019 Beginners: Application Parts

Lecture 382 Adding Application Parts to a Database

Section 93: Access 2019 Beginners: More Access Options

Lecture 383 Additional Access 2019 Options

Section 94: Access 2019 Beginners: Info Tab

Lecture 384 Edit Database Properties and Encrypt with Password

Section 95: Access 2019 Beginners: Course Close

Lecture 385 Course Close

Section 96: Access 2019 Advanced: Introduction

Lecture 386 Course Overview and Content

Lecture 387 WATCH ME: Essential Information for a Successful Training Experience

Lecture 388 Course Exercise Files

Lecture 389 Course Demo Files

Lecture 390 Downloadable Course Transcripts

Section 97: Access 2019 Advanced: Primary Keys and Indexes

Lecture 391 Primary Keys and Indexing Rules and Guidelines

Lecture 392 More About Indexes

Section 98: Access 2019 Advanced: Using Datasheet View

Lecture 393 Setting-up Northwind Database

Lecture 394 Working in a Datasheet View

Lecture 395 Customizing Datasheet View and Advanced Sorting and Filtering

Lecture 396 Subdatasheets

Lecture 397 Exercise 01

Section 99: Access 2019 Advanced: Linking to Other Access Databases

Lecture 398 Linking Two Tables to Other Access Databases

Section 100: Access 2019 Advanced: Using ODBC and SQL Server

Lecture 399 Acquiring and Installing SQL Server Express

Lecture 400 Setting Up SQL Server Database

Lecture 401 Exercise 02

Section 101: Access 2019 Advanced: Splitting an Access Database

Lecture 402 Splitting an Access Database into Front-end and Back-end

Lecture 403 Converting Shared Table into Local Table; Moving Back-end Database

Lecture 404 Exercise 03

Lecture 405 Addressing Multi-user Issues when Sharing Data

Section 102: Access 2019 Aadvanced: Macros

Lecture 406 Basics of Macros

Lecture 407 Macros on Events; AutoExec

Lecture 408 More About AutoExec; Bypassing AutoExec

Lecture 409 Macro Security Settings

Lecture 410 Exercise 04

Section 103: Access 2019 Advanced: The Ribbon

Lecture 411 Customizing the Ribbon and Quick Access Tool

Section 104: Access 2019 Advanced: Visual Basic for Applications

Lecture 412 Convert Macros to VBA; VBA Editor and Property Windows

Lecture 413 VBA Modules; Running Code and Error Handling

Lecture 414 Creating Modules; Subs, Functions, Intellisense and Variables

Lecture 415 Scope, Variable Naming and Strings

Lecture 416 Standard Functions; Logical, Case and Loop Statements

Section 105: Access 2019 Advanced: Access Events Model

Lecture 417 Adding Events to Assets Database

Lecture 418 Exercise 05

Lecture 419 Common Events; Form and Report Events

Lecture 420 Switchboard and Navigation Form; Error Handling

Lecture 421 Exercise 06

Section 106: Access 2019 Advanced: Forms

Lecture 422 Formatting Bound and Control Form

Lecture 423 Split Forms; Macro Error Handling

Lecture 424 Creating Form with Tab

Lecture 425 Go To Combo Box and Its Properties

Lecture 426 Exercise 07

Section 107: Access 2019 Advanced: Advanced Use of Queries

Lecture 427 Basics of Queries

Lecture 428 Syntax of SQL Statements

Lecture 429 Use of Multiple Where Criteria & Select Statements Function

Lecture 430 Exercise 08

Lecture 431 Action Queries - Part 1

Lecture 432 Action Queries - Part 2

Section 108: Access 2019 Advanced: Packaging You Application

Lecture 433 Steps in Packaging Access Application

Lecture 434 Exercise 9

Section 109: Conclusion

Lecture 435 Course Close

Section 110: Outlook 2019: Introduction

Lecture 436 An Overview of Outlook 2019

Lecture 437 READ ME: Essential Information for a Successful Training Experience

Lecture 438 Downloadable Course Transcripts

Lecture 439 Outlook 2019 vs Outlook Online in Office 365

Lecture 440 What to Expect from this Course

Lecture 441 Getting Help with Outlook 2019

Lecture 442 Keyboard Shortcuts

Section 111: Setting Up Outlook

Lecture 443 Navigating the Outlook Interface

Lecture 444 The Ribbons and the Quick Access Toolbar

Lecture 445 Adding an Email Account

Lecture 446 Practice Exercise 01

Section 112: Sending and Receiving Mail

Lecture 447 Sending and Receiving Mail

Lecture 448 Focused Inbox

Lecture 449 Customizing the Inbox

Lecture 450 Saving Attachments

Lecture 451 Customizing Mail Views

Lecture 452 Practice Exercise 02

Section 113: Searching Mail

Lecture 453 Searching Mail

Lecture 454 Creating Search Folders

Lecture 455 Practice Exercise 03

Section 114: Organizing and Managing Mail

Lecture 456 Ignoring Conversations

Lecture 457 Deleting, Archiving and Restoring Mail

Lecture 458 Cleaning Up Conversations

Lecture 459 Using Follow Up Flags and Categories

Lecture 460 Organizing Mail with Folders and Subfolders

Lecture 461 Using Quick Steps to Process Mail

Lecture 462 Working with Conditional Formating and Mail

Lecture 463 Auto-Process Mail using Rules

Lecture 464 Managing Junk Mail

Lecture 465 Practice Exercise 04

Section 115: Creating and Sending Mail

Lecture 466 Creating a New Mail Message

Lecture 467 Attaching Files, Photos, Graphics and Other Items

Lecture 468 Directing Mail with @mentions

Lecture 469 Recalling a Message

Lecture 470 Making decisions with Voting Buttons

Lecture 471 Adding an Email Signature

Lecture 472 Delivery Options

Lecture 473 Sending Automatic Replies

Lecture 474 Navigating using Hyperlinks and Bookmarks

Lecture 475 Practice Exercise 05

Section 116: Working with People

Lecture 476 Adding a New Contact

Lecture 477 Utilizing the Contact Card

Lecture 478 Creating a Contact Group

Lecture 479 Managing Contacts using Folders

Lecture 480 Practice Exercise 06

Section 117: Working with the Calendar

Lecture 481 Overview of the Calendar and Views

Lecture 482 Customizing the Look and Feel

Lecture 483 Creating an Appointment or All Day Event

Lecture 484 Creating a Meeting and Inviting Others

Lecture 485 Responding to Meeting Invites

Lecture 486 Sharing Calendars and Delegating Access

Lecture 487 Practice Exercise 07

Section 118: Tasks and Notes

Lecture 488 Creating a New Task

Lecture 489 Assigning and Completing Tasks

Lecture 490 Creating Notes

Lecture 491 Working with OneNote

Lecture 492 Practice Exercise 08

Section 119: The Backstage Options

Lecture 493 Opening and Exporting Data

Lecture 494 Printing

Lecture 495 Customizing Outlook Options

Section 120: Conclusion

Lecture 496 Course Close

Section 121: Congratulations!

Lecture 497 BONUS Lecture

Section 122: Microsoft Teams: Introduction

Lecture 498 What is Microsoft Teams and why is it useful?

Lecture 499 READ ME: Essential Information for a Successful Training Experience

Lecture 500 Downloadable Course Transcripts

Lecture 501 What to Expect from this Course

Lecture 502 How to access/download Teams

Lecture 503 Overview of the Teams Dashboard

Lecture 504 Getting Help with Microsoft Teams

Section 123: Creating Teams and Starting Conversations

Lecture 505 Create a Team and Add Internal and External Team Members

Lecture 506 Join an Existing Team

Lecture 507 Manage teams and members

Lecture 508 Create and Manage Channels

Lecture 509 Post and Receive Messages

Lecture 510 Target messages using @mentions

Lecture 511 Editing and Deleting Messages

Lecture 512 Bookmark and Like Messages

Lecture 513 Add images, emojis aand gifs to messages

Lecture 514 Formatting Messages

Lecture 515 Make a Announcement

Lecture 516 Using Tags

Lecture 517 Attaching Files and Images

Lecture 518 Send a Private Message

Lecture 519 Add Messaging Extensions

Section 124: Video and Audio Meetings

Lecture 520 Video and Audio Calls on Demand

Lecture 521 Sharing Files

Lecture 522 Schedule a Meeting

Lecture 523 Schedule a Live Event

Lecture 524 Record a Video Meeting or Call

Lecture 525 Notes

Section 125: Additional Features

Lecture 526 Use the Wiki tab to share information

Lecture 527 Using apps, bots and connectors

Lecture 528 Customizing Channel Tabs

Section 126: Searching

Lecture 529 Use Search to find specific messages, files or people

Lecture 530 Using Quick Commands

Section 127: Settings

Lecture 531 Adjust user settings

Lecture 532 Explore the administration settings

Section 128: Mobile App

Lecture 533 Working with the Teams Mobile App

Section 129: Teams Updates (2021)

Lecture 534 Out of Office

Lecture 535 Notification Settings

Lecture 536 Bypass the Lobby (Invitees)

Lecture 537 Control Attendees Mic Settings

Lecture 538 Share to Teams from Outlook

Lecture 539 Meet Now from the Calendar

Lecture 540 Recap of Meeting

Lecture 541 Use Grid View to share PowerPoint Content

Lecture 542 View Activity History

Lecture 543 Feel Connected with Together Mode

Lecture 544 Apply Background Effects

Lecture 545 React to Conversations with Emojis

Lecture 546 Publish a Company-wide Task list

Lecture 547 Approvals

Lecture 548 Breakout Rooms

Section 130: MS Teams: Conclusion

Lecture 549 Course Close

Section 131: An Introduction to OneNote

Lecture 550 What to Expect from this Course

Lecture 551 READ ME: Essential Information for a Successful Training Experience

Lecture 552 Downloadable Course Transcripts

Lecture 553 OneNote Versions

Lecture 554 Working with Keyboard Shortcuts

Lecture 555 Customizing the Quick Access Toolbar

Lecture 556 Using Touch Mode

Section 132: OneNote: Getting Started

Lecture 557 Opening a OneNote notebook and Touring the Interface

Lecture 558 Creating a OneNote Notebook

Lecture 559 Changing Notebook Properties and Closing

Lecture 560 Deleting a Notebook Stored in OneDrive

Lecture 561 Creating and Managing Locally Stored Notebook

Lecture 562 Creating, Moving and Deleting Sections

Lecture 563 Creating Section Groups

Lecture 564 Working with Pages and Subpages

Lecture 565 WINDOWS 10: Getting Started with OneNote

Section 133: OneNote: Adding Content

Lecture 566 Creating a Note on a Page

Lecture 567 Sending Content to OneNote

Lecture 568 Using the OneNote Clipper

Lecture 569 Using the Screen Clipper

Lecture 570 Adding Pictures and Online Pictures

Lecture 571 Embedding Online Video

Lecture 572 Adding Files

Lecture 573 Recording Audio and Video

Lecture 574 Inserting Links

Lecture 575 Inserting Equations and Symbols

Lecture 576 Copying and Pasting Content

Lecture 577 WINDOWS 10: Adding Content

Section 134: OneNote: Formatting Notes

Lecture 578 Formatting Text

Lecture 579 Using the Format Painter

Lecture 580 Using Styles

Lecture 581 Organize Content with a Table

Lecture 582 Creating a Todo List

Lecture 583 Checking Spelling

Lecture 584 WINDOWS 10: Formatting Notes

Section 135: OneNote: Organizing Content

Lecture 585 Searching a Notebook

Lecture 586 Tagging Notes

Lecture 587 Organizing the Interface

Lecture 588 Linking Notes

Lecture 589 WINDOWS 10: Organizing Content

Section 136: OneNote: Formatting Pages

Lecture 590 Page Setup Options

Lecture 591 Changing the Page Color and Background

Lecture 592 Customizing Fonts, Themes and the Interface

Lecture 593 Setting Paper Size

Lecture 594 WINDOWS 10: Formatting Pages

Section 137: OneNote: Working with Templates

Lecture 595 Applying a OneNote Template to a Page

Lecture 596 Creating Your Own Template

Lecture 597 WINDOWS 10: Working with Templates

Section 138: OneNote: Using Drawing Tools

Lecture 598 Working in Pen Mode

Lecture 599 Drawing Shapes with Touch

Lecture 600 Converting Handwriting to Typed Text

Lecture 601 WINDOWS 10: Using Drawing Tools

Section 139: OneNote: Interacting with Outlook

Lecture 602 Working with Outlook Tasks

Lecture 603 Outlook Meetings and Meeting Notes

Lecture 604 Sending Page Information by Email

Lecture 605 Windows 10: Interacting with Outlook

Section 140: OneNote: Sharing a Notebook

Lecture 606 Saving to OneDrive

Lecture 607 Inviting Others to a Notebook

Lecture 608 Converting Notebooks to Other Formats

Lecture 609 Exporting OneNote Content

Lecture 610 Synching Notebooks

Lecture 611 WINDOWS 10: Sharing a Notebook

Section 141: OneNote: Collaborating on a Notebook

Lecture 612 Author Indicators

Lecture 613 Page Versions

Lecture 614 The Notebook Recycle Bin

Lecture 615 WINDOWS 10: Collaborating on a Notebook

Section 142: OneNote: Setting OneNote Options

Lecture 616 Customizing OneNote Options

Lecture 617 Password Protection

Lecture 618 Setting Backup Options

Lecture 619 WINDOWS 10: Setting OneNote Options

Section 143: Other Versions of OneNote

Lecture 620 Using OneNote Online

Lecture 621 Working with OneNote Mobile app

Section 144: OneNote: Course Close

Lecture 622 Course Close

Section 145: Extras

Lecture 623 EXTRA LESSON: Designing Better Spreadsheets Webinar Recording

Lecture 624 EXTRA LESSON: Data Cleaning in Excel Webinar Recording

Lecture 625 EXTRA LESSON: Top Ten Excel Functions You HAVE to Know Webinar Recording

Lecture 626 EXTRA LESSON: Creating Engaging PowerPoint Presentations Webinar Recording

Lecture 627 EXTRA RESOURCE: The Most Frequently Used PowerPoint Shortcuts - Infographic

Lecture 628 EXTRA RESOURCE: The Most Frequently Used Excel Shortcuts - Infographic

Lecture 629 EXTRA RESOURCE: The Most Frequently Used Access Shortcuts - Infographic

Lecture 630 EXTRA RESOURCE: The Most Frequently Used Word Shortcuts - Infographic

Section 146: Bonuses

Lecture 631 Ten Excel Tips and Tricks - Part 1

Lecture 632 Ten Excel Tips and Tricks - Part 2

Lecture 633 Ten Excel Tips and Tricks - Part 3

Anyone new to Microsoft Office or upgrading from a previous version,Anyone looking to improve their productivity by mastering MS Office