| 001-Introduction-SMnv-english-onehack.us.srt | 5.15 KB | ||
| 001-Introduction-SMnv-onehack.us.mp4 | 69.6 MB | ||
| 001-Introduction-SMnv-persian-onehack.us.srt | 7.54 KB | ||
| 002-Course-Exercise-Files-NaKP-english-onehack.us.srt | 2.2 KB | ||
| 002-Course-Exercise-Files-NaKP-onehack.us.mp4 | 15.02 MB | ||
| 002-Course-Exercise-Files-NaKP-persian-onehack.us.srt | 3.19 KB | ||
| 003-Advanced-Excel-Formula-Fundamentals-Exercise-File-DOWNLOAD-ulRs-english-onehack.us.srt | 1.11 KB | ||
| 003-Advanced-Excel-Formula-Fundamentals-Exercise-File-DOWNLOAD-ulRs-onehack.us.mp4 | 8.1 MB | ||
| 003-Advanced-Excel-Formula-Fundamentals-Exercise-File-DOWNLOAD-ulRs-persian-onehack.us.srt | 1.61 KB | ||
| 004-Excel-Absolute-vs-Relative-Cell-References-HNXL-english-onehack.us.srt | 6.37 KB | ||
| 004-Excel-Absolute-vs-Relative-Cell-References-HNXL-onehack.us.mp4 | 44.01 MB | ||
| 004-Excel-Absolute-vs-Relative-Cell-References-HNXL-persian-onehack.us.srt | 9.07 KB | ||
| 005-Excel-Absolute-vs-Relative-Cell-References-CONTINUED-3HYo-english-onehack.us.srt | 7.39 KB | ||
| 005-Excel-Absolute-vs-Relative-Cell-References-CONTINUED-3HYo-onehack.us.mp4 | 51.2 MB | ||
| 005-Excel-Absolute-vs-Relative-Cell-References-CONTINUED-3HYo-persian-onehack.us.srt | 10.29 KB | ||
| 006-Variations-on-Excel-s-Absolute-References-baRO-english-onehack.us.srt | 14.6 KB | ||
| 006-Variations-on-Excel-s-Absolute-References-baRO-onehack.us.mp4 | 92.98 MB | ||
| 006-Variations-on-Excel-s-Absolute-References-baRO-persian-onehack.us.srt | 20.52 KB | ||
| 007-Excel-Name-Ranges-gUtq-english-onehack.us.srt | 8.56 KB | ||
| 007-Excel-Name-Ranges-gUtq-onehack.us.mp4 | 59.68 MB | ||
| 007-Excel-Name-Ranges-gUtq-persian-onehack.us.srt | 12.67 KB | ||
| 008-Creating-Powerful-Formulas-by-Nesting-Functions-JbZh-english-onehack.us.srt | 11.54 KB | ||
| 008-Creating-Powerful-Formulas-by-Nesting-Functions-JbZh-onehack.us.mp4 | 83.57 MB | ||
| 008-Creating-Powerful-Formulas-by-Nesting-Functions-JbZh-persian-onehack.us.srt | 16.64 KB | ||
| 009-Evaluating-Excel-Formulas-Exercise-File-DOWNLOAD-VV1Q-english-onehack.us.srt | 1.59 KB | ||
| 009-Evaluating-Excel-Formulas-Exercise-File-DOWNLOAD-VV1Q-onehack.us.mp4 | 11.75 MB | ||
| 009-Evaluating-Excel-Formulas-Exercise-File-DOWNLOAD-VV1Q-persian-onehack.us.srt | 2.18 KB | ||
| 010-Evaluate-Formulas-X0jx-english-onehack.us.srt | 9.69 KB | ||
| 010-Evaluate-Formulas-X0jx-onehack.us.mp4 | 67.24 MB | ||
| 010-Evaluate-Formulas-X0jx-persian-onehack.us.srt | 14.03 KB | ||
| 011-Locating-Errors-in-a-Formula-KzuX-english-onehack.us.srt | 9.71 KB | ||
| 011-Locating-Errors-in-a-Formula-KzuX-onehack.us.mp4 | 65.69 MB | ||
| 011-Locating-Errors-in-a-Formula-KzuX-persian-onehack.us.srt | 13.66 KB | ||
| 012-Using-Excel-s-IFERROR-Function-K2MR-english-onehack.us.srt | 6.66 KB | ||
| 012-Using-Excel-s-IFERROR-Function-K2MR-onehack.us.mp4 | 46.62 MB | ||
| 012-Using-Excel-s-IFERROR-Function-K2MR-persian-onehack.us.srt | 9.4 KB | ||
| 013-Array-Formulas-Exercise-File-DOWNLOAD-Lk8D-english-onehack.us.srt | 1.06 KB | ||
| 013-Array-Formulas-Exercise-File-DOWNLOAD-Lk8D-onehack.us.mp4 | 7.36 MB | ||
| 013-Array-Formulas-Exercise-File-DOWNLOAD-Lk8D-persian-onehack.us.srt | 1.61 KB | ||
| 014-What-are-Arrays-NFAW-english-onehack.us.srt | 7.25 KB | ||
| 014-What-are-Arrays-NFAW-onehack.us.mp4 | 48.13 MB | ||
| 014-What-are-Arrays-NFAW-persian-onehack.us.srt | 10.62 KB | ||
| 015-Nesting-Array-Formulas-XnbO-english-onehack.us.srt | 10.14 KB | ||
| 015-Nesting-Array-Formulas-XnbO-onehack.us.mp4 | 69.08 MB | ||
| 015-Nesting-Array-Formulas-XnbO-persian-onehack.us.srt | 14.63 KB | ||
| 016-Using-Arrays-to-SUM-Data-DHKV-english-onehack.us.srt | 6.75 KB | ||
| 016-Using-Arrays-to-SUM-Data-DHKV-onehack.us.mp4 | 43.45 MB | ||
| 016-Using-Arrays-to-SUM-Data-DHKV-persian-onehack.us.srt | 9.79 KB | ||
| 017-Streamline-Conditions-Using-Arrays-O9eq-english-onehack.us.srt | 7.37 KB | ||
| 017-Streamline-Conditions-Using-Arrays-O9eq-onehack.us.mp4 | 47.25 MB | ||
| 017-Streamline-Conditions-Using-Arrays-O9eq-persian-onehack.us.srt | 10.44 KB | ||
| 018-Index-and-Match-Functions-Exercise-File-DOWNLOAD-qaqs-english-onehack.us.srt | 1.82 KB | ||
| 018-Index-and-Match-Functions-Exercise-File-DOWNLOAD-qaqs-onehack.us.mp4 | 12.33 MB | ||
| 018-Index-and-Match-Functions-Exercise-File-DOWNLOAD-qaqs-persian-onehack.us.srt | 2.45 KB | ||
| 019-Excels-INDEX-Function-fm3n-english-onehack.us.srt | 9.39 KB | ||
| 019-Excels-INDEX-Function-fm3n-onehack.us.mp4 | 59.85 MB | ||
| 019-Excels-INDEX-Function-fm3n-persian-onehack.us.srt | 13.39 KB | ||
| 020-Excels-MATCH-Function-S9rk-english-onehack.us.srt | 5.63 KB | ||
| 020-Excels-MATCH-Function-S9rk-onehack.us.mp4 | 34.98 MB | ||
| 020-Excels-MATCH-Function-S9rk-persian-onehack.us.srt | 7.94 KB | ||
| 021-Nesting-INDEX-and-MATCH-8BRW-english-onehack.us.srt | 10.52 KB | ||
| 021-Nesting-INDEX-and-MATCH-8BRW-onehack.us.mp4 | 65.2 MB | ||
| 021-Nesting-INDEX-and-MATCH-8BRW-persian-onehack.us.srt | 14.94 KB | ||
| 022-Intro-to-Return-an-Assoicated-Value-Using-INDEX-and-MATCH-Up8l-english-onehack.us.srt | 3.49 KB | ||
| 022-Intro-to-Return-an-Assoicated-Value-Using-INDEX-and-MATCH-Up8l-onehack.us.mp4 | 24.42 MB | ||
| 022-Intro-to-Return-an-Assoicated-Value-Using-INDEX-and-MATCH-Up8l-persian-onehack.us.srt | 5.16 KB | ||
| 023-Exercise-File-DOWNLOAD-auAf-english-onehack.us.srt | 3.64 KB | ||
| 023-Exercise-File-DOWNLOAD-auAf-onehack.us.mp4 | 21.52 MB | ||
| 023-Exercise-File-DOWNLOAD-auAf-persian-onehack.us.srt | 5.34 KB | ||
| 024-Intro-to-Creating-a-Dynamic-SUM-Using-INDEX-1lmo-english-onehack.us.srt | 5.45 KB | ||
| 024-Intro-to-Creating-a-Dynamic-SUM-Using-INDEX-1lmo-onehack.us.mp4 | 36.12 MB | ||
| 024-Intro-to-Creating-a-Dynamic-SUM-Using-INDEX-1lmo-persian-onehack.us.srt | 8.02 KB | ||
| 025-Creating-a-Dynamic-SUM-Using-INDEX-Continued-PPTd-english-onehack.us.srt | 8.2 KB | ||
| 025-Creating-a-Dynamic-SUM-Using-INDEX-Continued-PPTd-onehack.us.mp4 | 57.29 MB | ||
| 025-Creating-a-Dynamic-SUM-Using-INDEX-Continued-PPTd-persian-onehack.us.srt | 11.55 KB | ||
| 026-Intro-to-Combine-Multiplication-with-INDEX-and-MATCH-pt0s-english-onehack.us.srt | 4.31 KB | ||
| 026-Intro-to-Combine-Multiplication-with-INDEX-and-MATCH-pt0s-onehack.us.mp4 | 33.92 MB | ||
| 026-Intro-to-Combine-Multiplication-with-INDEX-and-MATCH-pt0s-persian-onehack.us.srt | 6.21 KB | ||
| 027-Combine-Multiplication-with-INDEX-and-MATCH-Continued-avBD-english-onehack.us.srt | 12.96 KB | ||
| 027-Combine-Multiplication-with-INDEX-and-MATCH-Continued-avBD-onehack.us.mp4 | 89.64 MB | ||
| 027-Combine-Multiplication-with-INDEX-and-MATCH-Continued-avBD-persian-onehack.us.srt | 18.29 KB | ||
| 028-Intro-to-Create-a-Dynamic-VLOOKUP-with-MATCH-Aprv-english-onehack.us.srt | 11.25 KB | ||
| 028-Intro-to-Create-a-Dynamic-VLOOKUP-with-MATCH-Aprv-onehack.us.mp4 | 79.68 MB | ||
| 028-Intro-to-Create-a-Dynamic-VLOOKUP-with-MATCH-Aprv-persian-onehack.us.srt | 15.51 KB | ||
| 029-Create-a-Dynamic-VLOOKUP-with-MATCH-Continued-J1aM-english-onehack.us.srt | 10.82 KB | ||
| 029-Create-a-Dynamic-VLOOKUP-with-MATCH-Continued-J1aM-onehack.us.mp4 | 70.9 MB | ||
| 029-Create-a-Dynamic-VLOOKUP-with-MATCH-Continued-J1aM-persian-onehack.us.srt | 15.42 KB | ||
| 030-Create-a-Dynamic-VLOOKUP-with-MATCH-Continued-L9Sb-english-onehack.us.srt | 8.42 KB | ||
| 030-Create-a-Dynamic-VLOOKUP-with-MATCH-Continued-L9Sb-onehack.us.mp4 | 48.96 MB | ||
| 030-Create-a-Dynamic-VLOOKUP-with-MATCH-Continued-L9Sb-persian-onehack.us.srt | 11.63 KB | ||
| 031-Intro-to-Turn-INDEX-and-MATCH-into-an-ARRAY-tB7U-english-onehack.us.srt | 4.8 KB | ||
| 031-Intro-to-Turn-INDEX-and-MATCH-into-an-ARRAY-tB7U-onehack.us.mp4 | 35.94 MB | ||
| 031-Intro-to-Turn-INDEX-and-MATCH-into-an-ARRAY-tB7U-persian-onehack.us.srt | 6.96 KB | ||
| 032-Turn-INDEX-and-MATCH-into-an-ARRAY-Continued-BI9L-english-onehack.us.srt | 9.39 KB | ||
| 032-Turn-INDEX-and-MATCH-into-an-ARRAY-Continued-BI9L-onehack.us.mp4 | 66.38 MB | ||
| 032-Turn-INDEX-and-MATCH-into-an-ARRAY-Continued-BI9L-persian-onehack.us.srt | 13.82 KB | ||
| 033-Intro-to-Returning-Multiple-Values-with-INDEX-aVDF-english-onehack.us.srt | 7.44 KB | ||
| 033-Intro-to-Returning-Multiple-Values-with-INDEX-aVDF-onehack.us.mp4 | 54.22 MB | ||
| 033-Intro-to-Returning-Multiple-Values-with-INDEX-aVDF-persian-onehack.us.srt | 11.01 KB | ||
| 034-Returning-Multiple-Values-with-INDEX-Continued-wZSO-english-onehack.us.srt | 11.91 KB | ||
| 034-Returning-Multiple-Values-with-INDEX-Continued-wZSO-onehack.us.mp4 | 76.26 MB | ||
| 034-Returning-Multiple-Values-with-INDEX-Continued-wZSO-persian-onehack.us.srt | 16.98 KB | ||
| 035-Returning-Multiple-Values-with-INDEX-Continued-XRCN-english-onehack.us.srt | 12.81 KB | ||
| 035-Returning-Multiple-Values-with-INDEX-Continued-XRCN-onehack.us.mp4 | 33.91 MB | ||
| 035-Returning-Multiple-Values-with-INDEX-Continued-XRCN-persian-onehack.us.srt | 18.34 KB | ||
| 036-Returning-Multiple-Values-with-INDEX-Continued-3Y6l-english-onehack.us.srt | 5.49 KB | ||
| 036-Returning-Multiple-Values-with-INDEX-Continued-3Y6l-onehack.us.mp4 | 33.28 MB | ||
| 036-Returning-Multiple-Values-with-INDEX-Continued-3Y6l-persian-onehack.us.srt | 7.86 KB | ||
| 037-Intro-to-Adding-Criteria-to-INDEX-and-MATCH-WgWq-english-onehack.us.srt | 5.49 KB | ||
| 037-Intro-to-Adding-Criteria-to-INDEX-and-MATCH-WgWq-onehack.us.mp4 | 38.21 MB | ||
| 037-Intro-to-Adding-Criteria-to-INDEX-and-MATCH-WgWq-persian-onehack.us.srt | 8.02 KB | ||
| 038-Adding-Criteria-to-INDEX-and-MATCH-Continued-ZZPB-english-onehack.us.srt | 7.69 KB | ||
| 038-Adding-Criteria-to-INDEX-and-MATCH-Continued-ZZPB-onehack.us.mp4 | 57.07 MB | ||
| 038-Adding-Criteria-to-INDEX-and-MATCH-Continued-ZZPB-persian-onehack.us.srt | 10.92 KB | ||
| 039-Return-an-Assoicated-Value-Using-INDEX-and-MATCH-Continued-M3Tq-english-onehack.us.srt | 6.81 KB | ||
| 039-Return-an-Assoicated-Value-Using-INDEX-and-MATCH-Continued-M3Tq-onehack.us.mp4 | 44.43 MB | ||
| 039-Return-an-Assoicated-Value-Using-INDEX-and-MATCH-Continued-M3Tq-persian-onehack.us.srt | 9.67 KB | ||
| 040-Intro-to-Conditional-Formatting-Using-MATCH-iLQf-english-onehack.us.srt | 3.02 KB | ||
| 040-Intro-to-Conditional-Formatting-Using-MATCH-iLQf-onehack.us.mp4 | 20.22 MB | ||
| 040-Intro-to-Conditional-Formatting-Using-MATCH-iLQf-persian-onehack.us.srt | 4.3 KB | ||
| 041-Conditional-Formatting-Using-MATCH-Continued-jtDD-english-onehack.us.srt | 5.57 KB | ||
| 041-Conditional-Formatting-Using-MATCH-Continued-jtDD-onehack.us.mp4 | 37.87 MB | ||
| 041-Conditional-Formatting-Using-MATCH-Continued-jtDD-persian-onehack.us.srt | 8.26 KB | ||
| 042-Congratulations-Sxee-english-onehack.us.srt | 1.49 KB | ||
| 042-Congratulations-Sxee-onehack.us.mp4 | 18.33 MB | ||
| 042-Congratulations-Sxee-persian-onehack.us.srt | 2.08 KB | ||
| ????-Request-a-Course-????.txt | 276 B | ||
| exercise_files | |||
| 2-Advanced-Excel-Formula-Fundamentals-__-3-AdvFundamentals-01.xlsx | 14.21 KB | ||
| 3-Evaluating-and-Debugging-Excel-Formulas-__-9-EvaluateFormulas-01.xlsx | 13.81 KB | ||
| 4-Excel-Array-Formulas-__-13-ArrayFormulas-01.xlsx | 15.16 KB | ||
| 5-Fundamentals-of-Using-Excels-INDEX-and-MATCH-Functions-__-18-IndexMatchFunctions-01.xlsx | 10.4 KB | ||
| 6-Excel-Index-and-Match-Exercises-__-23-ExcelAdvFunctions-01.xlsm | 48.92 KB | ||
| ▲ 132 total files | |||
Official Course URL: https://www.udemy.com/course/microsoft-excel-advanced-functions-with-index-and-match/
Course Overview:
Elevate your Excel skills with the "Microsoft Excel Advanced Functions with INDEX and MATCH" course, designed to teach you the intricacies of Excel's powerful INDEX and MATCH functions. Led by experienced instructor Kyle Pew, this course ensures you master dynamic spreadsheet functionalities, enhancing your analytical capabilities.
What You'll Learn:
- Complex Excel Functions: Build and understand advanced functions for comprehensive data analysis.
- Automation: Learn to automate repetitive tasks and calculations, saving time and improving accuracy.
- Dynamic Calculations: Employ advanced techniques to create responsive Excel calculations.
- Formula Evaluation: Enhance your ability to troubleshoot and optimize Excel formulas.
- Using Arrays: Streamline complex tasks using array formulas, making your worksheets more efficient.
Course Benefits:
- Expert Instruction: Gain insights from Kyle Pew, a Microsoft Certified Trainer with extensive teaching experience.
- Practical Exercises: Engage with hands-on exercises that reinforce learning and application of skills.
- Lifetime Access: Access course materials at any time to refresh your knowledge.
- Certificate of Completion: Earn a certificate to validate your advanced Excel skills.
Course Size: 1.93 GB
Subtitles: English, Persian
Who is this course for? Ideal for Excel users looking to enhance their skills in complex calculations and data analysis using advanced functions
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 2 GB | freecoursewb | 3 weeks | 36 | 8 | |
| 2.2 GB | freecoursewb | 1 month | 25 | 9 | |
|
Udemy - Microsoft Power BI for Excel Users - Turn Data into Insights Posted by
freecoursewb in Other
|
2.6 GB | freecoursewb | 1 month | 9 | 5 |
| 999.5 MB | freecoursewb | 1 month | 11 | 6 | |
|
Udemy - Microsoft Excel - The Smart Path to Advanced Nested Functions Posted by
freecoursewb in Other
|
1.9 GB | freecoursewb | 1 month | 6 | 1 |
All Comments