The Ultimate Microsoft Office 2021/365 Training Bundle from Udemy

This bundle includes downloadable course instructor files and exercise files to work with and follow along.

Learn Microsoft Excel, Word, PowerPoint, and Outlook 2021 with this huge-value six-course bundle from Microsoft Office expert, Simon Sez IT.

Microsoft Office remains the go-to tool for the modern worker, yet so many users fall short of using its full potential.

We’re here to make sure you aren’t one of those people.

In this Microsoft Office bundle, we make the four essential and widely used MS Office programs (Excel, Word, PowerPoint, and Outlook) simple to understand. The bundle includes six full-length courses to help you achieve your goals: Excel 2021 for Beginners, Word 2021, PowerPoint 2021, Outlook 2021, Excel 2021 Intermediate, and Excel 2021 Advanced.

Each course goes into depth on how to get the most from each program and will help you become a more skillful user.

What's included?

Excel 2021 for Beginners

Become familiar with what’s new in Excel 2021
Navigate the Excel 2021 interface
Utilize useful keyboard shortcuts to increase productivity
Create your first Excel spreadsheet
Use basic and intermediate Excel formulas and functions
Effectively apply formatting to cells and use conditional formatting
Use Excel lists and master sorting and filtering
Work efficiently by using the cut, copy, and paste options
Link to other worksheets and workbooks
Analyze data using charts
Insert pictures in a spreadsheet
Work with views, zooms, and freezing panes
Set page layout and print options
Protect and share workbooks
Save your workbook in different file formats

Word 2021

Navigate the Word 2021 interface
Customize the quick access toolbar
Access and modify Word options
Create new documents from scratch and from a template
Open and save existing documents
Switch between different document views
Enter, select, and apply formatting to text
Use cut, copy, paste, and different paste options
Find and replace text in a document
Format paragraphs
Align paragraphs using indents and tab stops
Insert bulleted and numbered lists
Apply a theme to control the look and feel of the document
Apply and modify Word styles
Insert content like shapes, icons, text boxes, 3D images, SmartArt, and charts
Annotate a document
Organize information using tables
Adjust the margins and orientation
Insert section and page breaks
Apply headers and footers
Insert blank pages and cover pages
Link to websites, other documents, and other sections using hyperlinks and bookmarks
Create re-usable content with Quick Parts
Create and format a table of contents
Add footnotes and end notes to a document
Create citations and inserting a bibliography
Create an index
Add captions to pictures and create a table of figures
Create multiple letters, envelopes, and labels using mail merge
Check spelling and set up auto-correct options
Track changes from multiple authors
Compare and combine documents
Adjust document properties
Check a document for accessibility and compatibility issues
Protect a document to prevent changes
Share a document with others
Collaborate on a document with others in real time
Print a document

PowerPoint 2021

Create visually stunning presentations that meet best practice guidelines
Find free, high-quality resources like images, icons, fonts, and videos
Improve efficiency with keyboard shortcuts and the Quick Access Toolbar
Open, close, and save presentations
Work with PowerPoint templates
Apply slide layouts to new or existing slides
Duplicate, arrange, copy, and paste slides and objects
Work with images, icons, video, text, shapes, and audio files
Correctly select, align, and group objects on a slide
Work with animations, transitions, and motion paths
Create summary pages using slide and summary zoom
Insert and edit charts, diagrams, and tables
Insert hyperlinks to other slides, external websites, and mail addresses
Create motion video backgrounds
Insert screenshots and record and narrate presentations
Work with the Slide Master to make universal changes
Incorporate third-party add-ins into PowerPoint
Prepare a presentation for delivery by adding speaker notes, header and footer, and comments
Set up a custom slide show and rehearsing timings
Use Presenter View to deliver a presentation
Export, share, and print a presentation

Outlook 2021

