Master Excel 2019 PC/Mac with Beginner to Advanced Courses

Focused View

Simon Sez IT

26:04:10

7 View

1 - Excel 2019 Beginner Intro to Excel

1 - Intro to Excel.mp4

01:00

2 - WATCH ME Essential Information for a Successful Training Experience.mp4

02:03

3 - DOWNLOAD ME Course Exercise Files.html

3 - Excel-2019-Exercise-Files.zip

4 - Downloadable course transcripts.html

4 - Excel-2019-Transcripts.pdf

5 - Whats New In Excel 2019.mp4

07:52

6 - Course Overview.mp4

01:16

7 - Overview of the Excel Window.mp4

08:25

8 - MouseFeatures.mp4

03:12

9 - Back Stage View.mp4

02:37

2 - Excel 2019 Beginner Creating Workbooks

10 - Entering Text and Numbers.mp4

04:32

11 - Creating Basic Formulas.mp4

06:49

12 - Relative References.mp4

03:01

13 - Order of Operations.mp4

04:48

14 - Working with Ranges.mp4

04:14

15 - Module 2 Practice Exercise.mp4

01:35

3 - Excel 2019 Beginner Saving Workbooks

16 - Working with the Save and Save As Commands.mp4

04:34

17 - File Extensions Share Export and Publish Files.mp4

03:44

18 - Module 3 Practice Exercise.mp4

00:59

4 - Excel 2019 Beginner Navigating Workbooks

19 - Opening a File.mp4

05:33

20 - Working with Larger Files.mp4

05:34

21 - Freeze Panes Option.mp4

03:16

22 - Split Screen Option.mp4

03:22

23 - Module 4 Practice Exercise.mp4

02:50

5 - Excel 2019 Beginner Page Setup Print Options

24 - Headers and Footers.mp4

07:23

25 - Print Titles.mp4

02:52

26 - Comments.mp4

05:23

27 - Page Setup Options.mp4

07:30

28 - Fit to Print on One Page.mp4

03:59

29 - Printing Workbooks.mp4

03:55

30 - Module 5 Practice Exercise.mp4

01:53

6 - Excel 2019 Beginners Working with Rows Columns and Cells

31 - Adding and deleting rows columns and cells.mp4

06:12

32 - Changing Column and Row Widths.mp4

03:45

33 - Module 6 Practice Exercise.mp4

01:11

7 - Excel 2019 Beginners Moving Data

34 - Cut Copy and Paste.mp4

07:07

35 - Copying Formulas.mp4

05:09

36 - Module 7 Practice Exercise.mp4

01:20

8 - Excel 2019 Beginners Formulas Functions

37 - Overview of Formulas.mp4

02:48

38 - Create Formulas Using Functions Part 1.mp4

10:04

39 - Create Formulas Using Functions Part 2.mp4

05:24

40 - Absolute Values.mp4

05:16

41 - Module 8 Practice Exercise.mp4

01:20

9 - Excel 2019 Beginner Working with Sheets

42 - Adding Deleting and Renaming Sheets.mp4

04:09

43 - Additional Sheet Tab Options.mp4

05:19

44 - 3Dimensional Formulas.mp4

05:28

45 - Module 9 Practice Exercise.mp4

01:31

10 - Excel 2019 Beginner Formatting Worksheets

46 - Formatting Cells Part 1.mp4

10:04

47 - Formatting Cells Part 2.mp4

03:38

48 - Formatting Numbers.mp4

09:24

49 - Borders and Shading.mp4

07:08

50 - Format as Table.mp4

06:07

51 - Using Styles.mp4

03:49

52 - Using Format Painter.mp4

04:29

53 - Protecting Sheets.mp4

09:01

54 - Fill Handle and Custom Lists.mp4

07:17

55 - Module 10 Practice Exercise.mp4

01:10

11 - Excel 2019 Beginner Charts

56 - Creating Charts.mp4

09:48

57 - Types of Charts.mp4

05:58

58 - Editing Charts Part 1.mp4

11:00

59 - Editing Charts Part 2.mp4

03:12

60 - Using Graphics to Enhance Charts.mp4

05:05

61 - Linking Chart Titles.mp4

02:47

62 - Module 11 Practice Exercise.mp4

00:53

12 - Excel 2019 Beginner Working with Names

63 - Creating Range Names.mp4

07:45

64 - Managing Names.mp4

03:17

65 - Using Names in Formulas.mp4

05:59

66 - Module 12 Practice Exercise.mp4

01:20

