AWS, Microsoft, Google

1 - Intro to Excel

2 - WATCH ME Essential Information for a Successful Training Experience

3 - Excel-2019-Beginner-Course-Exercise-Files

5 - Whats New In Excel 2019

6 - Course Overview

7 - Overview of the Excel window

8 - MouseFeatures

9 - Back Stage View

1 - Excel 2019 Introduction

10 - Entering Text and Numbers

11 - Creating Basic Formulas

12 - Relative References

13 - Order of Operations

14 - Working with Ranges

15 - Module 2 Practice Exercise

2 - Excel 2019 Beginner Creating Workbooks

16 - Working with the Save and Save As Commands

17 - File Extensions Share Export and Publish Files

18 - Module 3 Practice Exercise

3 - Excel 2019 Beginner Saving Workbooks

19 - Opening a File

20 - Working with Larger Files

21 - Freeze Panes Option

22 - Split Screen Option

23 - Module 4 Practice Exercise

4 - Excel 2019 Beginner Navigating Workbooks

24 - Headers and Footers

25 - Print Titles

26 - Comments

27 - Page Setup Options

28 - Fit to Print on One Page

29 - Printing Workbooks

30 - Module 5 Practice Exercise

5 - Excel 2019 Beginner Page Setup Print Options

31 - Adding and deleting rows columns and cells

32 - Changing Column and Row Widths

33 - Module 6 Practice Exercise

6 - Excel 2019 Beginners Working with Rows Columns and Cells

34 - Cut Copy and Paste

35 - Copying Formulas

36 - Module 7 Practice Exercise

7 - Excel 2019 Beginners Moving Data

37 - Overview of Formulas

38 - Create Formulas Using Functions Part 1

39 - Create Formulas Using Functions Part 2

40 - Absolute Values

41 - Module 8 Practice Exercise

8 - Excel 2019 Beginners Formulas Functions

42 - Adding Deleting and Renaming Sheets

43 - Additional Sheet Tab Options

44 - 3 Dimensional Formulas

45 - Module 9 Practice Exercise

9 - Excel 2019 Beginner Working with Sheets

46 - Formatting Cells Part 1

47 - Formatting Cells Part 2

48 - Formatting Numbers

49 - Borders and Shading

50 - Format as Table

51 - Using Styles

52 - Using Format Painter

53 - Protecting Sheets

54 - Fill Handle and Custom Lists

55 - Module 10 Practice Exercise

10 - Excel 2019 Beginner Formatting Worksheets

56 - Creating Charts

57 - Types of Charts

58 - Editing Charts Part 1

59 - Editing Charts Part 2

60 - Using Graphics to Enhance Charts

61 - Linking Chart Titles

62 - Module 11 Practice Exercise

11 - Excel 2019 Beginner Charts

63 - Creating Range Names

64 - Managing Names

65 - Using Names in Formulas

66 - Module 12 Practice Exercise

12 - Excel 2019 Beginner Working with Names

67 - Remove Duplicates

68 - Sort Data

69 - Filter Data

70 - Advanced Filters

71 - Module 13 Practice Exercise

13 - Excel 2019 Beginner Sorting and Filtering

72 - Creating an Outline

73 - Subtotals

74 - Module 14 Practice Exercise

14 - Excel 2019 Beginner Outlining and Subtotaling

75 - Arranging Files

76 - New Window Option

77 - Custom Views

78 - Module 15 Practice Exercise

15 - Excel 2019 Beginner Working with Views

79 - Creating Formulas Between File

80 - Working with Links

81 - Consolidating Data

82 - Module 16 Practice Exercise

16 - Excel 2019 Beginner Linking Files

83 - If Statements

84 - VLookups

85 - Data Validation

86 - Formula Auditing

87 - Module 17 Practice Exercise

17 - Excel 2019 Beginner Advanced Formula Creation

88 - Pivot Tables

89 - Pivot Charts

90 - Module 18 Practice Exercise

18 - Excel 2019 Beginner Pivot Tables

91 - Slicers

92 - Goal Seeker

93 - Text to Columns

94 - Watch Window

95 - Customizing Ribbons and Tabs

