The Ultimate Microsoft Office 2021/365 Training Bundle | Udemy


The Ultimate Microsoft Office 2021/365 Training Bundle | Udemy [Update 01/2023]
English | Size:
Genre: eLearning

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

What you’ll 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

**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:

  1. 50+ hours of video tutorials
  2. 500+ individual video lectures
  3. Course and exercise files to follow along
  4. Certificate of completion

Who this course is for:

  • Users new to Microsoft Office 2021 and those upgrading from previous software versions
  • Anyone who wants to be more productive at work and organize their spreadsheets, documents, mail, calendar, or presentations
  • Users who are brand new to Excel or those who have a foundation of Excel and seeking to advance their Excel 2021/365 knowledge

nitroflare.com/view/CD27BD80075BD00/TheUltimateMicrosoftOffice2021365TrainingBundle.part01.rar
nitroflare.com/view/0C403F3192C43BA/TheUltimateMicrosoftOffice2021365TrainingBundle.part02.rar
nitroflare.com/view/7A0B8B827B387E6/TheUltimateMicrosoftOffice2021365TrainingBundle.part03.rar
nitroflare.com/view/248BEE3EC37DF5D/TheUltimateMicrosoftOffice2021365TrainingBundle.part04.rar
nitroflare.com/view/1239B72F36FF621/TheUltimateMicrosoftOffice2021365TrainingBundle.part05.rar
nitroflare.com/view/7CC86D8070B6409/TheUltimateMicrosoftOffice2021365TrainingBundle.part06.rar
nitroflare.com/view/97EE3B387449FBE/TheUltimateMicrosoftOffice2021365TrainingBundle.part07.rar
nitroflare.com/view/21658F6271474D6/TheUltimateMicrosoftOffice2021365TrainingBundle.part08.rar
nitroflare.com/view/1B139BFBD90B73E/TheUltimateMicrosoftOffice2021365TrainingBundle.part09.rar
nitroflare.com/view/6AF1DFFEE71B9FA/TheUltimateMicrosoftOffice2021365TrainingBundle.part10.rar
nitroflare.com/view/CBE32A6BA194000/TheUltimateMicrosoftOffice2021365TrainingBundle.part11.rar
nitroflare.com/view/0CB0A1B741C2392/TheUltimateMicrosoftOffice2021365TrainingBundle.part12.rar
nitroflare.com/view/36CA9EB9FFF90D8/TheUltimateMicrosoftOffice2021365TrainingBundle.part13.rar
nitroflare.com/view/B4507234B6E861B/TheUltimateMicrosoftOffice2021365TrainingBundle.part14.rar
nitroflare.com/view/B75FA1082E7A46B/TheUltimateMicrosoftOffice2021365TrainingBundle.part15.rar
nitroflare.com/view/0E32A5FA2181A41/TheUltimateMicrosoftOffice2021365TrainingBundle.part16.rar
nitroflare.com/view/8B4C2D14B02D90A/TheUltimateMicrosoftOffice2021365TrainingBundle.part17.rar
nitroflare.com/view/E66B7E6E0A07E18/TheUltimateMicrosoftOffice2021365TrainingBundle.part18.rar
nitroflare.com/view/C6C4E4EAB8B1797/TheUltimateMicrosoftOffice2021365TrainingBundle.part19.rar
nitroflare.com/view/CEB2C6BEFDF5D6A/TheUltimateMicrosoftOffice2021365TrainingBundle.part20.rar
nitroflare.com/view/CD90619B1DFBEB0/TheUltimateMicrosoftOffice2021365TrainingBundle.part21.rar
nitroflare.com/view/0CC1B5044F0305C/TheUltimateMicrosoftOffice2021365TrainingBundle.part22.rar
nitroflare.com/view/E5A473823035F57/TheUltimateMicrosoftOffice2021365TrainingBundle.part23.rar
nitroflare.com/view/C0E7858E94F0C5D/TheUltimateMicrosoftOffice2021365TrainingBundle.part24.rar
nitroflare.com/view/28201085625198B/TheUltimateMicrosoftOffice2021365TrainingBundle.part25.rar
nitroflare.com/view/63582FD6BEE9199/TheUltimateMicrosoftOffice2021365TrainingBundle.part26.rar
nitroflare.com/view/EBB3D45CE565853/TheUltimateMicrosoftOffice2021365TrainingBundle.part27.rar
nitroflare.com/view/04F2DB35A0AA837/TheUltimateMicrosoftOffice2021365TrainingBundle.part28.rar
nitroflare.com/view/BBFEF80A0C0D150/TheUltimateMicrosoftOffice2021365TrainingBundle.part29.rar
nitroflare.com/view/B526353DE24FE0E/TheUltimateMicrosoftOffice2021365TrainingBundle.part30.rar
nitroflare.com/view/312D7BBB499CB5E/TheUltimateMicrosoftOffice2021365TrainingBundle.part31.rar
nitroflare.com/view/2E33F1FDF450A01/TheUltimateMicrosoftOffice2021365TrainingBundle.part32.rar
nitroflare.com/view/18B173FDD579C48/TheUltimateMicrosoftOffice2021365TrainingBundle.part33.rar
nitroflare.com/view/0C7DB4D1F1E1713/TheUltimateMicrosoftOffice2021365TrainingBundle.part34.rar
nitroflare.com/view/7F3D4715CD2EF3B/TheUltimateMicrosoftOffice2021365TrainingBundle.part35.rar
nitroflare.com/view/47788A8DEF7D675/TheUltimateMicrosoftOffice2021365TrainingBundle.part36.rar
nitroflare.com/view/6A0CFD6475AF709/TheUltimateMicrosoftOffice2021365TrainingBundle.part37.rar
nitroflare.com/view/91E8739386B92BD/TheUltimateMicrosoftOffice2021365TrainingBundle.part38.rar
nitroflare.com/view/648C659D202B6F4/TheUltimateMicrosoftOffice2021365TrainingBundle.part39.rar