13 - Excel 2019 Beginner Sorting and Filtering

67 - Remove Duplicates.mp4

07:45

68 - Sort Data.mp4

10:28

69 - Filter Data.mp4

07:38

70 - Advanced Filters.mp4

04:46

71 - Module 13 Practice Exercise.mp4

00:57

14 - Excel 2019 Beginner Outlining and Subtotaling

72 - Creating an Outline.mp4

06:01

73 - Subtotals.mp4

08:00

74 - Module 14 Practice Exercise.mp4

01:08

15 - Excel 2019 Beginner Working with Views

75 - Arranging Files.mp4

03:14

76 - New Window Option.mp4

02:45

77 - Custom Views.mp4

05:32

78 - Module 15 Practice Exercise.mp4

01:07

16 - Excel 2019 Beginner Linking Files

79 - Creating Formulas Between File.mp4

06:35

80 - Working with Links.mp4

04:01

81 - Consolidating Data.mp4

05:16

82 - Module 16 Practice Exercise.mp4

01:30

17 - Excel 2019 Beginner Advanced Formula Creation

83 - If Statements.mp4

07:49

84 - VLookups.mp4

07:39

85 - Data Validation.mp4

08:13

86 - Formula Auditing.mp4

05:29

87 - Module 17 Practice Exercise.mp4

01:20

18 - Excel 2019 Beginner Pivot Tables

88 - Pivot Tables.mp4

09:36

89 - Pivot Charts.mp4

03:16

90 - Module 18 Practice Exercise.mp4

00:56

19 - Excel 2019 Beginner Additional Excel Features

91 - Slicers.mp4

04:41

92 - Goal Seeker.mp4

02:56

93 - Text to Columns.mp4

02:49

94 - Watch Window.mp4

02:32

95 - Customizing Ribbons and Tabs.mp4

03:25

96 - Module 19 Practice Exercise.mp4

01:23

20 - Excel 2019 Beginner Shortcuts

97 - Excel Shortcuts Every User Should Know.mp4

12:00

21 - Excel 2019 Beginner Closing

98 - Closing Video.mp4

00:37

22 - Excel 2019 Advanced Introduction to Excel 2019 Advanced Course

99 - Introduction to the Course.mp4

06:39

100 - WATCH ME Essential Information for a Successful Training Experience.mp4

02:11

101 - Excel 2019 Advanced Course Exercise Files.html

101 - Excel-2019-Advanced-Exercise-Files.zip

102 - Excel 2019 Advanced Course Demo Files.html

102 - Excel-2019-Advanced-Course-Files.zip

103 - Downloadable course transcripts.html

103 - Excel-2019-Advanced-Full-Transcripts.pdf

104 - Course Structure.mp4

04:19

23 - Excel 2019 Advanced Functions

105 - Functions Part 1.mp4

13:38

106 - Functions Part 2.mp4

08:04

107 - Autosum.mp4

06:01

24 - Excel 2019 Advanced Date and Time Functions

108 - How Date and Time Works.mp4

10:00

109 - Basic Date and Time Functions.mp4

09:43

110 - Complex Date and Time Functions.mp4

10:38

25 - Excel 2019 Advanced Text Functions

111 - Using Text Functions Part 1.mp4

12:21

112 - Using Text Functions Part 2.mp4

12:12

26 - Excel 2019 Advanced Logical Functions

113 - Logical Functions.mp4

09:44

114 - Exercise 01.mp4

01:58

27 - Excel 2019 Advanced Lookup Functions

115 - Lookup Functions Part 1.mp4

14:02

116 - Lookup Functions Part 2.mp4

07:56

117 - Exercise 02.mp4

05:37

28 - Excel 2019 Advanced Financial Functions

118 - Financial Functions and Terminology.mp4

08:51

119 - Personal Financial Functions.mp4

09:18

120 - Principal and Interest Payments.mp4

07:23

121 - Depreciation.mp4

05:04

122 - Exercise 03.mp4

01:37

29 - Excel 2019 Advanced Statistical Functions

123 - Statistical Functions for Description Part 1.mp4

13:32

124 - Statistical Functions for Description Part 2.mp4

13:43

125 - Statistical Functions for Forecasting Part 1.mp4

11:54

126 - Statistical Functions for Forecasting Part 2.mp4

11:45

127 - Exercise 04.mp4

01:45

128 - One Click Forecasting.mp4

08:56

129 - Statistical Functions for Inference.mp4

11:09

30 - Excel 2019 Advanced Connecting to External Data

