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

سرفصل های دوره

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

1 - Microsoft Excel 2021 for Beginners Introduction

1 - Course Introduction

2 - WATCH ME Essential Information for a Successful Training Experience

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

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

7 - Launching Excel

8 - The Start Screen

9 - Exploring the Interface

10 - Understanding Ribbons Tabs and Menus

11 - The Backstage Area

12 - Customizing the Quick Access Toolbar

13 - Useful Keyboard Shortcuts

14 - Getting Help

15 - Exercise 01

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

16 - Working with Excel Templates

17 - Working with Workbooks and Worksheets

18 - Saving Workbooks and Worksheets

19 - Entering and Editing Data

20 - Navigating and Selecting Cells Rows and Columns

21 - Exercise 02

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

22 - Formulas and Functions Explained

23 - Performing Calculations with the SUM Function

24 - Counting Values and Blanks

25 - Finding the Average with the AVERAGE Function

26 - Working with the MIN and MAX Functions

27 - Handling Errors in Formulas

28 - Absolute vs Relative Referencing

29 - Autosum and AutoFill

30 - Flash Fill

31 - Exercise 03

5 - Microsoft Excel 2021 for Beginners Using Named Ranges

32 - What are Named Ranges

33 - Creating Named Ranges

34 - Managing Named Ranges

35 - Using Named Ranges in Calculations

36 - Exercise 04

6 - Microsoft Excel 2021 for Beginners Formatting Numbers and Cells

37 - Applying Number Formats

38 - Applying Date and Time Formats

39 - Formatting Cells Rows and Columns

40 - Using Format Painter

41 - Exercise 05

7 - Microsoft Excel 2021 for Beginners Formatting Worksheets

42 - Working with Rows and Columns

43 - Deleting and Clearing Cells

44 - Aligning Text and Numbers

45 - Applying Themes and Styles

46 - Exercise 06

8 - Microsoft Excel 2021 for Beginners Working with Excel Lists

47 - How to Structure a List

48 - Sorting a List SingleLevel Sort

49 - Sorting a List MultiLevel Sort

50 - Sorting Using a Custom List Custom Sort

51 - Using Autofilter to Filter a List

52 - Format as a Table

53 - Creating Subtotals in a List

54 - Exercise 07

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

55 - Using Cut and Copy

56 - Paste Options

57 - Pasting from the Clipboard

58 - Linking to Other Worksheets and Workbooks

59 - 3D Referencing

60 - Inserting Hyperlinks to Worksheets

61 - Exercise 08

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

62 - Looking up Information with VLOOKUP

63 - VLOOKUP Approximate Match

64 - Error Handling Functions

65 - Basic Logical Functions IF AND OR

66 - Making Decisions with IF Statements

67 - Cleaning Data Using Text Functions

68 - Working with Time and Date Functions

69 - Exercise 09

11 - Microsoft Excel 2021 for Beginners Analyzing Data with Charts

70 - Choosing the Correct Chart Type

71 - Presenting Data with Charts

72 - Formatting Charts

73 - Exercise 10

12 - Microsoft Excel 2021 for Beginners Conditional Formatting

74 - Highlighting Cell Values

75 - Data Bars

76 - Color Scales

77 - Icon Sets

78 - Exercise 11

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

79 - Inserting Pictures

80 - Inserting Shapes and Text Boxes

81 - Inserting Icons and 3D Models

82 - Creating Diagrams Using SmartArt

83 - Inserting Screenshots

84 - Inserting Comments

85 - Exercise 12

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

86 - Workbook Views

87 - Using Zoom in a Worksheet

88 - Arranging Workbooks and Worksheets

89 - Freezing Panes

90 - Exercise 13

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

91 - Setting Margins and Orientation

92 - Setting and Clearing the Print Area

93 - Inserting Page Breaks

94 - Setting Print Titles and a Background

95 - Inserting Headers and Footers

96 - Printing a Workbook

97 - Exercise 14

16 - Microsoft Excel 2021 for Beginners Finalizing the Spreadsheet

98 - Protecting Workbooks and Worksheets

99 - Spell Checking

100 - Inspecting the Workbook

101 - Saving the Workbook in Different Formats

102 - Sharing a Workbook

103 - Exercise 15

17 - Microsoft Excel 2021 for Beginners Course Close

104 - Course Close

18 - Microsoft Excel 2021 Intermediate Introduction

105 - Course Introduction

106 - WATCH ME Essential Information for a Successful Training Experience

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

111 - Improving Readability with Cell Styles

112 - Controlling Data Input

113 - Adding Navigation Buttons

20 - Microsoft Excel 2021 Intermediate Making Decisions with Logical Functions

114 - Logical Functions AND OR IF

