Udemy - Excel 101 For Virtual Assistants

Files:

• Get Bonus Downloads Here.url (0.2 KB)
~Get Your Files Here ! 1 - Introduction
• 1 - How to go about learning Microsoft Excel.html (3.0 KB)
• 10 - Delete and hide cells in a workbook.mp4 (85.6 MB)
• 11 - What Virtual Assistants should be aware of.html (2.8 KB)
• 2 - The Microsoft Excel user interface.mp4 (43.9 MB)
• 3 - Navigating the Microsoft Excel interface.mp4 (95.0 MB)
• 4 - Three types of clicks.mp4 (24.5 MB)
• 5 - Data Types in Excel.html (1.7 KB)
• 6 - Basic Data Entry.mp4 (26.7 MB)
• 7 - Introduction to Excel formulae.mp4 (85.8 MB)
• 8 - Excel formulae and functions.mp4 (212.1 MB)
• 8 - Excel-CS.pdf (1.0 MB)
• 9 - Absolute cell reference.mp4 (68.3 MB)
2 - Formatting in Microsoft Excel
• 12 - Basics of formatting.mp4 (112.5 MB)
• 13 - Formatting with themes.mp4 (62.1 MB)
• 14 - Tips and Tricks to speed up Data Entry.html (2.3 KB)
• 15 - Freeze Panes.html (1.8 KB)
• 16 - Conditional Formatting.mp4 (86.2 MB)
• 17 - Tips and Tricks for better formatting.html (2.4 KB)
3 - Filter sort and custom sort
• 18 - Filter.mp4 (76.6 MB)
• 19 - Custom Sort.mp4 (68.4 MB)
• 20 - Summary on Filtering Sorting and Custom Sorting.html (1.4 KB)
4 - Charts with Microsoft Excel
• 21 - Introduction to variables and plotting relationships between variables.mp4 (102.2 MB)
• 22 - Charts with Categorical Data.html (3.1 KB)
• 23 - Histograms boxplots and scatterplots.mp4 (94.0 MB)
• 24 - Line bar and pie charts.mp4 (161.7 MB)
5 - Pivot Tables with Microsoft Excel
• 25 - Pivot Tables.mp4 (147.5 MB)
• 26 - Pivot tables with Slicer.mp4 (107.4 MB)
6 - Intermediate Excel
• 27 - Logical statements in Excel IF.mp4 (73.0 MB)
• 28 - Logical statements Nested IF.mp4 (62.0 MB)
• 29 - Logical statements AND OR.mp4 (62.0 MB)
• 30 - CHOOSE Statement.mp4 (28.6 MB)
• 31 - VLOOKUP Exact Match.mp4 (64.7 MB)
• 32 - VLOOKUP Range.mp4 (57.8 MB)
• 33 - INDEX MATCH Statement.mp4 (39.1 MB)
• 34 - Data Validation.mp4 (129.5 MB)
• 35 - Data Validation Drop Down.mp4 (32.5 MB)
• 36 - Data Tables.mp4 (41.8 MB)
• 37 - Use Cases for Data Tables.html (2.7 KB)
• 38 - Goal seek.mp4 (48.1 MB)
• 39 - Use Cases for Goal Seek.html (2.6 KB)
• 40 - Trace precedents and dependents.mp4 (72.3 MB)
• 41 - Tips and Tricks to get the most out of Excel.html (2.0 KB)
• Bonus Resources.txt (0.4 KB)