96 - Module 19 Practice Exercise

19 - Excel 2019 Beginner Additional Excel Features

97 - Excel Shortcuts Every User Should Know

20 - Excel 2019 Beginner Shortcuts

98 - Closing Video

21 - Excel 2019 Beginner Closing

99 - Introduction to the Course

100 - WATCH ME Essential Information for a Successful Training Experience

101 - Excel-2019-Advanced-Exercise-Files

102 - Excel-2019-Advanced-Course-Files

104 - Course Structure

22 - Excel 2019 Advanced Intro to Advanced Course

105 - Functions Part 1

106 - Functions Part 2

107 - Autosum

23 - Excel 2019 Advanced Functions

108 - How Date and Time Works

109 - Basic Date and Time Functions

110 - Complex Date and Time Functions

24 - Excel 2019 Advanced Date and Time Functions

111 - Using Text Functions Part 1

112 - Using Text Functions Part 2

25 - Excel 2019 Advanced Text Functions

113 - Logical Functions

114 - Exercise 01

26 - Excel 2019 Advanced Logical Functions

115 - Lookup Functions Part 1

116 - Lookup Functions Part 2

117 - Exercise 02

27 - Excel 2019 Advanced Lookup Functions

118 - Financial Functions and Terminology

119 - Personal Financial Functions

120 - Principal and Interest Payments

121 - Depreciation

122 - Exercise 03

28 - Excel 2019 Advanced Financial Functions

123 - Statistical Functions for Description Part 1

124 - Statistical Functions for Description Part 2

125 - Statistical Functions for Forecasting Part 1

126 - Statistical Functions for Forecasting Part 2

127 - Exercise 04

128 - One Click Forecasting

129 - Statistical Functions for Inference

29 - Excel 2019 Advanced Statistical Functions

130 - Connecting to Other workbooks

131 - Connecting to Access Databases

132 - Connecting Web Data Sources

133 - Get and Transform

134 - Exercise 05

30 - Excel 2019 Advanced Connecting to External Data

135 - Introduction to Tables

136 - Working with Tables

137 - Table References

138 - Table Styles

139 - Exercise 6

31 - Excel 2019 Advanced Tables

140 - Introduction to Pivot Tables

141 - WorkingwithPivot Tables

142 - Filters and Slicers

143 - Pivot and Charts

144 - Exercise 07

32 - Excel 2019 Advanced Pivot Tables

145 - What If Analysis

146 - Scenario Manager

147 - Goal Seek

148 - Solver

149 - Exercise 08

33 - Excel 2019 Advanced Data Analysis

150 - Area Charts

151 - Surface Charts

152 - Radar Charts

153 - Bubble Charts

154 - Sparklines

155 - Stock Charts

156 - Exercise 9

34 - Excel 2019 Advanced Graphs and Charts

157 - Web App Part 1

158 - Web App Part 2

35 - Excel 2019 Advanced Excel Web App

159 - Close

36 - Excel 2019 Advanced Course Conclusion

160 - Welcome and Overview

161 - WATCH ME Essential Information for a Successful Training Experience

162 - Word-2019-Exercise-Files

164 - Overview of the MS Word Screen

165 - The Backstage View

37 - Word 2019 Introduction

166 - Creating a New Blank Document

38 - Word 2019 Getting Started with Word

<p><span style="color: rgb(55, 65, 81); color: rgb(55, 65, 81)">The Ultimate Microsoft Office Expert course is designed for those looking to elevate their skills in the world's most popular office software suite. Covering in-depth tutorials on Word, Excel, PowerPoint, and more, this course is perfect for individuals aiming to enhance their office productivity, data management, and presentation skills. With expert-led instruction and practical exercises, you'll become proficient in navigating and utilizing the full capabilities of Microsoft Office, making you an invaluable asset in any professional setting. Whether for career advancement or personal growth, this course is your gateway to becoming a Microsoft Office pro.</span></p>

Master Microsoft Office and Boost Your Productivity!

Ultimate Microsoft 365 Expert

Ultimate Microsoft 365 Expert

My Digital Academy

Course Details

Course content