The Ultimate Microsoft Excel Bundle - 7 Courses, 50+ Hours

Focused View

Simon Sez IT

43:47:54

160 View

1 - Microsoft Excel 2021 for Beginners Introduction

1 - Course Introduction.mp4

02:19

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

02:11

3 - Downloadable Course Transcript.html

3 - Excel-2021-Beginners-Transcription.pdf

4 - DOWNLOAD ME Course Files.html

4 - Microsoft-Excel-2021-for-Beginners-Course-Files.zip

5 - DOWNLOAD ME Exercise Files.html

5 - Microsoft-Excel-2021-for-Beginners-Exercises-Files.zip

6 - Excel 2021 vs Excel for Microsoft 365.mp4

05:39

2 - Microsoft Excel 2021 for Beginners Getting Started in Excel 2021

7 - Launching Excel.mp4

03:38

8 - The Start Screen.mp4

10:12

9 - Exploring the Interface.mp4

11:39

10 - Understanding Ribbons Tabs and Menus.mp4

08:29

11 - The Backstage Area.mp4

04:40

12 - Customizing the Quick Access Toolbar.mp4

09:43

13 - Useful Keyboard Shortcuts.mp4

09:41

14 - Getting Help.mp4

06:36

15 - Exercise 01.mp4

02:19

3 - Microsoft Excel 2021 for Beginners Creating You First Excel Spreadsheet

16 - Working with Excel Templates.mp4

09:02

17 - Working with Workbooks and Worksheets.mp4

07:34

18 - Saving Workbooks and Worksheets.mp4

08:44

19 - Entering and Editing Data.mp4

09:53

20 - Navigating and Selecting Cells Rows and Columns.mp4

07:21

21 - Exercise 02.mp4

05:19

4 - Microsoft Excel 2021 for Beginners Introduction to Excel Formulas and Functions

22 - Formulas and Functions Explained.mp4

11:42

23 - Performing Calculations with the SUM Function.mp4

07:38

24 - Counting Values and Blanks.mp4

07:26

25 - Finding the Average with the AVERAGE Function.mp4

04:18

26 - Working with the MIN and MAX Functions.mp4

02:24

27 - Handling Errors in Formulas.mp4

08:41

28 - Absolute vs Relative Referencing.mp4

06:56

29 - Autosum and AutoFill.mp4

09:41

30 - Flash Fill.mp4

05:02

31 - Exercise 03.mp4

05:12

5 - Microsoft Excel 2021 for Beginners Using Named Ranges

32 - What are Named Ranges.mp4

04:40

33 - Creating Named Ranges.mp4

04:25

34 - Managing Named Ranges.mp4

03:49

35 - Using Named Ranges in Calculations.mp4

05:19

36 - Exercise 04.mp4

04:17

6 - Microsoft Excel 2021 for Beginners Formatting Numbers and Cells

37 - Applying Number Formats.mp4

10:02

38 - Applying Date and Time Formats.mp4

05:39

39 - Formatting Cells Rows and Columns.mp4

08:38

40 - Using Format Painter.mp4

04:39

41 - Exercise 05.mp4

04:06

7 - Microsoft Excel 2021 for Beginners Formatting Worksheets

42 - Working with Rows and Columns.mp4

08:25

43 - Deleting and Clearing Cells.mp4

06:25

44 - Aligning Text and Numbers.mp4

11:13

45 - Applying Themes and Styles.mp4

07:41

46 - Exercise 06.mp4

05:22

8 - Microsoft Excel 2021 for Beginners Working with Excel Lists

47 - How to Structure a List.mp4

04:37

48 - Sorting a List SingleLevel Sort.mp4

05:06

49 - Sorting a List MultiLevel Sort.mp4

05:06

50 - Sorting Using a Custom List Custom Sort.mp4

08:12

51 - Using Autofilter to Filter a List.mp4

06:45

52 - Format as a Table.mp4

10:18

53 - Creating Subtotals in a List.mp4

07:34

54 - Exercise 07.mp4

04:37

9 - Microsoft Excel 2021 for Beginners Moving and Linking to Data

55 - Using Cut and Copy.mp4

04:56

56 - Paste Options.mp4

07:45

57 - Pasting from the Clipboard.mp4

04:31

58 - Linking to Other Worksheets and Workbooks.mp4

06:26

59 - 3D Referencing.mp4

05:54

60 - Inserting Hyperlinks to Worksheets.mp4

09:39

61 - Exercise 08.mp4

04:41

