We guarantee that all our online courses will meet or exceed your
expectations. If you are not fully satisfied with a course - for
any reason at all - simply request a full refund. We guarantee no
hassles. That's our promise to you.
Go ahead and order with confidence!
| Section 01: Getting Started | |||
| Introduction | |||
| Getting started on Windows, macOS, and Linux | |||
| How to ask great questions | |||
| FAQ’s | |||
| Section 02: 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 | |||
| Section 03: Excel 2021: Rows, Columns, and Cells | |||
| Adding Rows and Columns | |||
| Modifying Rows and Column lengths | |||
| Section 04: Excel 2021: Data Handling | |||
| Copy, Cut, and Paste | |||
| Copying Formulas | |||
| Section 05: Excel 2021: Page Setting Up and Print | |||
| Page setup options | |||
| Fit to print on One Page | |||
| Print Workbooks | |||
| Section 06: Excel 2021: Sorting and Filtering | |||
| Sorting Data Ascending Order | |||
| Sorting Data Descending Order | |||
| Filter Data | |||
| Section 07: Excel 2021: Writing Formulas | |||
| Creating Basic Formulas | |||
| Datetime Formulas | |||
| Mathematical formulas phase1 | |||
| Mathematical formulas phase2 | |||
| Section 08: Excel 2021: Advanced Formulas | |||
| VLOOKUP formula | |||
| HLOOKUP formula | |||
| Section 09: Excel 2021: XLOOKUP only for 2021 and Office 365 | |||
| XLOOKUP | |||
| Handling #NA and Approximates match in XLOOKUP | |||
| Section 10: 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 | |||
| Section 11: Excel 2021: Formatting data and tables | |||
| Formatting Font | |||
| Formatting Alignment | |||
| Formatting Numbers | |||
| Formatting Date | |||
| Formatting Tables | |||
| Section 12: Excel 2021: Pivot Tables | |||
| Pivot Tables | |||
| Pivot Charts | |||
| Section 13: Excel 2021: Charts | |||
| Excel Charts – Categories | |||
| Elements of a chart | |||
| Creating Charts | |||
| Column or Bar charts | |||
| Formatting charts | |||
| Line Charts | |||
| Pie and Doughnut charts | |||
| Section 14: PowerPoint 2021: Course Introduction | |||
| Overview | |||
| Start PowerPoint Presentation | |||
| Screen setting and Views | |||
| Section 15: PowerPoint 2021: Basics | |||
| Presentation Tips and Guidelines | |||
| Creating a New Presentation | |||
| Working with Slides | |||
| Save a Presentation | |||
| Print Slides | |||
| Section 16: PowerPoint 2021: Text and Bullet Options | |||
| Formatting Text | |||
| Slide Text Alignments | |||
| Multi-Column Text Alignments | |||
| Adding Bullets and Numbered List Items | |||
| Section 17: PowerPoint 2021: Adding Graphic Assets | |||
| Insert Shapes | |||
| Insert Icons | |||
| Insert Graphics | |||
| Add 3D Models | |||
| Insert Pictures | |||
| Section 18: PowerPoint 2021: Picture Formatting | |||
| Picture Options | |||
| Picture Cropping | |||
| Applying Built-in Picture Styles | |||
| Section 19: PowerPoint 2021: SmartArt Graphics | |||
| Add SmartArt Graphic | |||
| Modifying SmartArt | |||
| Creating a Target Chart using SmartArt | |||
| Section 20: PowerPoint 2021: Working with Tables | |||
| Create a Table on Slide | |||
| Formatting Tables | |||
| Inserting Tables | |||
| Table Layouts | |||
| Section 21: PowerPoint 2021: Working with Charts | |||
| Add a Chart | |||
| Formatting Charts | |||
| Insert Chart from Microsoft Excel | |||
| Section 22: PowerPoint 2021: Adding Multimedia | |||
| Adding Video to a Presentation | |||
| Adding Audio to a Presentation | |||
| Screen Recording and Adding | |||
| Section 23: PowerPoint 2021: Working with Transition | |||
| Applying Transitions to Presentation | |||
| Section 24: PowerPoint 2021: Animation | |||
| Object Animation | |||
| Effect Options | |||
| Advanced Animation | |||
| Triggers to control animation | |||
| Section 25: PowerPoint 2021: Slideshow Effects | |||
| Onscreen Presentation | |||
| Hiding Slides | |||
| Changing Order of Slides | |||
| Copying Slides | |||
| Section 26: Word 2021: Introduction | |||
| Overview of MS Word | |||
| Start MS Word 2021 | |||
| Section 27: Word 2021: Basics | |||
| Create a new blank document | |||
| Creating a paragraph text | |||
| Non-printing characters | |||
| Save a document | |||
| Open a document | |||
| Find and replace | |||
| Section 28: Word 2021: Word Formatting | |||
| AutoCorrect options | |||
| Formatting text | |||
| Copy cut and paste | |||
| Character formatting | |||
| Format painter | |||
| Work with numbers | |||
| Add bullets | |||
| Outline creation | |||
| Section 29: 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 | |||
| Section 30: Word 2021: Styles | |||
| Working with styles | |||
| Creating styles | |||
| Clear formatting | |||
| Section 31: Word 2021: Page Layout | |||
| Margins | |||
| Orientation | |||
| Page size setting | |||
| Adding columns | |||
| Page break – section break | |||
| Adding watermark | |||
| Headers and footers | |||
| Section 32: Word 2021: Envelops and Lables | |||
| Create envelops | |||
| Creating labels | |||
| Section 33: Word 2021: Mail Merges | |||
| Creating a mail merge document | |||
| Section 34: Word 2021: Review and Printing | |||
| Thesaurus and spell check | |||
| Word count | |||
| Speech – read aloud | |||
| Language – translate | |||
| Tracking | |||