Work with the new simplified ribbon as part of the wider Outlook interface.
Configure a Microsoft and Gmail account.
Customize the Quick Access Toolbar.
Open and customize Outlook Today.
Know where to go to get Help.
Open, Read, Send and Receive mail.
Insert Attachments and Save Attachments from a Message.
Use the Search and Filter buttons to find Mail.
Flag Messages as Junk and work with the Blocked Senders List.
Ignore conversations that are no longer relevant.
Clean-up long conversation threads.
Organize mail using Follow-up Flags, Categories and Folders.
Make emails stand out using Conditional Formatting.
Process messages automatically using Rules.
Create Search Folders to re-run common searches.
Delete and Archive Mail.
Create and Format New Messages.
Resend and Recall a Message.
Reply and Forward Messages.
Create and Attach an Email Signature.
Add Voting Buttons to get feedback from recipients.
Set Delivery Options on messages.
Use mentions to target specific people.
Translate messages from one language to another.
Use Read Aloud to have messages read to you.
Send an Out of Office message.
Annotate and Draw using Ink.
Insert tables, shapes, icons and other media into messages.
Add new contacts.
Import multiple contacts from a CSV file into Outlook.
Organize contacts using contact groups and folders.
Share contacts with others.
Customize Calendar Settings.
Create Appointments, All Day Events and Meetings.
Use the Scheduler to find free time.
Respond to meeting invites.
Create a Microsoft Teams Meeting from within Outlook.
Add Delegates to manage your inbox on your behalf.
Share Calendars with others.
Create and edit tasks in the to do list.
Assign task to others and monitor the completion status.
Create and manage notes.
Customize Outlook Settings.
Clean-up a Mailbox that’s reached its size limit.

Excel 2021 Intermediate

Design better spreadsheets and control user input
Use logical functions to make better business decisions
Construct functional and flexible lookup formulas
Use Excel tables to structure data and make it easy to update
Extract unique values from a list
Sort and filter data using advanced features and new Excel formulas
Work with date and time functions
Extract data using text functions
Import data and clean it up before analysis
Analyze data using PivotTables
Represent data visually with PivotCharts
Add interactions to PivotTables and PivotCharts
Create an interactive dashboard to present high-level metrics
Audit formulas and troubleshoot common Excel errors
Control user input with data validation
Use WhatIf analysis tools to see how changing inputs affect outcomes

Excel 2021 Advanced

Using the NEW dynamic array functions to perform tasks
Creating advanced and flexible lookup formulas
Using statistical functions to rank data and to calculate the MEDIAN and MODE
Producing accurate results when working with financial data using math functions
Creating variables and functions with LET and LAMBDA
Analyzing data with advanced PivotTable and PivotChart hacks
Creating interactive reports and dashboards by incorporating form controls
Importing and cleaning data using Power Query
Predicting future values using forecast functions and forecast sheets
Recording and running macros to automate repetitive tasks
Understanding and making minor edits to VBA code
Combining functions to create practical formulas to complete specific tasks.

This bundle includes:

50+ hours of video tutorials
500+ individual video lectures
Course and exercise files to follow along
Certificate of completion

What's inside

Learning objectives

Become familiar with what’s new in excel 2021
Navigate the excel 2021 interface and create your first spreadsheet
Utilize useful keyboard shortcuts to increase productivity
Use basic and intermediate excel formulas and functions
Effectively apply formatting to cells and use conditional formatting
Use excel lists, master sorting and filtering, and work with views, zooms, and freezing panes
Work efficiently by using the cut, copy, and paste options
Analyze data using charts, insert pictures in a spreadsheet, and link to other worksheets and workbooks
Protect and share workbooks, set page layout and print options, and save your workbook in different file formats
Navigating the interface and mastering the most common uses of word 2021/365
Accessing and modifying word options and customizing the quick access toolbar
Creating new documents from scratch and from a template and switching between different document views
Applying and modifying word styles and annotating a document
Inserting content like shapes, icons, text boxes, 3d images, smartart, and charts
Applying headers and footers, creating a table of contents, and creating re-usable content with quick parts
Linking to websites, other documents, and other sections using hyperlinks and bookmarks
Creating multiple letters, envelopes, and labels using mail merge and tracking changes from multiple authors
Checking a document, sharing a document with others, and collaborating in real time
Creating visually stunning presentations that meet best practice guidelines
Improving efficiency with keyboard shortcuts and the quick access toolbar
Working with powerpoint templates and applying slide layouts to new or existing slides
Working with images, icons, video, text, shapes, audio files, animations, transitions, and motion paths
Correctly selecting, aligning, and grouping objects on a slide and inserting charts, diagrams, and tables

