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'll 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

Requirements
Microsoft Office 2021 or 365 applications (Excel, Word, PowerPoint, and Outlook) installed on your computer.
No prior knowledge of Excel, Word, PowerPoint, or Outlook is required

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 BeginnersBecome familiar with what’s new in Excel 2021Navigate the Excel 2021 interfaceUtilize useful keyboard shortcuts to increase productivityCreate your first Excel spreadsheetUse basic and intermediate Excel formulas and functionsEffectively apply formatting to cells and use conditional formattingUse Excel lists and master sorting and filteringWork efficiently by using the cut, copy, and paste optionsLink to other worksheets and workbooksAnalyze data using chartsInsert pictures in a spreadsheetWork with views, zooms, and freezing panesSet page layout and print optionsProtect and share workbooksSave your workbook in different file formatsExcel 2021 IntermediateDesign better spreadsheets and control user inputUse logical functions to make better business decisionsConstruct functional and flexible lookup formulasUse Excel tables to structure data and make it easy to updateExtract unique values from a listSort and filter data using advanced features and new Excel formulasWork with date and time functionsExtract data using text functionsImport data and clean it up before analysisAnalyze data using PivotTablesRepresent data visually with PivotChartsAdd interactions to PivotTables and PivotChartsCreate an interactive dashboard to present high-level metricsAudit formulas and troubleshoot common Excel errorsControl user input with data validationUse WhatIf analysis tools to see how changing inputs affect outcomesPowerPoint 2021 for BeginnersCreate visually stunning presentations that meet best practice guidelinesFind free, high-quality resources like images, icons, fonts, and videosImprove efficiency with keyboard shortcuts and the Quick Access ToolbarOpen, close, and save presentationsWork with PowerPoint templatesApply slide layouts to new or existing slidesDuplicate, arrange, copy, and paste slides and objectsWork with images, icons, video, text, shapes, and audio filesCorrectly select, align, and group objects on a slideWork with animations, transitions, and motion pathsCreate summary pages using slide and summary zoomInsert and edit charts, diagrams, and tablesInsert hyperlinks to other slides, external websites, and mail addressesCreate motion video backgroundsInsert screenshots and record and narrate presentationsWork with the Slide Master to make universal changesIncorporate third-party add-ins into PowerPointPrepare a presentation for delivery by adding speaker notes, header and footer, and commentsSet up a custom slide show and rehearsing timingsUse Presenter View to deliver a presentationExport, share, and print a presentationWord 2021 for BeginnersNavigate the Word 2021 interfaceCustomize the quick access toolbarAccess and modify Word optionsCreate new documents from scratch and from a templateOpen and save existing documentsSwitch between different document viewsEnter, select, and apply formatting to textUse cut, copy, paste, and different paste optionsFind and replace text in a documentFormat paragraphsAlign paragraphs using indents and tab stopsInsert bulleted and numbered listsApply a theme to control the look and feel of the documentApply and modify Word stylesInsert content like shapes, icons, text boxes, 3D images, SmartArt, and chartsAnnotate a documentOrganize information using tablesAdjust the margins and orientationInsert section and page breaksApply headers and footersInsert blank pages and cover pagesLink to websites, other documents, and other sections using hyperlinks and bookmarksCreate re-usable content with Quick PartsCreate and format a table of contentsAdd footnotes and end notes to a documentCreate citations and inserting a bibliographyCreate an indexAdd captions to pictures and create a table of figuresCreate multiple letters, envelopes, and labels using mail mergeCheck spelling and set up auto-correct optionsTrack changes from multiple authorsCompare and combine documentsAdjust document propertiesCheck a document for accessibility and compatibility issuesProtect a document to prevent changesShare a document with othersCollaborate on a document with others in real timePrint a documentOutlook 2021Work 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 tutorials400+ individual video lecturesCourse and exercise files to follow alongCertificate of completion

Who this course is for:
Users of Microsoft 2021 and those upgrading from previous software versions, Users who have Microsoft Office foundation and seeking to advance their Word, Excel, Outlook, and/or PowerPoint knowledge., Anyone who wants to be more productive at work and organize their spreadsheets, documents, mail, calendar, or presentations