10 - Microsoft Excel 2021 for Beginners An Introduction to Intermediate Formulas

62 - Looking up Information with VLOOKUP.mp4

10:02

63 - VLOOKUP Approximate Match.mp4

05:08

64 - Error Handling Functions.mp4

07:10

65 - Basic Logical Functions IF AND OR.mp4

12:24

66 - Making Decisions with IF Statements.mp4

04:33

67 - Cleaning Data Using Text Functions.mp4

12:09

68 - Working with Time and Date Functions.mp4

11:17

69 - Exercise 09.mp4

10:19

11 - Microsoft Excel 2021 for Beginners Analyzing Data with Charts

70 - Choosing the Correct Chart Type.mp4

06:34

71 - Presenting Data with Charts.mp4

10:01

72 - Formatting Charts.mp4

12:51

73 - Exercise 10.mp4

03:54

12 - Microsoft Excel 2021 for Beginners Conditional Formatting

74 - Highlighting Cell Values.mp4

07:13

75 - Data Bars.mp4

05:32

76 - Color Scales.mp4

04:55

77 - Icon Sets.mp4

07:49

78 - Exercise 11.mp4

05:43

13 - Microsoft Excel 2021 for Beginners Inserting Items into a Spreadsheet

79 - Inserting Pictures.mp4

10:53

80 - Inserting Shapes and Text Boxes.mp4

09:04

81 - Inserting Icons and 3D Models.mp4

06:00

82 - Creating Diagrams Using SmartArt.mp4

10:41

83 - Inserting Screenshots.mp4

04:27

84 - Inserting Comments.mp4

05:13

85 - Exercise 12.mp4

09:16

14 - Microsoft Excel 2021 for Beginners Working with Views and Zoom

86 - Workbook Views.mp4

06:21

87 - Using Zoom in a Worksheet.mp4

02:56

88 - Arranging Workbooks and Worksheets.mp4

05:01

89 - Freezing Panes.mp4

04:00

90 - Exercise 13.mp4

03:26

15 - Microsoft Excel 2021 for Beginners Page Layout and Print Options

91 - Setting Margins and Orientation.mp4

05:05

92 - Setting and Clearing the Print Area.mp4

02:53

93 - Inserting Page Breaks.mp4

04:32

94 - Setting Print Titles and a Background.mp4

04:29

95 - Inserting Headers and Footers.mp4

05:42

96 - Printing a Workbook.mp4

06:00

97 - Exercise 14.mp4

03:06

16 - Microsoft Excel 2021 for Beginners Finalizing the Spreadsheet

98 - Protecting Workbooks and Worksheets.mp4

09:02

99 - Spell Checking.mp4

03:45

100 - Inspecting the Workbook.mp4

07:21

101 - Saving the Workbook in Different Formats.mp4

04:21

102 - Sharing a Workbook.mp4

05:35

103 - Exercise 15.mp4

03:28

17 - Microsoft Excel 2021 for Beginners Course Close

104 - Course Close.mp4

01:06

18 - Microsoft Excel 2021 Intermediate Introduction

105 - Course Introduction.mp4

06:16

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

02:11

107 - Downloadable Course Transcript.html

107 - Excel-2021-Intermediate-Transcription.pdf

108 - DOWNLOAD ME Course Exercise Files.html

108 - Microsoft-Excel-2021-Intermediate-Exercises-Files.zip

109 - DOWNLOAD ME Course Instructor Files.html

109 - Microsoft-Excel-2021-Intermediate-Course-Files.zip

19 - Microsoft Excel 2021 Intermediate Designing Better Spreadsheets

110 - The Golden Rules of Spreadsheet Design.mp4

11:54

111 - Improving Readability with Cell Styles.mp4

04:58

112 - Controlling Data Input.mp4

08:19

113 - Adding Navigation Buttons.mp4

08:42

20 - Microsoft Excel 2021 Intermediate Making Decisions with Logical Functions

114 - Logical Functions AND OR IF.mp4

13:18

115 - The IF Function.mp4

05:26

116 - Nested IFs.mp4

08:01

117 - The IFS Function.mp4

06:04

118 - Conditional IFs SUMIF COUNTIF AVERAGEIF.mp4

06:45

119 - Multiple Criteria SUMIFS COUNTIFS AVERAGEIFS.mp4

07:12

120 - Error Handling with IFERROR and IFNA.mp4

06:01

121 - Exercise 01.mp4

07:29

21 - Microsoft Excel 2021 Intermediate Looking Up Information

122 - Looking Up Information using VLOOKUP Exact Match.mp4