130 - Connecting to Other Workbooks.mp4

13:09

131 - Connecting to Access Databases.mp4

12:50

132 - Connecting Web Data Sources.mp4

07:52

133 - Get and Transform.mp4

14:25

134 - Exercise 05.mp4

05:06

31 - Excel 2019 Advanced Tables

135 - Introduction to Tables.mp4

12:13

136 - Working with Tables.mp4

10:40

137 - Table References.mp4

08:31

138 - Table Styles.mp4

05:33

139 - Exercise 6.mp4

01:21

32 - Excel 2019 Advanced Pivot Tables

140 - Introduction to Pivot Tables.mp4

09:50

141 - Working with Pivot Tables.mp4

12:43

142 - Filters and Slicers.mp4

12:25

143 - Pivot and Charts.mp4

08:30

144 - Exercise 07.mp4

02:28

33 - Excel 2019 Advanced Data Analysis

145 - What If Analysis.mp4

10:15

146 - Scenario Manager.mp4

11:21

147 - Goal Seek.mp4

07:25

148 - Solver.mp4

12:00

149 - Exercise 08.mp4

01:43

34 - Graphs and Charts

150 - Area Charts.mp4

06:40

151 - Surface Charts.mp4

04:40

152 - Radar Charts.mp4

05:21

153 - Bubble Charts.mp4

07:19

154 - Sparklines.mp4

09:33

155 - Stock Charts.mp4

09:06

156 - Exercise 9.mp4

03:33

35 - Excel 2019 Advanced Excel Web App

157 - Web App Part 1.mp4

10:07

158 - Web App Part 2.mp4

09:52

36 - Excel 2019 Advanced Course Conclusion

159 - Close.mp4

00:49

37 - Excel 2019 for Mac Beginner Introduction to Excel

160 - Introduction to Excel for Mac.mp4

05:23

161 - WATCH ME Essential Information for a Successful Training Experience.mp4

02:11

162 - Course Exercise Files.html

162 - Excel-2019-For-Mac-Exercise-Files.zip

163 - Course Demo Files.html

163 - Excel-2019-for-Mac-Demo-Files.zip

164 - Downloadable Course Transcript.html

164 - Microsoft-Excel-2019-Mac-Course-by-Simon-Sez-IT.pdf

165 - The Difference between PC and Mac Excel.mp4

07:12

166 - Course Overview.mp4

03:42

167 - Overview of the Excel window.mp4

15:38

168 - Mouse and Trackpad Features.mp4

03:34

169 - Creating a New Workbook.mp4

03:17

38 - Excel 2019 for Mac Beginner Creating Workbooks

170 - Entering Text and Numbers.mp4

09:14

171 - Creating Basic Formulas.mp4

09:53

172 - Relative vs Absolute References.mp4

08:06

173 - Order of Operations.mp4

03:42

174 - Working with Ranges.mp4

06:52

175 - Practice Exercise 01.mp4

02:02

39 - Excel 2019 for Mac Beginner Saving Workbooks

176 - Saving and Sharing Spreadsheets.mp4

06:41

177 - Practice Exercise 02.mp4

00:53

40 - Excel 2019 for Mac Beginner Navigating Large Workbooks

178 - Freeze Panes Option.mp4

03:46

179 - Split Screen Option.mp4

02:35

180 - Arranging Windows Option.mp4

02:16

181 - Practice Exercise 03.mp4

00:57

41 - Excel 2019 for Mac Beginner Page Setup and Print Options

182 - Headers and Footers.mp4

06:20

183 - Print Titles.mp4

03:12

184 - Comments.mp4

06:05

185 - Page Setup Options.mp4

05:09

186 - Printing Workbooks.mp4

03:32

187 - Practice Exercise 04.mp4

01:23

42 - Excel 2019 for Mac Beginner Working with Rows Columns and Cells

188 - Adding and Deleting Rows Columns and Cells.mp4

03:42

189 - Changing Column and Row Widths.mp4

03:50

190 - Practice Exercise 05.mp4

01:07

43 - Excel 2019 for Mac Beginner Moving Data

191 - Cut Copy and Paste.mp4

07:38

192 - Copying Formulas.mp4

06:01

193 - Practice Exercise 06.mp4

01:14

44 - Excel 2019 for Mac Beginner Formulas and Functions

194 - Overview of Formulas.mp4

08:41

195 - Creating Formulas using Functions Part 1.mp4

13:25

196 - Creating Formulas using Functions Part 2.mp4