115 - The IF Function

116 - Nested IFs

117 - The IFS Function

118 - Conditional IFs SUMIF COUNTIF AVERAGEIF

119 - Multiple Criteria SUMIFS COUNTIFS AVERAGEIFS

120 - Error Handling with IFERROR and IFNA

121 - Exercise 01

21 - Microsoft Excel 2021 Intermediate Looking Up Information

122 - Looking Up Information using VLOOKUP Exact Match

123 - Looking Up Information using VLOOKUP Approx Match

124 - Looking Up Information Horizontally using HLOOKUP

125 - Performing Flexible Lookups with INDEX and MATCH

126 - Using XLOOKUP and XMATCH

127 - The OFFSET Function

128 - The INDIRECT Function

129 - Exercise 02

22 - Microsoft Excel 2021 Intermediate Advanced Sorting and Filtering

130 - Performing Sorts on Multiple Columns

131 - Sorting Using a Custom List

132 - The SORT and SORTBY Functions

133 - Using the Advanced Filter

134 - Extracting Unique Values The UNIQUE Function

135 - The FILTER Function

136 - Exercise 03

23 - Microsoft Excel 2021 Intermediate Working with Date and Time

137 - Understanding How Dates are Stored in Excel

138 - Applying Custom Date Formats

139 - Using Date and Time Functions

140 - Using the WORKDAY and WORKDAYINT Functions

141 - Using the NETWORKDAYS and NETWORKDAYSINT Function

142 - Tabulate Date Differences with the DATEDIF Function

143 - Calculate Dates with EDATE and EOMONTH

144 - Exercise 04

24 - Microsoft Excel 2021 Intermediate Preparing Data for Analysis

145 - Importing Data into Excel

146 - Removing Blank Rows Cells and Duplicates

147 - Changing Case and Removing Spaces

148 - Splitting Data using Text to Columns

149 - Splitting Data using Text Functions

150 - Splitting or Combining Cell Data Using Flashfill

151 - Joining Data using CONCAT

152 - Formatting Data as a Table

153 - Exercise 05

25 - Microsoft Excel 2021 Intermediate PivotTables

154 - PivotTables Explained

155 - Creating a PivotTable from Scratch

156 - Pivoting the PivotTable Fields

157 - Applying Subtotals and Grand Totals

158 - Applying Number Formatting to PivotTable Data

159 - Show Values As and Summarize Values By

160 - Grouping PivotTable Data

161 - Formatting Error Values and Empty Cells

162 - Choosing a Report Layout

163 - Applying PivotTable Styles

164 - Exercise 06

26 - Microsoft Excel 2021 Intermediate Pivot Charts

165 - Creating a Pivot Chart

166 - Formatting a Pivot Chart Part 1

167 - Formatting a Pivot Chart Part 2

168 - Using Map Charts

169 - Exercise 07

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

170 - Inserting and Formatting Slicers

171 - Inserting Timeline Slicers

172 - Connecting Slicers to Pivot Charts

173 - Updating PivotTable Data

174 - Exercise 08

28 - Microsoft Excel 2021 Intermediate Interactive Dashboards

175 - What is a Dashboard

176 - Assembling a Dashboard Part 1

177 - Assembling a Dashboard Part 2

178 - Assembling a Dashboard Part 3

179 - Exercise 09

29 - Microsoft Excel 2021 Intermediate Formula Auditing

180 - Troubleshooting Common Errors

181 - Tracing Precedents and Formula Auditing

182 - Exercise 10

30 - Microsoft Excel 2021 Intermediate Data Validation

183 - Creating Dynamic Dropdown Lists

184 - Other Types of Data Validation

185 - Custom Data Validation

186 - Exercise 11

31 - Microsoft Excel 2021 Intermediate WhatIf Analysis Tools

187 - Goal Seek and the PMT Function

188 - Using Scenario Manager

189 - Data Tables One Variable

190 - Data Tables Two Variables

191 - Exercise 12

32 - Microsoft Excel 2021 Intermediate Course Close

192 - Course Close

33 - Microsoft Excel 2021 Advanced Introduction

193 - Course Introduction

194 - WATCH ME Essential Information for a Successful Training Experience

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

34 - Microsoft Excel 2021 Advanced Dynamic Arrays

199 - What are Dynamic Arrays

200 - Introduction to Spills and Arrays

201 - Extract and Count Unique Entries

202 - Unique vs Distinct

203 - Extract Unique Values with Multiple Criteria

204 - Extract Unique Values by Column

205 - The SORT Function

206 - The SORT Function Horizontal SORT

207 - The SORTBY Function

208 - The SORTBY Function Horizontal SORT

209 - Simple SEQUENCE and Unstacking Records

210 - The FILTER Function

