Udemy - Microsoft Excel - Sweet and Short

Files:

• Get Bonus Downloads Here.url (0.2 KB)
~Get Your Files Here ! 1. Excel Essentials
• 1. Opening a Workbook.mp4 (10.5 MB)
• 1.1 Double click to open.xlsx (8.4 KB)
• 10. Working with Dates & Times.mp4 (15.2 MB)
• 10.1 Working with Dates & Times.xlsx (11.0 KB)
• 11. Adding notes and comments.mp4 (9.8 MB)
• 11.1 Adding comments2.xlsm (12.8 KB)
• 12. Simple Formulas (Totals & Averages).mp4 (11.6 MB)
• 12.1 Simple Formulas (Totals and Averages).xlsm (10.4 KB)
• 13. Formatting Rows & Columns.mp4 (13.3 MB)
• 13.1 Formatting Rows & Columns - Worksheet.xlsx (12.0 KB)
• 14. Inserting pictures and shapes into Excel.mp4 (18.8 MB)
• 14.1 Inserting pictures and shapes into Excel.xlsx (20.8 KB)
• 14.2 Your Logo.png (28.1 KB)
• 15. Working with Themes.mp4 (17.3 MB)
• 15.1 Working with Themes.xlsx (19.4 KB)
• 16. Freeze Panes.mp4 (25.2 MB)
• 16.1 Freeze Panes.xlsx (40.7 KB)
• 17. Getting your sheet ready for printing.mp4 (15.8 MB)
• 17.1 Getting your sheet ready for printing.xlsx (12.3 KB)
• 18. Page break preview.mp4 (14.4 MB)
• 18.1 Page break preview.xlsx (12.3 KB)
• 19. Spell checker.mp4 (13.3 MB)
• 19.1 Spell Checker.docx (12.1 KB)
• 19.2 Spell Checker.xlsx (9.6 KB)
• 2. Saving a workbook.mp4 (12.6 MB)
• 2.1 Saving workbooks.xlsx (12.6 KB)
• 20. Clear all Button.mp4 (9.6 MB)
• 20.1 Clear All Button.xlsx (11.7 KB)
• 21. Find and Replace.mp4 (18.2 MB)
• 21.1 Find and Replace.xlsx (15.5 KB)
• 22. Merge Cells.mp4 (12.9 MB)
• 22.1 Merge Cells.xlsx (12.9 KB)
• 23. Microsoft Templates.mp4 (11.9 MB)
• 23.1 Microsoft Template.xlsx (61.4 KB)
• 24. Excel Essential Quiz.html (0.1 KB)
• 3. Managing the Backstage View.mp4 (10.7 MB)
• 4. Familiarity with file formats.mp4 (15.3 MB)
• 4.1 Comma Separated Values.csv (0.1 KB)
• 5. Comprehensive knowledge of the ribbon tabs.mp4 (17.4 MB)
• 5.1 Comprehensive knowledge of the ribbon tabs.xlsx (16.5 KB)
• 6. Customize the Quick Access Tool Bar.mp4 (19.5 MB)
• 6.1 Customize the Quick Access Tool Bar.xlsx (11.4 KB)
• 7. Excel Interface Overview.mp4 (13.7 MB)
• 7.1 Excel Interface Overview.xlsx (12.9 KB)
• 8. Data entry and editing techniques.mp4 (8.6 MB)
• 8.1 Data Entry and Editing Techniques.xlsx (9.1 KB)
• 9. Data Autofill.mp4 (10.1 MB)
• 9.1 Data Autofill.xlsx (13.0 KB)
2. Working with tables
• 1. Why use a table.mp4 (15.7 MB)
• 1.1 Why use a table.xlsx (22.2 KB)
• 2. The components of a table.mp4 (15.6 MB)
• 2.1 The components of a table.xlsx (17.3 KB)
• 3. Formatting of a Table.mp4 (14.8 MB)
• 3.1 Formatting of a table.xlsx (13.2 KB)
• 4. Using autofilter.mp4 (20.5 MB)
• 4.1 Using Autofilter.xlsx (17.2 KB)
• 5. Slicers with tables.mp4 (11.9 MB)
• 5.1 Slicers with Tables.xlsx (21.0 KB)
• 6. Advanced Sorting.mp4 (20.2 MB)
• 6.1 Advanced Sorting.xlsx (16.6 KB)
• 7. Calculating totals on a table.mp4 (15.0 MB)
• 7.1 Calculating totals on a table.xlsx (21.1 KB)
• 8. Referencing within a table.mp4 (15.8 MB)
• 8.1 Referencing within a table.xlsx (15.6 KB)
• 9. Working with Tables - Quiz.html (0.1 KB)
3. Formatting
• 1. What data really looks like.mp4 (8.5 MB)
• 1.1 What data really looks like.xlsx (9.9 KB)
• 10. Insert a shape of any type.mp4 (15.2 MB)
• 10.1 Insert a shape of any type.xlsx (14.2 KB)
• 11. Advanced Manipulation of SmartArt.mp4 (9.7 MB)
• 11.1 SmartArt.xlsx (7.7 KB)
• 12. Insert symbols and equations.mp4 (11.3 MB)
• 12.1 Insert Symbols and Equations.xlsx (8.9 KB)
• 13. Formatting a graphic object.mp4 (12.3 MB)
• 13.1 Formatting a graphic object.xlsx (7.8 KB)
• 14. Change the shape of a graphic object.mp4 (7.2 MB)
• 14.1 Change the shape of a graphic object.xlsx (10.7 KB)
• 15. Selection pane.mp4 (7.9 MB)
• 15.1 Selection pane.xlsx (42.6 KB)
• 16. Object Arrangement.mp4 (7.7 MB)
• 16.1 Object Arrangement.xlsx (29.7 KB)
• 17. Perform multi-criteria sorts and customized sorts.mp4 (17.8 MB)
• 17.1 Perform multi-criteria sorts.xlsx (15.3 KB)
• 18. Inputting in multiple cells.mp4 (11.5 MB)
• 18.1 Inputting in multiple cells.xlsx (9.1 KB)
• 19. Advanced knowledge of custom lists.mp4 (10.5 MB)
• 19.1 Advanced knowledge of custom lists.xlsx (8.5 KB)
• 2. Applying formatting to a cell.mp4 (12.2 MB)
• 2.1 Applying formatting to a cell.xlsx (9.4 KB)
• 20. Advanced knowledge of Hypertext links.mp4 (14.7 MB)
• 20.1 Advanced knowledge of Hypertext links.xlsx (16.2 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.1 Create and Edit a form.xlsm (19.0 KB)
• 22. Create and edit a form - Part 2.mp4 (12.2 MB)
• 22.1 Create and Edit a form.xlsm (17.5 KB)
• 23. Formatting Quiz.html (0.1 KB)
• 3. Text vs Numerical Data.mp4 (14.5 MB)
• 3.1 Text vs Numerical Data.xlsx (10.9 KB)
• 4. Formatting Dates.mp4 (15.9 MB)
• 4.1 Formatting Dates.xlsx (10.3 KB)
• 5. Working with Currencies.mp4 (15.0 MB)
• 5.1 Working with Currencies.xlsx (10.8 KB)
• 6. Formatting Percentages.mp4 (9.2 MB)
• 6.1 Formatting Percentages.xlsx (10.4 KB)
• 7. Format Painter.mp4 (12.9 MB)
• 7.1 Format Painter.xlsx (10.1 KB)
• 8. Conditional Formatting with a formula.mp4 (23.0 MB)
• 8.1 Conditional Formatting with a formula.xlsx (12.1 KB)
• 9. Insert a screenshot.mp4 (17.2 MB)
• 9.1 Insert a screenshot - destination.xlsx (11.7 KB)
• 9.2 Insert a screenshot.xlsx (12.6 KB)
4. Core Functions
• 1. Equals and Targeting cells.mp4 (12.1 MB)
• 1.1 Equals and Targeting cells.xlsx (13.0 KB)
• 10. ROUND, ROUNDUP and ROUNDDOWN Functions.mp4 (13.7 MB)
• 10.1 ROUND, ROUNDUP and ROUNDDOWN Functions.xlsx (10.6 KB)
• 11. LEFT and RIGHT functions.mp4 (11.9 MB)
• 11.1 LEFT and RIGHT Functions.xlsx (11.7 KB)
• 12. MID function.mp4 (9.6 MB)
• 12.1 MID Function.xlsx (11.6 KB)
• 13. Errors in Functions.mp4 (16.0 MB)
• 13.1 Errors in Functions.xlsx (12.1 KB)
• 14. CONCATENATE Function.mp4 (11.8 MB)
• 14.1 Concatenate Function.xlsx (10.1 KB)
• 15. UPPER, LOWER and PROPER Functions.mp4 (9.2 MB)
• 15.1 UPPER, LOWER and PROPER Functions.xlsx (10.3 KB)
• 16. Core Functions - Quiz.html (0.1 KB)
• 2. Functions vs Formulas.mp4 (10.1 MB)
• 2.1 Functions vs Formulas.xlsx (11.3 KB)
• 3. Adding, subtracting, multiplication and division.mp4 (11.6 MB)
• 3.1 Adding, subtracting, Multiplication and Division.xlsx (12.6 KB)
• 4. Components of a Function.mp4 (13.3 MB)
• 4.1 Components of a Function.xlsx (11.8 KB)
• 5. Sum and Average Function.mp4 (15.6 MB)
• 5.1 Sum and Average Function.xlsx (11.0 KB)
• 6. More than one function in a cell.mp4 (7.8 MB)
• 6.1 More than one function in a cell.xlsx (9.8 KB)
• 7. Absolute References ($ signs).mp4 (20.7 MB)
• 7.1 Absolute references.xlsx (11.9 KB)
• 8. Look for - Help with Functions.mp4 (15.8 MB)
• 8.1 Look for and help with Functions.xlsx (10.0 KB)
• 9. COUNT Function.mp4 (9.5 MB)
• 9.1 COUNT Function.xlsx (10.4 KB)
5. VLOOKUPS
• 1. What you can do with a VLOOKUP.mp4 (20.6 MB)
• 1.1 What you can do with a VLOOKUP.xlsx (16.5 KB)
• 10. VLOOKUP - Quiz.html (0.1 KB)
• 2. The correct dataset structure.mp4 (14.4 MB)
• 2.1 The correct dataset structure.xlsx (14.0 KB)
• 3. Doing a VLOOKUP.mp4 (14.8 MB)
• 3.1 Doing a VLOOKUP.xlsx (13.4 KB)
• 4. Common problems with VLOOKUP.mp4 (16.1 MB)
• 4.1 Common problems with a VLOOKUP.xlsx (13.6 KB)
• 5. Exact or Approximate match.mp4 (18.8 MB)
• 5.1 Exact or Approximate match.xlsx (15.8 KB)
• 6. Comparing two sheets with a VLOOKUP.mp4 (14.2 MB)
• 6.1 Comparing two sheets with a VLOOKUP.xlsx (16.3 KB)
• 7. Matching on more than one criteria.mp4 (17.9 MB)
• 7.1 Matching on more than one criteria.xlsx (13.2 KB)
• 8. HLOOKUP function.mp4 (10.8 MB)
• 8.1 HLOOKUP Function.xlsx (16.0 KB)
• 9. Error Handling - IFERROR function.mp4 (14.9 MB)
• 9.1 Error handling - IFERROR function.xlsx (14.3 KB)
• Bonus Resources.txt (0.4 KB)