10:41

123 - Looking Up Information using VLOOKUP Approx Match.mp4

04:25

124 - Looking Up Information Horizontally using HLOOKUP.mp4

05:38

125 - Performing Flexible Lookups with INDEX and MATCH.mp4

10:28

126 - Using XLOOKUP and XMATCH.mp4

10:09

127 - The OFFSET Function.mp4

10:50

128 - The INDIRECT Function.mp4

09:07

129 - Exercise 02.mp4

05:03

22 - Microsoft Excel 2021 Intermediate Advanced Sorting and Filtering

130 - Performing Sorts on Multiple Columns.mp4

07:03

131 - Sorting Using a Custom List.mp4

03:35

132 - The SORT and SORTBY Functions.mp4

10:00

133 - Using the Advanced Filter.mp4

06:52

134 - Extracting Unique Values The UNIQUE Function.mp4

05:16

135 - The FILTER Function.mp4

09:30

136 - Exercise 03.mp4

05:41

23 - Microsoft Excel 2021 Intermediate Working with Date and Time

137 - Understanding How Dates are Stored in Excel.mp4

04:11

138 - Applying Custom Date Formats.mp4

07:09

139 - Using Date and Time Functions.mp4

08:44

140 - Using the WORKDAY and WORKDAYINT Functions.mp4

03:49

141 - Using the NETWORKDAYS and NETWORKDAYSINT Function.mp4

02:57

142 - Tabulate Date Differences with the DATEDIF Function.mp4

06:14

143 - Calculate Dates with EDATE and EOMONTH.mp4

07:22

144 - Exercise 04.mp4

04:51

24 - Microsoft Excel 2021 Intermediate Preparing Data for Analysis

145 - Importing Data into Excel.mp4

09:56

146 - Removing Blank Rows Cells and Duplicates.mp4

05:20

147 - Changing Case and Removing Spaces.mp4

09:03

148 - Splitting Data using Text to Columns.mp4

07:03

149 - Splitting Data using Text Functions.mp4

08:05

150 - Splitting or Combining Cell Data Using Flashfill.mp4

05:00

151 - Joining Data using CONCAT.mp4

07:30

152 - Formatting Data as a Table.mp4

08:33

153 - Exercise 05.mp4

05:41

25 - Microsoft Excel 2021 Intermediate PivotTables

154 - PivotTables Explained.mp4

02:12

155 - Creating a PivotTable from Scratch.mp4

04:49

156 - Pivoting the PivotTable Fields.mp4

05:31

157 - Applying Subtotals and Grand Totals.mp4

03:14

158 - Applying Number Formatting to PivotTable Data.mp4

03:00

159 - Show Values As and Summarize Values By.mp4

05:50

160 - Grouping PivotTable Data.mp4

05:39

161 - Formatting Error Values and Empty Cells.mp4

05:02

162 - Choosing a Report Layout.mp4

04:35

163 - Applying PivotTable Styles.mp4

04:49

164 - Exercise 06.mp4

04:05

26 - Microsoft Excel 2021 Intermediate Pivot Charts

165 - Creating a Pivot Chart.mp4

05:04

166 - Formatting a Pivot Chart Part 1.mp4

08:36

167 - Formatting a Pivot Chart Part 2.mp4

09:14

168 - Using Map Charts.mp4

05:30

169 - Exercise 07.mp4

04:18

27 - Microsoft Excel 2021 Intermediate Adding Interaction to PivotTables and Charts

170 - Inserting and Formatting Slicers.mp4

07:30

171 - Inserting Timeline Slicers.mp4

05:07

172 - Connecting Slicers to Pivot Charts.mp4

05:01

173 - Updating PivotTable Data.mp4

04:25

174 - Exercise 08.mp4

06:48

28 - Microsoft Excel 2021 Intermediate Interactive Dashboards

175 - What is a Dashboard.mp4

05:27

176 - Assembling a Dashboard Part 1.mp4

11:25

177 - Assembling a Dashboard Part 2.mp4

10:47

178 - Assembling a Dashboard Part 3.mp4

08:49

179 - Exercise 09.mp4

02:27

29 - Microsoft Excel 2021 Intermediate Formula Auditing

180 - Troubleshooting Common Errors.mp4

08:11

181 - Tracing Precedents and Formula Auditing.mp4

07:44

182 - Exercise 10.mp4

07:30

30 - Microsoft Excel 2021 Intermediate Data Validation

183 - Creating Dynamic Dropdown Lists.mp4

07:27