211 - FILTER with Logic Operator OR

212 - FILTER with Logic Operator AND

213 - FILTER with Logic Operator Both or Neither

214 - FILTER with Logic Operator One or the Other

215 - Using RANDARRAY and RANDBETWEEN to Randomize Data

216 - Using XLOOKUP to Perform Complex Lookups

217 - Using XMATCH

218 - Exercise 02

35 - Microsoft Excel 2021 Advanced Advanced Lookup and Reference Functions

219 - Performing 2Way Lookups

220 - Using the CHOOSE Function

221 - Using the SWITCH Function

222 - Exercise 03

36 - Microsoft Excel 2021 Advanced Statistical Functions

223 - Using MEDIAN MODESNGL and MODEMULT

224 - Using LARGE and SMALL

225 - Ranking Data with Sorting using RANKEQ and RANKAVG

226 - The COUNTBLANK Function

227 - Exercise 04

37 - Microsoft Excel 2021 Advanced Math Functions

228 - Rounding Values using ROUND ROUNDUP and ROUNDDOWN

229 - Specialized Rounding MROUND CEILINGMATH and FLOORMATH

230 - Using the AGGREGATE Function

231 - Exercise 05

38 - Microsoft Excel 2021 Advanced New Functions LET and LAMBDA

232 - The LET Function

233 - The LAMBDA Function

234 - Exercise 06

39 - Microsoft Excel 2021 Advanced Advanced PivotTables and Pivot Charts

235 - Creating a Custom PivotTable Style

236 - Applying Custom Number Formatting

237 - Sorting Using Custom Lists

238 - Applying Multiple Filters to Data

239 - Adjusting Slicer Settings

240 - Locking Workbooks but not Slicers

241 - Creating a Calculated Field

242 - Creating a Calculated Item

243 - Solve Order

244 - GETPIVOTDATA

245 - Using GETPIVOTDATA Dependent Data Validation Lists

246 - Creating a Dynamic Pivot Chart Title

247 - Adding a Dynamic Series to a Pivot Chart

248 - Adding Totals to a Stacked Column Chart

249 - Exercise 07

40 - Microsoft Excel 2021 Advanced Form Controls

250 - Introduction to Form Controls

251 - Combo Box Select from a List

252 - Check Box CheckUncheck Option

253 - Option Button Choose an Option

254 - Spin Button Move Up and Down a List

255 - List Box Select from a List of Items

256 - Scroll Bar Scroll Through a List

257 - Exercise 08

41 - Microsoft Excel 2021 Advanced Working with Power Query

258 - Power Query Overview

259 - Importing Data Using Get and Transform

260 - The Power Query Editor

261 - Combining Files

262 - Transforming Files

263 - Loading Files into Excel

264 - Exercise 09

42 - Microsoft Excel 2021 Advanced Forecasting

265 - Getting Forecast Data with FRED

266 - Creating a Linear Sales Forecast

267 - Creating a Sales Forecast with Seasonality

268 - Adding Confidence Levels

269 - Using Forecast Sheets

270 - Exercise 10

43 - Microsoft Excel 2021 Advanced Macros and VBA

271 - Using Macros to Automate Tasks

272 - Recording Saving and Running Macros

273 - Recording a Macro with Relative Referencing

274 - Multistep Macros

275 - The VBA Editor

276 - Assigning Macros to Buttons

277 - Creating a Custom Macro Ribbon

278 - Exercise 11

44 - Microsoft Excel 2021 Advanced Practical Excel Advanced Formulas

279 - Finding the Last Occurrence of a Value

280 - Finding the Closest Value

281 - Extract Data from the Middle of a String

282 - Exercise 12

45 - Microsoft Excel 2021 Advanced Course Close

283 - Course Close

46 - Excel for Business Analysts Introduction

284 - Introduction to Business Analysis

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

288 - Absolute vs Relative Referencing

289 - Exercise 01

48 - Excel for Business Analysts Merging and Looking Up Data

290 - Merging Data from Different Sources

291 - Looking Up Information with VLOOKUP Exact

292 - Looking Up information with VLOOKUP Approx

293 - How to Use VLOOKUP with Data that Expands

294 - Using HLOOKUP

295 - Combining VLOOKUP and MATCH

296 - Using INDEX MATCH and XLOOKUP

297 - Data Validation Lists with Lookups

298 - Exercise 02

49 - Excel for Business Analysts Making Better Decisions with IF

299 - How to Use the IF function

300 - More Examples of the IF Function

301 - Working with Nested Ifs

302 - The IFS function

303 - Error handling with IFERROR and IFNA

304 - Using MAX and MIN instead of the IF function

305 - Using SUMIFS and COUNTIFS

306 - Exercise 03

