Udemy - Master Excel From Novice to Expert!

Files:

• Get Bonus Downloads Here.url (0.2 KB)
~Get Your Files Here ! 1. Getting started with Excel
• 1. Account Information.mp4 (5.3 MB)
• 2. Introduction to the Course.mp4 (20.1 MB)
• 3. Excel Interface.mp4 (14.1 MB)
• 4. Customising the Quick Access Toolbar.mp4 (20.4 MB)
• 5. Customising Excel Ribbon.mp4 (20.9 MB)
• 6. Common Excel Shortcut Keys.mp4 (5.2 MB)
• 7. Workbook vs Worksheet.mp4 (4.1 MB)
• 8. How to save an Excel File.mp4 (12.4 MB)
10. Excel Templates
• 1. Introduction to Excel Templates.mp4 (17.8 MB)
• 2. Creating a Custom Template.mp4 (22.1 MB)
11. Sorting Data
• 1. Getting Started with Sorting Data.mp4 (15.4 MB)
• 1.1 Practice File.xlsx (42.7 KB)
• 2. Sorting Data.mp4 (19.0 MB)
• 3. Multi Level Sorting.mp4 (21.2 MB)
• 4. Custom Sorting.mp4 (19.1 MB)
• 5. Applying Filters to Datasets.mp4 (30.9 MB)
• 6. Converting Datasets into Tables.mp4 (46.9 MB)
12. Data Validation
• 1. Introduction to Data Validation.mp4 (7.0 MB)
• 2. Data Validation Drop Down List.mp4 (11.3 MB)
• 3. Different Types of Data Validation.mp4 (28.2 MB)
• 4. Dynamic Drop Down List.mp4 (17.7 MB)
• 5. Custom Error Alerts.mp4 (21.5 MB)
13. Database Functions
• 1. SUMIF and SUMIFS Function.mp4 (72.1 MB)
• 2. DSUM Function.mp4 (54.9 MB)
• 3. Benefits of using DSUM Function.mp4 (39.2 MB)
• 4. SUBTOTAL Function.mp4 (61.9 MB)
14. Pivot Tables
• 1. Creating a Pivot Table.mp4 (51.3 MB)
• 2. Modifying Excel Pivot Tables.mp4 (27.0 MB)
• 3. More on Modifying Pivot Tables.mp4 (30.7 MB)
• 4. Grouping and Filtering Data in Pivot Tables.mp4 (58.4 MB)
• 5. Drilling Down feature in Excel Pivot Tables.mp4 (21.7 MB)
• 6. Pivot Charts and Slicers.mp4 (72.9 MB)
15. Excel's Conditional Functions
• 1. IF() Function.mp4 (28.3 MB)
• 2. IF() Function and AND() Function.mp4 (48.8 MB)
• 3. IF() and OR() Function.mp4 (27.9 MB)
• 4. Nesting Multiple IF() Functions.mp4 (32.1 MB)
• 5. COUNTIF() Function.mp4 (24.6 MB)
16. Excel's Lookup Functions
• 1. VLOOKUP() Function.mp4 (66.2 MB)
• 2. HLOOKUP() Function.mp4 (31.9 MB)
• 3. INDEX() Function.mp4 (26.8 MB)
• 4. MATCH() Function.mp4 (17.8 MB)
• 5. INDEX() AND MATCH() Functions Together.mp4 (32.0 MB)
17. Whatif Tools
• 1. Scenario Manager.mp4 (24.7 MB)
• 2. Goal Seek.mp4 (13.8 MB)
18. Text Based Functions
• 1. LEFT(), MID() and RIGHT() Function.mp4 (28.8 MB)
• 2. CONCATENATE() Function.mp4 (13.6 MB)
19. Auditing
• 1. Tracing Precedents and Dependents.mp4 (19.8 MB)
• 2. Show Formulas feature.mp4 (14.4 MB)
• 3. Grouping Data.mp4 (27.2 MB)
• 4. 3D referencing in Excel.mp4 (27.7 MB)
• 5. Freeze Pans.mp4 (32.3 MB)
2. Values, Referencing and Formulas
• 1. Labels and Entering Data.mp4 (16.9 MB)
• 2. Formating Date Values.mp4 (25.9 MB)
• 3. Getting Started with Formulas.mp4 (18.2 MB)
• 4. Fill Handle.mp4 (11.8 MB)
• 5. Relative vs Absolute Cell Reference.mp4 (24.4 MB)
3. Getting Started with Excel Functions
• 1. Introduction to Excel Functions.mp4 (11.2 MB)
• 2. More on Excel Functions.mp4 (26.4 MB)
• 3. AVERAGE Function, MIN Function and More.mp4 (21.9 MB)
4. Adjusting Excel Worksheets
• 1. How to Move and Copy Data.mp4 (11.6 MB)
• 2. Inserting and Deleting Rows and Columns.mp4 (22.8 MB)
• 3. Adjusting Width and Height of Columns.mp4 (17.8 MB)
• 4. Hiding and Unhiding Rows and Columns.mp4 (12.3 MB)
• 5. How to Make a Copy, Rename and Delete a Worksheet.mp4 (12.2 MB)
5. Protection in Excel
• 1. Protecting Worksheets and Specific Cells.mp4 (20.1 MB)
• 2. Protecting Workbook.mp4 (9.7 MB)
• 3. Encrypting Excel Workbook with a Password.mp4 (11.8 MB)
6. Formatting to Make Cells Look Good
• 1. Formatting Cells and Fonts.mp4 (22.0 MB)
• 2. Formatting Numbers.mp4 (11.3 MB)
• 3. Format Painter.mp4 (10.4 MB)
• 4. Cell Styles.mp4 (16.2 MB)
• 5. Merging Cells.mp4 (8.5 MB)
• 6. Introduction to Conditional Formatting.mp4 (21.0 MB)
• 7. More on Conditional Formatting.mp4 (21.6 MB)
7. Inserting Shapes and Images
• 1. How to Insert Shapes and Images.mp4 (23.0 MB)
• 2. More on Shapes.mp4 (39.3 MB)
• 3. Smart Art.mp4 (30.0 MB)
8. Learn to use Charts
• 1. Introduction to Charts.mp4 (16.2 MB)
• 2. Formatting a Chart.mp4 (13.5 MB)
• 3. Formatting Individual Elements of a Chart.mp4 (33.9 MB)
• 4. More on Charts.mp4 (33.0 MB)
• 5. Moving a Chart and Introduction to Pie Charts.mp4 (49.4 MB)
9. Printing
• 1. Introduction to Printing Options.mp4 (25.5 MB)
• 2. Page Layout View.mp4 (27.3 MB)
• 3. Headers and Footers.mp4 (17.8 MB)
• 4. Printing Specific Cells.mp4 (18.2 MB)
• Bonus Resources.txt (0.4 KB)