AWS, Microsoft, Google

Business & Entrepreneurship

1 - Intro to Excel

2 - WATCH ME Essential Information for a Successful Training Experience

3-4 - 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

Module 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

Module 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

Module 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

Module 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

Module 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

Module 6 - Excel 2019 Beginners Working with Rows Columns and Cells

34 - Cut Copy and Paste

35 - Copying Formulas

36 - Module 7 Practice Exercise

Module 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

Module 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

Module 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

Module 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

Module 11 - Excel 2019 Beginner Charts

63 - Creating Range Names

64 - Managing Names

65 - Using Names in Formulas

66 - Module 12 Practice Exercise

Module 12 - Excel 2019 Beginner Working with Names

67 - Remove Duplicates

68 - Sort Data

69 - Filter Data

70 - Advanced Filters

71 - Module 13 Practice Exercise

Module 13 - Excel 2019 Beginner Sorting and Filtering

72 - Creating an Outline

73 - Subtotals

74 - Module 14 Practice Exercise

Module 14 - Excel 2019 Beginner Outlining and Subtotaling

75 - Arranging Files

76 - New Window Option

77 - Custom Views

78 - Module 15 Practice Exercise

Module 15 - Excel 2019 Beginner Working with Views

79 - Creating Formulas Between File

80 - Working with Links

81 - Consolidating Data

82 - Module 16 Practice Exercise

Module 16 - Excel 2019 Beginner Linking Files

83 - If Statements

84 - VLookups

85 - Data Validation

86 - Formula Auditing

87 - Module 17 Practice Exercise

Module 17 - Excel 2019 Beginner Advanced Formula Creation

88 - Pivot Tables

89 - Pivot Charts

90 - Module 18 Practice Exercise

Module 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

Module 19 - Excel 2019 Beginner Additional Excel Features

97 - Excel Shortcuts Every User Should Know

Module 20 - Excel 2019 Beginner Shortcuts

98 - Closing Video

Module 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

Module 22 - Excel 2019 Advanced Intro to Advanced Course

105 - Functions Part 1

106 - Functions Part 2

107 - Autosum

Module 23 - Excel 2019 Advanced Functions

108 - How Date and Time Works

109 - Basic Date and Time Functions

110 - Complex Date and Time Functions

Module 24 - Excel 2019 Advanced Date and Time Functions

111 - Using Text Functions Part 1

112 - Using Text Functions Part 2

Module 25 - Excel 2019 Advanced Text Functions

113 - Logical Functions

114 - Exercise 01

Module 26 - Excel 2019 Advanced Logical Functions

115 - Lookup Functions Part 1

116 - Lookup Functions Part 2

117 - Exercise 02

Module 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

Module 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

Module 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

Module 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

Module 31 - Excel 2019 Advanced Tables

140 - Introduction to Pivot Tables

141 - WorkingwithPivot Tables

142 - Filters and Slicers

143 - Pivot and Charts

144 - Exercise 07

Module 32 - Excel 2019 Advanced Pivot Tables

145 - What If Analysis

146 - Scenario Manager

147 - Goal Seek

148 - Solver

149 - Exercise 08

Module 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

Module 34 - Excel 2019 Advanced Graphs and Charts

157 - Web App Part 1

158 - Web App Part 2

Module 35 - Excel 2019 Advanced Excel Web App

159 - Close

Module 36 - Excel 2019 Advanced Course Conclusion

<p><span style="color: rgb(55, 65, 81); color: rgb(55, 65, 81)">Dive into our Microsoft Excel course, taking you from beginner basics to advanced mastery. Uncover the secrets of data manipulation, formula crafting, and dynamic chart creation. Whether you're analyzing data, managing budgets, or organizing projects, this course is your comprehensive guide to becoming an Excel wizard. Perfect for professionals enhancing their skillset or individuals seeking to organize their personal life. Start your journey to Excel excellence today! #MicrosoftExcel #ExcelSkills #DataHero 📊🚀</span></p>

Microsoft Excel - Beginner to Advanced

My Digital Academy

Course Details

Course content