Microsoft Office 2021/365 Essentials Bundle
Learn the essentials of Microsoft Office in this 5-course bundle for Office 365 or Office 2021 users.
What you will learn
What’s new in Excel 2021
Navigating the Excel 2021 interface
Analyzing data using PivotTables and representing data visually with charts and PivotCharts
Adding interactions to PivotTables and PivotCharts
Creating an interactive dashboard to present high-level metrics
Auditing formulas and troubleshooting common Excel errors
How to use Excel tables to structure data and make it easy to update
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
Ignore conversations that are no longer relevant, resend and recall a message, and flag messages as junk
Translate messages from one language to another, send an out-of-office message, and draw using ink
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
Navigating the interface and mastering the most common uses of Word 2021/365
Creating new documents from scratch and from a template and switching between different document views
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
Checking a document, sharing a document with others, and collaborating in real time
Working with PowerPoint templates and applying slide layouts to new or existing slides
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
Description
**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.
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.
This bundle includes:
40+ hours of video tutorials
400+ individual video lectures
Course and exercise files to follow along
Certificate of completion
Content
Excel 2021 Beginner: Introduction
Excel 2021 Beginner: Getting Started in Excel 2021
Excel 2021 Beginner: Creating You First Excel Spreadsheet
Excel 2021 Beginner: Introduction to Excel Formulas and Functions
Excel 2021 Beginner: Using Named Ranges
Excel 2021 Beginner: Formatting Numbers and Cells
Excel 2021 Beginner: Formatting Worksheets
Excel 2021 Beginner: Working with Excel Lists
Excel 2021 Beginner: Moving and Linking to Data
Excel 2021 Beginner: An Introduction to Intermediate Formulas
Excel 2021 Beginner: Analyzing Data with Charts
Excel 2021 Beginner: Conditional Formatting
Excel 2021 Beginner: Inserting Items into a Spreadsheet
Excel 2021 Beginner: Working with Views and Zoom
Excel 2021 Beginner: Page Layout and Print Options
Excel 2021 Beginner: Finalizing the Spreadsheet
Excel 2021 Beginner: Course Close
Excel 2021 Intermediate: Introduction
Excel 2021 Intermediate: Designing Better Spreadsheets
Excel 2021 Intermediate: Making Decisions with Logical Functions
Excel 2021 Intermediate: Looking Up Information
Excel 2021 Intermediate: Advanced Sorting and Filtering
Excel 2021 Intermediate: Working with Date and Time
Excel 2021 Intermediate: Preparing Data for Analysis
Excel 2021 Intermediate: PivotTables
Excel 2021 Intermediate: Pivot Charts
Excel 2021 Intermediate: Adding Interaction to PivotTables and Charts
Excel 2021 Intermediate: Interactive Dashboards
Excel 2021 Intermediate: Formula Auditing
Excel 2021 Intermediate: Data Validation
Excel 2021 Intermediate: WhatIf Analysis Tools
Excel 2021 Intermediate: Course Close
PowerPoint 2021: Introduction
PowerPoint 2021: Getting Started in PowerPoint 2021
PowerPoint 2021: Slides and Layouts
Slide Workshop: Title Slide
PowerPoint 2021: Selection, Alignment and Grouping
Slide Workshop: Meet The Team
Slide Workshop: Divider Slides
Slide Workshop: Our Destinations
Slide Workshop: Tables, Charts and Diagrams
PowerPoint 2021: More Graphics
PowerPoint 2021: Video, Audio and Screenshots
Slide Workshop: Transitions, Zoom and Motion Paths
PowerPoint 2021: Master Slides
PowerPoint 2021: Extending PowerPoint with Add-ins
PowerPoint 2021: Preparing Slides for Delivery
PowerPoint 2021: Delivering a Presentation
PowerPoint 2021: Exporting, Sharing and Printing
PowerPoint 2021: Course Close
Word 2021: Introduction
Word 2021: The Basics
Word 2021: Get Started - Work with Documents
Word 2021: View Documents
Word 2021: Work with Text
Word 2021: Work with Paragraphs
Word 2021: Themes
Word 2021: Word Styles
Word 2021: Insert Pictures, Tables and Other Objects
Word 2021: Format Pages
Word 2021: References
Word 2021: Mail Merge
Word 2021: Spelling and Grammar
Word 2021: Track Changes and Comments
Word 2021: Finalize a Document
Word 2021: Course Close
Reviews
Coupons
Submit by | Date | Coupon Code | Discount | Emitted/Used | Status |
---|---|---|---|---|---|
- | 10/1/2022 | BESTSEPT2 | 88% OFF | expired |