arrow_back
Mastering Microsoft Office 2021-365: Word, Excel, PowerPoint
1b Getting started on Windows macOS and Linux
1c How to ask great questions
1d FAQs
2a Excel Overview
2b Start Excel Spreadsheet
2c Enter Text and Numbers
2d Relative References
2e Working with ranges
2f Save and Save as Actions
2g File Extensions, Share, Export, and Publish files
3a Adding Rows and Columns
3b Modifying Rows and Column lengths
4a Copy Cut and Paste
4b Copying Formulas
5a Page setup options
5b Fit to print on One Page
5c Print Workbooks
6a Sorting Data Ascending Order
6b Sorting Data Descending Order
6c Filter Data
7a Basic formula operations
7b Date time functions
7c Mathematical functions phase1
7d Mathematical functions phase2
8a V Lookup formula
8b HLookup formula
9a XLookup
9b Handling NA and Approximates match in XLookup
10a Split Text into columns
10b Flash Fill
10c Data Validation
10d Remove Duplicates
10e Get - import Data from Text
10f Get - import Data from CSV
11a Formatting Font
11b Formatting Alignment
11c Formatting Number
11d Formatting Date
11e Formatting tables
12a Creating Pivot Table
12b Pivot charts
13a Excel Charts – Categories
13b Elements of a chart
13c Creating charts
13d Column or Bar charts
13e Formatting charts
13f Line charts
13g Pie and Doughnut charts
14a Overview
14b Start PowerPoint Presentation
14c Screen setting and Views
15a Presentation Tips and Guidelines
15b Creating a New Presentation
15c Working with Slides
15d Save a Presentation
15e Print Slides
16a Formatting Text
16b Slide Text Alignments
16c Multi-Column Text Alignments
16d Adding Bullets and Numbered List Items
17a Insert Shapes
17b Insert Icons
17c Insert Graphics
17d Add 3D Models
17e Insert Pictures
18a Picture Options
18b Picture Cropping
18c Applying Built-in Picture Styles
19a Add SmartArt Graphic
19b Modifying SmartArt
19c Creating a Target Chart using SmartArt
20a Create a Table on Slide
20b Formatting Tables
20c Inserting Tables
20d Table Layouts
21a Add a Chart
21b Formatting Charts
21c Insert Chart from Microsoft Excel
22a Adding Video to a Presentation
22b Adding Audio to a Presentation
22c Screen Recording and Adding
23a Applying Transitions to Presentation
24a Object Animation
24b Effect Options
24c Advanced Animation
24d Triggers to control animation
25a Onscreen Presentation
25b Hiding Slides
25c Changing Order of Slides
25d Copying Slides
26a Overview of MS Word
26b Start MS Word 2021
27a Create a New Blank Document
27b Creating a Paragraph Text
27c Non-printing characters
27d Save a Document
27e Open a Document
27f Find and Replace
28a AutoCorrect Options
28b Formatting Text
28c Copy Cut and Paste
28d Character Formatting
28e Format Painter
28f Work with Numbers
28g Add Bullets
28h Outline Creation
29a Creating a Table
29b Adding Rows and Columns to a table
29c Formatting Table Data
29d Borders and Shading
29e Sorting in a Table
29f Draw a Table
29g Convert Text to Table
29h Convert Table to Text
29i Insert a Spreadsheet
29j Quick Tables – Readily Available Formats
30a Working with Styles
30b Creating Styles
30c Clear Formatting
31a Margins
31b Orientation
31c Page size setting
31d Adding columns
31e Page break section break
31f Adding watermark
31g Headers and footers
32a Create envelops
32b Creating labels
33a Creating a mail merge document
34a Thesaurus and spell check
34b Word count
34c Speech - read aloud
34d Language - translate
34e Tracking