| 0 | 217 KB | ||
| 1 | 220.2 KB | ||
| 1. Absolute reference.mp4 | 34.9 MB | ||
| 1. Data Formatting.mp4 | 20.9 MB | ||
| 1. Important Information.html | 204.8 B | ||
| 1. What is Excel.mp4 | 9.5 MB | ||
| 2 | 147.7 KB | ||
| 3 | 13 KB | ||
| 4 | 69.8 KB | ||
| 5 | 113.6 KB | ||
| 6 | 298.4 KB | ||
| 10. Basic Formulas II.mp4 | 11.8 MB | ||
| 10. Course Completion.html | 102.4 B | ||
| 10. Practice 2.mp4 | 13.4 MB | ||
| 10.1 SUMIFSPRACTICE.xlsx | 9.2 KB | ||
| 11. Basic Formulas III.mp4 | 11.4 MB | ||
| 11. WORKDAY.INTL.mp4 | 22.3 MB | ||
| 11.1 WORKDAY.xlsx | 9 KB | ||
| 12. Basic Formulas IV.mp4 | 13.1 MB | ||
| 12. NETWORKDAY.INTL.mp4 | 12 MB | ||
| 13. Basic Formulas V.mp4 | 12 MB | ||
| 13. Presenting Data.mp4 | 11.1 MB | ||
| 14. Basic Formulas VI.mp4 | 13.4 MB | ||
| 14. Dynamic Data.mp4 | 48.8 MB | ||
| 15. Find and Replace.mp4 | 13.9 MB | ||
| 16. Advanced Find and Replace.mp4 | 24 MB | ||
| 17. Assignment 1.mp4 | 11.6 MB | ||
| 18. Solution 1.mp4 | 14.2 MB | ||
| 2. Copying External Data.mp4 | 27.8 MB | ||
| 2. Mixed Referencing.mp4 | 33.2 MB | ||
| 2. Open-Input-Save.mp4 | 22.8 MB | ||
| 2. UPPER-LOWER.mp4 | 19.2 MB | ||
| 3. Customization.mp4 | 10.3 MB | ||
| 3. Data Validation.mp4 | 25.6 MB | ||
| 3. Organize Data.mp4 | 44.5 MB | ||
| 3. PROPER-TRIM.mp4 | 28 MB | ||
| 4. Arrange Data.mp4 | 23.2 MB | ||
| 4. Combined Formula.mp4 | 11.8 MB | ||
| 4. Interface.mp4 | 8.3 MB | ||
| 4. Types of Data Validation.mp4 | 27.3 MB | ||
| 5. Ask Y or N.mp4 | 13.9 MB | ||
| 5. Formula-Status-Bar.mp4 | 17.6 MB | ||
| 5. Text Conversion.mp4 | 47.4 MB | ||
| 5. VLOOKUP Limitation.mp4 | 22.4 MB | ||
| 6. Data Validation Example.mp4 | 23.9 MB | ||
| 6. INDEX-MATCH.mp4 | 50.3 MB | ||
| 6. Tabs.mp4 | 18.7 MB | ||
| 6. Text to Columns.mp4 | 32.9 MB | ||
| 6.1 Index and Match.xlsx | 9.3 KB | ||
| 7. Navigation.mp4 | 38.4 MB | ||
| 7. Relative Reference.mp4 | 14 MB | ||
| 7 | 69.7 KB | ||
| 7. Conditional Formatting.mp4 | 31.3 MB | ||
| 7. Practice 1.mp4 | 19.6 MB | ||
| 8. Assignment 2.mp4 | 25.7 MB | ||
| 8. Conditional Formatting Example.mp4 | 30.1 MB | ||
| 8. SUMIFS.mp4 | 32.2 MB | ||
| 8. Shortcuts.mp4 | 11 MB | ||
| 8 | 343.9 KB | ||
| 9 | 191.9 KB | ||
| 9. AVERAGEIFS-COUNTIFS.mp4 | 23.1 MB | ||
| 9. Basic Formulas I.mp4 | 12 MB | ||
| 9. Stay Creative.mp4 | 18.9 MB | ||
| 9.1 Conditional Formulas.xlsx | 9.2 KB | ||
| TutsNode.net.txt | 102.4 B | ||
| [TGx]Downloaded from torrentgalaxy.to .txt | 614.4 B | ||
| 10 | 423.6 KB | ||
| 11 | 472.1 KB | ||
| 12 | 182.6 KB | ||
| 13 | 219.3 KB | ||
| 14 | 332.3 KB | ||
| 15 | 415.5 KB | ||
| 16 | 30.5 KB | ||
| 17 | 114.7 KB | ||
| 18 | 326 KB | ||
| 19 | 436.5 KB | ||
| 20 | 170.3 KB | ||
| 21 | 77.6 KB | ||
| 22 | 213.9 KB | ||
| 23 | 119 KB | ||
| 24 | 425.3 KB | ||
| 25 | 348.9 KB | ||
| 26 | 135 KB | ||
| 27 | 259.3 KB | ||
| 28 | 449.6 KB | ||
| 29 | 283.7 KB | ||
| 30 | 498.9 KB | ||
| 31 | 90 KB | ||
| 32 | 111.3 KB | ||
| 33 | 54.3 KB | ||
| 34 | 75.2 KB | ||
| 35 | 419.9 KB | ||
| 36 | 465.8 KB | ||
| 37 | 504.6 KB | ||
| 38 | 40 KB | ||
| 39 | 160.8 KB | ||
| 40 | 234.8 KB | ||
| 41 | 368.9 KB | ||
| 42 | 93.6 KB | ||
| 43 | 398.7 KB | ||
| 44 | 8 KB | ||
| 45 | 243.8 KB | ||
| 46 | 35.5 KB | ||
| ▲ 103 total files | |||
Description
Welcome to Microsoft Excel Course. Here you will learn a lot of things right from scratch. Learn How to open a file, save a file, then slowly move on to the advanced topics like How to create Dynamic Data, Using Choose, Workday, Networkday, Index, Match, Proper and more.
As we all know that Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android, iOS and iPadOS. It features calculation or computation capabilities, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications.
Following Formulas are covered:
UPPER function changes all text to CAPITALS
LOWER function changes all text to lower case
PROPER function changes the first letter in each word to upper case and all other letters to lower case – Generally this is useful for fixing names.
TRIM function removes all spaces from text except for single spaces between words.
INDEX function returns a value or the reference to a value from within a table or range. There are two ways to use the INDEX function: If you want to return the value of a specified cell or array of cells, see Array form. If you want to return a reference to specified cells, see Reference form.
MATCH function searches for a specified item in a range of cells, and then returns the relative position of that item in the range.
WORKDAY returns a number that represents a date that is the indicated number of working days before or after a date (the starting date).
More Formulas like- NETWORKDAY, CHOOSE, AVERAGEIFS, COUNTIFS, SUMIFS.INTL and more….Let’s learn microsoft excel.
Who this course is for:
Anyone who want to learn Excel. Professionals who want to learn advance formulas in excel
Requirements
No prior experienced required. Learn Everything From Scratch
Last Updated 3/2023
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 9.85 GB | rarecloud | 10 months | 6 | 11 | |
| 3.1 GB | freecoursewb | 1 year | 0 | 0 | |
|
Udemy - Markdown Masterclass - Learn Markdown from Basic to Advanced Posted by
freecoursewb in Other
|
733.8 MB | freecoursewb | 1 year | 13 | 2 |
| 2.2 GB | freecoursewb | 1 year | 6 | 4 | |
| 1 GB | freecoursewb | 1 year | 0 | 0 |
All Comments