rapidgator.net/file/ea79d732d7a3c1a53b4d9497eac657e4/TheUltimateMicrosoftOffice2021365TrainingBundle.part01.rar.html
rapidgator.net/file/e8f99616d4a79143e27434401dd93fb7/TheUltimateMicrosoftOffice2021365TrainingBundle.part02.rar.html
rapidgator.net/file/76137c5253216dfc74030a73bcae86df/TheUltimateMicrosoftOffice2021365TrainingBundle.part03.rar.html
rapidgator.net/file/0e2688fa02384c78bc8c01b569aafa71/TheUltimateMicrosoftOffice2021365TrainingBundle.part04.rar.html
rapidgator.net/file/bea184c6a22a71c32d48af9185306341/TheUltimateMicrosoftOffice2021365TrainingBundle.part05.rar.html
rapidgator.net/file/1c799afde9e451b0273091e32cc64d27/TheUltimateMicrosoftOffice2021365TrainingBundle.part06.rar.html
rapidgator.net/file/bb60e08eb7d9de1e65c6e5ddb22863a5/TheUltimateMicrosoftOffice2021365TrainingBundle.part07.rar.html
rapidgator.net/file/62a93689173d7761825844ffcd4b5ec1/TheUltimateMicrosoftOffice2021365TrainingBundle.part08.rar.html
rapidgator.net/file/0a2bcd8372ba98e5801bfebdabe7cb23/TheUltimateMicrosoftOffice2021365TrainingBundle.part09.rar.html
rapidgator.net/file/6807b59e8792250baf014a30b52eb477/TheUltimateMicrosoftOffice2021365TrainingBundle.part10.rar.html
rapidgator.net/file/e55bfb2634faca5f207fe757bc0d58d9/TheUltimateMicrosoftOffice2021365TrainingBundle.part11.rar.html
rapidgator.net/file/0771cd738e21f7c9ef8ce57d67fab77e/TheUltimateMicrosoftOffice2021365TrainingBundle.part12.rar.html
rapidgator.net/file/cee8ceb6536e77cbe410736d42d83f3e/TheUltimateMicrosoftOffice2021365TrainingBundle.part13.rar.html
rapidgator.net/file/234946a9fd61d9c49dcad4df4da55afe/TheUltimateMicrosoftOffice2021365TrainingBundle.part14.rar.html
rapidgator.net/file/6ed0b3b3c3c0d5f6a4e48f4baba4f9fa/TheUltimateMicrosoftOffice2021365TrainingBundle.part15.rar.html
rapidgator.net/file/d1cf6452c2e797458835aab01ca82a95/TheUltimateMicrosoftOffice2021365TrainingBundle.part16.rar.html
rapidgator.net/file/eb7a62d964ec83c682ddba1a50d3657e/TheUltimateMicrosoftOffice2021365TrainingBundle.part17.rar.html
rapidgator.net/file/a3a233a39d57c6aa7e91859f91ab33a7/TheUltimateMicrosoftOffice2021365TrainingBundle.part18.rar.html
rapidgator.net/file/1adea47071a0c927aab9e58006d86a68/TheUltimateMicrosoftOffice2021365TrainingBundle.part19.rar.html
rapidgator.net/file/32166b51b71f66090a69267245e60ecb/TheUltimateMicrosoftOffice2021365TrainingBundle.part20.rar.html
rapidgator.net/file/608d222e65b00229707b864a0f058bed/TheUltimateMicrosoftOffice2021365TrainingBundle.part21.rar.html
rapidgator.net/file/d52b370ada9a6d40fba528db0db4ab52/TheUltimateMicrosoftOffice2021365TrainingBundle.part22.rar.html
rapidgator.net/file/963f40b3317592e36a6100fac0e60996/TheUltimateMicrosoftOffice2021365TrainingBundle.part23.rar.html
rapidgator.net/file/2a691a8933a82054820b09ac660781f7/TheUltimateMicrosoftOffice2021365TrainingBundle.part24.rar.html
rapidgator.net/file/89602ef57e0cc0e48f08ea4597047a64/TheUltimateMicrosoftOffice2021365TrainingBundle.part25.rar.html
rapidgator.net/file/a049267073fcf9ceada05f43c1bc6c9a/TheUltimateMicrosoftOffice2021365TrainingBundle.part26.rar.html
rapidgator.net/file/91a9703989c9ddb7cb546b9b6382fbcf/TheUltimateMicrosoftOffice2021365TrainingBundle.part27.rar.html
rapidgator.net/file/e7125177479744dc7770384d96f9f70a/TheUltimateMicrosoftOffice2021365TrainingBundle.part28.rar.html
rapidgator.net/file/abe46e6ef1d9a7dd75d140d7a5bced7d/TheUltimateMicrosoftOffice2021365TrainingBundle.part29.rar.html
rapidgator.net/file/59dcfde5635d2b2beca916b862ef98d0/TheUltimateMicrosoftOffice2021365TrainingBundle.part30.rar.html
rapidgator.net/file/82bef7ede5567fa2f4c69cc16efce2eb/TheUltimateMicrosoftOffice2021365TrainingBundle.part31.rar.html
rapidgator.net/file/bcfed06be10d7722233abe3f5ca0d873/TheUltimateMicrosoftOffice2021365TrainingBundle.part32.rar.html
rapidgator.net/file/bca95862c1cee6b65546b733e5fce895/TheUltimateMicrosoftOffice2021365TrainingBundle.part33.rar.html
rapidgator.net/file/f05fb6888c6f23e29e69517b7933cc6d/TheUltimateMicrosoftOffice2021365TrainingBundle.part34.rar.html
rapidgator.net/file/589be037df759e4a4e49522278fcc81c/TheUltimateMicrosoftOffice2021365TrainingBundle.part35.rar.html
rapidgator.net/file/b06102b1567deee221138b71f215d8e0/TheUltimateMicrosoftOffice2021365TrainingBundle.part36.rar.html
rapidgator.net/file/f7bf345a9c02256e8be99f9b219de13e/TheUltimateMicrosoftOffice2021365TrainingBundle.part37.rar.html
rapidgator.net/file/11adf67509150e99bb714ee0cc98fccd/TheUltimateMicrosoftOffice2021365TrainingBundle.part38.rar.html
rapidgator.net/file/d1ce45dc8601278ae95acbbe39c4605b/TheUltimateMicrosoftOffice2021365TrainingBundle.part39.rar.html

If any links die or problem unrar, send request to
forms.gle/e557HbjJ5vatekDV9

Leave a Comment