Microsoft Office; Excel, Word & Powerpoint 2019 - Beginners

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

What you'll learn
Learn the essential Microsoft Office Skills in this three-course bundle: Excel, Word and PowerPoint
Discover new and improved features in Excel 2019.
Complete data entry, cell formatting, working with multiple worksheets and the “Ribbon” interface.
Discover how to format dates and numbers in Excel.
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
Discover how to create stunning charts and graphs in Excel
Learn practical methods to sort and filter your data
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 present information in a non-text format
Wow your audience by adding animations, audio and video
Discover practical tips to present your 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
How to controlling page appearance 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
Requirements
Excel, Word, and PowerPoint installed on your machine. Preferably Office 2019 or Office 365
Description
**This course includes practice exercises and LIFETIME access**Massive value bundle - 3 full courses in one! Learn Excel, PowerPoint and Word 2019 with Microsoft Office experts Simon Sez IT.This mega Microsoft Office bundle is perfect if you're looking to finally get to grips with Excel, PowerPoint and Word. Each course goes into depth on how to get the most from each program and will  help you become an intermediate user.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 Word***Exercise and demo files included***This bundle includes:21+ hours of video tutorials250+ individual video lecturesExercise files to practice what you learnedCertificate of completionHere’s what our students are saying…“I've been familiar with this program for years, but am getting more comfortable and learning more than I could have imagined this early in the course.”- Aimee Hutcherson“I'm learning alot of new material that I had no idea existed. So yes , I'm very much liking this course. Will continue to practice all the new skills I've learned thus far."- Eralda Chung-Colon“I enjoy learning all of the new things in this course so far and I really appreciate how thorough the instructor is at explaining everything. Great Course!!"- Jennifer LambertDid 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 Adding Deleting and Renaming Sheets

Lecture 43 Additional Sheet Tab Options

Lecture 44 3 Dimensional Formulas

Section 10: Excel 2019 Beginner: Formatting Worksheets

Lecture 45 Formatting Cells Part 1

Lecture 46 Formatting Cells Part 2

Lecture 47 Formatting Numbers

Lecture 48 Borders and Shading

Lecture 49 Format as Table

Lecture 50 Using Styles

Lecture 51 Using Format Painter

Lecture 52 Protecting Sheets

Lecture 53 Fill Handle and Custom Lists

Lecture 54 Module 10 - Practice Exercise

Section 11: Excel 2019 Beginner: Charts

Lecture 55 Creating Charts

Lecture 56 Types of Charts

Lecture 57 Editing Charts Part 1

Lecture 58 Editing Charts Part 2

Lecture 59 Using Graphics to Enhance Charts

Lecture 60 Linking Chart Titles

Lecture 61 Module 11 - Practice Exercise

Section 12: Excel 2019 Beginner: Working with Names

Lecture 62 Creating Range Names

Lecture 63 Managing Names

Lecture 64 Using Names in Formulas

Lecture 65 Module 12 - Practice Exercise

Section 13: Excel 2019 Beginner: Sorting and Filtering

Lecture 66 Remove Duplicates

Lecture 67 Sort Data

Lecture 68 Filter Data

Lecture 69 Advanced Filters

Lecture 70 Module 13 - Practice Exercise

Section 14: Excel 2019 Beginner: Outlining and Subtotaling

Lecture 71 Creating an Outline

Lecture 72 Subtotals

Lecture 73 Module 14 - Practice Exercise

Section 15: Excel 2019 Beginner: Working with Views

Lecture 74 Arranging Files

Lecture 75 New Window Option

Lecture 76 Custom Views

Lecture 77 Module 15 - Practice Exercise

Section 16: Excel 2019 Beginner: Linking Files

Lecture 78 Creating Formulas Between File

Lecture 79 Working with Links

Lecture 80 Consolidating Data

Lecture 81 Module 16 - Practice Exercise

Section 17: Excel 2019 Beginner: Advanced Formula Creation

Lecture 82 If Statements

Lecture 83 VLookups

Lecture 84 Data Validation

Lecture 85 Formula Auditing

Lecture 86 Module 17 - Practice Exercise

Section 18: Excel 2019 Beginner: Pivot Tables

Lecture 87 Pivot Tables

Lecture 88 Pivot Charts

Lecture 89 Module 18 - Practice Exercise

Section 19: Excel 2019 Beginner: Additional Excel Features

Lecture 90 Slicers

Lecture 91 Goal Seeker

Lecture 92 Text to Columns

Lecture 93 Watch Window

Lecture 94 Customizing Ribbons and Tabs