184 - Other Types of Data Validation.mp4

07:05

185 - Custom Data Validation.mp4

10:10

186 - Exercise 11.mp4

06:53

31 - Microsoft Excel 2021 Intermediate WhatIf Analysis Tools

187 - Goal Seek and the PMT Function.mp4

05:33

188 - Using Scenario Manager.mp4

07:27

189 - Data Tables One Variable.mp4

04:29

190 - Data Tables Two Variables.mp4

04:12

191 - Exercise 12.mp4

08:32

32 - Microsoft Excel 2021 Intermediate Course Close

192 - Course Close.mp4

01:34

33 - Microsoft Excel 2021 Advanced Introduction

193 - Course Introduction.mp4

02:46

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

02:11

195 - Downloadable Course Transcript.html

195 - Excel-2021-Advanced-Transcription.pdf

196 - DOWNLOAD ME Course Exercise Files.html

196 - Microsoft-Excel-2021-Advanced-Exercises-Files.zip

197 - DOWNLOAD ME Course Instructor Files.html

197 - Microsoft-Excel-2021-Advanced-Course-Files.zip

198 - Exercise 01.mp4

01:47

34 - Microsoft Excel 2021 Advanced Dynamic Arrays

199 - What are Dynamic Arrays.mp4

02:14

200 - Introduction to Spills and Arrays.mp4

10:49

201 - Extract and Count Unique Entries.mp4

06:14

202 - Unique vs Distinct.mp4

03:24

203 - Extract Unique Values with Multiple Criteria.mp4

03:11

204 - Extract Unique Values by Column.mp4

04:23

205 - The SORT Function.mp4

08:53

206 - The SORT Function Horizontal SORT.mp4

06:06

207 - The SORTBY Function.mp4

06:10

208 - The SORTBY Function Horizontal SORT.mp4

03:05

209 - Simple SEQUENCE and Unstacking Records.mp4

10:10

210 - The FILTER Function.mp4

06:51

211 - FILTER with Logic Operator OR.mp4

04:48

212 - FILTER with Logic Operator AND.mp4

05:39

213 - FILTER with Logic Operator Both or Neither.mp4

04:11

214 - FILTER with Logic Operator One or the Other.mp4

04:49

215 - Using RANDARRAY and RANDBETWEEN to Randomize Data.mp4

09:44

216 - Using XLOOKUP to Perform Complex Lookups.mp4

12:22

217 - Using XMATCH.mp4

06:20

218 - Exercise 02.mp4

13:09

35 - Microsoft Excel 2021 Advanced Advanced Lookup and Reference Functions

219 - Performing 2Way Lookups.mp4

08:25

220 - Using the CHOOSE Function.mp4

10:02

221 - Using the SWITCH Function.mp4

04:31

222 - Exercise 03.mp4

07:05

36 - Microsoft Excel 2021 Advanced Statistical Functions

223 - Using MEDIAN MODESNGL and MODEMULT.mp4

06:16

224 - Using LARGE and SMALL.mp4

07:27

225 - Ranking Data with Sorting using RANKEQ and RANKAVG.mp4

07:41

226 - The COUNTBLANK Function.mp4

04:45

227 - Exercise 04.mp4

07:05

37 - Microsoft Excel 2021 Advanced Math Functions

228 - Rounding Values using ROUND ROUNDUP and ROUNDDOWN.mp4

06:59

229 - Specialized Rounding MROUND CEILINGMATH and FLOORMATH.mp4

04:30

230 - Using the AGGREGATE Function.mp4

04:32

231 - Exercise 05.mp4

05:52

38 - Microsoft Excel 2021 Advanced New Functions LET and LAMBDA

232 - The LET Function.mp4

15:07

233 - The LAMBDA Function.mp4

14:13

234 - Exercise 06.mp4

11:49

39 - Microsoft Excel 2021 Advanced Advanced PivotTables and Pivot Charts

235 - Creating a Custom PivotTable Style.mp4

09:47

236 - Applying Custom Number Formatting.mp4

10:01

237 - Sorting Using Custom Lists.mp4

04:38

238 - Applying Multiple Filters to Data.mp4

05:06

239 - Adjusting Slicer Settings.mp4

12:02

240 - Locking Workbooks but not Slicers.mp4

03:18

241 - Creating a Calculated Field.mp4

08:01

242 - Creating a Calculated Item.mp4

06:30

243 - Solve Order.mp4

08:11

244 - GETPIVOTDATA.mp4

11:57

