Microsoft Office; Excel, Word & PowerPoint 2019 - Beginners
4.3 (273 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
920 students enrolled

Microsoft Office; Excel, Word & PowerPoint 2019 - Beginners

Learn the essentials of Microsoft Office in this 3-course bundle for Office 355 or Office 2019 users.
4.3 (273 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
920 students enrolled
Created by Simon Sez IT
Last updated 5/2020
English
English [Auto-generated]
Current price: $104.99 Original price: $149.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 26.5 hours on-demand video
  • 10 articles
  • 6 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
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

**Course includes practice exercise files, LIFETIME access and is covered by the Udemy money-back guarantee**


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 2019

  • What's new in Excel 2019

  • Creating workbooks

  • Entering text, numbers and working with dates

  • Navigating workbooks

  • Page setup and print options

  • Working with rows, columns and cells

  • Cut, Copy and Paste

  • Introduction to functions and formulas

  • Formatting in Excel, including formatting cells and numbers

  • Creating charts and graphs

  • Sorting and Filtering

  • Introduction to PivotTables

  • Logical and lookup formulas - the basics


PowerPoint 2019

  • How to navigate around PowerPoint

  • Presentation dos and don'ts

  • Text and bullet edition options

  • How to use graphics, images, objects and shapes

  • Using SmartArt

  • Working with Charts and Graphs

  • How to utilize Master Slides and just how much time this could save you

  • How to add audio and video to a presentation

  • All about transitions between slides

  • Animation, the animation pane and motion paths

  • Setting your slideshow options

  • Presentation preparation and delivery

  • The backstage area of PowerPoint including printing a presentation


Word 2019

  • How to get started with Word 2019

  • Word 2019 basics including navigation, editing and saving

  • Character formatting in Word including Format Painter and AutoCorrect

  • How to properly work with bullets and numbering in Microsoft Word

  • All about formatting paragraphs and managing lists

  • Working with Tables in Word including formatting, converting data and formulas

  • Page appearance including page-breaks, watermarks and styles

  • All about Sectioning a document

  • Inserting graphics, pictures, shapes, icons and 3d models (new for 2019)

  • How to work with envelopes and labels

  • All about mail-merge and operating Word at scale

  • How to create an Index or Contents page

  • Reviewing and Printing in Word and Page Setup

  • Protecting a Word document and basic macros in Word

***Exercise and demo files included***


This bundle includes:

  1. 21+ hours of video tutorials

  2. 250+ individual video lectures

  3. Exercise files to practice what you learned

  4. Certificate of completion


Here’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 Lambert


Did 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!


Just search "Simon Sez IT" to see our full list of individual courses and incredible value multi-course bundles on Udemy.

Who this course is for:
  • Anyone new to Microsoft Office or upgrading from a previous version
Course content
Expand all 265 lectures 26:26:53
+ Excel 2019: Introduction
8 lectures 26:05
Essential Information for a Successful Training Experience
01:19
Course Exercise Files
00:24
Overview of the Excel window
08:25
Mouse-Features
03:12
Back Stage View
02:37
Section 1 Quiz
4 questions
+ Excel 2019 Beginner: Creating Workbooks
6 lectures 24:59
Entering Text and Numbers
04:32
Creating Basic Formulas
06:49
Relative References
03:01
Order of Operations
04:48
Working with Ranges
04:14
Module 2 - Practice Exercise
01:35
Section 2 Quiz
3 questions
+ Excel 2019 Beginner: Saving Workbooks
3 lectures 09:17
Working with the Save and Save As Commands
04:34
File Extensions, Share, Export and Publish Files
03:44
Module 3 - Practice Exercise
00:59
Section 3 Quiz
1 question
+ Excel 2019 Beginner: Navigating Workbooks
5 lectures 20:35
Opening a File
05:33
Working with Larger Files
05:34
Freeze Panes Option
03:16
Split Screen Option
03:22
Module 4 - Practice Exercise
02:50
Section 4 Quiz
1 question
+ Excel 2019 Beginner: Page Setup & Print Options
7 lectures 32:55
Headers and Footers
07:23
Print Titles
02:52
Comments
05:23
Page Setup Options
07:30
Fit to Print on One Page
03:59
Printing Workbooks
03:55
Module 5 - Practice Exercise
01:53
Section 5 Quiz
3 questions
+ Excel 2019 Beginners: Working with Rows, Columns and Cells
3 lectures 11:08
Adding and deleting rows columns and cells
06:12
Changing Column and-Row Widths
03:45
Module 6 - Practice Exercise
01:11
Section 6 Quiz
2 questions
+ Excel 2019 Beginners: Moving Data
3 lectures 13:36
Cut, Copy and Paste
07:07
Copying Formulas
05:09
Module 7 - Practice Exercise
01:20
Section 7 Quiz
1 question
+ Excel 2019 Beginners: Formulas & Functions
5 lectures 24:52
Overview of Formulas
02:48
Create Formulas Using Functions Part 1
10:04
Create Formulas Using Functions Part 2
05:24
Absolute Values
05:16
Module 8 - Practice Exercise
01:20
Section 8 Quiz
4 questions
+ Excel 2019 Beginner: Working with Sheets
4 lectures 16:13
Adding Deleting and Renaming Sheets
04:09
Additional Sheet Tab Options
05:19
3 Dimensional Formulas
05:28
Module 9 - Practice Exercise
01:17
Section 9 Quiz
3 questions
+ Excel 2019 Beginner: Formatting Worksheets
10 lectures 01:02:07
Formatting Cells Part 1
10:04
Formatting Cells Part 2
03:38
Formatting Numbers
09:24
Borders and Shading
07:08
Format as Table
06:07
Using Styles
03:49
Using Format Painter
04:29
Protecting Sheets
09:01
Fill Handle and Custom Lists
07:17
Module 10 - Practice Exercise
01:10
Section 10 Quiz
2 questions