Lecture 95 Module 19 - Practice Exercise

Section 20: Excel 2019 Beginner: Shortcuts

Lecture 96 Excel Shortcuts Every User Should Know

Section 21: Excel 2019 Beginner: Closing

Lecture 97 Closing Video

Section 22: PowerPoint 2019: Course Introduction

Lecture 98 Welcome and Overview

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

Lecture 100 DOWNLOAD ME: Course Exercise Files

Lecture 101 Downloadable Course Transcripts

Section 23: PowerPoint 2019: Overview

Lecture 102 Navigate a PowerPoint Presentation

Lecture 103 Overview of the Screen and Views

Lecture 104 Exercise 1

Section 24: PowerPoint 2019: Getting Started

Lecture 105 Presentation Tips and Guidelines

Lecture 106 Creating a New Presentation

Lecture 107 Working with Slides

Lecture 108 Saving a Presentation

Lecture 109 Exercise 02

Section 25: PowerPoint 2019: Text and Bullet Editing Options

Lecture 110 Formatting Text

Lecture 111 Working with Bullets and Numbered Lists

Lecture 112 Exercise 03

Section 26: PowerPoint 2019: Adding Graphics

Lecture 113 Inserting Shapes

Lecture 114 Inserting Graphics

Lecture 115 Inserting Icons and 3D Models

Lecture 116 Inserting Pictures

Lecture 117 Exercise 04

Section 27: PowerPoint 2019: Working with objects

Lecture 118 Selecting Objects

Lecture 119 Editing Objects

Lecture 120 Formatting Objects - Part 1

Lecture 121 Formatting Objects - Part 2

Lecture 122 Arranging Objects

Lecture 123 Grouping Objects

Lecture 124 Exercise 05

Section 28: PowerPoint 2019: Editing Pictures

Lecture 125 Picture Options

Lecture 126 Cropping Pictures

Lecture 127 Formatting Pictures

Lecture 128 Things You Can Do with Pictures

Lecture 129 Exercise 06

Section 29: PowerPoint 2019: Working with SmartArt

Lecture 130 Creating SmartArt

Lecture 131 Modifying SmartArt

Lecture 132 Creating a Flowchart using SmartArt

Lecture 133 Exercise 07

Section 30: PowerPoint 2019: Working with Tables

Lecture 134 Creating Tables

Lecture 135 Formatting Tables

Lecture 136 Inserting Tables

Lecture 137 Exercise 08

Section 31: PowerPoint 2019: Working with Charts

Lecture 138 Adding Charts

Lecture 139 Formatting Charts

Lecture 140 Inserting Charts from Microsoft Excel

Lecture 141 Exercise 09

Section 32: PowerPoint 2019: Unlocking the Power of Masters

Lecture 142 Using Master Slides

Lecture 143 Modifying Master Slides

Lecture 144 Creating a New Master Design Template

Lecture 145 Exercise 10

Section 33: PowerPoint 2019: Adding Media

Lecture 146 Adding Video to a Presentation

Lecture 147 Adding Audio to a Presentation

Lecture 148 Exercise 11

Section 34: PowerPoint 2019: Working with Transitions

Lecture 149 Applying Transitions

Lecture 150 Transition Options

Lecture 151 Exercise 12

Section 35: PowerPoint 2019: Animation

Lecture 152 Animating an Object

Lecture 153 Effect Options

Lecture 154 Working with the Animation Pane

Lecture 155 Motion Paths

Lecture 156 Triggers

Lecture 157 Exercise 13

Section 36: PowerPoint 2019: Hyperlinks and Action Buttons

Lecture 158 Working with Action Buttons

Lecture 159 Working with Hyperlinks

Lecture 160 Exercise 14

Section 37: PowerPoint 2019: Slideshow Options

Lecture 161 Onscreen Presentation Options

Lecture 162 Hiding Slides

Lecture 163 Changing the Order of Slides

Lecture 164 Copying Slides

Lecture 165 Slideshow Options

Lecture 166 Exercise 15

Section 38: PowerPoint 2019: Preparing a Presentation for Delivery

Lecture 167 Rehearse Timings

Lecture 168 Recording a Presentation

Lecture 169 Slide Show Settings

Lecture 170 Creating a Custom Slide Show

Lecture 171 Exercise 16

Section 39: PowerPoint 2019: Exploring the Backstage Area

Lecture 172 Exporting options

Lecture 173 The Backstage Area

Lecture 174 Printing a Presentation

Lecture 175 Exercise 17

Section 40: PowerPoint 2019: Course Close

Lecture 176 Conclusion