245 - Using GETPIVOTDATA Dependent Data Validation Lists.mp4

08:37

246 - Creating a Dynamic Pivot Chart Title.mp4

10:41

247 - Adding a Dynamic Series to a Pivot Chart.mp4

12:47

248 - Adding Totals to a Stacked Column Chart.mp4

05:52

249 - Exercise 07.mp4

10:10

40 - Microsoft Excel 2021 Advanced Form Controls

250 - Introduction to Form Controls.mp4

04:14

251 - Combo Box Select from a List.mp4

07:21

252 - Check Box CheckUncheck Option.mp4

06:48

253 - Option Button Choose an Option.mp4

06:30

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

05:54

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

04:59

256 - Scroll Bar Scroll Through a List.mp4

05:01

257 - Exercise 08.mp4

05:57

41 - Microsoft Excel 2021 Advanced Working with Power Query

258 - Power Query Overview.mp4

01:35

259 - Importing Data Using Get and Transform.mp4

07:09

260 - The Power Query Editor.mp4

04:45

261 - Combining Files.mp4

04:52

262 - Transforming Files.mp4

09:30

263 - Loading Files into Excel.mp4

04:02

264 - Exercise 09.mp4

05:54

42 - Microsoft Excel 2021 Advanced Forecasting

265 - Getting Forecast Data with FRED.mp4

05:34

266 - Creating a Linear Sales Forecast.mp4

08:21

267 - Creating a Sales Forecast with Seasonality.mp4

05:02

268 - Adding Confidence Levels.mp4

06:58

269 - Using Forecast Sheets.mp4

07:16

270 - Exercise 10.mp4

02:21

43 - Microsoft Excel 2021 Advanced Macros and VBA

271 - Using Macros to Automate Tasks.mp4

06:40

272 - Recording Saving and Running Macros.mp4

10:00

273 - Recording a Macro with Relative Referencing.mp4

06:58

274 - Multistep Macros.mp4

07:09

275 - The VBA Editor.mp4

07:55

276 - Assigning Macros to Buttons.mp4

06:43

277 - Creating a Custom Macro Ribbon.mp4

06:34

278 - Exercise 11.mp4

05:29

44 - Microsoft Excel 2021 Advanced Practical Excel Advanced Formulas

279 - Finding the Last Occurrence of a Value.mp4

07:48

280 - Finding the Closest Value.mp4

06:15

281 - Extract Data from the Middle of a String.mp4

08:53

282 - Exercise 12.mp4

05:45

45 - Microsoft Excel 2021 Advanced Course Close

283 - Course Close.mp4

03:23

46 - Excel for Business Analysts Introduction

284 - Introduction to Business Analysis.mp4

05:25

285 - DOWNLOAD ME Course Exercise Files.html

285 - Excel-for-Business-Analysts-Exercise-Files.zip

286 - DOWNLOAD ME Course Instructor Files.html

286 - Excel-for-Business-Analysts-Course-Files.zip

47 - Excel for Business Analysts The Basics

287 - A Recap of Basic Formulas.mp4

12:42

288 - Absolute vs Relative Referencing.mp4

08:15

289 - Exercise 01.mp4

02:03

48 - Excel for Business Analysts Merging and Looking Up Data

290 - Merging Data from Different Sources.mp4

02:48

291 - Looking Up Information with VLOOKUP Exact.mp4

10:57

292 - Looking Up information with VLOOKUP Approx.mp4

06:27

293 - How to Use VLOOKUP with Data that Expands.mp4

10:00

294 - Using HLOOKUP.mp4

12:16

295 - Combining VLOOKUP and MATCH.mp4

12:25

296 - Using INDEX MATCH and XLOOKUP.mp4

17:25

297 - Data Validation Lists with Lookups.mp4

08:30

298 - Exercise 02.mp4

06:24

49 - Excel for Business Analysts Making Better Decisions with IF

299 - How to Use the IF function.mp4

05:30

300 - More Examples of the IF Function.mp4

07:08

301 - Working with Nested Ifs.mp4

06:35

302 - The IFS function.mp4

08:47

303 - Error handling with IFERROR and IFNA.mp4

09:21

304 - Using MAX and MIN instead of the IF function.mp4

11:25

305 - Using SUMIFS and COUNTIFS.mp4

11:51

306 - Exercise 03.mp4

01:32

50 - Excel for Business Analysts Preparing Data for Analysis

307 - Splitting Data Using Text Functions.mp4

16:13

308 - Using the Flash Fill Command.mp4

04:39

309 - Concatenating Data.mp4

