Microsoft Office 2021/365 Essentials Bundle
Five must-have courses for mastering Microsoft Office
The 5-Course Microsoft Office 2021/365 Essentials Bundle
If mastering Microsoft's most popular software applications has been on your to-do list, then this is the training bundle for you.
Composed of five full-length courses, hundreds of individual video lectures, and exercise files and tests, this training bundle is jam-packed with practical tips, tricks and information essential for your success with Microsoft.
Microsoft Excel 2021/365 - Beginners Course
What you'll learn:
- What’s new in Excel 2021
- Navigate the Excel 2021 interface
- Useful keyboard shortcuts to increase productivity
- Create your first Excel spreadsheet
- Basic and intermediate Excel formulas and functions
- Effectively apply formatting to cells and use conditional formatting
- Smartly use of Excel lists and sorting and filtering
- Use the cut, copy, and paste options
- Link to other worksheets and workbooks
- Analyze data using charts
- Insert pictures into 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
Master Microsoft PowerPoint 2021:
What you'll learn:
- 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/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 rehearse timings
- Use Presenter View to deliver a presentation
- Export, share, and print a presentation.
Microsoft Word 2021/365 for Beginners:
What you'll learn:
- 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 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
- Organise 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 insert 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.
What you'll learn:
- 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 for 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.
Microsoft Outlook 2021/365
NOTE: This course will be published in early August 2022, and added to this bundle
Course Format
- This is a video-led course.
- This course includes practice exercises.
Course Certificate Included
This course includes an optional online quiz that will generate a course certificate upon completion.
Why Trust Us?
Part of the Simon Sez IT family, Stream Skill has taught over 1 million students since its start in 2008. We’ve created over 140 software training courses, 8,000+ video tutorials, and helped thousands of people across the world learn how to use Microsoft Office.