Ms Office; Excel, Word, Access & Powerpoint 2019 - Beginners

Learn the essentials of Microsoft Office in this 4-course bundle for Office 365 or Office 2019 users.

What you'll learn
Learn the essential Microsoft Office Skills in this four-course bundle: Excel, Word, PowerPoint and Access
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
Requirements
Excel, Word, PowerPoint and Access installed on your machine. Preferably Office 2019 or Office 365
Description
**This course includes practice exercises and LIFETIME access**Learn Excel, PowerPoint, Access and Word 2019 with this tremendous value 4-course bundle from Office experts Simon Sez IT.Microsoft Office remains the go-to tool for the modern worker, yet so many workers don’t utilize its full potential.We’re here to make sure you aren’t one of those people.In this Microsoft Office Beginners bundle, we make the four essential MS Office programs (Excel, Word, PowerPoint and Access) simple to understand. This bundle includes 4, full-length courses to help you achieve your goals.What's included?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 basicsPowerPoint 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 presentationWord 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 AccessWhere 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 Access***Exercise and demo files included***This bundle includes:29+ hours of video tutorials300+ individual video lecturesExercise files to practice what you learnedCertificate of completionHere’s what our students are saying…"Highly recommended this course to everyone.This is the best course i ever had. Good English that we can understand. Suberb….. I understood every lesson in the course."- Yunesh Garusinghe"I really love the way you describe all the things. the language of the instructions were really simple. I really gain a new knowledge and understanding from this course. I am really looking forward to apply this all in my work. Thank you."- Cavin Macwan"Nervous at first, had no idea how to do or work it . The instructor made it easy to follow along!"- Coreen TeohDid you know?Simon Sez IT teaches all sorts of software, including:- Microsoft Excel- Microsoft PowerPoint- Microsoft Word- Microsoft Project- Microsoft Outlook- QuickBooks- Photoshop Elements- Web Development Languages- And so much more!

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 Transcripts

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 Working with the Save and Save As Commands

Lecture 43 Adding Deleting and Renaming Sheets

Lecture 44 Additional Sheet Tab Options

Lecture 45 3 Dimensional Formulas

Lecture 46 Module 9 - Practice Exercise

Section 10: Excel 2019 Beginner: Formatting Worksheets

Lecture 47 Formatting Cells Part 1

Lecture 48 Formatting Cells Part 2

Lecture 49 Formatting Numbers

Lecture 50 Borders and Shading

Lecture 51 Format as Table

Lecture 52 Using Styles

Lecture 53 Using Format Painter

Lecture 54 Protecting Sheets

Lecture 55 Fill Handle and Custom Lists

Lecture 56 Module 10 - Practice Exercise

Section 11: Excel 2019 Beginner: Charts

Lecture 57 Creating Charts

Lecture 58 Types of Charts

Lecture 59 Editing Charts Part 1

Lecture 60 Editing Charts Part 2

Lecture 61 Using Graphics to Enhance Charts

Lecture 62 Linking Chart Titles

Lecture 63 Module 11 - Practice Exercise

Section 12: Excel 2019 Beginner: Working with Names

Lecture 64 Creating Range Names

Lecture 65 Managing Names

Lecture 66 Using Names in Formulas

Lecture 67 Module 12 - Practice Exercise

Section 13: Excel 2019 Beginner: Sorting and Filtering

Lecture 68 Remove Duplicates

Lecture 69 Sort Data

Lecture 70 Filter Data

Lecture 71 Advanced Filters

Lecture 72 Module 13 - Practice Exercise

Section 14: Excel 2019 Beginner: Outlining and Subtotaling

Lecture 73 Creating an Outline

Lecture 74 Subtotals

Lecture 75 Module 14 - Practice Exercise

Section 15: Excel 2019 Beginner: Working with Views

Lecture 76 Arranging Files

Lecture 77 New Window Option

Lecture 78 Custom Views

Lecture 79 Module 15 - Practice Exercise

Section 16: Excel 2019 Beginner: Linking Files

Lecture 80 Creating Formulas Between File

Lecture 81 Working with Links

Lecture 82 Consolidating Data

Lecture 83 Module 16 - Practice Exercise

Section 17: Excel 2019 Beginner: Advanced Formula Creation

Lecture 84 If Statements

Lecture 85 VLookups

Lecture 86 Data Validation

Lecture 87 Formula Auditing