09:03

310 - Standardizing Data.mp4

09:00

311 - Formatting Data as a Table.mp4

09:45

312 - Exercise 04.mp4

02:28

51 - Excel for Business Analysts PivotTables

313 - An Introduction to PivotTables.mp4

03:15

314 - Creating a PivotTable.mp4

12:40

315 - Summarizing Data.mp4

13:52

316 - Calculations in PivotTables.mp4

15:13

317 - Using Slicers to filter information.mp4

09:55

318 - Exercise 05.mp4

01:53

52 - Excel for Business Analysts Visualizing Data with Charts

319 - Creating a Pivot Chart.mp4

10:38

320 - Formatting a Pivot Chart.mp4

14:25

321 - Using Sparklines.mp4

07:52

322 - A Basic Interactive Dashboard.mp4

14:45

323 - Exercise 06.mp4

02:51

53 - Excel for Business Analysts Forecasting

324 - Forecast Sheets.mp4

07:18

325 - The Forecast Function.mp4

07:24

326 - Exercise 07.mp4

01:35

54 - Excel for Business Analysts Additional Useful Tools in Excel

327 - Conditional Formatting.mp4

11:28

328 - The INDIRECT Function.mp4

13:29

329 - The OFFSET Function.mp4

10:32

330 - Using Histograms.mp4

04:55

331 - Regression.mp4

06:41

332 - Exercise 08.mp4

02:12

55 - Excel for Business Analysts WhatIf Analysis

333 - Goal Seek.mp4

07:43

334 - Scenario Manager.mp4

08:01

335 - Data Tables.mp4

07:13

336 - Solver.mp4

06:50

337 - Exercise 09.mp4

01:42

56 - Excel for Business Analysts Course Close

338 - Course Close.mp4

00:44

57 - PowerPivot PowerQuery DAX Introduction

339 - Welcome and Overview.mp4

03:02

340 - DOWNLOAD ME Course Exercise Files.html

340 - PowerPivot-PowerQuery-DAX-Exercise-Files.zip

341 - DOWNLOAD ME Course Instructor Files.html

341 - PowerPivot-PowerQuery-DAX-Instructor-Demo-Files.zip

342 - What is Power Query.mp4

05:24

343 - What is Power Pivot.mp4

03:43

58 - PowerPivot PowerQuery DAX Getting Started with Power Query

344 - Exploring the Power Query Editor.mp4

06:29

345 - Common Power Query Transformations.mp4

08:59

346 - Editing an Existing Query.mp4

09:55

347 - Import Multiple Files from a Folder.mp4

11:06

348 - Connect to Data in Another Excel Workbook.mp4

09:37

349 - Troubleshooting Data Errors When Using the Sample Files.mp4

02:11

350 - IMPORTANT Checking the Location of your Querys Source.mp4

03:34

351 - Get Data From the Web.mp4

05:39

352 - Practise Exercise.mp4

01:05

59 - PowerPivot PowerQuery DAX Useful Power Query Features

353 - Unpivoting Columns.mp4

05:32

354 - Combine Data from Multiple Tables with Merge Queries.mp4

06:11

355 - Use Merge Queries to Compare Two Tables.mp4

05:03

356 - Stack Data into One Table with Append Queries.mp4

06:02

357 - Duplicating and Referencing Queries.mp4

09:10

358 - Grouping and Aggregating Data.mp4

07:53

359 - Conditional Columns in Power Query.mp4

07:14

360 - Practise Exercise.mp4

01:14

60 - PowerPivot PowerQuery DAX Creating the Data Model

361 - Enable the Power Pivot AddIn.mp4

01:54

362 - Understanding the Power Pivot Window.mp4

04:42

363 - Creating Relationships Between tables.mp4

05:03

364 - Managing the Relationships of the Model.mp4

03:01

365 - Creating a PivotTable from the Data Model.mp4

04:42

366 - Hide Fields from Client Tools.mp4

03:19

367 - Grouping Queries.mp4

04:33

368 - Practise Exercise.mp4

00:49

61 - PowerPivot PowerQuery DAX Introduction to DAX

369 - Why use DAX.mp4

03:14

370 - Creating Calculated Columns with DAX.mp4

05:09

371 - Creating your First DAX Measure.mp4

06:17

372 - The COUNTROWS Function.mp4

05:09

373 - SUMX and RELATED Functions.mp4

04:45

374 - Practise Exercise.mp4

00:49

62 - PowerPivot PowerQuery DAX More DAX Measures

