Ultimate Microsoft Office; Excel, Word, PowerPoint & Access from Udemy

This course includes practice exercises and

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 13 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 9 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, Microsoft Teams, Microsoft Word, and Microsoft OneNote.

UPDATED

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

Microsoft Teams

How to access, download and set up Teams
How to create your first team and manage members and channels
All about posting and receiving public and private messages
How to do user announcements, tags, and message extensions
How to schedule an audio or video call
How to use the audio and video calling options including recording calls
How to use the meeting notes function
How to create a wiki
All about using apps, bots, and connectors
How to adjust admin and user settings
How to use Teams on your mobile device

Microsoft OneNote

How to get started using OneNote Desktop or OneNote Windows 10
How to add text, videos, images, clips, and links to OneNote
How to use the screen clipping tool in OneNote
How to format notes in OneNote
How to create a to-do list in OneNote
How to add tags in OneNote and search for content
How to link notes in OneNote
How to format pages in OneNote
How to use the pen tools in OneNote, including handwriting to text
How to link OneNote with Outlook
How to share notebooks in OneNote
How to collaborate using OneNote
How to customize your options in OneNote
About using OneNote Online and the OneNote App

Exercise and demo files included

This bundle includes:

68+ hours of video tutorials
600+ individual video lectures
Exercise files to practice what you learned
Certificate of completion
NINE 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 Office Microsoft Teams and Microsoft OneNote were recorded using Office 365.

Here’s what our students are saying…

"I'm finding this course very helpful and the instructor is very easy to understand. I am learning so much more than I did from another course I tried to take and lost interest in. This course has really kept my interest."- Dianne Munizza

"Loving the lessons. Easy to understand and can replay the lesson if I did not catch something the first time.."- Monica Yvette Disbrow

"It's still early on in the course, but I love it. He's so very clear with each tiny thing he's teaching you. He sounds quite like a gentle and patient friend or mentor walking you through step by step. He also repeats things (not monotonously) which helps you retain what you're learning. When I first registered for this course, I thought 'oh my goodness, what have I done'... when you look at the 'your progress' dropdown at the upper right corner of your dashboard and see that you're on #21 of 518(. ), it can seem a bit intimidating. But, no I think with this particular instructor's gift of friendly teaching, we'll all do fantastically well. "- Celine Barton

What's inside

Learning objectives

Learn the essential and advanced microsoft office skills in excel, word, powerpoint, outlook, teams and access
Huge value bundle - eight courses!
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 including how to copy slides, and exporting your presentation
Master the most common uses of microsoft word
Learn word tools 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
Sorting information and running queries in access
Navigating the access 2019 interface
Discover how to into import data from excel in access
Learn queries, use validations, how to create and print reports in access
How to compact, repair and backup your access database
How to create a linked table in access
How to get set up in outlook
All about sending and receiving emails
How to customize your mailbox and view
How to organize and manage your mail including ignoring, flagging and conditional formatting
Creating and managing tasks and reminders
How to use signatures and voting buttons
Adding, managing and searching contacts in the address book
Working with the outlook calendar, including creating meetings and appointments
How to create notes and link outlook to onenote
Show more
Show less

Learn the essential and advanced microsoft office skills in excel, word, powerpoint, outlook, teams and access
Huge value bundle - eight courses!
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 including how to copy slides, and exporting your presentation
Master the most common uses of microsoft word
Learn word tools 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
Sorting information and running queries in access
Navigating the access 2019 interface
Discover how to into import data from excel in access
Learn queries, use validations, how to create and print reports in access
How to compact, repair and backup your access database
How to create a linked table in access
How to get set up in outlook
All about sending and receiving emails
How to customize your mailbox and view
How to organize and manage your mail including ignoring, flagging and conditional formatting
Creating and managing tasks and reminders
How to use signatures and voting buttons
Adding, managing and searching contacts in the address book
Working with the outlook calendar, including creating meetings and appointments
How to create notes and link outlook to onenote
Show more
Show less

Syllabus

Excel 2019: Introduction

Intro to Excel

WATCH ME: Essential Information for a Successful Training Experience