14:17

197 - Practice Exercise 07.mp4

02:08

45 - Excel 2019 for Mac Beginner Working with Sheets

198 - Sheet Tab Options.mp4

06:08

199 - 3 Dimensional Formulas.mp4

06:25

200 - Practice Exercise 08.mp4

02:09

46 - Excel 2019 for Mac Beginner Formatting Worksheets

201 - Formatting Cells Part 1.mp4

08:12

202 - Formatting Cells Part 2.mp4

07:35

203 - Number Formatting.mp4

07:13

204 - Formatting as Table.mp4

09:46

205 - Using Styles.mp4

08:15

206 - Conditional Formatting.mp4

10:19

207 - Using Format Painter.mp4

03:07

208 - Protecting Sheets.mp4

06:05

209 - Fill Handle and Custom Lists.mp4

04:43

210 - Practice Exercise 09.mp4

02:09

47 - Excel 2019 For Mac Beginner Charts

211 - Creating Charts.mp4

05:47

212 - Editing Charts Part 1.mp4

09:11

213 - Editing Charts Part 2.mp4

08:12

214 - Practice Exercise 10.mp4

01:25

48 - Excel 2019 for Mac BeginnerSorting and Filtering

215 - Remove Duplicates.mp4

06:42

216 - Sort Data.mp4

04:35

217 - Filter Data.mp4

06:29

218 - Advanced Filter.mp4

03:36

219 - Practice Exercise 11.mp4

01:08

49 - Excel 2019 for Mac Beginner Conclusion

220 - Course Close.mp4

01:25

50 - Extras

221 - EXTRA LESSON Designing Better Spreadsheets Webinar Recording.mp4

01:04:55

222 - EXTRA LESSON Data Cleaning in Excel Webinar Recording.mp4

52:26

223 - EXTRA LESSON Top Ten Excel Functions You HAVE to Know Webinar Recording.mp4

01:11:18

224 - EXTRA RESOURCE The Most Frequently Used Excel Shortcuts Infographic.html

224 - PC-Excel-Most-Used.pdf

51 - Additional Training

225 - READ ME This Additional Training Is Optional.html

226 - Ten Excel Tips and Tricks Part 1.mp4

43:23

227 - Ten Excel Tips and Tricks Part 2.mp4

40:36

228 - Ten Excel Tips and Tricks Part 3.mp4

37:09

Description

Finally master spreadsheets on PC or Mac with Excel, Beginners - Advanced 3 course 2019/365 bundle

What You'll Learn?

Now includes Excel for Mac 2019 Beginner
Discover new and improved features in Excel 2019
Learn to master data analysis tools like Pivot tables, Slicers, Sparklines and Data Bars in Excel
Learn essential logical functions like IF, SUMIF, COUNTIF
Learn powerful Lookup Functions VLOOKUP, HLOOKUP and INDEX MATCH
Complete data entry, cell formatting, working with multiple worksheets and the “Ribbon” interface.
You'll cover all the basics like how to rename, insert, move, and reference an Excel worksheet
Discover how to format dates and numbers in Excel
Learn practical methods in which you can backup and recover your Excel spreadsheets
Effectively use autofill and flashfill so you are more productive.
Discover the essentials of using fomulas and functions.
Discover how to create awesome charts and graphs in Excel
Learn practical methods to sort and filter your data using Microsoft Excel
How to protect and secure your Excel data
Working with dates and times in Microsoft Excel
Averages, percentiles, and LINEST functions
You'll learn financial and statistical functions like calculating depreciation
Learn to visualize your data using Sparklines, data bars and Pivot Charts in Excel
How to import and export data to and from Excel

Who is this for?

Those new to using Microsoft Excel.

No previous knowledge of Excel required. This course is created for absolute beginners.

If you want to refresh your memory and understanding of Excel.

Users of earlier versions of Excel looking to update their skills.

Users with basic knowledge of Excel and those upgrading from previous software versions

Users who have a foundation of Microsoft Excel and seeking to advance their Excel knowledge.

What You Need to Know?

Microsoft Excel desktop version for Windows installed and ready to use on your computer.

More details

Description
This course includes practice exercises and LIFETIME access
Feb 2020 - Excel Beginners for Mac 2019 Course added!

Everything you need to become a spreadsheet guru in Microsoft Excel 2019/365 from Beginner to Advanced users by Excel experts Simon Sez IT.

