The Ultimate Microsoft Office 2021/365 Training Bundle

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

4.56 (1978 reviews)

Udemy

platform

English

language

Microsoft

What you will learn

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

The Ultimate Microsoft Office 2021/365 Training Bundle

What you will learn

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