Creating motion video backgrounds, inserting screenshots, and recording/narrating presentations
Working with the slide master to make universal changes and incorporating third-party add-ins into powerpoint
Preparing a presentation for delivery by adding speaker notes, header and footer, and comments
Using presenter view to deliver a presentation and exporting, sharing, and printing a presentation
Work with the new simplified ribbon as part of the wider outlook 2021 interface and configure a microsoft and gmail account
Open and customize outlook today, customize outlook settings, and clean up a mailbox that’s reached its size limit
Open, read, send, and receive mail, insert attachments, save attachments from a message, and use the search and filter buttons to find mail
Ignore conversations that are no longer relevant, resend and recall a message, and flag messages as junk
Organize mail using follow-up flags, categories, and folders, and process messages automatically using rules
Create and attach an email signature, add voting buttons to get feedback from recipients, and set delivery options on messages
Translate messages from one language to another, send an out-of-office message, and draw using ink
Import multiple contacts from a csv file into outlook, organize contacts using contact groups and folders, and share contacts with others
Create appointments, all-day events, and meetings, use the scheduler to find free time, and create a microsoft teams meeting from within outlook
Add delegates to manage your inbox on your behalf, assign tasks to others, and monitor the completion status
Using the new dynamic array functions to perform tasks
Using statistical functions to rank data and to calculate the median and mode
Importing and cleaning data using power query
Recording and running macros to automate repetitive tasks
Understanding and making minor edits to vba code
Predicting future values using forecast functions and forecast sheets
Show more
Show less

Become familiar with what’s new in excel 2021
Navigate the excel 2021 interface and create your first spreadsheet
Utilize useful keyboard shortcuts to increase productivity
Use basic and intermediate excel formulas and functions
Effectively apply formatting to cells and use conditional formatting
Use excel lists, master sorting and filtering, and work with views, zooms, and freezing panes
Work efficiently by using the cut, copy, and paste options
Analyze data using charts, insert pictures in a spreadsheet, and link to other worksheets and workbooks
Protect and share workbooks, set page layout and print options, and save your workbook in different file formats
Navigating the interface and mastering the most common uses of word 2021/365
Accessing and modifying word options and customizing the quick access toolbar
Creating new documents from scratch and from a template and switching between different document views
Applying and modifying word styles and annotating a document
Inserting content like shapes, icons, text boxes, 3d images, smartart, and charts
Applying headers and footers, creating a table of contents, and creating re-usable content with quick parts
Linking to websites, other documents, and other sections using hyperlinks and bookmarks
Creating multiple letters, envelopes, and labels using mail merge and tracking changes from multiple authors
Checking a document, sharing a document with others, and collaborating in real time
Creating visually stunning presentations that meet best practice guidelines
Improving efficiency with keyboard shortcuts and the quick access toolbar
Working with powerpoint templates and applying slide layouts to new or existing slides
Working with images, icons, video, text, shapes, audio files, animations, transitions, and motion paths
Correctly selecting, aligning, and grouping objects on a slide and inserting charts, diagrams, and tables
Creating motion video backgrounds, inserting screenshots, and recording/narrating presentations
Working with the slide master to make universal changes and incorporating third-party add-ins into powerpoint
Preparing a presentation for delivery by adding speaker notes, header and footer, and comments
Using presenter view to deliver a presentation and exporting, sharing, and printing a presentation
Work with the new simplified ribbon as part of the wider outlook 2021 interface and configure a microsoft and gmail account
Open and customize outlook today, customize outlook settings, and clean up a mailbox that’s reached its size limit
Open, read, send, and receive mail, insert attachments, save attachments from a message, and use the search and filter buttons to find mail
Ignore conversations that are no longer relevant, resend and recall a message, and flag messages as junk
Organize mail using follow-up flags, categories, and folders, and process messages automatically using rules
Create and attach an email signature, add voting buttons to get feedback from recipients, and set delivery options on messages
Translate messages from one language to another, send an out-of-office message, and draw using ink
Import multiple contacts from a csv file into outlook, organize contacts using contact groups and folders, and share contacts with others
Create appointments, all-day events, and meetings, use the scheduler to find free time, and create a microsoft teams meeting from within outlook
Add delegates to manage your inbox on your behalf, assign tasks to others, and monitor the completion status
Using the new dynamic array functions to perform tasks
Using statistical functions to rank data and to calculate the median and mode
Importing and cleaning data using power query
Recording and running macros to automate repetitive tasks
Understanding and making minor edits to vba code
Predicting future values using forecast functions and forecast sheets
Show more
Show less