Excel for Beginners 2019
With this 7-hour Microsoft Excel 2019/365 course, youâ€™ll gain a fantastic grounding in Microsoft Excel. This in-depth course is perfect for those brand new to Excel and who are using Excel 2019 or Excel 365 editions. This course is perfect if youâ€™re brand new to Excel or are upgrading from an older version.

What You'll Learn
What's new in Excel 2019
Creating workbooks
Entering text, numbers and working with dates
Navigating workbooks
Page setup and print options
Working with rows, columns and cells
Cut, Copy and Paste
Introduction to functions and formulas
Formatting in Excel, including formatting cells and numbers
Creating charts and graphs
Sorting and Filtering
Introduction to PivotTables
Logical and lookup formulas - the basics

Advanced Excel 2019
With this 8-hour, expert-led video training course, youâ€™ll gain an in-depth understanding of more advanced Excel features that delve into high-level consolidation, analysis and reporting of financial information.

What You'll Learn
What's new/different in Excel 2019
Advanced charting and graphing in Excel
How to use detailed formatting tools
Lookup and advanced lookup functions
Financial functions including calculating interest and depreciation
Statistical functions
Connecting to other workbooks and datasets outside of Excel e.g. MS Access and the web.
How to create awesome visualizations using sparklines and data bars
Mastery of PivotTables and Pivot Charts
Scenario Manager, Goal Seek and Solver
Advanced charts such as Surface, Radar, Bubble and Stock Charts
Exercise and demo files included in both courses

This 3-course bundle includes:
20-hours of video tutorials
Over 200 individual video lectures
Exercise files to practice what you learned
Demo files used by the trainer
Certificates of completion

This Excel mega bundle is designed for students of all Excel capabilities. If you are brand new to Microsoft Excel or who are upgrading from a previous version and want to keep up to date with Excel 2019 and 365 developments, then the start at the beginning.
If you already have a good understanding of MS Excel then you might want to start in the Advanced section where the expert author will help you take your spreadsheeting skills to the next level.

Contents and Overview
Through 200+ lectures and over 20-hours of content, this course will teach you to understand spreadsheet basics, including:
Creating your first workbook and how to navigate Excel
Page and print setup - just print the bits of Excel you mean to!
Moving data around and adding and deleting
Introduction to formulas and functions, what you need to know.
How to create amazing looking charts and graphs
Before moving onto the most business-relevant advanced functions and formulas you might need. This includes:
Financial functions (interest depreciation etc.)
Statistical functions
How to best visualize your data using PivotTables and Pivot Charts
Advanced charting
And so much more...

Upon completion of this course, you'll have a great grounding in Excel formulas and functions. Youâ€™ll be confident in navigating, sharing and using spreadsheets in a variety of ways.
Youâ€™ll be able to create charts that have an impact from databases that communicate data and financial records efficiently and effectively.
You will be able to report data in various formats including: tables, graphs and PivotTables. Once completed you'll have advanced understanding of Excel that will positively impact your professional capability.

Hereâ€™s what our students are sayingâ€¦
â˜…â˜…â˜…â˜…â˜… "A comprehensive and well structured course, and the examples and explanations are clearly presented; and the instructor is very engaging, easy to listen to and even entertaining (which is always a plus for keeping ones interest.â€
- Arnold Schwartz
â˜…â˜…â˜…â˜…â˜… â€œInstructor explains topics in clearly. The course is relevant and is helpful to people who have no or little experience with Excel like me. Update: The instructor makes learning fun and simple, I have been learning many different functions that are necessary when applying to real life business situations.â€
- Daniel Trujillo

â˜…â˜…â˜…â˜…â˜… â€œOne of the BEST courses I have taken on Excel. This course takes the student through all of the options for charting and data visualization. The examples are structured so there is no redundancy and time wasting steps. Well done!â€
- Jim Tibbetts

Did you know?
Simon Sez IT teaches all sorts of software, including:
- Microsoft Excel
- Microsoft PowerPoint
- Microsoft Word
- Microsoft Project
- Microsoft Outlook
- QuickBooks
- Photoshop Elements
- Web Development Languages
- And so much more!
Who this course is for:
Those new to using Microsoft Excel.
No previous knowledge of Excel required. This course is created for absolute beginners.
If you want to refresh your memory and understanding of Excel.
Users of earlier versions of Excel looking to update their skills.
Users with basic knowledge of Excel and those upgrading from previous software versions
Users who have a foundation of Microsoft Excel and seeking to advance their Excel knowledge.

User Reviews

Rating

average 0

Total votes0

Focused display

Excel

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.