The Ultimate Microsoft Office 2021/365 Training Bundle

The Ultimate Microsoft Office 2021/365 Training Bundle, available at $84.99, has an average rating of 4.6, with 558 lectures, 83 quizzes, based on 1489 reviews, and has 8699 subscribers.

You will learn about 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 course is ideal for individuals who are Users new to Microsoft Office 2021 and those upgrading from previous software versions or Anyone who wants to be more productive at work and organize their spreadsheets, documents, mail, calendar, or presentations or Users who are brand new to Excel or those who have a foundation of Excel and seeking to advance their Excel 2021/365 knowledge It is particularly useful for Users new to Microsoft Office 2021 and those upgrading from previous software versions or Anyone who wants to be more productive at work and organize their spreadsheets, documents, mail, calendar, or presentations or Users who are brand new to Excel or those who have a foundation of Excel and seeking to advance their Excel 2021/365 knowledge.

Enroll now: The Ultimate Microsoft Office 2021/365 Training Bundle

Summary

Title: The Ultimate Microsoft Office 2021/365 Training Bundle

Price: $84.99

Average Rating: 4.6

Number of Lectures: 558

Number of Quizzes: 83

Number of Published Lectures: 558

Number of Published Quizzes: 83

Number of Curriculum Items: 641

Number of Published Curriculum Objects: 641

Original Price: $199.99

Quality Status: approved

Status: Live

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

Who Should Attend

• 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

Target Audiences

• 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