Microsoft Excel - Advanced Excel Formulas and Functions by Nikkya...

Files:

• Get Bonus Downloads Here.url (0.2 KB)
~Get Your Files Here ! 1. Introduction
• 1. Introduction.mp4 (28.3 MB)
• 2. Course Excercise Files.mp4 (10.7 MB)
• 2.1 Excel 1.1 (Advance).xlsx (54.9 KB)
• 2.2 Excel 1.1.xlsx (775.3 KB)
10. Using What-If Analysis Tools In Excel
• 1. Using Goal Seek Tool In Excel.mp4 (37.8 MB)
• 2. Using Data Table Tool In Excel.mp4 (37.0 MB)
• 3. Using Scenario Manager Tool In Excel.mp4 (52.1 MB)
• 4. Excel What-if Analysis Quiz.html (0.2 KB)
2. Excel PivotTables
• 1. Understanding Excel PivotTables.mp4 (35.0 MB)
• 10. Filtering With Slicer Tool Technique In Excel.mp4 (43.1 MB)
• 11. Excel PivotTable Quiz.html (0.2 KB)
• 2. Creating Excel PivotTable In Same Worksheet.mp4 (88.8 MB)
• 3. Creating Excel PivotTables In New Worksheet.mp4 (66.6 MB)
• 4. Grouping PivotTable Data In Excel.mp4 (59.8 MB)
• 5. Formatting PivotTable Data In Excel.mp4 (40.7 MB)
• 6. Modifying PivotTable Calculations In Excel.mp4 (58.1 MB)
• 7. Drilling Down Into PivotTable In Excel.mp4 (22.0 MB)
• 8. Creating PivotChart Base On PivotTable In Excel.mp4 (59.9 MB)
• 9. Filter Option In PivotTable Data In Excel.mp4 (34.5 MB)
3. PowerPivot
• 1. Explaining PowerPivot And Add-In PowerPivot Tab In Ribbon.mp4 (38.3 MB)
• 2. Creating Data Model For PowerPivot In Excel.mp4 (43.2 MB)
• 3. Creating Relationship After Creating Data Model.mp4 (38.3 MB)
• 4. Creating PivotTable Base On Data Model.mp4 (52.7 MB)
• 5. Excel Power Pivot Quiz.html (0.2 KB)
4. Working With Large Set Of Excel Data
• 1. Freeze Panes Tool In Excel.mp4 (34.6 MB)
• 2. Grouping (Outline) Data In Excel.mp4 (57.2 MB)
• 3. Linking Worksheet In Excel.mp4 (26.3 MB)
• 4. Linking Worksheet With Consolidate Tool In Excel.mp4 (39.3 MB)
• 5. Print Options For Large Set Of Data In Excel.mp4 (93.8 MB)
• 6. Excel Large Set Quiz.html (0.2 KB)
5. Working With Excel Conditional Function
• 1. Working With Name Ranges In Excel.mp4 (88.8 MB)
• 2. Editing Name Ranges In Excel.mp4 (26.4 MB)
• 3. Using If Function In Excel.mp4 (54.4 MB)
• 4. Nesting or Multiple Functions In Excel.mp4 (65.9 MB)
• 5. Using And Function With If Function Together.mp4 (49.2 MB)
• 6. Using CountIf Function In Excel.mp4 (23.1 MB)
• 7. Using SumIf Function In Excel.mp4 (60.6 MB)
• 8. Using IfError Function In Excel.mp4 (19.5 MB)
• 9. Excel Conditional function Quiz.html (0.2 KB)
6. Working With Lookup Function In Excel
• 1. Using Vlookup Function In Excel.mp4 (48.1 MB)
• 2. Using Hlookup Function In Excel.mp4 (49.7 MB)
• 3. Using Index Function In Excel.mp4 (52.8 MB)
• 4. Using Match Function In Excel.mp4 (31.8 MB)
• 5. Using Hlookup+Match Function In Excel.mp4 (56.6 MB)
• 6. Excel Lookup Function Quiz.html (0.2 KB)
7. Working With Excel Text Based Functions
• 1. Using Left, Right & Mid Function In Excel.mp4 (72.0 MB)
• 2. Using Len Function In Excel.mp4 (19.1 MB)
• 3. Using Concatenate Function In Excel.mp4 (23.9 MB)
• 4. Excel Text Based Quiz.html (0.2 KB)
8. Working With Formula Auditing In Excel Worksheet
• 1. Using Trace Precedent In Excel.mp4 (32.7 MB)
• 2. Using Trace Dependents Function In Excel.mp4 (26.4 MB)
• 3. Using Show Formula Function In Excel.mp4 (21.5 MB)
• 4. Using Watch Window Function In Excel.mp4 (43.7 MB)
• 5. Excel Formula Auditing Quiz.html (0.2 KB)
9. Protecting Excel Worksheets And Workbooks
• 1. Protecting Complete Or Specific Cell In A Worksheet.mp4 (50.4 MB)
• 2. Protecting The Structure Of A Workbook In Excel.mp4 (21.7 MB)
• 3. Protecting Workbook With Password In Excel.mp4 (30.8 MB)
• 4. Excel Protection Quiz.html (0.2 KB)
• Bonus Resources.txt (0.4 KB)