Course Exercise Files

Downloadable Course Transcript

What's New In Excel 2019

Course Overview

Overview of the Excel window

Mouse-Features

Back Stage View

Section Quiz

Excel 2019 Beginner: Creating Workbooks

Entering Text and Numbers

Creating Basic Formulas

Relative References

Order of Operations

Working with Ranges

Module 2 - Practice Exercise

Excel 2019 Beginner: Saving Workbooks

Working with the Save and Save As Commands

File Extensions, Share, Export and Publish Files

Module 3 - Practice Exercise

Excel 2019 Beginner: Navigating Workbooks

Opening a File

Working with Larger Files

Freeze Panes Option

Split Screen Option

Module 4 - Practice Exercise

Excel 2019 Beginner: Page Setup & Print Options

Headers and Footers

Print Titles

Comments

Page Setup Options

Fit to Print on One Page

Printing Workbooks

Module 5 - Practice Exercise

Excel 2019 Beginners: Working with Rows, Columns and Cells

Adding and deleting rows columns and cells

Changing Column and-Row Widths

Module 6 - Practice Exercise

Excel 2019 Beginners: Moving Data

Cut, Copy and Paste

Copying Formulas

Module 7 - Practice Exercise

Excel 2019 Beginners: Formulas & Functions

Overview of Formulas

Create Formulas Using Functions Part 1

Create Formulas Using Functions Part 2

Absolute Values

Module 8 - Practice Exercise

Excel 2019 Beginner: Working with Sheets

Adding Deleting and Renaming Sheets

Additional Sheet Tab Options

3 Dimensional Formulas

Module 9 - Practice Exercise

Excel 2019 Beginner: Formatting Worksheets

Formatting Cells Part 1

Formatting Cells Part 2

Formatting Numbers

Borders and Shading

Format as Table

Using Styles

Using Format Painter

Protecting Sheets

Fill Handle and Custom Lists

Module 10 - Practice Exercise

Excel 2019 Beginner: Charts

Creating Charts

Types of Charts

Editing Charts Part 1

Editing Charts Part 2

Using Graphics to Enhance Charts

Linking Chart Titles

Module 11 - Practice Exercise

Excel 2019 Beginner: Working with Names

Creating Range Names

Managing Names

Using Names in Formulas

Module 12 - Practice Exercise

Excel 2019 Beginner: Sorting and Filtering

Remove Duplicates

Sort Data

Filter Data

Advanced Filters

Module 13 - Practice Exercise

Excel 2019 Beginner: Outlining and Subtotaling

Creating an Outline

Subtotals

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Covers a wide range of Microsoft Office applications, providing a comprehensive skill set applicable to various professional tasks

Includes beginner to advanced training in Microsoft Excel and Access, offering a comprehensive grounding in PowerPoint, Outlook, Teams, Word, and OneNote

Teaches advanced charting and graphing in Excel, along with mastery of PivotTables and Pivot Charts, which are essential for data analysis

Explores presentation preparation and delivery, including animation, audio, and video, which are useful for creating engaging presentations

Explores mail merge and basic macros in Word, which are useful for automating repetitive tasks and improving efficiency

Uses MS Office 2019, which may differ from newer versions in terms of interface and features, but the core concepts remain relevant

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Ultimate Microsoft Office; Excel, Word, PowerPoint & Access with these activities:

Review Basic Spreadsheet Concepts

Show steps

Reinforce foundational spreadsheet knowledge to better understand Excel-specific features and functions.

Browse courses on Spreadsheet

Show steps

Review the basic concepts of rows, columns, and cells.
Practice creating simple formulas and using basic functions like SUM and AVERAGE.
Familiarize yourself with common spreadsheet terminology.

Read 'Excel 2019 Bible'

Show steps

Deepen your understanding of Excel with a comprehensive guide that covers a wide range of topics.

View Putting Knowledge to Work on Amazon

Show steps

Read the chapters relevant to the course syllabus.
Try out the examples and exercises provided in the book.
Use the book as a reference when working on Excel projects.

Complete Excel Formula Exercises

Show steps

