Mastering Microsoft Office 2021-365: Word, Excel, PowerPoint

U1: Getting Started

- Introduction
- Getting started on Windows, macOS, and Linux
- How to ask great questions
- FAQ’s

U2: Excel 2021: Basics

- Excel Overview
- Start Excel Spreadsheet
- Enter Text and Numbers
- Relative References
- Working with ranges
- Save and Save as Actions
- File Extensions, Share, Export, and Publish files

U3: Excel 2021: Rows, Columns, and Cells

- Adding Rows and Columns
- Modifying Rows and Column lengths

U4: Excel 2021: Data Handling

- Adding Rows and Columns
- Modifying Rows and Column lengths

U5: Excel 2021: Page Setting Up and Print

- Page setup options
- Fit to print on One Page
- Print Workbooks

U6: Excel 2021: Sorting and Filtering

- Sorting Data Ascending Order
- Sorting Data Descending Order
- Filter Data

U7: Excel 2021: Writing Formulas

- Creating Basic Formulas
- Datetime Formulas
- Mathematical formulas phase1
- Mathematical formulas phase2

U8: Excel 2021: Advanced Formulas

- VLOOKUP formula
- HLOOKUP formula

U9: Excel 2021: XLOOKUP only for 2021 and Office 365

- XLOOKUP
- Handling #NA and Approximates match in XLOOKUP

U10: Excel 2021: Data and Tools

- Split Text into columns
- Flash Fill
- Data Validation
- Remove Duplicates
- Import Data from Text files
- Import Data from .CSV files

U11: Excel 2021: Formatting data and tables

- Formatting Font
- Formatting Alignment
- Formatting Numbers
- Formatting Date
- Formatting Tables

U12: Excel 2021: Pivot Tables

- Pivot Tables
- Pivot Charts

U13: Excel 2021: Charts

- Excel Charts – Categories
- Elements of a chart
- Creating Charts
- Column or Bar charts
- Formatting charts
- Line Charts
- Pie and Doughnut charts

U14: PowerPoint 2021: Course Introduction

- Overview
- Start PowerPoint Presentation
- Screen setting and Views

U15: PowerPoint 2021: Basics

- Presentation Tips and Guidelines
- Creating a New Presentation
- Working with Slides
- Save a Presentation
- Print Slides

U16: PowerPoint 2021: Text and Bullet Options

- Formatting Text
- Slide Text Alignments
- Multi-Column Text Alignments
- Adding Bullets and Numbered List Items

U17: PowerPoint 2021: Adding Graphic Assets

- Insert Shapes
- Insert Icons
- Insert Graphics
- Add 3D Models
- Insert Pictures

U18: PowerPoint 2021: Picture Formatting

- Picture Options
- Picture Cropping
- Applying Built-in Picture Styles

U19: PowerPoint 2021: SmartArt Graphics

- Add SmartArt Graphic
- Modifying SmartArt
- Creating a Target Chart using SmartArt

U20: PowerPoint 2021: Working with Tables

- Create a Table on Slide
- Formatting Tables
- Inserting Tables

U21: PowerPoint 2021: Working with Charts

- Add a Chart
- Formatting Charts
- Insert Chart from Microsoft Excel

U22: PowerPoint 2021: Adding Multimedia

- Adding Video to a Presentation
- Adding Audio to a Presentation
- Screen Recording and Adding

U23: PowerPoint 2021: Working with Transition

- Applying Transitions to Presentation

U24: PowerPoint 2021: Animation

- Object Animation
- Effect Options
- Advanced Animation
- Triggers to control animation

U25: PowerPoint 2021: Slideshow Effects

- Onscreen Presentation
- Hiding Slides
- Changing Order of Slides
- Copying Slides

U26: Word 2021: Introduction

- Overview of MS Word
- Start MS Word 2021

U27: Word 2021: Basics

- Create a new blank document
- Creating a paragraph text
- Non-printing characters
- Save a document
- Open a document
- Find and replace

U28: Word 2021: Word Formatting

- AutoCorrect options
- Formatting text
- Copy cut and paste
- Character formatting
- Format painter
- Work with numbers
- Add bullets
- Outline creation

U29: Word 2021: Tables

- Creating a table
- Adding rows and columns to a table
- Formatting table data
- Borders and shading
- Sorting in a table
- Draw a table
- Convert text to table
- Convert table to text
- Insert a spreadsheet
- Quick tables – readily available formats

U30: Word 2021: Styles

- Working with styles
- Creating styles
- Clear formatting

U31: Word 2021: Page Layout

- Margins
- Orientation
- Page size setting
- Adding columns
- Page break – section break
- Adding watermark
- Headers and footers

U32: Word 2021: Envelops and Lables

- Create envelops
- Creating labels

U33: Word 2021: Mail Merges

- Creating a mail merge document

U34: Word 2021: Review and Printing

- Thesaurus and spell check
- Word count
- Speech - read aloud
- Language - translate
- Tracking

G-Tools: For students

- Exclusive access to cutting-edge tools for students: improve your employability, participate in exclusive events, take advantage of our smart virtual assistant and more.

⚑ Certificate of completion

- Your personalized digital certificate, a unique badge of your achievements, with international validity, course duration and QR code for instant verification.