Syllabus

Excel 2021 Beginners: Introduction

About This Bundle

Course Introduction

WATCH ME: Essential Information for a Successful Training Experience

Traffic lights

Read about what's good

what should give you pause

and possible dealbreakers

Covers Excel, Word, PowerPoint, and Outlook, which are essential tools for creating documents, presentations, managing emails, and analyzing data in professional settings

Teaches learners how to create professional-looking documents, presentations, and spreadsheets, which are useful skills for academic assignments and research

Progresses from basic Excel functions to intermediate and advanced topics, such as dynamic arrays, Power Query, and VBA, which allows learners to gradually build their skills

Explores data analysis using PivotTables, PivotCharts, and forecast functions, which are valuable tools for extracting insights and making data-driven decisions

Focuses on the 2021 versions of Microsoft Office applications, so learners should be aware that some features and interfaces may differ from older versions

Focuses on the 365 versions of Microsoft Office applications, so learners should be aware that some features and interfaces may differ from older versions

Reviews summary

Comprehensive microsoft office 2021/365 training bundle

According to learners, this bundle is a highly comprehensive resource covering the core Microsoft Office applications: Excel (Beginner, Intermediate, and Advanced), Word, PowerPoint, and Outlook. Many found the instructor's teaching style to be clear and engaging, making complex topics easy to understand. The inclusion of downloadable exercise files was frequently highlighted as a major benefit, allowing for practical, hands-on learning. While the breadth of content is a strength, some note that the pace may vary in suitability depending on your existing skill level.

Pace might vary depending on prior experience.

"If you're a complete beginner, the pace is probably just right, but if you have some experience, parts might feel a bit slow."

"For someone already familiar with basics, the initial sections might be a bit tedious, but it picks up."

"I found some of the introductory parts covered ground I already knew, but it was a good refresher."

"The intermediate and advanced sections move at a good clip, assuming you grasped the fundamentals."

In-depth coverage of Excel at multiple skill levels.

"The intermediate and advanced Excel sections were particularly useful for taking my skills to the next level."

"Learned so many new formulas and functions I didn't know existed, especially in the advanced Excel parts."

"The PivotTable and Power Query modules in Excel were incredibly informative and practical."

"Excellent coverage of Excel features from basic data entry to complex functions and analysis."

"The dynamic array functions section in advanced Excel was a great addition."

Exercise files allow for valuable hands-on practice.

"The downloadable exercise files are essential; I couldn't have learned as effectively without them."

"Working through the examples with the instructor using the provided files solidified my understanding."

"The hands-on practice using the exercise files made a huge difference in retaining the information."

"I loved being able to pause the video and work on the exact file the instructor was using."

"Plenty of exercises to practice what you learn, which is great for real-world application."

Instructor explains concepts clearly and is easy to follow.

"The instructor is very clear and easy to understand, which makes learning complex functions much simpler."

"I appreciate the instructor's teaching style; it's engaging and keeps me focused through the long lectures."

"Simon Sez IT consistently delivers with knowledgeable and patient instructors. This course is no exception."

"He breaks down the topics well and provides helpful tips along the way."

"I found the explanations straightforward and the demonstrations very helpful."

Covers multiple Office apps from beginner to advanced levels.

"This bundle covers everything I needed across Excel, Word, and PowerPoint. A true one-stop shop."

"The range from beginner to advanced Excel is fantastic and offers great value for money."

"I was impressed by how much content was packed into this course bundle."

"Getting training on Word, Excel, PowerPoint, and Outlook all in one place is incredibly convenient."

"The different levels for Excel are perfect for users with varying degrees of prior experience."

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 The Ultimate Microsoft Office 2021/365 Training Bundle with these activities:

Review Excel Basics

Show steps

Refamiliarize yourself with fundamental Excel concepts to ensure a solid foundation for the course.

Browse courses on Excel Basics

Show steps

Review basic formulas and functions.
Practice creating and formatting simple spreadsheets.
Familiarize yourself with the Excel interface.

Excel 2021 Bible

Show steps