375 - Create a Date Table in Power Pivot.mp4

08:46

376 - The CALCULATE Function.mp4

03:31

377 - The DIVIDE Function.mp4

03:09

378 - Using the DATESYTD Function.mp4

02:20

379 - Calculate the Percentage of a Total.mp4

06:17

380 - Practise Exercise.mp4

01:05

63 - PowerPivot PowerQuery DAX Using PivotTables and Slicers

381 - Create PivotTables and PivotCharts.mp4

11:57

382 - Using Slicers with your PivotTables.mp4

06:21

383 - Create a Top 10 PivotTable.mp4

08:25

384 - Practise Exercise.mp4

00:47

64 - PowerPivot PowerQuery DAX Closing

385 - Wrap Up.mp4

01:26

65 - Pivot Tables for Beginners Introduction

386 - Course Introduction.mp4

05:10

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

02:03

388 - DOWNLOAD ME Course Exercise Files.html

388 - Pivot-Tables-Exercise-Files.zip

389 - DOWNLOAD ME Course Instructor Files.html

389 - Pivot-Tables-Course-Files.zip

390 - What are Pivot Tables and Why are They Useful.mp4

06:12

66 - Pivot Tables for Beginners Preparing Data for Analysis

391 - The Importance of Cleaning Data.mp4

03:05

392 - Removing Blank Rows.mp4

05:30

393 - Removing Duplicate Rows.mp4

02:37

394 - Clearing Formatting.mp4

04:26

395 - Applying Number Formatting.mp4

08:38

396 - Changing the Case.mp4

09:16

397 - Removing Spaces and Nonprinting Characters.mp4

10:06

398 - Merging and Splitting Columns.mp4

13:00

399 - Convert Numbers Stored as Text.mp4

02:28

400 - Finding and Replacing Text.mp4

06:07

401 - Spell Check.mp4

03:57

402 - Exercise 01.mp4

04:01

67 - Pivot Tables for Beginners The Importance of Excel Tables

403 - Excel Tables vs Pivot Tables.mp4

05:24

404 - Format Data as a Table.mp4

08:47

405 - Exercise 02.mp4

01:50

68 - Pivot Tables for Beginners Creating a Basic Pivot Table Report

406 - Using Recommended Pivot Tables.mp4

05:29

407 - Creating a Pivot Table from Scratch.mp4

05:45

408 - Pivot Table Ribbons and Fields.mp4

06:39

409 - Pivoting the Fields.mp4

05:32

410 - Adding Multiple Dimensions.mp4

02:47

411 - Deleting Fields and Locking the Report Layout.mp4

03:41

412 - Exercise 03.mp4

01:37

Description

Master Microsoft Excel with this huge-value beginner to advanced seven-course bundle and become an Excel power user!

What You'll Learn?

Become familiar with what’s new in Excel 2021 and navigate the Excel 2021 interface
Create your first Excel spreadsheet and use basic and intermediate Excel formulas and functions
Utilize useful keyboard shortcuts to increase productivity
Linking to other worksheets & workbooks and protecting & sharing workbooks
How to use logical functions to make better business decisions
Creating an interactive dashboard to present high-level metrics
Using the NEW dynamic array functions to perform tasks
Recording and running macros to automate repetitive tasks
Predicting future values using forecast functions and forecast sheets
Using statistical functions to rank data and to calculate the MEDIAN and MODE
Understanding and making minor edits to VBA code
How to merge data from different sources using VLOOKUP, HLOOKUP, INDEX MATCH, and XLOOKUP
How to standardize and clean data ready for analysis in Excel
Conducting a Linear Forecast and Forecast Smoothing in Excel
All about Histograms and Regression in Excel
How to use Goal Seek, Scenario Manager, and Solver to fill data gaps in Excel
Learn to unlock advanced Excel tools Power Query and Power Pivot
Analyze huge buckets of data to make informed business decisions
How to create PivotTables
Grouping and ungrouping PivotTable data and dealing with errors
Creating PivotCharts and adding sparklines and slicers
Adding slicers and timelines and applying them to multiple tables
Combining data from multiple worksheets for a PivotTable
All about the GETPIVOTDATA function
How to use 3D maps from a PivotTable
Updating your data in a PivotTable and PivotChart

Who is this for?

Suitable for learners of all levels

Excel users upgrading from a previous version and want to keep up to date with Excel 2021 developments

Business analysts or those looking to perform Data Analysis using Excel

Beginner Excel users who want to learn how to use Pivot Tables

Advanced Excel users who want to learn Power Pivot and Power Query