Section 41: Word 2019: Introduction

Lecture 177 Welcome and Overview

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

Lecture 179 DOWNLOAD ME: Course Exercise Files

Lecture 180 Downloadable Course Transcripts

Lecture 181 Overview of the MS Word Screen

Lecture 182 The Backstage View

Section 42: Word 2019: Getting Started with Word

Lecture 183 Creating a New Blank Document

Lecture 184 Working with Non-Printing Characters and Line Spacing

Lecture 185 Saving a Document

Lecture 186 Opening a Document

Lecture 187 Navigating a Document

Lecture 188 Go To, Find and Replace

Lecture 189 Editing a Document

Lecture 190 Practice Exercise

Section 43: Word 2019: Character Formatting

Lecture 191 AutoCorrect Options

Lecture 192 Selecting Text

Lecture 193 Cut, Copy and Paste

Lecture 194 Character Formatting Options

Lecture 195 Format Painter

Lecture 196 Working with Numbers

Lecture 197 Working with Bullets

Lecture 198 Creating an Outline

Lecture 199 Practice Exercise

Section 44: Word 2019: Paragraph Formatting

Lecture 200 Alignment Options

Lecture 201 Line Spacing Options

Lecture 202 Working with Indents

Lecture 203 Working with Tabs

Lecture 204 Practice Exercise

Section 45: Word 2019: Managing Lists

Lecture 205 Sorting a List

Section 46: Word 2019: Tables

Lecture 206 Working with Tables

Lecture 207 Creating a Table

Lecture 208 Adding Rows and Columns to a Table

Lecture 209 Formatting Table Data

Lecture 210 Borders and Shading

Lecture 211 Sorting in a Table

Lecture 212 Drawing in a Table

Lecture 213 Converting Existing Data to a Table

Lecture 214 Quick Tables

Lecture 215 Using Formulas in Tables

Lecture 216 Practice Exercise

Section 47: Word 2019: Styles

Lecture 217 Working with Styles

Lecture 218 Creating Styles

Lecture 219 Editing Styles

Lecture 220 Practice Exercise

Section 48: Word 2019: Controlling Page Appearance

Lecture 221 Working with Page Breaks

Lecture 222 Working with Columns

Lecture 223 Adding a Watermark

Lecture 224 Headers and Footers

Section 49: Word 2019: Sectioning

Lecture 225 What is Sectioning?

Lecture 226 Sectioning a Document

Lecture 227 Odd and Even Sections

Lecture 228 Practice Exercise

Section 50: Word 2019: Graphics

Lecture 229 Inserting Pictures

Lecture 230 Inserting Pictures into Existing Documents

Lecture 231 Picture Options

Lecture 232 Working with Shapes

Lecture 233 Icons and 3D Models

Lecture 234 SmartArt, Charts and Screenshots

Lecture 235 Practice Exercise

Section 51: Word 2019: Envelopes and Labels

Lecture 236 Working with Envelopes

Lecture 237 Working with Labels

Section 52: Word 2019: Mail Merges

Lecture 238 What is Mail Merge?

Lecture 239 Creating a Mail Merge Document - Part 1

Lecture 240 Creating a Mail Merge Document - Part 2

Lecture 241 Merging a Document with an Existing Data Source

Lecture 242 Merging Envelopes and Labels

Lecture 243 Merging a Directory

Lecture 244 Practice Exercise

Section 53: Word 2019: Page Setup Options

Lecture 245 Building Blocks

Lecture 246 Auto Text

Lecture 247 Practice Exercise

Section 54: Word 2019: Indexing and Table of Contents

Lecture 248 Creating an Index

Lecture 249 Creating a Table of Contents

Lecture 250 Practice Exercise

Section 55: Word 2019: Review and Printing

Lecture 251 Using the Thesaurus and Spell Check

Lecture 252 Comments

Lecture 253 Page Setup Options

Lecture 254 Printing

Lecture 255 Practice Exercise

Section 56: Word 2019: Other Word Options

Lecture 256 Word Options

Lecture 257 Protecting a Document

Lecture 258 Macros

Section 57: Wrap Up

Lecture 259 Closing

Section 58: Extras

Lecture 260 EXTRA LESSON: Designing Better Spreadsheets Webinar Recording

Lecture 261 EXTRA LESSON: Data Cleaning in Excel Webinar Recording

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

Lecture 263 EXTRA LESSON: Creating Engaging PowerPoint Presentations Webinar Recording

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

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

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

Section 59: Congratulations!

Lecture 267 BONUS Lecture

Anyone new to Microsoft Office or upgrading from a previous version