Lecture 88 Module 17 - Practice Exercise

Section 18: Excel 2019 Beginner: Pivot Tables

Lecture 89 Pivot Tables

Lecture 90 Pivot Charts

Lecture 91 Module 18 - Practice Exercise

Section 19: Excel 2019 Beginner: Additional Excel Features

Lecture 92 Slicers

Lecture 93 Goal Seeker

Lecture 94 Text to Columns

Lecture 95 Watch Window

Lecture 96 Customizing Ribbons and Tabs

Lecture 97 Module 19 - Practice Exercise

Section 20: Excel 2019 Beginner: Shortcuts

Lecture 98 Excel Shortcuts Every User Should Know

Section 21: Excel 2019 Beginner: Closing

Lecture 99 Closing Video

Section 22: Word 2019: Introduction

Lecture 100 Welcome and Overview

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

Lecture 102 Course Exercise Files

Lecture 103 Downloadable Course Transcripts

Lecture 104 Overview of the MS Word Screen

Lecture 105 The Backstage View

Section 23: Word 2019: Getting Started with Word

Lecture 106 Creating a New Blank Document

Lecture 107 Working with Non-Printing Characters and Line Spacing

Lecture 108 Saving a Document

Lecture 109 Opening a Document

Lecture 110 Navigating a Document

Lecture 111 Go To, Find and Replace

Lecture 112 Editing a Document

Lecture 113 Practice Exercise

Section 24: Character Formatting

Lecture 114 AutoCorrect Options

Lecture 115 Selecting Text

Lecture 116 Cut, Copy and Paste

Lecture 117 Character Formatting Options

Lecture 118 Format Painter

Lecture 119 Working with Numbers

Lecture 120 Working with Bullets

Lecture 121 Creating an Outline

Lecture 122 Practice Exercise

Section 25: Word 2019: Paragraph Formatting

Lecture 123 Alignment Options

Lecture 124 Line Spacing Options

Lecture 125 Working with Indents

Lecture 126 Working with Tabs

Lecture 127 Practice Exercise

Section 26: Word 2019: Managing Lists

Lecture 128 Sorting a List

Section 27: Word 2019: Tables

Lecture 129 Working with Tables

Lecture 130 Creating a Table

Lecture 131 Adding Rows and Columns to a Table

Lecture 132 Formatting Table Data

Lecture 133 Borders and Shading

Lecture 134 Sorting in a Table

Lecture 135 Drawing in a Table

Lecture 136 Converting Existing Data to a Table

Lecture 137 Quick Tables

Lecture 138 Using Formulas in Tables

Lecture 139 Practice Exercise

Section 28: Word 2019: Styles

Lecture 140 Working with Styles

Lecture 141 Creating Styles

Lecture 142 Editing Styles

Lecture 143 Practice Exercise

Section 29: Word 2019: Controlling Page Appearance

Lecture 144 Working with Page Breaks

Lecture 145 Working with Columns

Lecture 146 Adding a Watermark

Lecture 147 Headers and Footers

Section 30: Word 2019: Sectioning

Lecture 148 What is Sectioning?

Lecture 149 Sectioning a document

Lecture 150 Odd and Even Sections

Lecture 151 Practice Exercise

Section 31: Word 2019: Graphics

Lecture 152 Inserting Pictures

Lecture 153 Inserting Pictures into Existing Documents

Lecture 154 Picture Options

Lecture 155 Working with Shapes

Lecture 156 Icons and 3D Models

Lecture 157 SmartArt, Charts and Screenshots

Lecture 158 Practice Exercise

Section 32: Word 2019: Envelopes and Labels

Lecture 159 Working with Envelopes

Lecture 160 Working with Labels

Section 33: Word 2019: Mail Merges

Lecture 161 What is Mail Merge?

Lecture 162 Creating a Mail Merge Document - Part 1

Lecture 163 Creating a Mail Merge Document - Part 2

Lecture 164 Merging a Document with an Existing Data Source

Lecture 165 Merging Envelopes and Labels

Lecture 166 Merging a Directory

Lecture 167 Practice Exercise

Section 34: Word 2019: Page Setup Options

Lecture 168 Building Blocks

Lecture 169 Auto Text

Lecture 170 Practice Exercise

Section 35: Word 2019: Indexing and Table of Contents

Lecture 171 Creating an Index

Lecture 172 Creating a Table of Contents

Lecture 173 Practice Exercise