More details

Description
This bundle includes practice exercises, downloadable files, and LIFETIME access

Let us take you on a journey from being an Excel novice to an Excel expert with this amazing value 7-course training bundle. By the end of this training, you will be able to clean, summarize, and analyze data easily, as well as create PivotTables, charts, macros, and so much more!

We'll take you on a no-nonsense journey to learn specific functions, formulas, and tools that Excel has to help conduct business or data analysis. We'll also look at three advanced Excel features: Power Pivot, Power Query, and DAX. This suite of Excel functions allows you to manipulate, analyze, and evaluate millions of rows of data from Excel or other databases.

This ultimate Excel course bundle is designed for students of all levels. If you are brand new to Microsoft Excel, this course can get you started on your journey. If you already have a good understanding of Excel, you can further your skills with the more advanced courses in this bundle. This is the only Excel training you are ever going to need!

All courses include practice exercises and follow-along instructor files so you can immediately apply what you learn.

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

Excel 2021 Intermediate
Designing better spreadsheets and controlling user input
How to use logical functions to make better business decisions
Constructing functional and flexible lookup formulas
How to use Excel tables to structure data and make it easy to update
Extracting unique values from a list
Sorting and filtering data using advanced features and new Excel formulas
Working with date and time functions
Extracting data using text functions
Importing data and cleaning it up before analysis
Analyzing data using PivotTables
Representing data visually with PivotCharts
Adding interactions to PivotTables and PivotCharts
Creating an interactive dashboard to present high-level metrics
Auditing formulas and troubleshooting common Excel errors
How to control user input with data validation
Using 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.

Excel for Business Analysts
How to merge data from different sources using VLOOKUP, HLOOKUP, INDEX MATCH, and XLOOKUP
How to use IF, IFS, IFERROR, SUMIF, and COUNTIF to apply logic to your analysis
How to split data using text functions SEARCH, LEFT, RIGHT, MID
How to standardize and clean data ready for analysis
About using the PivotTable function to perform data analysis
How to use slicers to draw out information
How to display your analysis using Pivot Charts
All about forecasting and using the Forecast Sheets
Conducting a Linear Forecast and Forecast Smoothing
How to use Conditional Formatting to highlight areas of your data
All about Histograms and Regression
How to use Goal Seek, Scenario Manager, and Solver to fill data gaps

Power Pivot, Power Query & DAX
How to get started with Power Query
How to connect Excel to multiple workbooks
How to get data from the web and other sources
How to merge and append queries using Power Query
How the Power Pivot window works
How to set up and manage relationships in a data model
How to create a PivotTable to display your data from the Power Pivot data model
How to add calculated columns using DAX
How to use functions such as CALCULATE, DIVIDE, DATESYTD in DAX
All about creating Pivot Charts and PivotTables and using your data model
How to use slicers to adjust the data you display

PivotTables for Beginners
How to clean and prepare your data
Creating a basic PivotTable
Using the PivotTable fields pane
Adding fields and pivoting the fields
Formatting numbers in PivotTable
Different ways to summarize data
Grouping PivotTable data
Using multiple fields and dimension
The methods of aggregation
How to choose and lock the report layout
Applying PivotTable styles
Sorting data and using filters
Create pivot charts based on PivotTable data
Selecting the right chart for your data
Apply conditional formatting
Add slicers and timelines to your dashboards
Adding new data to the original source dataset
Updating PivotTables and charts

Advanced PivotTables
How to do a PivotTable (a quick refresher)
How to combine data from multiple worksheets for a PivotTable
Grouping, ungrouping, and dealing with errors
How to format a PivotTable, including adjusting styles
How to use the Value Field Settings
Advanced Sorting and Filtering in PivotTables
How to use Slicers, Timelines on multiple tables
How to create a Calculated Field
All about GETPIVOTDATA
How to create a Pivot Chart and add sparklines and slicers
How to use 3D Maps from a PivotTable
How to update your data in a PivotTable and Pivot Chart
All about Conditional Formatting in a PivotTable
How to create amazing-looking dashboards

This bundle includes:
50+ hours of video tutorials
480+ individual video lectures
Course and exercise files to follow along
Certificate of completion
Who this course is for:
Suitable for learners of all levels
Excel users upgrading from a previous version and want to keep up to date with Excel 2021 developments
Business analysts or those looking to perform Data Analysis using Excel
Beginner Excel users who want to learn how to use Pivot Tables
Advanced Excel users who want to learn Power Pivot and Power Query

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.