Microsoft Office 2021/365 Essentials Bundle (Udemy.com)

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

Learn Excel (beginner and intermediate), PowerPoint, Word, and Outlook 2021 with this tremendous value five-course bundle from Office experts 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 three essential MS Office programs (Excel, PowerPoint, Word, and Outlook) simple to understand. The bundle includes five full-length courses to help you achieve your goals: Excel 2021 for Beginners, Excel 2021 Intermediate, PowerPoint 2021 for Beginners, Word 2021 for Beginners, and Outlook 2021 for Beginners.

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

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

PowerPoint 2021 for Beginners

• 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

Word 2021 for Beginners

• 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

Outlook 2021

• Work with the new simplified ribbon as part of the wider Outlook interface.

• Configure a Microsoft and Gmail account.