| 1. Equals and Targeting cells.mp4 | 12.1 MB | ||
| 1. Opening a Workbook.mp4 | 10.5 MB | ||
| 1. What data really looks like.mp4 | 8.5 MB | ||
| 1. What you can do with a VLOOKUP.mp4 | 20.6 MB | ||
| 1. Why use a table.mp4 | 15.7 MB | ||
| 1.1 Double click to open.xlsx | 8.4 KB | ||
| 1.1 Equals and Targeting cells.xlsx | 13 KB | ||
| 1.1 What data really looks like.xlsx | 9.9 KB | ||
| 1.1 What you can do with a VLOOKUP.xlsx | 16.5 KB | ||
| 1.1 Why use a table.xlsx | 22.2 KB | ||
| 10. Insert a shape of any type.mp4 | 15.2 MB | ||
| 10. ROUND, ROUNDUP and ROUNDDOWN Functions.mp4 | 13.7 MB | ||
| 10. VLOOKUP - Quiz.html | 102.4 B | ||
| 10. Working with Dates & Times.mp4 | 15.2 MB | ||
| 10.1 Insert a shape of any type.xlsx | 14.2 KB | ||
| 10.1 ROUND, ROUNDUP and ROUNDDOWN Functions.xlsx | 10.6 KB | ||
| 10.1 Working with Dates & Times.xlsx | 11 KB | ||
| 11. Adding notes and comments.mp4 | 9.8 MB | ||
| 11. Advanced Manipulation of SmartArt.mp4 | 9.7 MB | ||
| 11. LEFT and RIGHT functions.mp4 | 11.9 MB | ||
| 11.1 Adding comments2.xlsm | 12.8 KB | ||
| 11.1 LEFT and RIGHT Functions.xlsx | 11.7 KB | ||
| 11.1 SmartArt.xlsx | 7.7 KB | ||
| 12. Insert symbols and equations.mp4 | 11.3 MB | ||
| 12. MID function.mp4 | 9.6 MB | ||
| 12. Simple Formulas (Totals & Averages).mp4 | 11.6 MB | ||
| 12.1 Insert Symbols and Equations.xlsx | 8.9 KB | ||
| 12.1 MID Function.xlsx | 11.6 KB | ||
| 12.1 Simple Formulas (Totals and Averages).xlsm | 10.4 KB | ||
| 13. Errors in Functions.mp4 | 16 MB | ||
| 13. Formatting Rows & Columns.mp4 | 13.3 MB | ||
| 13. Formatting a graphic object.mp4 | 12.3 MB | ||
| 13.1 Errors in Functions.xlsx | 12.1 KB | ||
| 13.1 Formatting Rows & Columns - Worksheet.xlsx | 12 KB | ||
| 13.1 Formatting a graphic object.xlsx | 7.8 KB | ||
| 14. CONCATENATE Function.mp4 | 11.8 MB | ||
| 14. Change the shape of a graphic object.mp4 | 7.2 MB | ||
| 14. Inserting pictures and shapes into Excel.mp4 | 18.8 MB | ||
| 14.1 Change the shape of a graphic object.xlsx | 10.7 KB | ||
| 14.1 Concatenate Function.xlsx | 10.1 KB | ||
| 14.1 Inserting pictures and shapes into Excel.xlsx | 20.8 KB | ||
| 14.2 Your Logo.png | 28.1 KB | ||
| 15. Selection pane.mp4 | 7.9 MB | ||
| 15. UPPER, LOWER and PROPER Functions.mp4 | 9.2 MB | ||
| 15. Working with Themes.mp4 | 17.3 MB | ||
| 15.1 Selection pane.xlsx | 42.6 KB | ||
| 15.1 UPPER, LOWER and PROPER Functions.xlsx | 10.3 KB | ||
| 15.1 Working with Themes.xlsx | 19.4 KB | ||
| 16. Core Functions - Quiz.html | 102.4 B | ||
| 16. Freeze Panes.mp4 | 25.2 MB | ||
| 16. Object Arrangement.mp4 | 7.7 MB | ||
| 16.1 Freeze Panes.xlsx | 40.7 KB | ||
| 16.1 Object Arrangement.xlsx | 29.7 KB | ||
| 17. Getting your sheet ready for printing.mp4 | 15.8 MB | ||
| 17. Perform multi-criteria sorts and customized sorts.mp4 | 17.8 MB | ||
| 17.1 Getting your sheet ready for printing.xlsx | 12.3 KB | ||
| 17.1 Perform multi-criteria sorts.xlsx | 15.3 KB | ||
| 18. Inputting in multiple cells.mp4 | 11.5 MB | ||
| 18. Page break preview.mp4 | 14.4 MB | ||
| 18.1 Inputting in multiple cells.xlsx | 9.1 KB | ||
| 18.1 Page break preview.xlsx | 12.3 KB | ||
| 19. Advanced knowledge of custom lists.mp4 | 10.5 MB | ||
| 19. Spell checker.mp4 | 13.3 MB | ||
| 19.1 Advanced knowledge of custom lists.xlsx | 8.5 KB | ||
| 19.1 Spell Checker.docx | 12.1 KB | ||
| 19.2 Spell Checker.xlsx | 9.6 KB | ||
| 2. Applying formatting to a cell.mp4 | 12.2 MB | ||
| 2. Functions vs Formulas.mp4 | 10.1 MB | ||
| 2. Saving a workbook.mp4 | 12.6 MB | ||
| 2. The components of a table.mp4 | 15.6 MB | ||
| 2. The correct dataset structure.mp4 | 14.4 MB | ||
| 2.1 Applying formatting to a cell.xlsx | 9.4 KB | ||
| 2.1 Functions vs Formulas.xlsx | 11.3 KB | ||
| 2.1 Saving workbooks.xlsx | 12.6 KB | ||
| 2.1 The components of a table.xlsx | 17.3 KB | ||
| 2.1 The correct dataset structure.xlsx | 14 KB | ||
| 20. Advanced knowledge of Hypertext links.mp4 | 14.7 MB | ||
| 20. Clear all Button.mp4 | 9.6 MB | ||
| 20.1 Advanced knowledge of Hypertext links.xlsx | 16.2 KB | ||
| 20.1 Clear All Button.xlsx | 11.7 KB | ||
| 20.2 How to link an external document into your excel sheet.pdf | 98.7 KB | ||
| 20.3 Word document.docx | 11.5 KB | ||
| 21. Create and edit a form - Part 1.mp4 | 10.1 MB | ||
| 21. Find and Replace.mp4 | 18.2 MB | ||
| 21.1 Create and Edit a form.xlsm | 19 KB | ||
| 21.1 Find and Replace.xlsx | 15.5 KB | ||
| 22. Create and edit a form - Part 2.mp4 | 12.2 MB | ||
| 22. Merge Cells.mp4 | 12.9 MB | ||
| 22.1 Create and Edit a form.xlsm | 17.5 KB | ||
| 22.1 Merge Cells.xlsx | 12.9 KB | ||
| 23. Formatting Quiz.html | 102.4 B | ||
| 23. Microsoft Templates.mp4 | 11.9 MB | ||
| 23.1 Microsoft Template.xlsx | 61.4 KB | ||
| 24. Excel Essential Quiz.html | 102.4 B | ||
| 3. Adding, subtracting, multiplication and division.mp4 | 11.6 MB | ||
| 3. Doing a VLOOKUP.mp4 | 14.8 MB | ||
| 3. Formatting of a Table.mp4 | 14.8 MB | ||
| 3. Managing the Backstage View.mp4 | 10.7 MB | ||
| 3. Text vs Numerical Data.mp4 | 14.5 MB | ||
| 3.1 Adding, subtracting, Multiplication and Division.xlsx | 12.6 KB | ||
| 3.1 Doing a VLOOKUP.xlsx | 13.4 KB | ||
| 3.1 Formatting of a table.xlsx | 13.2 KB | ||
| 3.1 Text vs Numerical Data.xlsx | 10.9 KB | ||
| 4. Common problems with VLOOKUP.mp4 | 16.1 MB | ||
| 4. Components of a Function.mp4 | 13.3 MB | ||
| 4. Familiarity with file formats.mp4 | 15.3 MB | ||
| 4. Formatting Dates.mp4 | 15.9 MB | ||
| 4. Using autofilter.mp4 | 20.5 MB | ||
| 4.1 Comma Separated Values.csv | 102.4 B | ||
| 4.1 Common problems with a VLOOKUP.xlsx | 13.6 KB | ||
| 4.1 Components of a Function.xlsx | 11.8 KB | ||
| 4.1 Formatting Dates.xlsx | 10.3 KB | ||
| 4.1 Using Autofilter.xlsx | 17.2 KB | ||
| 5. Comprehensive knowledge of the ribbon tabs.mp4 | 17.4 MB | ||
| 5. Exact or Approximate match.mp4 | 18.8 MB | ||
| 5. Slicers with tables.mp4 | 11.9 MB | ||
| 5. Sum and Average Function.mp4 | 15.6 MB | ||
| 5. Working with Currencies.mp4 | 15 MB | ||
| 5.1 Comprehensive knowledge of the ribbon tabs.xlsx | 16.5 KB | ||
| 5.1 Exact or Approximate match.xlsx | 15.8 KB | ||
| 5.1 Slicers with Tables.xlsx | 21 KB | ||
| 5.1 Sum and Average Function.xlsx | 11 KB | ||
| 5.1 Working with Currencies.xlsx | 10.8 KB | ||
| 6. Advanced Sorting.mp4 | 20.2 MB | ||
| 6. Comparing two sheets with a VLOOKUP.mp4 | 14.2 MB | ||
| 6. Customize the Quick Access Tool Bar.mp4 | 19.5 MB | ||
| 6. Formatting Percentages.mp4 | 9.2 MB | ||
| 6. More than one function in a cell.mp4 | 7.8 MB | ||
| 6.1 Advanced Sorting.xlsx | 16.6 KB | ||
| 6.1 Comparing two sheets with a VLOOKUP.xlsx | 16.3 KB | ||
| 6.1 Customize the Quick Access Tool Bar.xlsx | 11.4 KB | ||
| 6.1 Formatting Percentages.xlsx | 10.4 KB | ||
| 6.1 More than one function in a cell.xlsx | 9.8 KB | ||
| 7. Absolute References ($ signs).mp4 | 20.7 MB | ||
| 7. Calculating totals on a table.mp4 | 15 MB | ||
| 7. Excel Interface Overview.mp4 | 13.7 MB | ||
| 7. Format Painter.mp4 | 12.9 MB | ||
| 7. Matching on more than one criteria.mp4 | 17.9 MB | ||
| 7.1 Absolute references.xlsx | 11.9 KB | ||
| 7.1 Calculating totals on a table.xlsx | 21.1 KB | ||
| 7.1 Excel Interface Overview.xlsx | 12.9 KB | ||
| 7.1 Format Painter.xlsx | 10.1 KB | ||
| 7.1 Matching on more than one criteria.xlsx | 13.2 KB | ||
| 8. Conditional Formatting with a formula.mp4 | 23 MB | ||
| 8. Data entry and editing techniques.mp4 | 8.6 MB | ||
| 8. HLOOKUP function.mp4 | 10.8 MB | ||
| 8. Look for - Help with Functions.mp4 | 15.8 MB | ||
| 8. Referencing within a table.mp4 | 15.8 MB | ||
| 8.1 Conditional Formatting with a formula.xlsx | 12.1 KB | ||
| 8.1 Data Entry and Editing Techniques.xlsx | 9.1 KB | ||
| 8.1 HLOOKUP Function.xlsx | 16 KB | ||
| 8.1 Look for and help with Functions.xlsx | 10 KB | ||
| 8.1 Referencing within a table.xlsx | 15.6 KB | ||
| 9. COUNT Function.mp4 | 9.5 MB | ||
| 9. Data Autofill.mp4 | 10.1 MB | ||
| 9. Error Handling - IFERROR function.mp4 | 14.9 MB | ||
| 9. Insert a screenshot.mp4 | 17.2 MB | ||
| 9. Working with Tables - Quiz.html | 102.4 B | ||
| 9.1 COUNT Function.xlsx | 10.4 KB | ||
| 9.1 Data Autofill.xlsx | 13 KB | ||
| 9.1 Error handling - IFERROR function.xlsx | 14.3 KB | ||
| 9.1 Insert a screenshot - destination.xlsx | 11.7 KB | ||
| 9.2 Insert a screenshot.xlsx | 12.6 KB | ||
| Bonus Resources.txt | 409.6 B | ||
| Get Bonus Downloads Here.url | 204.8 B | ||
| ▲ 165 total files | |||
Microsoft Excel - Sweet and Short
https://DevCourseWeb.com
Published 8/2023
Created by Andre Louw,Ane Taljaard
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English | Duration: 77 Lectures ( 2h 15m ) | Size: 1 GB
Excel Mastery Made Simple: Unleashing Efficiency in Every Cell
What you'll learn
Learn basic fundamentals of Excel
Work with Tables and Graphs
Learn about VLOOKUPS, Pivot Tables and many more
Learn core functions
Requirements
No experience needed. You will learn everything from Beginner to advanced. You will need Microsoft Excel for this course.
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 2 GB | freecoursewb | 1 month | 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