Solidify your understanding of Excel formulas by completing a series of practice exercises.

Browse courses on Excel Formulas

Show steps

Find online resources or workbooks with Excel formula exercises.
Work through the exercises, focusing on different types of formulas (e.g., logical, lookup, financial).
Check your answers and review the solutions to understand any mistakes.

Four other activities

Expand to see all activities and additional details

Show all seven activities

Create a Budgeting Spreadsheet

Show steps

Apply your Excel skills by creating a practical budgeting spreadsheet to manage personal or business finances.

Browse courses on Excel

Show steps

Define the categories for income and expenses.
Create formulas to calculate totals and track spending.
Use charts to visualize the budget data.

Create a PowerPoint Presentation on a Topic of Interest

Show steps

Practice your PowerPoint skills by creating a presentation on a topic you are passionate about.

Browse courses on PowerPoint

Show steps

Choose a topic and gather relevant information.
Design the slides with clear and concise content.
Incorporate visuals, animations, and transitions to enhance the presentation.

Read 'Microsoft Access 2019 Bible'

Show steps

Enhance your Access skills with a detailed guide that covers database design and application development.

View Microsoft Excel 365 Bible on Amazon

Show steps

Read the chapters relevant to the course syllabus.
Try out the examples and exercises provided in the book.
Use the book as a reference when working on Access projects.

Design a Database in Access

Show steps

Apply your Access knowledge by designing a database for a specific purpose, such as managing customer information or tracking inventory.

Browse courses on Microsoft Access

Show steps

Define the tables and fields needed for the database.
Create relationships between the tables.
Design forms and reports to interact with the data.

Career center

Learners who complete Ultimate Microsoft Office; Excel, Word, PowerPoint & Access will develop knowledge and skills that may be useful to these careers:

Executive Assistant

Executive assistants support management by handling administrative tasks. They need to be highly skilled in Microsoft Office. This course helps an executive assistant by providing training across a range of applications, including Word for document management, Outlook for communication, PowerPoint for presentations, and Excel for data organization. The course ensures an executive assistant gains the necessary tools to perform a wide variety of administrative tasks.

See salaries and explore the career path for Executive Assistant

Administrative Assistant

Administrative assistants provide crucial support to teams and organizations. They manage documents, schedules, and communications, relying heavily on Microsoft Office programs. This course offers training in Word for document creation, Outlook for email management, PowerPoint for presentations, and Access for database management. An administrative assistant will benefit greatly from the course's practical approach to mastering these essential software tools. The breadth of the course ensures an administrative assistant is well-prepared for everyday tasks.

See salaries and explore the career path for Administrative Assistant

Office Manager

Office managers oversee the daily administrative and operational functions of an office. They often need to be skilled in using Microsoft Office. This course provides relevant training in Word for document management, Outlook for communication, Excel for data tracking, and Access for database management. An office manager's work demands a wide range of software skills, and this course is ideal for anyone that wants to master administrative tasks that use the Microsoft suite.

See salaries and explore the career path for Office Manager

Office Clerk

Office clerks perform a variety of administrative and clerical tasks to support the smooth operation of an office. This course is relevant because it provides an office clerk a broad foundation in Microsoft Office applications. It provides training in Word for managing documents, Outlook for communication, Excel for data entry and basic analysis, and Access for database management. These skills are vital, and this course provides all the fundamentals needed to perform daily administrative duties effectively.

See salaries and explore the career path for Office Clerk

Data Analyst

A data analyst uses software to organize and study large sets of information. This often involves using Microsoft Excel to perform calculations, create visualizations, and extract insights. This course provides a comprehensive foundation in Excel, including advanced charting, pivot tables, and data analysis techniques. The course's deep dive into Excel's functions and formulas helps a data analyst turn raw data into meaningful information, and is vital for anyone hoping to excel in this role.

See salaries and explore the career path for Data Analyst

Financial Analyst

Financial analysts examine financial data to help businesses make informed decisions. Often, they use Microsoft Excel extensively for financial modeling, analysis, and reporting. This course provides a detailed curriculum on Excel, including advanced functions, financial formulas, charting, and pivot tables. These help a financial analyst to better analyze data and create insightful reports. A financial analyst will find the advanced Excel training in this course particularly useful because of its ability to handle sophisticated data analysis.

