Microsoft Office; Excel, Word & PowerPoint 2019 – Beginners

Microsoft Office; Excel, Word & PowerPoint 2019 – Beginners, available at $109.99, has an average rating of 4.45, with 271 lectures, 44 quizzes, based on 1018 reviews, and has 3653 subscribers.

You will learn about 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 This course is ideal for individuals who are Anyone new to Microsoft Office or upgrading from a previous version It is particularly useful for Anyone new to Microsoft Office or upgrading from a previous version.

Enroll now: Microsoft Office; Excel, Word & PowerPoint 2019 – Beginners

Summary

Title: Microsoft Office; Excel, Word & PowerPoint 2019 – Beginners

Price: $109.99

Average Rating: 4.45

Number of Lectures: 271

Number of Quizzes: 44

Number of Published Lectures: 271

Number of Published Quizzes: 44

Number of Curriculum Items: 315

Number of Published Curriculum Objects: 315

Original Price: $129.99

Quality Status: approved

Status: Live

What You Will 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

Who Should Attend

Anyone new to Microsoft Office or upgrading from a previous version

Target Audiences

Anyone new to Microsoft Office or upgrading from a previous version

**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 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:

21+ hours of video tutorials
250+ individual video lectures
Exercise files to practice what you learned
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!

Course Curriculum

Chapter 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

Chapter 2: Excel 2019 Beginner: Creating Workbooks

Lecture 1: Entering Text and Numbers

Lecture 2: Creating Basic Formulas

Lecture 3: Relative References

Lecture 4: Order of Operations

Lecture 5: Working with Ranges

Lecture 6: Module 2 – Practice Exercise

Chapter 3: Excel 2019 Beginner: Saving Workbooks

Lecture 1: Working with the Save and Save As Commands

Lecture 2: File Extensions, Share, Export and Publish Files

Lecture 3: Module 3 – Practice Exercise

Chapter 4: Excel 2019 Beginner: Navigating Workbooks

Lecture 1: Opening a File

Lecture 2: Working with Larger Files

Lecture 3: Freeze Panes Option

Lecture 4: Split Screen Option

Lecture 5: Module 4 – Practice Exercise

Chapter 5: Excel 2019 Beginner: Page Setup & Print Options

Lecture 1: Headers and Footers

Lecture 2: Print Titles

Lecture 3: Comments

Lecture 4: Page Setup Options

Lecture 5: Fit to Print on One Page

Lecture 6: Printing Workbooks

Lecture 7: Module 5 – Practice Exercise

Chapter 6: Excel 2019 Beginners: Working with Rows, Columns and Cells

Lecture 1: Adding and deleting rows columns and cells

Lecture 2: Changing Column and-Row Widths

Lecture 3: Module 6 – Practice Exercise

Chapter 7: Excel 2019 Beginners: Moving Data

Lecture 1: Cut, Copy and Paste

Lecture 2: Copying Formulas

Lecture 3: Module 7 – Practice Exercise

Chapter 8: Excel 2019 Beginners: Formulas & Functions

Lecture 1: Overview of Formulas

Lecture 2: Create Formulas Using Functions Part 1

Lecture 3: Create Formulas Using Functions Part 2

Lecture 4: Absolute Values

Lecture 5: Module 8 – Practice Exercise

Chapter 9: Excel 2019 Beginner: Working with Sheets

Lecture 1: Adding Deleting and Renaming Sheets

Lecture 2: Additional Sheet Tab Options

Lecture 3: 3 Dimensional Formulas

Chapter 10: Excel 2019 Beginner: Formatting Worksheets

Lecture 1: Formatting Cells Part 1

Lecture 2: Formatting Cells Part 2

Lecture 3: Formatting Numbers

Lecture 4: Borders and Shading

Lecture 5: Format as Table

Lecture 6: Using Styles

Lecture 7: Using Format Painter

Lecture 8: Protecting Sheets

Lecture 9: Fill Handle and Custom Lists

Lecture 10: Module 10 – Practice Exercise

Chapter 11: Excel 2019 Beginner: Charts

Lecture 1: Creating Charts

Lecture 2: Types of Charts

Lecture 3: Editing Charts Part 1

Lecture 4: Editing Charts Part 2

Lecture 5: Using Graphics to Enhance Charts

Lecture 6: Linking Chart Titles

Lecture 7: Module 11 – Practice Exercise

Chapter 12: Excel 2019 Beginner: Working with Names

Lecture 1: Creating Range Names

Lecture 2: Managing Names

Lecture 3: Using Names in Formulas

Lecture 4: Module 12 – Practice Exercise

Chapter 13: Excel 2019 Beginner: Sorting and Filtering

Lecture 1: Remove Duplicates

Lecture 2: Sort Data

Lecture 3: Filter Data

Lecture 4: Advanced Filters

Lecture 5: Module 13 – Practice Exercise

Chapter 14: Excel 2019 Beginner: Outlining and Subtotaling

Lecture 1: Creating an Outline

Lecture 2: Subtotals

Lecture 3: Module 14 – Practice Exercise

Instructors

Simon Sez IT
870,000+ Students, 260+ Courses, Learners in 180+ Countries

Rating Distribution

1 stars: 13 votes
2 stars: 16 votes
3 stars: 107 votes
4 stars: 359 votes
5 stars: 523 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu