The Ultimate Microsoft Office 2021/365 Training Bundle

Focused View

Simon Sez IT

58:57:26

75 View

01 - Excel 2021 Beginners Introduction

001 About This Bundle.mp4

02:11

002 Course Introduction.mp4

02:19

003 WATCH ME Essential Information for a Successful Training Experience.mp4

02:11

004 DOWNLOAD ME Course Exercise Files.html

004 Excel-2021-Exercise-Files.zip

005 DOWNLOAD ME Course Instructor Files.html

005 Excel-2021-Course-Files.zip

006 Downloadable Course Transcript.html

006 Excel-2021-Beginners-Transcription.pdf

007 Excel 2021 vs Excel for Microsoft 365.mp4

05:39

02 - Excel 2021 Beginners Getting Started in Excel 2021

001 Launching Excel.mp4

03:38

002 The Start Screen.mp4

10:12

003 Exploring the Interface.mp4

11:39

004 Understanding Ribbons, Tabs and Menus.mp4

08:29

005 The Backstage Area.mp4

04:40

006 Customizing the Quick Access Toolbar.mp4

09:44

007 Useful Keyboard Shortcuts.mp4

09:41

008 Getting Help.mp4

06:31

009 Exercise 01.mp4

02:19

03 - Excel 2021 Beginners Creating You First Excel Spreadsheet

001 Working with Excel Templates.mp4

09:02

002 Working with Workbooks and Worksheets.mp4

06:48

003 Saving Workbooks and Worksheets.mp4

08:44

004 Entering and Editing Data.mp4

09:52

005 Navigating and Selecting Cells, Rows and Columns.mp4

07:21

006 Exercise 02.mp4

05:19

04 - Excel 2021 Beginners Introduction to Excel Formulas and Functions

001 Formulas and Functions Explained.mp4

11:42

002 Performing Calculations with the SUM Function.mp4

07:38

003 Counting Values and Blanks.mp4

07:26

004 Finding the Average with the AVERAGE Function.mp4

04:18

005 Working with the MIN and MAX Functions.mp4

02:24

006 Handling Errors in Formulas.mp4

08:41

007 Absolute vs Relative Referencing.mp4

06:57

008 Autosum and AutoFill.mp4

09:41

009 Flash Fill.mp4

05:02

010 Exercise 03.mp4

05:12

05 - Excel 2021 Beginners Using Named Ranges

001 What are Named Ranges.mp4

04:41

002 Creating Named Ranges.mp4

04:25

003 Managing Named Ranges.mp4

03:49

004 Using Named Ranges in Calculations.mp4

05:19

005 Exercise 04.mp4

04:17

06 - Excel 2021 Beginners Formatting Numbers and Cells

001 Applying Number Formats.mp4

10:03

002 Applying Date and Time Formats.mp4

05:39

003 Formatting Cells, Rows and Columns.mp4

08:37

004 Using Format Painter.mp4

04:39

005 Exercise 05.mp4

04:06

07 - Excel 2021 Beginners Formatting Worksheets

001 Working with Rows and Columns.mp4

08:25

002 Deleting and Clearing Cells.mp4

06:25

003 Aligning Text and Numbers.mp4

11:13

004 Applying Themes and Styles.mp4

07:41

005 Exercise 06.mp4

05:22

08 - Excel 2021 Beginners Working with Excel Lists

001 How to Structure a List.mp4

04:37

002 Sorting a List (Single-Level Sort).mp4

04:58

003 Sorting a List (Multi-Level Sort).mp4

05:06

004 Sorting Using a Custom List (Custom Sort).mp4

08:12

005 Using Autofilter to Filter a List.mp4

06:45

006 Format as a Table.mp4

10:18

007 Creating Subtotals in a List.mp4

07:34

008 Exercise 07.mp4

04:37

09 - Excel 2021 Beginners Moving and Linking to Data

001 Using Cut and Copy.mp4

04:57

002 Paste Options.mp4

07:45

003 Pasting from the Clipboard.mp4

04:32

004 Linking to Other Worksheets and Workbooks.mp4

06:26

005 3D Referencing.mp4

05:54

006 Inserting Hyperlinks to Worksheets.mp4

09:39

007 Exercise 08.mp4

04:41

10 - Excel 2021 Beginners An Introduction to Intermediate Formulas

001 Looking up Information with VLOOKUP.mp4

10:02

002 VLOOKUP Approximate Match.mp4

05:09

003 Error Handling Functions.mp4

07:10

004 Basic Logical Functions (IF, AND, OR).mp4

12:24

005 Making Decisions with IF Statements.mp4

04:33

006 Cleaning Data using Text Functions.mp4

12:09

007 Working with Time and Date Functions.mp4

11:17

008 Exercise 09.mp4

10:18

11 - Excel 2021 Beginners Analyzing Data with Charts

001 Choosing the Correct Chart Type.mp4

06:34

002 Presenting Data with Charts.mp4

10:01

003 Formatting Charts.mp4

12:51

004 Exercise 10.mp4

03:54

12 - Excel 2021 Beginners Conditional Formatting

001 Highlighting Cell Values.mp4

07:14

002 Data Bars.mp4

05:32

003 Color Scales.mp4

04:55

004 Icon Sets.mp4

07:49

005 Exercise 11.mp4

05:43

13 - Excel 2021 Beginners Inserting Items into a Spreadsheet

001 Inserting Pictures.mp4

10:53

002 Inserting Shapes and Text Boxes.mp4

09:04

003 Inserting Icons and 3D Models.mp4

06:00

004 Creating Diagrams using SmartArt.mp4

10:41

005 Inserting Screenshots.mp4

04:27

006 Inserting Comments.mp4

05:13

007 Exercise 12.mp4

09:16

14 - Excel 2021 Beginners Working with Views and Zoom

001 Workbook Views.mp4

06:22

002 Using Zoom in a Worksheet.mp4

02:56

003 Arranging Workbooks and Worksheets.mp4

05:01

004 Freezing Panes.mp4

04:00

005 Exercise 13.mp4

03:25

15 - Excel 2021 Beginners Page Layout and Print Options

001 Setting Margins and Orientation.mp4

05:05

002 Setting and Clearing the Print Area.mp4

02:53

003 Inserting Page Breaks.mp4

04:32

004 Setting Print Titles and a Background.mp4

04:29

005 Inserting Headers and Footers.mp4

05:42

006 Printing a Workbook.mp4

06:00

007 Exercise 14.mp4

03:06

16 - Excel 2021 Beginners Finalizing the Spreadsheet

001 Protecting Workbooks and Worksheets.mp4

09:02

002 Spell Checking.mp4

03:45

003 Inspecting the Workbook.mp4

07:21

004 Saving the Workbook in Different Formats.mp4

04:21

005 Sharing a Workbook.mp4

05:35

006 Exercise 15.mp4

03:28

17 - Excel 2021 Beginners Course Close

001 Course Close.mp4

01:07

18 - Word 2021 Introduction

001 Course Introduction.mp4

09:32

002 WATCH ME Essential Information for a Successful Training Experience.mp4

02:11

003 DOWNLOAD ME Course Exercise Files.html

003 Word-2021-Exercise-Files.zip

004 DOWNLOAD ME Course Instructor Files.html

004 Word-2021-Course-Files.zip

005 DOWNLOAD ME Course Transcript.html

005 Word-2021-transcript.pdf

006 Exercise 01.mp4

02:17

19 - Word 2021 - The Basics

001 The Start Screen.mp4

10:20

002 Explore the Word Interface.mp4

09:07

003 Work with the Ruler and Zoom.mp4

05:54

004 Check Spelling as You Type.mp4

04:57

005 Customize the Quick Access Toolbar.mp4

07:34

006 Keyboard Shortcuts.mp4

07:01

007 Screentips, Contextual Menus and Ribbons.mp4

08:12

008 Get Help.mp4

07:11

009 Exercise 02.mp4

04:20

20 - Word 2021 Get Started - Work with Documents

001 Create and Save a Document.mp4

07:32

002 Open and Edit an Existing Document.mp4

06:19

003 Create a Document from a Template.mp4

07:00

004 Navigate Around a Document.mp4

05:45

005 Find Tools in Word.mp4

02:41

006 Exercise 03.mp4

06:00

21 - Word 2021 View Documents

001 Switch Document Views.mp4

07:10

002 Use the Immersive Reader and Focus.mp4

05:44

003 Dark Mode.mp4

05:35

004 Exercise 04.mp4

04:12

22 - Word 2021 Work with Text

001 Enter Text and Apply Basic Formatting.mp4

09:42

002 Make Selections.mp4

04:16

003 Advanced Text Formatting.mp4

06:57

004 Move Text with Cut, Copy and Paste.mp4

07:45

005 Copy Formatting Using Format Painter.mp4

03:37

006 Paste Options.mp4

05:58

007 Find and Replace.mp4

10:02

008 Exercise 05.mp4

05:01

23 - Word 2021 Work with Paragraphs

001 Format Paragraphs and Alignment.mp4

04:20

002 Line Spacing Options.mp4

04:47

003 Work with Non-Printing Characters.mp4

05:08

004 Bullets and Numbered Lists.mp4

07:58

005 Indent Paragraphs.mp4

05:15

006 Align Text with Tabs.mp4

11:04

007 Exercise 06.mp4

06:21

24 - Word 2021 Themes

001 Apply a Theme.mp4

08:43

002 Create a Custom Theme.mp4

05:20

003 Exercise 07.mp4

02:59

25 - Word 2021 Word Styles

001 Why Styles are Useful.mp4

05:39

002 Apply Styles to Paragraphs.mp4

05:55

003 Modify Styles in the Styles Pane.mp4

08:02

004 Create a Custom Style.mp4

06:38

005 Exercise 08.mp4

05:48

26 - Word 2021 Insert Pictures, Tables and Other Objects

001 Insert and Format Pictures.mp4

09:48

002 Insert Stock and Online Pictures.mp4

06:19

003 Text Wrapping.mp4

05:56

004 Insert and Format Text Boxes.mp4

07:24

005 Insert and Format Shapes.mp4

10:35

006 Use the Selection Pane.mp4

06:05

007 Insert Other Graphics.mp4

08:05

008 Insert SmartArt, Charts and Screenshots.mp4

08:44

009 Draw with Touch.mp4

06:41

010 Organize Information in a Table.mp4

11:42

011 Exercise 09.mp4

08:49

27 - Word 2021 Format Pages

001 Page Size and Margins.mp4

05:53

002 Work with Section and Page Breaks.mp4

08:02

003 Inserting Additional Pages (Cover Page and Blanks).mp4

06:34

004 Apply Columns.mp4

05:34

005 Add Headers, Footers and Page Numbers.mp4

10:45

006 Insert Hyperlinks.mp4

08:22

007 Insert Bookmarks.mp4

03:41

008 Use Quick Parts.mp4

05:29

009 Exercise 10.mp4

07:25

28 - Word 2021 References

001 Modify and Update a Table of Contents.mp4

10:39

002 Use Footnotes and Endnotes.mp4

03:28

003 Build a Bibliography.mp4

08:02

004 Insert Captions and a Table of Figures.mp4

09:52

005 Create an Index.mp4

06:58

006 Insert a Table of Authorities.mp4

03:47

007 Insert Cross References.mp4

06:49

008 Exercise 11.mp4

06:46

29 - Word 2021 Mail Merge

001 Use the Mail Merge Wizard to Create Letters.mp4

09:24

002 Create Envelopes with Merge Fields.mp4

03:55

003 Create Labels Using Merge Fields.mp4

06:20

004 Exercise 12.mp4

03:44

30 - Word 2021 Spelling and Grammar

001 Check Spelling and Grammar.mp4

04:39

002 Use Auto-correct to Fix Mistakes.mp4

05:03

003 Exercise 13.mp4

02:38

31 - Word 2021 Track Changes and Comments

001 Use Track Changes.mp4

07:39

002 Accept and Reject Changes.mp4

04:01

003 Track Change Settings.mp4

05:57

004 Add Comments.mp4

03:51

005 Document Comparison.mp4

06:42

006 Exercise 14.mp4

03:39

32 - Word 2021 Finalize a Document

001 Print Documents.mp4

06:45

002 Document Properties.mp4

05:26

003 Check a Document for Issues.mp4

09:23

004 Protect a Document.mp4

08:58

005 Share a File with Others.mp4

06:15

006 Co-author Documents Online.mp4

03:37

007 Exercise 15.mp4

05:36

33 - Word 2021 Course Close

001 Course Close.mp4

01:37

34 - PowerPoint 2021 Introduction

001 Introduction to PowerPoint 2021.mp4

07:00

002 WATCH ME Essential Information for a Successful Training Experience.mp4

02:11

003 DOWNLOAD ME Course Exercise Files.html

003 PowerPoint-2021-Exercise-Files.zip

004 DOWNLOAD ME Course Files.html

005 Downloadable Course Transcripts.html

005 PowerPoint-2021-Transcription.pdf

006 Creating Visually Stunning Presentations.mp4

05:35

007 Presentation Tips and Best Practice.mp4

12:27

008 Free PowerPoint Resources.mp4

09:09

009 Exercise 01.mp4

01:14

35 - PowerPoint 2021 Getting Started in PowerPoint 2021

001 The PowerPoint 2021 Interface.mp4

11:40

002 Customizing the Quick Access Toolbar.mp4

07:50

003 Opening, Closing, and Saving Presentations.mp4

06:17

004 Using PowerPoint Templates.mp4

06:36

005 Setting PowerPoint Options.mp4

07:37

006 Exercise 02.mp4

03:51

36 - PowerPoint 2021 Slides and Layouts

001 Slide Layouts.mp4

06:04

002 Adding, Arranging, and Duplicating Slides.mp4

06:05

003 Reusing Slides from Other Presentations.mp4

04:30

004 Creating Slides from an Outline.mp4

03:24

005 Slide Themes and Backgrounds.mp4

10:16

006 Exercise 03.mp4

04:30

37 - PowerPoint 2021 Slide Workshop Title Slide

001 Resizing a Background Image Crop and Fill.mp4

05:52

002 Transparent Shape Overlays.mp4

06:43

003 Drawing and Formatting Shapes.mp4

06:33

004 Locking Shapes and Setting a Default Shape.mp4

03:34

005 Merging Shapes.mp4

09:08

006 Inserting a Logo Filling Shapes with Pictures.mp4

04:17

007 Adding a Title and Subtitle Inserting Text Boxes.mp4

09:14

008 Using the Eyedropper Tool.mp4

05:14

009 Exercise 04.mp4

06:30

38 - PowerPoint 2021 Selection, Alignment and Grouping

001 Selecting Objects.mp4

06:12

002 Arranging, Renaming, and Changing the Z-Order.mp4

07:45

003 Aligning and Grouping Objects.mp4

09:54

004 Exercise 05.mp4

03:42

39 - PowerPoint 2021 Slide Workshop Meet The Team

001 Duplicating and Reformatting Slides.mp4

07:34

002 Filling Shapes with Images.mp4

06:58

003 Copying Formatting Format Painter.mp4

08:59

004 Bullets, Numbered Lists, and Paragraph Text.mp4

12:12

005 The Morph Transition.mp4

07:00

006 Exercise 06.mp4

08:02

40 - PowerPoint 2021 Slide Workshop Divider Slides

001 Merging Images Across Shapes.mp4

06:15

002 Inserting and Formatting Icons.mp4

08:41

003 Compressing Pictures.mp4

04:09

004 Animating Objects Entrance, Emphasis, and Exit Effects.mp4

09:24

005 Applying Multiple Animations.mp4

04:41

006 Triggering Animations.mp4

04:20

007 Organising Slides Slide Sorter View.mp4

03:14

008 Exercise 07.mp4

07:12

41 - PowerPoint 2021 Slide Workshop Our Destinations

001 Adding Half-Page Image Slides.mp4

07:50

002 Actions Linking to Slides.mp4

06:10

003 Using Slide Zoom.mp4

07:52

004 Inserting Hyperlinks to Slides, Websites, Documents, and Email.mp4

07:50

005 Exercise 08.mp4

09:01

42 - PowerPoint 2021 Slide Workshop Tables, Charts and Diagrams

001 Adding and Formatting Tables.mp4

09:11

002 Creating a Process Flow Diagram with SmartArt.mp4

08:09

003 Creating a Custom Process Flow Diagram with Shapes and Connectors.mp4

10:23

004 Creating an Organization Diagram with SmartArt.mp4

09:35

005 Inserting Charts Line Chart.mp4

06:45

006 Formatting Charts.mp4

11:46

007 Exercise 09.mp4

14:16

43 - PowerPoint 2021 More Graphics

001 Inserting Stickers, Cut Out People, Illustrations, and Cartoon Images.mp4

08:13

002 Removing an Image Background.mp4

05:35

003 Exercise 10.mp4

06:57

44 - PowerPoint 2021 Video, Audio and Screenshots

001 Inserting and Editing Videos.mp4

07:05

002 Creating a Motion Video Background.mp4

06:03

003 Adding Audio Files.mp4

04:46

004 Inserting Screenshots.mp4

04:49

005 Recording the Screen.mp4

05:37

006 Exercise 11.mp4

04:04

45 - PowerPoint 2021 Slide Workshop Transitions, Zoom and Motion Paths

001 Adding and Modifying Slide Transitions.mp4

07:50

002 Advanced Morph.mp4

04:41

003 Summary Zoom.mp4

06:56

004 Pan and Zoom.mp4

06:17

005 Animating Objects with Motion Paths.mp4

10:42

006 Exercise 12.mp4

12:23

46 - PowerPoint 2021 Master Slides

001 What are Master Slides.mp4

05:02

002 Modifying Master Slides.mp4

06:03

003 Exercise 13.mp4

02:28

47 - PowerPoint 2021 Extending PowerPoint with Add-ins

001 PowerPoint Add-ins.mp4

04:16

002 Countdown Timer Add-in.mp4

03:39

003 QR Code Add-in.mp4

03:24

004 Pro Word Cloud.mp4

04:10

005 Exercise 14.mp4

08:32

48 - PowerPoint 2021 Preparing Slides for Delivery

001 Adding a Header and Footer.mp4

06:12

002 Adding and Formatting Speaker Notes to a Presentation.mp4

04:36

003 Using the Notes Master.mp4

03:24

004 Hiding and Unhiding Slides.mp4

02:23

005 Rehearse Timings.mp4

06:13

006 Setting Up and Running a Custom Slide Show.mp4

08:49

007 Adding and Replying to Comments.mp4

04:44

008 Exercise 15.mp4

05:45

49 - PowerPoint 2021 Delivering a Presentation

001 Using Presenter View.mp4

05:05

002 On-screen Presentation Options.mp4

05:29

003 Record and Narrate a Presentation.mp4

04:58

004 Exercise 16.mp4

01:10

50 - PowerPoint 2021 Exporting, Sharing and Printing

001 Sharing a Presentation.mp4

06:16

002 Exporting a Presentation.mp4

08:07

003 The Info Tab.mp4

08:45

004 Protecting a Presentation.mp4

04:56

005 Printing a Presentation.mp4

06:16

006 Exercise 17.mp4

03:11

51 - PowerPoint 2021 Course Close

001 Course Close.mp4

02:46

52 - Outlook 2021 Introduction

001 Course Introduction.mp4

03:43

002 WATCH ME Essential Information for a Successful Training Experience.mp4

02:11

003 DOWNLOAD ME Course Exercise Files.html

003 Outlook-2021-Exercise-Files.zip

004 DOWNLOAD ME Course Instructor Files.html

004 Outlook-2021-Course-Files.zip

005 Downloadable Course Transcript.html

005 Outlook-2021-transcript.pdf

006 Staying Organized with Outlook 2021.mp4

04:10

007 Exercise 01.mp4

00:53

53 - Outlook 2021 Get Started and Connect Accounts

001 Explore the Outlook 2021 Interface.mp4

11:41

002 Configure a Microsoft Account.mp4

02:44

003 Add a Gmail Account (IMAP).mp4

03:32

004 Check Spelling and Grammar Settings.mp4

06:06

005 Customize the Quick Access Toolbar.mp4

08:31

006 Using Outlook Today.mp4

04:22

007 Get Help.mp4

07:45

008 Exercise 02.mp4

06:24

54 - Outlook 2021 Work with Mail - The Basics

001 Send and Receive Mail.mp4

03:58

002 Open and Read Mail.mp4

06:38

003 Compose a Mail and Save to Drafts.mp4

08:15

004 Insert Attachments.mp4

04:53

005 Save Attachments from a Message.mp4

04:43

006 Search and Find Mail.mp4

07:31

007 Use Filters to Find Mail.mp4

02:30

008 Customize the Inbox.mp4

09:42

009 Exercise 03.mp4

06:47

55 - Outlook 2021 Organize and Manage Mail

001 Flag Messages as Junk.mp4

05:13

002 Ignore Conversations.mp4

02:48

003 Clean Up Conversations.mp4

02:44

004 Apply Follow Up Flags and Set Reminders.mp4

05:31

005 Assign Mail to Categories.mp4

06:51

006 Organize Mail into Folders and Subfolders.mp4

06:04

007 Make Emails Stand Out with Conditional Formatting.mp4

05:29

008 Process Messages with Mail Rules.mp4

10:38

009 Use Search Folders for Email Management.mp4

05:15

010 Delete and Archive Mail.mp4

05:22

011 Exercise 04.mp4

05:56

56 - Outlook 2021 Create and Send Mail

001 Create and Format a New Message.mp4

08:20

002 Resend and Recall a Message.mp4

03:36

003 Reply to and Forward a Message.mp4

03:49

004 Create and Attach an Email Signature.mp4

05:37

005 Create Voting Buttons.mp4

07:50

006 Set Delivery Options.mp4

05:16

007 Use Mentions to Target Specific People.mp4

02:19

008 Translate and Read Messages Aloud.mp4

02:28

009 Send an Out Of Office (Auto-Reply) Message.mp4

03:23

010 Annotate Messages with Ink.mp4

04:41

011 Insert Tables, Shapes, Icons and Other Items into a Mail.mp4

09:24

012 Exercise 05.mp4

03:48

57 - Outlook 2021 Work with Contacts

001 Add a New Contact.mp4

06:53

002 Import Contact Information from Excel.mp4

08:21

003 Create Contact Groups.mp4

03:29

004 Organize Contacts with Folders.mp4

03:10

005 Share Contact Cards with Others.mp4

05:50

006 Exercise 06.mp4

04:18

58 - Outlook 2021 Manage Appointments and Meetings with the Calendar

001 Customize Calendar Settings.mp4

07:07

002 Create an Appointment or All Day Event.mp4

05:49

003 Create and Respond to a Meeting Invite.mp4

08:03

004 Add Delegates to Act on Your Behalf.mp4

08:19

005 Work with Teams in Outlook.mp4

05:31

006 Share Your Calendar and Open Other Calendars.mp4

05:21

007 Exercise 07.mp4

02:53

59 - Outlook 2021 Tasks and Notes

001 Create Tasks in the ToDo List.mp4

04:33

002 Edit, Assign and Monitor Tasks.mp4

05:34

003 Create and Manage Notes.mp4

03:32

004 Exercise 08.mp4

03:25

60 - Outlook 2021 Outlook Settings

001 Customize Outlook Settings.mp4

11:39

002 The Navigation Pane.mp4

03:40

003 Mailbox Cleanup.mp4

05:16

004 Exercise 09.mp4

02:45

61 - Outlook 2021 Course Close

001 Course Close.mp4

05:41

62 - Excel 2021 Intermediate Introduction

001 Course Introduction.mp4

06:16

002 WATCH ME Essential Information for a Successful Training Experience.mp4

02:11

003 DOWNLOAD ME Course Exercise Files.html

003 Excel-2021-Intermediate-Exercise-Files.zip

004 DOWNLOAD ME Course Instructor Files.html

004 Excel-2021-Intermediate-Course-Files.zip

005 Downloadable Course Transcripts.html

005 Microsoft-Excel-2021-Intermediate-transcript.pdf

63 - Excel 2021 Intermediate Designing Better Spreadsheets

001 The Golden Rules of Spreadsheet Design.mp4

11:54

002 Improving Readability with Cell Styles.mp4

04:58

003 Controlling Data Input.mp4

08:19

004 Adding Navigation Buttons.mp4

08:42

64 - Excel 2021 Intermediate Making Decisions with Logical Functions

001 Logical Functions (AND, OR, IF).mp4

13:18

002 The IF Function.mp4

05:27

003 Nested IFs.mp4

07:45

004 The IFS Function.mp4

06:04

005 Conditional IFs (SUMIF, COUNTIF, AVERAGEIF).mp4

06:45

006 Multiple Criteria (SUMIFS, COUNTIFS, AVERAGEIFS).mp4

07:12

007 Error Handling with IFERROR and IFNA.mp4

06:01

008 Exercise 01.mp4

07:29

65 - Excel 2021 Intermediate Looking Up Information

001 Looking Up Information using VLOOKUP (Exact Match).mp4

10:41

002 Looking Up Information using VLOOKUP (Approx Match).mp4

04:25

003 Looking Up Information Horizontally Using HLOOKUP.mp4

05:38

004 Performing Flexible Lookups With INDEX And MATCH.mp4

10:28

005 Using XLOOKUP and XMATCH.mp4

10:09

006 The OFFSET Function.mp4

10:50

007 The INDIRECT Function.mp4

09:07

008 Exercise 02.mp4

05:03

66 - Excel 2021 Intermediate Advanced Sorting and Filtering

001 Performing Sorts on Multiple Columns.mp4

07:04

002 Sorting Using a Custom List.mp4

03:35

003 The SORT and SORTBY Functions.mp4

10:00

004 Using the Advanced Filter.mp4

06:52

005 Extracting Unique Values - The UNIQUE Function.mp4

05:17

006 The FILTER Function.mp4

09:30

007 Exercise 03.mp4

05:41

67 - Excel 2021 Intermediate Working with Date and Time

001 Understanding How Dates are Stored in Excel.mp4

04:11

002 Applying Custom Date Formats.mp4

07:09

003 Using Date and Time Functions.mp4

08:44

004 Using the WORKDAY and WORKDAY.INT Functions.mp4

03:49

005 Using the NETWORKDAYS and NETWORKDAYS.INT Function.mp4

02:57

006 Tabulate Date Differences with the DATEDIF Function.mp4

06:14

007 Calculate Dates with EDATE and EOMONTH.mp4

07:22

008 Exercise 04.mp4

04:45

68 - Excel 2021 Intermediate Preparing Data for Analysis

001 Importing Data into Excel.mp4

09:56

002 Removing Blank Rows, Cells and Duplicates.mp4

05:20

003 Changing Case and Removing Spaces.mp4

09:03

004 Splitting Data using Text to Columns.mp4

07:03

005 Splitting Data using Text Functions.mp4

08:05

006 Splitting or Combining Cell Data Using Flash fill.mp4

05:00

007 Joining Data using CONCAT.mp4

07:30

008 Formatting Data as a Table.mp4

08:33

009 Exercise 05.mp4

05:41

69 - Excel 2021 Intermediate PivotTables

001 PivotTables Explained.mp4

02:12

002 Creating a PivotTable from Scratch.mp4

04:49

003 Pivoting the PivotTable Fields.mp4

05:31

004 Applying Subtotals and Grand Totals.mp4

03:14

005 Applying Number Formatting to PivotTable Data.mp4

03:00

006 Show Values As and Summarize Values By.mp4

05:51

007 Grouping PivotTable Data.mp4

05:39

008 Formatting Error Values and Empty Cells.mp4

05:02

009 Choosing a Report Layout.mp4

04:35

010 Applying PivotTable Styles.mp4

04:49

011 Exercise 06.mp4

04:05

70 - Excel 2021 Intermediate Pivot Charts

001 Creating a Pivot Chart.mp4

05:04

002 Formatting a Pivot Chart - Part 1.mp4

08:37

003 Formatting a Pivot Chart - Part 2.mp4

09:14

004 Using Map Charts.mp4

05:30

005 Exercise 07.mp4

04:19

71 - Excel 2021 Intermediate Adding Interaction to PivotTables and Charts

001 Inserting and Formatting Slicers.mp4

07:30

002 Inserting Timeline Slicers.mp4

05:08

003 Connecting Slicers to Pivot Charts.mp4

05:01

004 Updating PivotTable Data.mp4

03:41

005 Exercise 08.mp4

06:48

72 - Excel 2021 Intermediate Interactive Dashboards

001 What is a Dashboard.mp4

05:27

002 Assembling a Dashboard - Part 1.mp4

11:26

003 Assembling a Dashboard - Part 2.mp4

10:47

004 Assembling a Dashboard - Part 3.mp4

08:49

005 Exercise 09.mp4

02:27

73 - Excel 2021 Intermediate Formula Auditing

001 Troubleshooting Common Errors.mp4

08:11

002 Tracing Precedents and Formula Auditing.mp4

07:44

003 Exercise 10.mp4

07:30

74 - Excel 2021 Intermediate Data Validation

001 Creating Dynamic Drop-down Lists.mp4

07:27

002 Other Types of Data Validation.mp4

07:06

003 Custom Data Validation.mp4

10:11

004 Exercise 11.mp4

06:53

75 - Excel 2021 Intermediate WhatIf Analysis Tools

001 Goal Seek and the PMT Function.mp4

05:33

002 Using Scenario Manager.mp4

07:28

003 Data Tables One Variable.mp4

04:28

004 Data Tables Two Variables.mp4

04:13

005 Exercise 12.mp4

08:32

76 - Excel 2021 Intermediate Course Close

001 Course Close.mp4

01:35

77 - Bonuses

001 Ten Excel Tips and Tricks - Part 1.mp4

43:23

002 Ten Excel Tips and Tricks - Part 2.mp4

40:36

003 Ten Excel Tips and Tricks - Part 3.mp4

37:09

78 - Excel 2021 Advanced Introduction

001 Course Introduction.mp4

02:47

002 WATCH ME Essential Information for a Successful Training Experience.mp4

02:05

003 DOWNLOAD ME Course Demo Files.html

003 Excel-2021-Advanced-Course-Files.zip

004 DOWNLOAD ME Course Exercise Files.html

004 Excel-2021-Advanced-Exercises-Files.zip

005 Exercise 01.mp4

01:47

79 - Excel 2021 Advanced Dynamic Arrays

001 What are Dynamic Arrays.mp4

02:14

002 Introduction to Spills and Arrays.mp4

10:49

003 Extract and Count Unique Entries.mp4

06:14

004 Unique vs Distinct.mp4

03:24

005 Extract Unique Values with Multiple Criteria.mp4

03:11

006 Extract Unique Values by Column.mp4

04:23

007 The SORT Function.mp4

08:53

008 The SORT Function - Horizontal SORT.mp4

06:06

009 The SORTBY Function.mp4

06:10

010 The SORTBY Function - Horizontal SORT.mp4

03:05

011 Simple SEQUENCE and Unstacking Records.mp4

10:10

012 The FILTER Function.mp4

06:52

013 FILTER with Logic + Operator (OR).mp4

04:48

014 FILTER with Logic Operator (AND).mp4

05:39

015 FILTER with Logic = Operator (Both or Neither).mp4

04:11

016 FILTER with Logic - Operator (One or the Other).mp4

04:49

017 Using RANDARRAY and RANDBETWEEN to Randomize Data.mp4

09:44

018 Using XLOOKUP to Perform Complex Lookups.mp4

12:22

019 Using XMATCH.mp4

06:20

020 Exercise 02.mp4

13:09

80 - Excel 2021 Advanced Advanced Lookup and Reference Functions

001 Performing 2-Way Lookups.mp4

08:25

002 Using the CHOOSE Function.mp4

10:02

003 Using the SWITCH Function.mp4

04:32

004 Exercise 03.mp4

07:06

81 - Excel 2021 Advanced Statistical Functions

001 Using MEDIAN, MODE.SNGL and MODE.MULT.mp4

06:16

002 Using LARGE and SMALL.mp4

07:27

003 Ranking Data with Sorting using RANK.EQ and RANK.AVG.mp4

07:41

004 The COUNTBLANK Function.mp4

04:45

005 Exercise 04.mp4

07:05

82 - Excel 2021 Advanced Math Functions

001 Creating a Custom PivotTable Style.mp4

06:59

002 Specialized Rounding (MROUND, CEILING.MATH and FLOOR.MATH).mp4

04:30

003 Using the AGGREGATE Function.mp4

04:32

004 Exercise 05.mp4

05:52

83 - Excel 2021 Advanced New Functions - LET and LAMBDA

001 The LET Function.mp4

15:07

002 The LAMBDA Function.mp4

14:13

003 Exercise 06.mp4

11:49

84 - Excel 2021 Advanced Advanced PivotTables and Pivot Charts

001 Creating a Custom PivotTable Style.mp4

09:48

002 Applying Custom Number Formatting.mp4

10:02

003 Sorting Using Custom Lists.mp4

04:38

004 Applying Multiple Filters to Data.mp4

05:06

005 Adjusting Slicer Settings.mp4

12:02

006 Locking Workbooks but not Slicers.mp4

03:18

007 Creating a Calculated Field.mp4

08:01

008 Creating a Calculated Item.mp4

06:30

009 Solve Order.mp4

08:11

010 GETPIVOTDATA.mp4

11:57

011 Using GETPIVOTDATA - Dependent Data Validation Lists.mp4

08:37

012 Creating a Dynamic Pivot Chart Title.mp4

10:41

013 Adding a Dynamic Series to a Pivot Chart.mp4

12:47

014 Adding Totals to a Stacked Column Chart.mp4

05:52

015 Exercise 07.mp4

10:10

85 - Excel 2021 Advanced Form Controls

001 Introduction to Form Controls.mp4

04:14

002 Combo Box - Select from a List.mp4

07:21

003 Check Box - CheckUncheck Option.mp4

06:48

004 Option Button - Choose an Option.mp4

06:31

005 Spin Button - Move Up and Down a List.mp4

05:54

006 List Box - Select from a List of Items.mp4

04:59

007 Scroll Bar - Scroll Through a List.mp4

05:01

008 Exercise 08.mp4

05:57

86 - Excel 2021 Advanced Working with Power Query

001 Power Query Overview.mp4

01:35

002 Importing Data Using Get and Transform.mp4

07:09

003 The Power Query Editor.mp4

04:45

004 Combining Files.mp4

04:52

005 Transforming Files.mp4

09:30

006 Loading Files into Excel.mp4

04:02

007 Exercise 09.mp4

05:54

87 - Excel 2021 Advanced Forecasting

001 Getting Forecast Data with FRED.mp4

05:34

002 Creating a Linear Sales Forecast.mp4

08:21

003 Creating a Sales Forecast with Seasonality.mp4

05:02

004 Adding Confidence Levels.mp4

06:58

005 Using Forecast Sheets.mp4

07:16

006 Exercise 10.mp4

02:21

88 - Excel 2021 Advanced Macros and VBA

001 Using Macros to Automate Tasks.mp4

06:40

002 Recording, Saving and Running Macros.mp4

10:00

003 Recording a Macro with Relative Referencing.mp4

06:58

004 Multi-step Macros.mp4

07:09

005 The VBA Editor.mp4

07:55

006 Assigning Macros to Buttons.mp4

06:43

007 Creating a Custom Macro Ribbon.mp4

06:34

008 Exercise 11.mp4

05:30

Description

Learn the essentials of Microsoft Office in this 6-course bundle for Office 365 or Office 2021 users.

What You'll 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

Who is this for?

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

What You Need to Know?

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

More details

Description
This bundle includes downloadable course instructor files and exercise files to work with and follow along.

Learn Microsoft Excel, Word, PowerPoint, and Outlook 2021 with this huge-value six-course bundle from Microsoft Office expert, Simon Sez IT.

Microsoft Office remains the go-to tool for the modern worker, yet so many users fall short of using its full potential.
Weâ€™re here to make sure you arenâ€™t one of those people.

In this Microsoft Office bundle, we make the four essential and widely used MS Office programs (Excel, Word, PowerPoint, and Outlook) simple to understand. The bundle includes six full-length courses to help you achieve your goals: Excel 2021 for Beginners, Word 2021, PowerPoint 2021, Outlook 2021, Excel 2021 Intermediate, and Excel 2021 Advanced.

Each course goes into depth on how to get the most from each program and will help you become a more skillful user.

What's included?

Excel 2021 for Beginners
Become familiar with whatâ€™s new in Excel 2021
Navigate the Excel 2021 interface
Utilize useful keyboard shortcuts to increase productivity
Create your first Excel spreadsheet
Use basic and intermediate Excel formulas and functions
Effectively apply formatting to cells and use conditional formatting
Use Excel lists and master sorting and filtering
Work efficiently by using the cut, copy, and paste options
Link to other worksheets and workbooks
Analyze data using charts
Insert pictures in 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

Word 2021
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 different 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
Organize 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 inserting 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

PowerPoint 2021
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 and 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 rehearsing timings
Use Presenter View to deliver a presentation
Export, share, and print a presentation

Outlook 2021
Work with the new simplified ribbon as part of the wider Outlook interface.
Configure a Microsoft and Gmail account.
Customize the Quick Access Toolbar.
Open and customize Outlook Today.
Know where to go to get Help.
Open, Read, Send and Receive mail.
Insert Attachments and Save Attachments from a Message.
Use the Search and Filter buttons to find Mail.
Flag Messages as Junk and work with the Blocked Senders List.
Ignore conversations that are no longer relevant.
Clean-up long conversation threads.
Organize mail using Follow-up Flags, Categories and Folders.
Make emails stand out using Conditional Formatting.
Process messages automatically using Rules.
Create Search Folders to re-run common searches.
Delete and Archive Mail.
Create and Format New Messages.
Resend and Recall a Message.
Reply and Forward Messages.
Create and Attach an Email Signature.
Add Voting Buttons to get feedback from recipients.
Set Delivery Options on messages.
Use mentions to target specific people.
Translate messages from one language to another.
Use Read Aloud to have messages read to you.
Send an Out of Office message.
Annotate and Draw using Ink.
Insert tables, shapes, icons and other media into messages.
Add new contacts.
Import multiple contacts from a CSV file into Outlook.
Organize contacts using contact groups and folders.
Share contacts with others.
Customize Calendar Settings.
Create Appointments, All Day Events and Meetings.
Use the Scheduler to find free time.
Respond to meeting invites.
Create a Microsoft Teams Meeting from within Outlook.
Add Delegates to manage your inbox on your behalf.
Share Calendars with others.
Create and edit tasks in the to do list.
Assign task to others and monitor the completion status.
Create and manage notes.
Customize Outlook Settings.
Clean-up a Mailbox thatâ€™s reached its size limit.

Excel 2021 Intermediate
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 before 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

Excel 2021 Advanced
Using the NEW dynamic array functions to perform tasks
Creating advanced and flexible lookup formulas
Using statistical functions to rank data and to calculate the MEDIAN and MODE
Producing accurate results when working with financial data using math functions
Creating variables and functions with LET and LAMBDA
Analyzing data with advanced PivotTable and PivotChart hacks
Creating interactive reports and dashboards by incorporating form controls
Importing and cleaning data using Power Query
Predicting future values using forecast functions and forecast sheets
Recording and running macros to automate repetitive tasks
Understanding and making minor edits to VBA code
Combining functions to create practical formulas to complete specific tasks.

This bundle includes:
50+ hours of video tutorials
500+ individual video lectures
Course and exercise files to follow along
Certificate of completion
Who this course is for:
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

User Reviews

Rating

average 0

Total votes0

Focused display

Microsoft Office

Simon Sez IT

Instructor's Courses

Since 2008, individuals, small businesses, and Fortune 500 companies with thousands of employees have benefited from the easy and hands-on software training offered by Simon Sez IT. With over 8,000 video tutorials on a range of software programs, Simon Sez IT ensures stress-free eLearning and enhanced employee productivity - no matter whether you are implementing new software or a technological upgrade for your workplace. With over 630,000 Udemy students in over 180 countries, Simon Sez IT is the preferred online learning choice for individuals and businesses everywhere.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.