MS Office; Excel, Word, Access & PowerPoint 2019 - Beginners

MS Office; Excel, Word, Access & PowerPoint 2019 - Beginners

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

Microsoft Access

• Where to start in Microsoft Access and whether to use a template or not

• How to modify Access to suit your needs

• All about importing data and the datasheet view

• How tables work in Access and how to create relationships between them

• Creating forms and sub-forms that feed data into your tables

• How to run queries in Access

• Setting up validations and calculations using expressions in Access

• Printing from Access

• To start to use macros and Modal Dialog

• The basics of the Access web app

• Exporting and reporting in Access

***Exercise and demo files included***

This bundle includes:

1. 29+ hours of video tutorials

2. 300+ individual video lectures

3. Exercise files to practice what you learned

4. Certificate of completion

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

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!

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

Url: View Details

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.

Rating: 4.44828

Level: Beginner Level

Duration: 35.5 hours

Instructor: Simon Sez IT