Section 36: Word 2019: Review and Printing

Lecture 174 Using the Thesaurus and Spell Check

Lecture 175 Comments

Lecture 176 Page Setup Options

Lecture 177 Printing

Lecture 178 Practice Exercise

Section 37: Word 2019: Other Word Options

Lecture 179 Word Options

Lecture 180 Protecting a Document

Lecture 181 Macros

Section 38: Word 2019: Wrap Up

Lecture 182 Closing

Section 39: PowerPoint 2019: Course Introduction

Lecture 183 Welcome and Overview

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

Lecture 185 Course Exercise Files

Lecture 186 Downloadable Course Transcripts

Section 40: PowerPoint 2019: Overview

Lecture 187 Navigate a PowerPoint Presentation

Lecture 188 Overview of the Screen and Views

Lecture 189 Exercise 1

Section 41: PowerPoint 2019: Getting Started

Lecture 190 Presentation Tips and Guidelines

Lecture 191 Creating a New Presentation

Lecture 192 Working with Slides

Lecture 193 Saving a Presentation

Lecture 194 Exercise 02

Section 42: PowerPoint 2019: Text and Bullet Editing Options

Lecture 195 Formatting Text

Lecture 196 Working with Bullets and Numbered Lists

Lecture 197 Exercise 03

Section 43: PowerPoint 2019: Adding Graphics

Lecture 198 Inserting Shapes

Lecture 199 Inserting Graphics

Lecture 200 Inserting Icons and 3D Models

Lecture 201 Inserting Pictures

Lecture 202 Exercise 04

Section 44: PowerPoint 2019: Working with objects

Lecture 203 Selecting Objects

Lecture 204 Editing Objects

Lecture 205 Formatting Objects - Part 1

Lecture 206 Formatting Objects - Part 2

Lecture 207 Arranging Objects

Lecture 208 Grouping Objects

Lecture 209 Exercise 05

Section 45: PowerPoint 2019: Editing pictures

Lecture 210 Picture Options

Lecture 211 Cropping Pictures

Lecture 212 Formatting Pictures

Lecture 213 Things You Can Do with Pictures

Lecture 214 Exercise 06

Section 46: PowerPoint 2019: Working with SmartArt

Lecture 215 Creating SmartArt

Lecture 216 Modifying SmartArt

Lecture 217 Creating a Flowchart using SmartArt

Lecture 218 Exercise 07

Section 47: PowerPoint 2019: Working with Tables

Lecture 219 Creating Tables

Lecture 220 Formatting Tables

Lecture 221 Inserting Tables

Lecture 222 Exercise 08

Section 48: PowerPoint 2019: Working with Charts

Lecture 223 Adding Charts

Lecture 224 Formatting Charts

Lecture 225 Inserting Charts from Microsoft Excel

Lecture 226 Exercise 09

Section 49: PowerPoint 2019: Unlocking the Power of Masters

Lecture 227 Using Master Slides

Lecture 228 Modifying Master Slides

Lecture 229 Creating a New Master Design Template

Lecture 230 Exercise 10

Section 50: PowerPoint 2019: Adding Media

Lecture 231 Adding Video to a Presentation

Lecture 232 Adding Audio to a Presentation

Lecture 233 Exercise 11

Section 51: PowerPoint 2019: Working with Transitions

Lecture 234 Applying Transitions

Lecture 235 Transition Options

Lecture 236 Exercise 12

Section 52: PowerPoint 2019: Animation

Lecture 237 Animating an Object

Lecture 238 Effect Options

Lecture 239 Working with the Animation Pane

Lecture 240 Motion Paths

Lecture 241 Triggers

Lecture 242 Exercise 13

Section 53: PowerPoint 2019: Hyperlinks and Action Buttons

Lecture 243 Working with Action Buttons

Lecture 244 Working with Hyperllinks

Lecture 245 Exercise 14

Section 54: PowerPoint 2019: Slideshow Options

Lecture 246 Onscreen Presentation Options

Lecture 247 Hiding Slides

Lecture 248 Changing the order of slides

Lecture 249 Copying slides

Lecture 250 Slideshow Options

Lecture 251 Exercise 15

Section 55: PowerPoint 2019: Preparing a presentation for delivery

Lecture 252 Rehearse Timings

Lecture 253 Recording a Presentation

Lecture 254 Slide Show Settings

Lecture 255 Creating a Custom Slide Show

