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.

Created by: Simon Sez IT
990,000+ Students, 290+ Courses, Learners in 180+ Countries

What Will I 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

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

Target audience

• 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