Srbija Posted October 30, 2022 Share #1 Posted October 30, 2022 Ms Office; Excel, Word, Access & Powerpoint 2019 - Beginners Last updated 1/2022 MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz Language: English | Size: 14.48 GB | Duration: 33h 42m 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 Homepage Hidden Content Give reaction to this post to see the hidden content. Hidden Content Give reaction to this post to see the hidden content. Hidden Content Give reaction to this post to see the hidden content. Hidden Content Give reaction to this post to see the hidden content. 1 Link to comment
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now