Lecture 256 Exercise 16

Section 56: PowerPoint 2019: Exploring the Backstage Area

Lecture 257 Exporting options

Lecture 258 The Backstage Area

Lecture 259 Printing a Presentation

Lecture 260 Exercise 17

Section 57: PowerPoint 2019: Course Close

Lecture 261 Conclusion

Section 58: Access 2019 Beginners: Introduction

Lecture 262 Introduction to Access 2019

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

Lecture 264 Course Exercise Files

Lecture 265 Course Demo Files

Lecture 266 Downloadable Course Transcripts

Lecture 267 Acquiring Access 2019

Lecture 268 Structure of the Course

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

Lecture 269 Using Database Templates

Lecture 270 Creating, Saving and Opening Databases

Lecture 271 The Access Workspace and Backstage

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

Section 60: Access 2019 Beginners: The Ribbon and Toolbars

Lecture 273 Working with the Ribbon

Lecture 274 The Quick Access Toolbar

Lecture 275 Contextual Menus

Lecture 276 The Status Bar

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

Lecture 277 Keyboard Shortcuts

Lecture 278 Key Tips

Section 62: Access 2019 Beginners: Access Options

Lecture 279 Exploring Access Options

Section 63: Access 2019 Beginners: Tables

Lecture 280 Creating a Table and Fields

Lecture 281 Indexed Field

Lecture 282 Lookup Wizard

Lecture 283 Numeric Fields

Lecture 284 Practice Exercise 01

Section 64: Access 2019 Beginners: Importing Data

Lecture 285 Importing Data from Excel

Lecture 286 Practice Exercise 02

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

Lecture 287 Backing up your Database

Lecture 288 Compact and Repair

Section 66: Access 2019 Beginners: Datasheet View

Lecture 289 Design in the Datasheet View

Lecture 290 Sorting and Filtering in Datasheet View

Lecture 291 Entering and Modifying Data in Datasheet View

Section 67: Access 2019 Beginners: Relationships

Lecture 292 Creating a Link Table

Lecture 293 Setting up Relationships

Lecture 294 Practice Exercise 03

Section 68: Access 2019 Beginners: Forms

Lecture 295 Creating a Form

Lecture 296 Modifying a Form

Lecture 297 Practice Exercise 04

Lecture 298 Forms in Layout View

Lecture 299 Forms in Design View

Lecture 300 Form Design

Lecture 301 Practice Exercise 05

Section 69: Access 2019 Beginners: Subforms

Lecture 302 Setting Up Subforms - Part 1

Lecture 303 Setting Up Subforms - Part 2

Lecture 304 Setting Up Subforms - Part 3

Lecture 305 Practice Exercise 06

Section 70: Access 2019 Beginners: Queries

Lecture 306 Creating a Query

Lecture 307 Joins

Lecture 308 Query Wizard

Lecture 309 Practice Exercise 07

Section 71: Access 2019 Beginners: Expressions

Lecture 310 Setting Up Validations

Lecture 311 Calculation using Expressions

Section 72: Access 2019 Beginners: Reports

Lecture 312 Basic Reports

Lecture 313 Report Design

Lecture 314 Complex Reports

Lecture 315 Practice Exercise 08

Section 73: Access 2019 Beginners: Printing

Lecture 316 Printing and Print Properties

Section 74: Access 2019 Beginners: More Data Types

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

Section 75: Access 2019 Beginners: More About Forms

Lecture 318 Form Controls

Lecture 319 Form Themes

Lecture 320 Navigation Forms

Section 76: Access 2019 Beginners: Exporting

Lecture 321 Exporting an Access Database

Section 77: Access 2019 Beginners: Application Parts

Lecture 322 Adding Application Parts to a Database

Section 78: Access 2019 Beginners: More Access Options

Lecture 323 Additional Access 2019 Options

Section 79: Access 2019 Beginners: Info Tab

Lecture 324 Edit Database Properties and Encrypt with Password

Section 80: Access 2019 Beginners: Course Close

Lecture 325 Course Close

Section 81: Extras

Lecture 326 EXTRA LESSON: Designing Better Spreadsheets Webinar Recording

Lecture 327 EXTRA LESSON: Data Cleaning in Excel Webinar Recording

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

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

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

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

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

Section 82: Congratulations!

Lecture 333 BONUS Lecture

Anyone new to Microsoft Office or upgrading from a previous version