50 - Excel for Business Analysts Preparing Data for Analysis

307 - Splitting Data Using Text Functions

308 - Using the Flash Fill Command

309 - Concatenating Data

310 - Standardizing Data

311 - Formatting Data as a Table

312 - Exercise 04

51 - Excel for Business Analysts PivotTables

313 - An Introduction to PivotTables

314 - Creating a PivotTable

315 - Summarizing Data

316 - Calculations in PivotTables

317 - Using Slicers to filter information

318 - Exercise 05

52 - Excel for Business Analysts Visualizing Data with Charts

319 - Creating a Pivot Chart

320 - Formatting a Pivot Chart

321 - Using Sparklines

322 - A Basic Interactive Dashboard

323 - Exercise 06

53 - Excel for Business Analysts Forecasting

324 - Forecast Sheets

325 - The Forecast Function

326 - Exercise 07

54 - Excel for Business Analysts Additional Useful Tools in Excel

327 - Conditional Formatting

328 - The INDIRECT Function

329 - The OFFSET Function

330 - Using Histograms

331 - Regression

332 - Exercise 08

55 - Excel for Business Analysts WhatIf Analysis

333 - Goal Seek

334 - Scenario Manager

335 - Data Tables

336 - Solver

337 - Exercise 09

56 - Excel for Business Analysts Course Close

338 - Course Close

57 - PowerPivot PowerQuery DAX Introduction

339 - Welcome and Overview

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

343 - What is Power Pivot

58 - PowerPivot PowerQuery DAX Getting Started with Power Query

344 - Exploring the Power Query Editor

345 - Common Power Query Transformations

346 - Editing an Existing Query

347 - Import Multiple Files from a Folder

348 - Connect to Data in Another Excel Workbook

349 - Troubleshooting Data Errors When Using the Sample Files

350 - IMPORTANT Checking the Location of your Querys Source

351 - Get Data From the Web

352 - Practise Exercise

59 - PowerPivot PowerQuery DAX Useful Power Query Features

353 - Unpivoting Columns

354 - Combine Data from Multiple Tables with Merge Queries

355 - Use Merge Queries to Compare Two Tables

356 - Stack Data into One Table with Append Queries

357 - Duplicating and Referencing Queries

358 - Grouping and Aggregating Data

359 - Conditional Columns in Power Query

360 - Practise Exercise

60 - PowerPivot PowerQuery DAX Creating the Data Model

361 - Enable the Power Pivot AddIn

362 - Understanding the Power Pivot Window

363 - Creating Relationships Between tables

364 - Managing the Relationships of the Model

365 - Creating a PivotTable from the Data Model

366 - Hide Fields from Client Tools

367 - Grouping Queries

368 - Practise Exercise

61 - PowerPivot PowerQuery DAX Introduction to DAX

369 - Why use DAX

370 - Creating Calculated Columns with DAX

371 - Creating your First DAX Measure

372 - The COUNTROWS Function

373 - SUMX and RELATED Functions

374 - Practise Exercise

62 - PowerPivot PowerQuery DAX More DAX Measures

375 - Create a Date Table in Power Pivot

376 - The CALCULATE Function

377 - The DIVIDE Function

378 - Using the DATESYTD Function

379 - Calculate the Percentage of a Total

380 - Practise Exercise

63 - PowerPivot PowerQuery DAX Using PivotTables and Slicers

381 - Create PivotTables and PivotCharts

382 - Using Slicers with your PivotTables

383 - Create a Top 10 PivotTable

384 - Practise Exercise

64 - PowerPivot PowerQuery DAX Closing

385 - Wrap Up

65 - Pivot Tables for Beginners Introduction

386 - Course Introduction

387 - WATCH ME Essential Information for a Successful Training Experience

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

66 - Pivot Tables for Beginners Preparing Data for Analysis

391 - The Importance of Cleaning Data

392 - Removing Blank Rows

393 - Removing Duplicate Rows

394 - Clearing Formatting

395 - Applying Number Formatting

396 - Changing the Case

397 - Removing Spaces and Nonprinting Characters

398 - Merging and Splitting Columns

399 - Convert Numbers Stored as Text

400 - Finding and Replacing Text

401 - Spell Check

402 - Exercise 01

67 - Pivot Tables for Beginners The Importance of Excel Tables

403 - Excel Tables vs Pivot Tables

404 - Format Data as a Table

405 - Exercise 02

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

406 - Using Recommended Pivot Tables

407 - Creating a Pivot Table from Scratch

408 - Pivot Table Ribbons and Fields

409 - Pivoting the Fields

410 - Adding Multiple Dimensions

411 - Deleting Fields and Locking the Report Layout

412 - Exercise 03

139,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy-Training