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
Screenshots

#