MS Office; Excel, Word, Access & PowerPoint 2019 - Beginners (Udemy.com)

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

Created by: Simon Sez IT

Produced in 2021

icon
What you will 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

icon
Quality Score

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 90 / 100

icon
Course 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 dont utilize its full potential.
Were here to make sure you arent 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 completionHeres 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!
Who this course is for:
Anyone new to Microsoft Office or upgrading from a previous version

icon
Instructor Details

Simon Sez IT

Since 2008, individuals, small businesses, and Fortune 500 companies with thousands of employees have benefited from the easy and hands-on software training offered by Simon Sez IT. With over 5,000 video tutorials on a range of software programs, Simon Sez IT ensures stress-free eLearning and enhanced employee productivity - no matter whether you are implementing new software or a technological upgrade for your workplace. With over 430,000 Udemy students in over 180 countries, Simon Sez IT is the preferred online learning choice for individuals and businesses everywhere.

icon
Reviews

4.5

80 total reviews

5 star 4 star 3 star 2 star 1 star
% Complete
% Complete
% Complete
% Complete
% Complete

By Adelina perestrelo on 11/22/2020

Este curso est a ajudar me imenso a trabalhar com o excel . Muito bom

By Amrit Raj on 11/1/2020

very good platform for learn to excel, PowerPoint, word and access.

By Shanelle Bergren on 10/26/2020

I am starting pretty with basic skills, so I appreciate the explanantions so far of the terminology and the descriptions of the pages.

By Dorothy Reed on 10/23/2020

so far ,very informative

By Soumitra Mondal on 10/12/2020

So far going well!

By Parvesh Thakur on 10/8/2020

It is a great course to start with. Especially the added live webinars are the best highlight of this course. As the course said it is a beginner friendly course do not expect much.
If you can add more seminars videos in future that would be a great help.

By Linda Nash on 9/25/2020

I have no idea what she is talking about...never saw Excel sheet before, so not know what I would use it for

By Rajkumar Middya on 9/23/2020

yes

By Sindhu.S on 9/22/2020

yes, i need to do some excercise and commend more

By Danila Dorman on 9/12/2020

yes it was good.

By Ashwini Mehta on 9/6/2020

yes,it is good

By Chettubathina Chandan Premjee on 8/24/2020

great course