| 1. Flash Fill.mp4 | 42.4 MB | ||
| 1. Introduction.mp4 | 44.4 MB | ||
| 1. Learn How To Create Pivot Tables In Excel.mp4 | 103.1 MB | ||
| 1. Learn How To Format An Excel Worksheet.mp4 | 73.4 MB | ||
| 1. Learn How To Use Basic Formulas In Excel.mp4 | 93 MB | ||
| 1.1 After File - Flash fill.xlsx | 11.1 KB | ||
| 1.1 Basic Formulas - Excel Guide.pdf | 111.4 KB | ||
| 1.1 Before and After file - Excel Pivot Tables.xlsx | 584.4 KB | ||
| 1.1 Before and After file - Formatting an Excel Worksheet.xlsx | 14.3 KB | ||
| 1.2 Before File - Flash fill.xlsx | 10.5 KB | ||
| 1.2 Before and After file - Excel Basic Formulas.xlsx | 15.7 KB | ||
| 1.2 Pivot Tables - Excel Guide.pdf | 147.3 KB | ||
| 1.3 Flash Fill - Guide.pdf | 229.6 KB | ||
| 10. Learn To Extract Data Using Excel Text Functions.mp4 | 69.9 MB | ||
| 10. Printing.html | 204.8 B | ||
| 10.1 After file - LEFT MID RIGHT functions.xlsx | 13.1 KB | ||
| 10.2 Before file - LEFT MID RIGHT functions.xlsx | 12.4 KB | ||
| 10.3 LEFT MID RIGHT functions - Excel Guide.pdf | 110.7 KB | ||
| 11. LEFT MID RIGHT Function.html | 204.8 B | ||
| 11. You've Achieved 100% Let's Celebrate! Remember To Share Your Certificate!!.mp4 | 10.4 MB | ||
| 11.1 All+Complete+-+Well+Done.pdf | 840 KB | ||
| 12. Change case functions and TRIM function.mp4 | 43.1 MB | ||
| 12.1 After file - Change case functions & TRIM function.xlsx | 13 KB | ||
| 12.2 Before file - Change case functions & TRIM function.xlsx | 12.2 KB | ||
| 12.3 Change case & trim - Guide.pdf | 91.2 KB | ||
| 13. Change case functions and TRIM function.html | 204.8 B | ||
| 14. Transpose Data.mp4 | 43.3 MB | ||
| 14.1 After file - Transpose.xlsx | 13.1 KB | ||
| 14.2 Before file - Transpose.xlsx | 12.2 KB | ||
| 15. Transpose Data.html | 204.8 B | ||
| 16. XLOOKUP Function.mp4 | 43.7 MB | ||
| 16.1 After file - XLOOKUP.xlsx | 13.9 KB | ||
| 16.2 Before file - XLOOKUP.xlsx | 13.6 KB | ||
| 2. Basic Formulas.html | 204.8 B | ||
| 2. Excel Pivot Tables.html | 204.8 B | ||
| 2. Flash Fill.html | 204.8 B | ||
| 2. Formatting an Excel Worksheet.html | 204.8 B | ||
| 2. Introduce Yourself To Your Fellow Students And Tell Us What You Want To Learn.html | 614.4 B | ||
| 3. Learn How To Apply Advanced Formatting To An Excel Worksheet.mp4 | 82.7 MB | ||
| 3. Learn How To Create Pivot Charts In Excel.mp4 | 91.4 MB | ||
| 3. Learn How To Do Excel Auditing.mp4 | 101 MB | ||
| 3. Learn How To Use New Excel Functions.mp4 | 100.7 MB | ||
| 3. Let's Celebrate Your Progress In This Course 25% 50% 75% 100%!!.mp4 | 12.8 MB | ||
| 3.1 Advanced Formatting - Excel Guide.pdf | 140 KB | ||
| 3.1 After File - Excel Auditing.xlsx | 18 KB | ||
| 3.1 After File - Excel Pivot Charts.xlsx | 24.2 KB | ||
| 3.1 After file - Exploring New Excel Functions.xlsx | 20.9 KB | ||
| 3.1 Let's+Celebrate+Your+Progress.pdf | 840 KB | ||
| 3.2 Before File - Excel Auditing.xlsx | 15.4 KB | ||
| 3.2 Before File - Excel Pivot Charts.xlsx | 10 KB | ||
| 3.2 Before and After file - Advanced Formatting.xlsx | 13.3 KB | ||
| 3.2 Before file - Exploring New Excel Functions.xlsx | 17.2 KB | ||
| 3.3 Before Report - Advanced Formatting PDF .pdf | 398.4 KB | ||
| 3.3 Pivot Charts - Excel Guide.pdf | 173.3 KB | ||
| 4. Advance Formatting.html | 204.8 B | ||
| 4. Excel Auditing.html | 204.8 B | ||
| 4. New Excel Functions.html | 204.8 B | ||
| 4. Pivot Charts.html | 204.8 B | ||
| 5. Learn Finance Functions And Formulas In Excel.mp4 | 81.2 MB | ||
| 5. Learn To Create & Break Excel Passwords.mp4 | 60.8 MB | ||
| 5. Learn To Do Copy & Pasting Smartly.mp4 | 144.7 MB | ||
| 5. You've Achieved 75% Let's Celebrate Your Progress And Keep Going To 100% .mp4 | 5.1 MB | ||
| 5.1 3+Quarters+Complete+-+Well+Done+Keep+Going.pdf | 613.5 KB | ||
| 5.1 After File - Excel Copy & Paste.xlsx | 44.8 KB | ||
| 5.1 After File - Excel Finance Functions & Formulas.xlsx | 17.1 KB | ||
| 5.1 After File - Excel Passwords - Unlocked Calculator.xlsx | 10.7 KB | ||
| 5.2 Before File - Excel Copy & Paste.xlsx | 27 KB | ||
| 5.2 Before File - Excel Finance Functions & Formulas.xlsx | 16.3 KB | ||
| 5.2 Before File - Excel Passwords.xlsx | 10.7 KB | ||
| 5.3 Copy & Paste - Excel Guide.pdf | 245.9 KB | ||
| 5.3 Finance Functions & Formulas - Excel Guide.pdf | 136.7 KB | ||
| 5.3 Passwords - Excel Guide.pdf | 126.1 KB | ||
| 6. Copy & Paste.html | 204.8 B | ||
| 6. Excel Finance Functions & Formulas.html | 204.8 B | ||
| 6. Excel Passwords.html | 204.8 B | ||
| 7. Learn Rounding Functions In Excel.mp4 | 112.6 MB | ||
| 7. Learn To Manage Excel External Links.mp4 | 44.4 MB | ||
| 7. You've Achieved 25% Let's Celebrate Your Progress And Keep Going To 50% .mp4 | 3.9 MB | ||
| 7.1 After file - Managing Excel External Links.xlsx | 11.3 KB | ||
| 7.1 Quarter+Complete+-+Well+Done+Keep+Going.pdf | 464.3 KB | ||
| 7.1 Rounding Data - Excel Guide.pdf | 108.5 KB | ||
| 7.2 Rounding Data.xlsx | 376.1 KB | ||
| 7.3 Managing External Links - Excel Guide.pdf | 254.3 KB | ||
| 8. Managing Excel External Links.html | 204.8 B | ||
| 8. Rounding Functions.html | 204.8 B | ||
| 9. Learn To Print An Excel Worksheet.mp4 | 83.6 MB | ||
| 9. You've Achieved 50% Let's Celebrate Your Progress And Keep Going To 75% .mp4 | 4.6 MB | ||
| 9.1 After File - Printing.xlsx | 16.4 KB | ||
| 9.1 Half+Complete+-+Well+Done+Keep+Going.pdf | 511.3 KB | ||
| 9.2 Before File - Printing.xlsx | 16.3 KB | ||
| 9.3 Print Output 1.pdf | 393.5 KB | ||
| 9.4 Print Output 2.pdf | 391.9 KB | ||
| 9.5 Printing - Excel Guide.pdf | 123.1 KB | ||
| Bonus Resources.txt | 409.6 B | ||
| Get Bonus Downloads Here.url | 204.8 B | ||
| Name List.xlsx | 9 KB | ||
| Sales Achievement Calculation.xlsx | 13 KB | ||
| Sales Targets - February.xlsx | 10.4 KB | ||
| Sales Targets - January.xlsx | 10.4 KB | ||
| ▲ 99 total files | |||
Excel Zero To Hero: Learn Excel Smart Tips For Beginners
https://DevCourseWeb.com
Published 2/2023
Created by Peter Alkema
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English | Duration: 25 Lectures ( 2h 44m ) | Size: 1.46 GB
Master Excel Formulas, Functions, Pivot Tables, Charts, Lookups, Passwords & Finance Functions PLUS Loads Of Quizzes
What you'll learn
Formatting for fonts/ numbers/ cells, freezing rows & columns, Use Text-to-Columns feature effectively, essential Excel shortcuts
Essential Excel functions such as SUM, SUMPRODUCT, CONCATENATE, VLOOKUP, HLOOKUP, COUNT, COUNTA, COUNTIF, SUMIF, AVERAGE, MAX, MIN
Latest Excel text functions such as TEXTBEFORE, TEXTAFTER, TEXTSPLIT, VSTACK, HSTACK, TOROW, TOCOL, WRAPROWS, WRAPCOLS, CHOOSECOLS, CHOOSEROWS, TAKE, DROP
Excel Finance Functions such as NPV, XNPV, IRR, XIRR, MIRR, RATE, NPER, PV, PMT, IPMT, FV, FVSCHEDULE, EFFECT
Protect and unprotect Excel sheets and break the password when you forget the password
Explore amazing copy & paste options such as Paste math operations, Paste column widths, Paste visible cells, Paste comments
Switch rows and columns - TRANSPOSE function, copy & paste using transpose, #SPILL! error
Rounding functions such as ROUND, ROUNDDOWN, ROUNDUP, TRUNC, INT, MROUND, CEILING, FLOOR, EVEN, ODD
How to use XLOOKUP and how to effectively use the XLOOKUP arguments
Managing external links, printing an Excel workbook
Flash Fill to quickly merge and extract data
Pivot Tables and Pivot Charts
Change case and remove unnecessary spaces
LEFT MID RIGHT functions to extract data from cells
Requirements
There are no requirements or pre-requisites
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 2.7 GB | freecoursewb | 2 weeks | 12 | 1 | |
| 2.7 GB | freecoursewb | 2 weeks | 18 | 1 | |
|
Udemy - Microsoft Power BI for Excel Users - Turn Data into Insights Posted by
freecoursewb in Other
|
2.6 GB | freecoursewb | 3 weeks | 9 | 5 |
|
Udemy - Microsoft Excel - The Smart Path to Advanced Nested Functions Posted by
freecoursewb in Other
|
1.9 GB | freecoursewb | 3 weeks | 6 | 1 |
| 3.8 GB | freecoursewb | 3 weeks | 19 | 5 |
All Comments