Supplement your learning with a comprehensive guide to Excel 2021.

View Excel 2019 Bible on Amazon

Show steps

Read relevant chapters based on course topics.
Practice the examples provided in the book.
Use the book as a reference for specific Excel functions and features.

Excel Formula Challenge

Show steps

Sharpen your Excel formula skills through targeted practice exercises.

Show steps

Complete online Excel formula challenges.
Focus on VLOOKUP, IF, and SUMIF functions.
Review solutions and understand the logic behind each formula.

Four other activities

Expand to see all activities and additional details

Show all seven activities

Microsoft Outlook 2021 Step by Step

Show steps

Enhance your Outlook skills with a step-by-step guide.

View Microsoft Word Step by Step (Office 2021 and... on Amazon

Show steps

Work through the exercises in the book.
Focus on the features covered in the Outlook section of the course.
Use the book as a reference for specific Outlook tasks.

Create a PowerPoint Presentation on a Topic of Interest

Show steps

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

Show steps

Choose a topic that interests you.
Create an outline for your presentation.
Design visually appealing slides with relevant content.
Practice your presentation delivery.

Automate a Task with Excel Macros

Show steps

Apply your knowledge by automating a repetitive task using Excel macros, enhancing your efficiency.

Show steps

Identify a repetitive task in your workflow.
Record a macro to automate the task.
Test and refine the macro for optimal performance.
Document the macro's functionality and usage.

Follow Advanced Excel Tutorials

Show steps

Refine your advanced Excel skills by following guided tutorials on specific topics.

Show steps

Identify areas where you want to improve your Excel skills.
Find reputable online tutorials on those topics.
Follow the tutorials step-by-step and practice the techniques.

Career center

Learners who complete The Ultimate Microsoft Office 2021/365 Training Bundle will develop knowledge and skills that may be useful to these careers:

Administrative Assistant

An administrative assistant relies heavily on software like Microsoft Office, and this course provides a comprehensive understanding of the core programs. The course covers essential skills in Excel, Word, PowerPoint, and Outlook, all of which are used daily by an administrative assistant to create documents, manage emails, schedule appointments, and prepare presentations. This training helps increase efficiency by teaching shortcuts and advanced features. This course is ideal for anyone wanting to sharpen their office skills.

See salaries and explore the career path for Administrative Assistant

Executive Assistant

An executive assistant often prepares presentations, documents, and manages schedules, making this Microsoft Office course very applicable. Mastery of Excel, Word, PowerPoint, and Outlook is crucial for an executive assistant, and this training provides comprehensive coverage of each program. The course teaches skills including document creation, data analysis, presentation design, and email management. This course can help an executive assistant better utilize Microsoft Office products.

See salaries and explore the career path for Executive Assistant

Office Manager

An office manager must be proficient in a range of office software, and this course on Microsoft Office helps make an office manager successful. The course covers Excel, Word, PowerPoint, and Outlook in depth, all of which are needed to manage office communications, prepare reports, coordinate events, and handle data. An office manager uses these skills daily. This course teaches efficient methods for formatting, analyzing, and sharing data. Anyone who wishes to be an office manager should take this course.

See salaries and explore the career path for Office Manager

Project Coordinator

A project coordinator often works with schedules, spreadsheets, and presentations, and this course provides the necessary skills in Microsoft Office to do so. The course extensively covers Excel, Word, PowerPoint, and Outlook. These applications are needed by a project coordinator to track project progress, create reports, communicate with teams, and present project updates. Skills in time management and data organization that are taught in this course may also be of assistance to a project coordinator.

See salaries and explore the career path for Project Coordinator

Data Analyst

A data analyst frequently uses Excel to manage and analyze data, making the Excel content of this course highly relevant. This course includes in-depth training on Excel 2021, with sections for beginners, intermediate, and advanced users. It covers formulas, functions, data analysis tools like PivotTables, and data import techniques, which are essential for data analysts to perform their daily tasks efficiently. This course would assist any aspiring data analyst to properly prepare data for analysis.

See salaries and explore the career path for Data Analyst

Financial Analyst

A financial analyst heavily relies on Excel to perform financial modeling and analysis. This course includes advanced Excel training, which is essential for financial analysts' day-to-day operations. The training covers in depth topics useful for a financial analyst, including formulas, functions, PivotTables, data analysis, and forecasting. Mastery of Excel is crucial for anyone who wishes to become a financial analyst. This course can be helpful to anyone who wishes to enter this field.

See salaries and explore the career path for Financial Analyst

Business Analyst

A business analyst uses Microsoft Office products daily, and this course helps build a foundation in these applications. This course includes comprehensive training in Excel, Word, PowerPoint, and Outlook. It provides a business analyst the necessary skills in data analysis, report generation, presentation design, and communications management. The course's coverage of advanced Excel features will be particularly helpful. Anyone who wishes to become a business analyst can begin by taking this course.

See salaries and explore the career path for Business Analyst

Marketing Coordinator

A marketing coordinator often needs to create marketing materials and track campaign data, making this Microsoft Office training a valuable resource. This course covers Excel, Word, PowerPoint, and Outlook, which are used to develop marketing reports, presentations, and email campaigns. Skills learned include using Excel for data analysis, Word for content creation, PowerPoint for presentations, and Outlook for managing communications. This course may be useful for marketing coordinators who want to increase productivity.

See salaries and explore the career path for Marketing Coordinator

Research Assistant

A research assistant often works with data, documents, and presentations. This course covers the essential Microsoft Office tools necessary for the job. The course includes comprehensive training in Excel for data analysis, Word for report writing, and PowerPoint for presenting findings. An understanding of Outlook for communication is also covered in this course. Skills learned in this training can be useful to increase the efficiency of a research assistant.

See salaries and explore the career path for Research Assistant

Training Specialist

A training specialist often creates training materials, presentations, and handouts, making this Microsoft Office course helpful. This training features courses in Word for creating handouts, PowerPoint for presentations, and Excel for organizing data. This course can assist a training specialist to more effectively manage their work and prepare materials for their training sessions. This course can be a good fit for a training specialist who wants to improve their technical skills.

See salaries and explore the career path for Training Specialist

Technical Writer

A technical writer uses Microsoft Word to create documentation, making this course quite useful for entry into the field. This course includes extensive training in Word 2021, covering everything from formatting documents to using advanced features like styles, tables of contents, and mail merge. The course also includes training in other office tools that technical writers might find helpful. Anyone who wants to be a technical writer should consider enrolling in this course.

See salaries and explore the career path for Technical Writer

Sales Representative

A sales representative often uses Microsoft Office programs to build client presentations, manage contact information, and track sales data. This course covers Excel, Word, PowerPoint, and Outlook, all of which are useful for sales representatives. The training includes creating presentations, managing communications, and utilizing data analysis. Proficiency in these programs will help a sales representative better manage their workflow. This course may be useful to sales representatives seeking to improve their office skills.

See salaries and explore the career path for Sales Representative

Freelancer

A freelancer often needs to manage their own documentation, presentations, and communications, and this training in Microsoft Office can be quite helpful. This course covers the four main Microsoft Office programs: Excel, Word, PowerPoint, and Outlook. It includes training in creating documents, analyzing data, designing presentations, and managing communications. A freelancer may find this course can help streamline their business work. This course may be useful for a freelancer who wishes to increase efficiency.

See salaries and explore the career path for Freelancer

Customer Service Representative

A customer service representative uses email and documentation, making this training helpful. This course covers core Microsoft Office programs including Outlook, Word, and Excel. These programs are helpful to customer service representatives who need to manage communications, create written standard operating procedures, and organize data. The course will allow a customer service representative to better handle the day-to-day tasks of the job. This course may be useful in acquiring these skills.

See salaries and explore the career path for Customer Service Representative

Teacher

A teacher can use Microsoft Office to create lesson plans, presentations, and assignments, so this course may be useful. The course covers Word, Excel, and PowerPoint, which are all helpful to teachers. This training can help a teacher more effectively manage classroom documents and develop attractive presentations. Skills learned in this training may assist in a teacher's daily workflow. This course may be appealing to teachers seeking to improve their technology skills.

See salaries and explore the career path for Teacher

The Ultimate Microsoft Office 2021/365 Training Bundle

What's inside

Learning objectives

Syllabus

Traffic lights

Save this course

Reviews summary

Comprehensive microsoft office 2021/365 training bundle

Activities

Career center

Reading list

Share

Similar courses