Skip to content Skip to sidebar Skip to footer

Widget Atas Posting

Ultimate Microsoft Office; Excel, Word, PowerPoint & Access

microsoft-office-excel-word-access-powerpoint
Udemy Coupon - Ultimate Microsoft Office; Excel, Word, PowerPoint & Access, Learn basic to advanced Microsoft Office skills in this 7-course bundle for Office 365 or Office 2019

  • Created by Simon Sez IT
  •  English [Auto-generated]
Students also bought

  • The Ultimate Microsoft Office 2016 Training Bundle
  • Microsoft Office Shortcuts and Speed Tips
  • MS Office - Advanced - Efficiency Training
  • MS Office 2013: 10-in-1 Courses To Maximize Productivity
  • MS Office; Excel, Word, Access & PowerPoint 2019 - Beginners


Preview this Course GET COUPON CODE

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

Learn Excel, PowerPoint, Access, Outlook and Word 2019 with this tremendous value 7-course bundle from Simon Sez IT.

The Microsoft Office suite is used by millions worldwide. Unlocking its full potential could see you drastically improve your productivity.

But you know all that because you’re on this page.

Instead, you’re probably wondering whether we’re the right team to teach you Office.

Simon Sez IT has been teaching MS Office for over ten years, and we’ve got pretty good at it. Just take a look at our Udemy ratings if you don’t believe us.

For this Ultimate Microsoft Office 2019 course, we’ve bundled together 7 of our best-selling titles into one huge value offering.

You don’t just get access to beginner courses either. You get advanced training in Microsoft Excel and Microsoft Access and a comprehensive grounding in Microsoft PowerPoint, Microsoft Outlook, and Microsoft Word.



***UPDATED APRIL 2020 - Outlook 2019 Added***



What's covered in each course?

Microsoft 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



Advanced Microsoft Excel 2019

What's new/different in Excel 2019

Advanced charting and graphing in Excel

How to use detailed formatting tools

Lookup and advanced lookup functions

Financial functions including calculating interest and depreciation

Statistical functions

Connecting to other workbooks and datasets outside of Excel e.g. MS Access and the web.

How to create awesome visualizations using sparklines and data bars

Mastery of PivotTables and Pivot Charts

Scenario Manager, Goal Seek and Solver

Advanced charts such as Surface, Radar, Bubble and Stock Charts



Microsoft 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



Microsoft 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 2019

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



Advanced Microsoft Access 2019

About Primary Keys and Indexes in Access

About customizing and filtering on the Datasheet View

How to link to other databases

All about using ODBC and SQL Server

How to split an Access database into front and back-end

All about Macros in Access including AutoExec

How to do basic VBA in Access including code and error handling

More advanced techniques around creating forms in Access

Advanced queries including “multiple where” criteria



Microsoft Outlook 2019

How to get set up in Outlook

Some useful Outlook keyboard shortcuts

All about sending and receiving emails

How to customize your mailbox and view

How to search in Outlook

How to organize and manage your mail including ignoring, flagging and conditional formatting

How to effectively deal with Junk Mail

Attaching files, photos, and graphics in Outlook

About recalling a message

How to use signatures and voting buttons

How to best use, add to, and manage contacts

Working with the Outlook Calendar, including creating meetings and appointments

How to share Calendars with colleagues

How to use Tasks in Outlook

How to create Notes and link Outlook to OneNote

How to print the right thing in Outlook

***Exercise and demo files included***



This bundle includes:

50+ hours of video tutorials

450+ individual video lectures

Exercise files to practice what you learned

Certificate of completion

SEVEN full-length Microsoft courses

These courses were all recorded in the 2019 versions of MS Office but are still applicable if you’re working with an older or more up to date version.



Who this course is for:
Anyone new to Microsoft Office or upgrading from a previous version

100% Off Udemy Coupon . Free Udemy Courses . Online Classes

Post a Comment for "Ultimate Microsoft Office; Excel, Word, PowerPoint & Access"

SUBSCRIBE VIA EMAIL