See salaries and explore the career path for Financial Analyst

Training Coordinator

Training coordinators develop and manage training programs, often using Microsoft Office for creating materials and coordinating tasks. This course is especially helpful because it provides training in PowerPoint for presentation creation, Word for written materials, and Excel for tracking participant progress. A training coordinator will find the comprehensive nature of this course indispensable because it covers essential software tools for training development.

See salaries and explore the career path for Training Coordinator

Business Operations Specialist

A business operations specialist ensures the smooth functioning of day-to-day business activities. This role often involves utilizing various software tools, and Microsoft Office is typically central to this work. This course enhances a business operations specialist's proficiency in Excel for data management, Word for reports, PowerPoint for presentations, and Access to manage business data. The course's comprehensive nature is particularly useful for a business operations specialist who needs to be proficient in handling operational tasks.

See salaries and explore the career path for Business Operations Specialist

Research Assistant

Research Assistants often need to collect, organize, and analyze data, and Microsoft Office tools are frequently used for these tasks. This course provides training in Excel for data management, Word for reports, and Access for creating databases. A research assistant will learn how to organize, visualize, and present data through this course. Any research assistant who needs to use Microsoft Office will benefit greatly from this course.

See salaries and explore the career path for Research Assistant

Project Manager

Project managers oversee projects from start to finish, requiring strong organizational and communication skills. This course provides training in several Microsoft tools that are essential to their work. Microsoft Project can be used for project planning, but other tools are vital. This course offers training in Excel for progress tracking, Word for reports, PowerPoint for updates, and Teams for collaboration. With the breadth and depth of this course, a project manager learns how to leverage Microsoft Office to improve efficiency and keep projects on track.

See salaries and explore the career path for Project Manager

Human Resources Assistant

Human resources assistants manage employee records, prepare reports, and handle communications. They often use Microsoft Office applications. This course provides training in Word for managing documents and creating communications, Excel for data management, and Outlook for email. This course is particularly useful for an human resources assistant who needs to be proficient in handling office tasks. A foundation in these core applications is essential for this role.

See salaries and explore the career path for Human Resources Assistant

Marketing Coordinator

Marketing coordinators support marketing campaigns and initiatives. This often requires a versatile skillset that includes proficiency in Microsoft Office. This course offers useful training in PowerPoint for creating marketing presentations, Word for composing reports and documents, and Excel for data analysis. The course's training in presentation and communication tools makes this course very relevant to the role of marketing coordinator.

See salaries and explore the career path for Marketing Coordinator

Technical Writer

Technical writers create clear and concise documentation for technical products or processes. Often, they need proficiency in certain Microsoft Office programs. This course helps a technical writer by offering detailed training in Word for document creation, including formatting and styles. It also covers PowerPoint for presentations, should a technical writer wish to present their work. This course covers essential office tools and is ideal for a technical writer who needs to produce professional-looking documents and presentations.

See salaries and explore the career path for Technical Writer

Sales Representative

Sales representatives need to create presentations, manage customer data, and track their progress. This course provides training in Microsoft tools very relevant to sales. PowerPoint is critical for sales presentations, while Excel helps with lead management and tracking sales figures. Furthermore, the course offers valuable instruction on Outlook for email management. This makes it ideal for a sales representative who needs to leverage Microsoft Office to improve their sales effectiveness.

See salaries and explore the career path for Sales Representative

Customer Service Representative

Customer service representatives interact with customers on a daily basis. They often use Microsoft Office applications to log information, communicate with customers, and manage communications. This course helps a customer service representative by providing practical training in Outlook for email management and Word for composing documents. The course's modules on email management and communication are vital for any customer service professional.

See salaries and explore the career path for Customer Service Representative

Ultimate Microsoft Office; Excel, Word, PowerPoint & Access

What's inside

Learning objectives

Syllabus

Good to know

Save this course

Activities

Career center

Featured in The Course Notes

Reading list

Share

Similar courses