[ FreeCourseWeb.com ] Udemy - Microsoft Excel - From zero to hero

File Name

Size

Get Bonus Downloads Here.url

183 B

~Get Your Files Here !/1. Introduction/1. Quick access toolbar.mp4

5.6 MB

~Get Your Files Here !/1. Introduction/1. Quick access toolbar.srt

855 B

~Get Your Files Here !/1. Introduction/10. Status Bar.mp4

2.4 MB

~Get Your Files Here !/1. Introduction/10. Status Bar.srt

497 B

~Get Your Files Here !/1. Introduction/11. Page Views.mp4

3.4 MB

~Get Your Files Here !/1. Introduction/11. Page Views.srt

730 B

~Get Your Files Here !/1. Introduction/12. Zoom.mp4

3.3 MB

~Get Your Files Here !/1. Introduction/12. Zoom.srt

461 B

~Get Your Files Here !/1. Introduction/2. Menu Tabs.mp4

1.8 MB

~Get Your Files Here !/1. Introduction/2. Menu Tabs.srt

318 B

~Get Your Files Here !/1. Introduction/3. Groups.mp4

2.6 MB

~Get Your Files Here !/1. Introduction/3. Groups.srt

577 B

~Get Your Files Here !/1. Introduction/4. Ribbon Display Options.mp4

3.7 MB

~Get Your Files Here !/1. Introduction/4. Ribbon Display Options.srt

720 B

~Get Your Files Here !/1. Introduction/5. Formula Bar.mp4

2.9 MB

~Get Your Files Here !/1. Introduction/5. Formula Bar.srt

487 B

~Get Your Files Here !/1. Introduction/6. Name Box.mp4

5.1 MB

~Get Your Files Here !/1. Introduction/6. Name Box.srt

886 B

~Get Your Files Here !/1. Introduction/7. Select All.mp4

2.5 MB

~Get Your Files Here !/1. Introduction/7. Select All.srt

475 B

~Get Your Files Here !/1. Introduction/8. Scroll Bars.mp4

2.0 MB

~Get Your Files Here !/1. Introduction/8. Scroll Bars.srt

331 B

~Get Your Files Here !/1. Introduction/9. Sheet Tabs and Control Buttons.mp4

2.4 MB

~Get Your Files Here !/1. Introduction/9. Sheet Tabs and Control Buttons.srt

528 B

~Get Your Files Here !/10. Formatting of Cells/1. Wrap Text.mp4

1.9 MB

~Get Your Files Here !/10. Formatting of Cells/1. Wrap Text.srt

316 B

~Get Your Files Here !/10. Formatting of Cells/10. Format Overview.mp4

4.4 MB

~Get Your Files Here !/10. Formatting of Cells/10. Format Overview.srt

823 B

~Get Your Files Here !/10. Formatting of Cells/11. Autosum, Custom Format Values.mp4

1.7 MB

~Get Your Files Here !/10. Formatting of Cells/11. Autosum, Custom Format Values.srt

213 B

~Get Your Files Here !/10. Formatting of Cells/12. Format Painter.mp4

3.8 MB

~Get Your Files Here !/10. Formatting of Cells/12. Format Painter.srt

753 B

~Get Your Files Here !/10. Formatting of Cells/12.1 Format painter.xlsx

20 kB

~Get Your Files Here !/10. Formatting of Cells/2. Format Cells Currency.mp4

4.4 MB

~Get Your Files Here !/10. Formatting of Cells/2. Format Cells Currency.srt

726 B

~Get Your Files Here !/10. Formatting of Cells/2.1 Format cells currency.xlsx

23 kB

~Get Your Files Here !/10. Formatting of Cells/3. Merge and Centre.mp4

2.8 MB

~Get Your Files Here !/10. Formatting of Cells/3. Merge and Centre.srt

417 B

~Get Your Files Here !/10. Formatting of Cells/3.1 Merge and center.xlsx

156 kB

~Get Your Files Here !/10. Formatting of Cells/4. Format Cells Font.mp4

6.6 MB

~Get Your Files Here !/10. Formatting of Cells/4. Format Cells Font.srt

1.0 kB

~Get Your Files Here !/10. Formatting of Cells/4.1 Format cells font.xlsx

156 kB

~Get Your Files Here !/10. Formatting of Cells/5. Format Cells Time.mp4

3.3 MB

~Get Your Files Here !/10. Formatting of Cells/5. Format Cells Time.srt

551 B

~Get Your Files Here !/10. Formatting of Cells/6. Format Cells Text.mp4

4.7 MB

~Get Your Files Here !/10. Formatting of Cells/6. Format Cells Text.srt

1.1 kB

~Get Your Files Here !/10. Formatting of Cells/7. Format Borders and Fill.mp4

3.7 MB

~Get Your Files Here !/10. Formatting of Cells/7. Format Borders and Fill.srt

565 B

~Get Your Files Here !/10. Formatting of Cells/8. Format Cells Accounting.mp4

3.8 MB

~Get Your Files Here !/10. Formatting of Cells/8. Format Cells Accounting.srt

592 B

~Get Your Files Here !/10. Formatting of Cells/9. Custom Format.mp4

7.0 MB

~Get Your Files Here !/10. Formatting of Cells/9. Custom Format.srt

1.2 kB

~Get Your Files Here !/10. Formatting of Cells/9.1 Custom format example 1.xlsx

22 kB

~Get Your Files Here !/10. Formatting of Cells/9.2 Custom format example 2.xlsx

18 kB

~Get Your Files Here !/11. Basic Calculations/1. Adding Non Consecutive Cells.mp4

4.6 MB

~Get Your Files Here !/11. Basic Calculations/1. Adding Non Consecutive Cells.srt

815 B

~Get Your Files Here !/11. Basic Calculations/2. Addition Method 1.mp4

3.0 MB

~Get Your Files Here !/11. Basic Calculations/2. Addition Method 1.srt

559 B

~Get Your Files Here !/11. Basic Calculations/3. Addition Method 2.mp4

3.2 MB

~Get Your Files Here !/11. Basic Calculations/3. Addition Method 2.srt

551 B

~Get Your Files Here !/11. Basic Calculations/4. Addition Method 3.mp4

3.6 MB

~Get Your Files Here !/11. Basic Calculations/4. Addition Method 3.srt

695 B

~Get Your Files Here !/11. Basic Calculations/5. Division.mp4

2.4 MB

~Get Your Files Here !/11. Basic Calculations/5. Division.srt

626 B

~Get Your Files Here !/11. Basic Calculations/6. Multiplication.mp4

2.4 MB

~Get Your Files Here !/11. Basic Calculations/6. Multiplication.srt

648 B

~Get Your Files Here !/11. Basic Calculations/7. Subtraction.mp4

1.5 MB

~Get Your Files Here !/11. Basic Calculations/7. Subtraction.srt

288 B

~Get Your Files Here !/11. Basic Calculations/7.1 Operators.xlsx

23 kB

~Get Your Files Here !/12. Working With Functions/1. Average.mp4

5.5 MB

~Get Your Files Here !/12. Working With Functions/1. Average.srt

649 B

~Get Your Files Here !/12. Working With Functions/2. Max.mp4

6.0 MB

~Get Your Files Here !/12. Working With Functions/2. Max.srt

616 B

~Get Your Files Here !/12. Working With Functions/3. Min.mp4

5.8 MB

~Get Your Files Here !/12. Working With Functions/3. Min.srt

697 B

~Get Your Files Here !/12. Working With Functions/3.1 Min Max Ave function.xlsx

13 kB

~Get Your Files Here !/13. Sorting/1. Sorting 1.mp4

4.3 MB

~Get Your Files Here !/13. Sorting/1. Sorting 1.srt

617 B

~Get Your Files Here !/13. Sorting/2. Sorting 2.mp4

4.0 MB

~Get Your Files Here !/13. Sorting/2. Sorting 2.srt

598 B

~Get Your Files Here !/13. Sorting/3. Sorting 3.mp4

3.3 MB

~Get Your Files Here !/13. Sorting/3. Sorting 3.srt

484 B

~Get Your Files Here !/13. Sorting/4. Sorting 4.mp4

4.7 MB

~Get Your Files Here !/13. Sorting/4. Sorting 4.srt

622 B

~Get Your Files Here !/13. Sorting/5. Sorting 5.mp4

3.1 MB

~Get Your Files Here !/13. Sorting/5. Sorting 5.srt

431 B

~Get Your Files Here !/13. Sorting/5.1 Sorting of Data.xlsx

19 kB

~Get Your Files Here !/14. Paste Special/1. Value.mp4

3.5 MB

~Get Your Files Here !/14. Paste Special/1. Value.srt

579 B

~Get Your Files Here !/14. Paste Special/2. Comment.mp4

3.1 MB

~Get Your Files Here !/14. Paste Special/2. Comment.srt

422 B

~Get Your Files Here !/14. Paste Special/3. Paste Link.mp4

3.7 MB

~Get Your Files Here !/14. Paste Special/3. Paste Link.srt

662 B

~Get Your Files Here !/14. Paste Special/4. Multiply.mp4

2.5 MB

~Get Your Files Here !/14. Paste Special/4. Multiply.srt

307 B

~Get Your Files Here !/14. Paste Special/5. Transpose.mp4

2.6 MB

~Get Your Files Here !/14. Paste Special/5. Transpose.srt

487 B

~Get Your Files Here !/14. Paste Special/5.1 Paste Special.xlsx

662 kB

~Get Your Files Here !/15. Cell References/1. Absolute Reference.mp4

12 MB

~Get Your Files Here !/15. Cell References/1. Absolute Reference.srt

1.8 kB

~Get Your Files Here !/15. Cell References/2. Relative Reference.mp4

6.2 MB

~Get Your Files Here !/15. Cell References/2. Relative Reference.srt

981 B

~Get Your Files Here !/15. Cell References/2.1 Relative and Absolute References.xlsx

21 kB

~Get Your Files Here !/16. Count/1. Scenario.mp4

4.1 MB

~Get Your Files Here !/16. Count/1. Scenario.srt

576 B

~Get Your Files Here !/16. Count/2. Count.mp4

4.9 MB

~Get Your Files Here !/16. Count/2. Count.srt

601 B

~Get Your Files Here !/16. Count/3. CountA.mp4

5.1 MB

~Get Your Files Here !/16. Count/3. CountA.srt

635 B

~Get Your Files Here !/16. Count/4. CountBlank.mp4

7.0 MB

~Get Your Files Here !/16. Count/4. CountBlank.srt

995 B

~Get Your Files Here !/16. Count/5. CountIF.mp4

7.1 MB

~Get Your Files Here !/16. Count/5. CountIF.srt

1.0 kB

~Get Your Files Here !/16. Count/5.1 Count.xlsx

15 kB

~Get Your Files Here !/17. Logical Functions/1. IF Example 1.mp4

8.8 MB

~Get Your Files Here !/17. Logical Functions/1. IF Example 1.srt

1.0 kB

~Get Your Files Here !/17. Logical Functions/1.1 IF Example 1.xlsx

16 kB

~Get Your Files Here !/17. Logical Functions/2. IF Example 2.mp4

7.9 MB

~Get Your Files Here !/17. Logical Functions/2. IF Example 2.srt

1010 B

~Get Your Files Here !/17. Logical Functions/2.1 IF Example 2.xlsx

15 kB

~Get Your Files Here !/17. Logical Functions/3. SumIF.mp4

6.2 MB

~Get Your Files Here !/17. Logical Functions/3. SumIF.srt

793 B

~Get Your Files Here !/17. Logical Functions/3.1 Sumif.xlsx

19 kB

~Get Your Files Here !/18. Financial/1. Setting The Scenario.mp4

2.3 MB

~Get Your Files Here !/18. Financial/1. Setting The Scenario.srt

360 B

~Get Your Files Here !/18. Financial/2. Payment.mp4

11 MB

~Get Your Files Here !/18. Financial/2. Payment.srt

1.6 kB

~Get Your Files Here !/18. Financial/2.1 Payment.xlsx

13 kB

~Get Your Files Here !/19. What-If Analysis (Goal Seek)/1. Goal Seek Example 1.mp4

2.4 MB

~Get Your Files Here !/19. What-If Analysis (Goal Seek)/1. Goal Seek Example 1.srt

1.2 kB

~Get Your Files Here !/19. What-If Analysis (Goal Seek)/2. Goal Seek Example 2.mp4

8.4 MB

~Get Your Files Here !/19. What-If Analysis (Goal Seek)/2. Goal Seek Example 2.srt

1.4 kB

~Get Your Files Here !/19. What-If Analysis (Goal Seek)/2.1 Goal seek.xlsx

18 kB

~Get Your Files Here !/2. Excel Options/1. Number Of Sheets.mp4

4.9 MB

~Get Your Files Here !/2. Excel Options/1. Number Of Sheets.srt

748 B

~Get Your Files Here !/2. Excel Options/2. R1C1 Reference Style.mp4

4.9 MB

~Get Your Files Here !/2. Excel Options/2. R1C1 Reference Style.srt

957 B

~Get Your Files Here !/2. Excel Options/3. After Pressing Enter, Move Selection.mp4

3.5 MB

~Get Your Files Here !/2. Excel Options/3. After Pressing Enter, Move Selection.srt

514 B

~Get Your Files Here !/2. Excel Options/4. Formula Bar, Sheet Tabs, Row And Column Headers.mp4

5.6 MB

~Get Your Files Here !/2. Excel Options/4. Formula Bar, Sheet Tabs, Row And Column Headers.srt

802 B

~Get Your Files Here !/2. Excel Options/5. Dealing With Zero Values.mp4

4.2 MB

~Get Your Files Here !/2. Excel Options/5. Dealing With Zero Values.srt

619 B

~Get Your Files Here !/20. What-If Analysis (Data Tables)/1. One data Table.mp4

7.4 MB

~Get Your Files Here !/20. What-If Analysis (Data Tables)/1. One data Table.srt

1.2 kB

~Get Your Files Here !/20. What-If Analysis (Data Tables)/1.1 One data table.xlsx

12 kB

~Get Your Files Here !/20. What-If Analysis (Data Tables)/2. Two Data Table.mp4

5.5 MB

~Get Your Files Here !/20. What-If Analysis (Data Tables)/2. Two Data Table.srt

878 B

~Get Your Files Here !/20. What-If Analysis (Data Tables)/2.1 Two data table.xlsx

18 kB

~Get Your Files Here !/21. Validation/1. Validation of Numbers.mp4

9.0 MB

~Get Your Files Here !/21. Validation/1. Validation of Numbers.srt

1.4 kB

~Get Your Files Here !/21. Validation/2. Validation on Time.mp4

5.8 MB

~Get Your Files Here !/21. Validation/2. Validation on Time.srt

866 B

~Get Your Files Here !/21. Validation/3. Validation List.mp4

8.9 MB

~Get Your Files Here !/21. Validation/3. Validation List.srt

1.1 kB

~Get Your Files Here !/21. Validation/4. Input Message.mp4

4.5 MB

~Get Your Files Here !/21. Validation/4. Input Message.srt

710 B

~Get Your Files Here !/21. Validation/5. Stop Alert.mp4

6.4 MB

~Get Your Files Here !/21. Validation/5. Stop Alert.srt

1.1 kB

~Get Your Files Here !/21. Validation/6. Warning Error Alert.mp4

5.3 MB

~Get Your Files Here !/21. Validation/6. Warning Error Alert.srt

932 B

~Get Your Files Here !/21. Validation/7. Removing a Validation.mp4

2.5 MB

~Get Your Files Here !/21. Validation/7. Removing a Validation.srt

432 B

~Get Your Files Here !/21. Validation/7.1 Validation.xlsx

24 kB

~Get Your Files Here !/22. Filter/1. Applying The Filter.mp4

11 MB

~Get Your Files Here !/22. Filter/1. Applying The Filter.srt

1.4 kB

~Get Your Files Here !/22. Filter/2. Customize Filter.mp4

7.3 MB

~Get Your Files Here !/22. Filter/2. Customize Filter.srt

882 B

~Get Your Files Here !/22. Filter/3. Removing Blank Rows.mp4

4.5 MB

~Get Your Files Here !/22. Filter/3. Removing Blank Rows.srt

658 B

~Get Your Files Here !/22. Filter/4. Removing The Filter.mp4

1.7 MB

~Get Your Files Here !/22. Filter/4. Removing The Filter.srt

198 B

~Get Your Files Here !/22. Filter/4.1 Autofilter.xlsx

20 kB

~Get Your Files Here !/23. Conditional Format/1. Conditional Format Example 1.mp4

13 MB

~Get Your Files Here !/23. Conditional Format/1. Conditional Format Example 1.srt

1.6 kB

~Get Your Files Here !/23. Conditional Format/2. Conditional Format Example 2.mp4

8.6 MB

~Get Your Files Here !/23. Conditional Format/2. Conditional Format Example 2.srt

1.2 kB

~Get Your Files Here !/23. Conditional Format/3. Conditional Format Example 3.mp4

14 MB

~Get Your Files Here !/23. Conditional Format/3. Conditional Format Example 3.srt

2.0 kB

~Get Your Files Here !/23. Conditional Format/3.1 Conditional format.xlsx

25 kB

~Get Your Files Here !/24. Charts/1. Chart Scenario.mp4

2.4 MB

~Get Your Files Here !/24. Charts/1. Chart Scenario.srt

393 B

~Get Your Files Here !/24. Charts/2. Creating a Chart.mp4

14 MB

~Get Your Files Here !/24. Charts/2. Creating a Chart.srt

2.0 kB

~Get Your Files Here !/24. Charts/3. Chart Styles.mp4

3.8 MB

~Get Your Files Here !/24. Charts/3. Chart Styles.srt

574 B

~Get Your Files Here !/24. Charts/4. Adding a Data Series.mp4

5.0 MB

~Get Your Files Here !/24. Charts/4. Adding a Data Series.srt

733 B

~Get Your Files Here !/24. Charts/5. Adding Labels To a Chart.mp4

6.3 MB

~Get Your Files Here !/24. Charts/5. Adding Labels To a Chart.srt

1.1 kB

~Get Your Files Here !/24. Charts/6. Apply a Filter To a Chart.mp4

3.3 MB

~Get Your Files Here !/24. Charts/6. Apply a Filter To a Chart.srt

395 B

~Get Your Files Here !/24. Charts/7. Scale The Axis.mp4

4.9 MB

~Get Your Files Here !/24. Charts/7. Scale The Axis.srt

757 B

~Get Your Files Here !/24. Charts/8. Axis Reverse Order.mp4

3.8 MB

~Get Your Files Here !/24. Charts/8. Axis Reverse Order.srt

640 B

~Get Your Files Here !/24. Charts/8.1 Charts.xlsx

17 kB

~Get Your Files Here !/25. Headers and Footers/1. Headers And Footers.mp4

2.2 MB

~Get Your Files Here !/25. Headers and Footers/1. Headers And Footers.srt

1.0 kB

~Get Your Files Here !/25. Headers and Footers/1.1 Headers Footers.xlsx

12 kB

~Get Your Files Here !/26. Subtotals/1. Applying Subtotal To a List.mp4

10 MB

~Get Your Files Here !/26. Subtotals/1. Applying Subtotal To a List.srt

1.2 kB

~Get Your Files Here !/26. Subtotals/2. Adding a Subtotal.mp4

9.3 MB

~Get Your Files Here !/26. Subtotals/2. Adding a Subtotal.srt

1.0 kB

~Get Your Files Here !/26. Subtotals/3. Removing Subtotal.mp4

2.1 MB

~Get Your Files Here !/26. Subtotals/3. Removing Subtotal.srt

202 B

~Get Your Files Here !/26. Subtotals/3.1 Subtotals.xlsx

22 kB

~Get Your Files Here !/27. Links/1. Linking Cells.mp4

6.0 MB

~Get Your Files Here !/27. Links/1. Linking Cells.srt

954 B

~Get Your Files Here !/27. Links/2. Linking Sheets Tabs.mp4

7.9 MB

~Get Your Files Here !/27. Links/2. Linking Sheets Tabs.srt

1.0 kB

~Get Your Files Here !/27. Links/3. Linking Workbooks.mp4

12 MB

~Get Your Files Here !/27. Links/3. Linking Workbooks.srt

1.4 kB

~Get Your Files Here !/27. Links/4. Array Links.mp4

6.4 MB

~Get Your Files Here !/27. Links/4. Array Links.srt

980 B

~Get Your Files Here !/27. Links/5. Paste Link.mp4

5.2 MB

~Get Your Files Here !/27. Links/5. Paste Link.srt

613 B

~Get Your Files Here !/27. Links/5.1 Linking.xlsx

34 kB

~Get Your Files Here !/27. Links/5.2 Main database .xlsx

13 kB

~Get Your Files Here !/28. Printing/1. Gridlines And Column Headers.mp4

6.5 MB

~Get Your Files Here !/28. Printing/1. Gridlines And Column Headers.srt

948 B

~Get Your Files Here !/28. Printing/2. Page Breaks.mp4

6.6 MB

~Get Your Files Here !/28. Printing/2. Page Breaks.srt

950 B

~Get Your Files Here !/28. Printing/3. Page Setup - Headers And Footers.mp4

12 MB

~Get Your Files Here !/28. Printing/3. Page Setup - Headers And Footers.srt

1.6 kB

~Get Your Files Here !/28. Printing/4. Page Setup - Margins.mp4

7.4 MB

~Get Your Files Here !/28. Printing/4. Page Setup - Margins.srt

1.0 kB

~Get Your Files Here !/28. Printing/5. Page Setup - Page.mp4

9.8 MB

~Get Your Files Here !/28. Printing/5. Page Setup - Page.srt

1.2 kB

~Get Your Files Here !/28. Printing/6. Page Setup - Print Area.mp4

6.1 MB

~Get Your Files Here !/28. Printing/6. Page Setup - Print Area.srt

829 B

~Get Your Files Here !/28. Printing/7. Page Setup - Rows To Repeat.mp4

5.8 MB

~Get Your Files Here !/28. Printing/7. Page Setup - Rows To Repeat.srt

873 B

~Get Your Files Here !/28. Printing/8. Print Only The Active Sheets.mp4

4.2 MB

~Get Your Files Here !/28. Printing/8. Print Only The Active Sheets.srt

519 B

~Get Your Files Here !/28. Printing/9. Printing Overview.mp4

5.7 MB

~Get Your Files Here !/28. Printing/9. Printing Overview.srt

826 B

~Get Your Files Here !/28. Printing/9.1 Database.xlsx

37 kB

~Get Your Files Here !/29. Protection/1. Protection Scenario.mp4

3.3 MB

~Get Your Files Here !/29. Protection/1. Protection Scenario.srt

580 B

~Get Your Files Here !/29. Protection/2. Method.mp4

6.4 MB

~Get Your Files Here !/29. Protection/2. Method.srt

1.2 kB

~Get Your Files Here !/29. Protection/3. Setting up The Protection.mp4

9.0 MB

~Get Your Files Here !/29. Protection/3. Setting up The Protection.srt

1.2 kB

~Get Your Files Here !/29. Protection/4. Applying The Protection.mp4

13 MB

~Get Your Files Here !/29. Protection/4. Applying The Protection.srt

1.6 kB

~Get Your Files Here !/29. Protection/5. Testing The Protection.mp4

5.9 MB

~Get Your Files Here !/29. Protection/5. Testing The Protection.srt

788 B

~Get Your Files Here !/29. Protection/6. Protect Workbook.mp4

6.7 MB

~Get Your Files Here !/29. Protection/6. Protect Workbook.srt

860 B

~Get Your Files Here !/29. Protection/7. Saving File With Workbook.mp4

6.7 MB

~Get Your Files Here !/29. Protection/7. Saving File With Workbook.srt

1.1 kB

~Get Your Files Here !/29. Protection/8. Opening a File With a Password.mp4

4.3 MB

~Get Your Files Here !/29. Protection/8. Opening a File With a Password.srt

553 B

~Get Your Files Here !/29. Protection/8.1 Protection.xlsx

19 kB

~Get Your Files Here !/3. Mouse Pointer Shapes/1. Mouse Pointer Shapes.mp4

2.6 MB

~Get Your Files Here !/3. Mouse Pointer Shapes/1. Mouse Pointer Shapes.srt

1.5 kB

~Get Your Files Here !/3. Mouse Pointer Shapes/1.1 Mouse pointer shapes.xlsx

11 kB

~Get Your Files Here !/30. Freeze Panes/1. Freeze Panes Example 1.mp4

7.0 MB

~Get Your Files Here !/30. Freeze Panes/1. Freeze Panes Example 1.srt

847 B

~Get Your Files Here !/30. Freeze Panes/2. Freeze Panes Example 2.mp4

5.7 MB

~Get Your Files Here !/30. Freeze Panes/2. Freeze Panes Example 2.srt

597 B

~Get Your Files Here !/30. Freeze Panes/2.1 Freeze panes.xlsx

22 kB

~Get Your Files Here !/31. Removing Duplicates/1. Removing Duplicate Values.mp4

8.8 MB

~Get Your Files Here !/31. Removing Duplicates/1. Removing Duplicate Values.srt

1.1 kB

~Get Your Files Here !/31. Removing Duplicates/1.1 Remove Duplicate Values.xlsx

22 kB

~Get Your Files Here !/32. Match/1. Match Scenario.mp4

2.9 MB

~Get Your Files Here !/32. Match/1. Match Scenario.srt

453 B

~Get Your Files Here !/32. Match/2. Match.mp4

11 MB

~Get Your Files Here !/32. Match/2. Match.srt

1.4 kB

~Get Your Files Here !/32. Match/2.1 Match function.xlsx

56 kB

~Get Your Files Here !/33. Logical Functions/1. And.mp4

6.6 MB

~Get Your Files Here !/33. Logical Functions/1. And.srt

947 B

~Get Your Files Here !/33. Logical Functions/2. IF_And.mp4

6.1 MB

~Get Your Files Here !/33. Logical Functions/2. IF_And.srt

1.0 kB

~Get Your Files Here !/33. Logical Functions/2.1 AND.xlsx

13 kB

~Get Your Files Here !/33. Logical Functions/3. Nested IF Scenario.mp4

3.3 MB

~Get Your Files Here !/33. Logical Functions/3. Nested IF Scenario.srt

546 B

~Get Your Files Here !/33. Logical Functions/4. Nested IF.mp4

9.0 MB

~Get Your Files Here !/33. Logical Functions/4. Nested IF.srt

1.0 kB

~Get Your Files Here !/33. Logical Functions/4.1 Nested IF.xlsx

16 kB

~Get Your Files Here !/34. Count/1. CountIFS Example 1.mp4

6.7 MB

~Get Your Files Here !/34. Count/1. CountIFS Example 1.srt

1.1 kB

~Get Your Files Here !/34. Count/2. CountIFS Scenario 1.mp4

2.6 MB

~Get Your Files Here !/34. Count/2. CountIFS Scenario 1.srt

338 B

~Get Your Files Here !/34. Count/3. CountIFS Scenario 2.mp4

11 MB

~Get Your Files Here !/34. Count/3. CountIFS Scenario 2.srt

1.1 kB

~Get Your Files Here !/34. Count/3.1 CountIFS.xlsx

18 kB

~Get Your Files Here !/35. Lookups/1. Vlookup Scenario 1.mp4

2.6 MB

~Get Your Files Here !/35. Lookups/1. Vlookup Scenario 1.srt

444 B

~Get Your Files Here !/35. Lookups/2. Vlookup Scenario 2.mp4

12 MB

~Get Your Files Here !/35. Lookups/2. Vlookup Scenario 2.srt

1.8 kB

~Get Your Files Here !/35. Lookups/3. Vlookup Scenario 3.mp4

6.1 MB

~Get Your Files Here !/35. Lookups/3. Vlookup Scenario 3.srt

766 B

~Get Your Files Here !/35. Lookups/4. Hlookup Scenario 1.mp4

2.7 MB

~Get Your Files Here !/35. Lookups/4. Hlookup Scenario 1.srt

427 B

~Get Your Files Here !/35. Lookups/5. Hlookup Scenario 2.mp4

8.3 MB

~Get Your Files Here !/35. Lookups/5. Hlookup Scenario 2.srt

1.1 kB

~Get Your Files Here !/35. Lookups/5.1 Lookups.xlsx

15 kB

~Get Your Files Here !/36. Tables/1. Applying The Table.mp4

7.3 MB

~Get Your Files Here !/36. Tables/1. Applying The Table.srt

1.1 kB

~Get Your Files Here !/36. Tables/2. Total Row.mp4

3.5 MB

~Get Your Files Here !/36. Tables/2. Total Row.srt

534 B

~Get Your Files Here !/36. Tables/3. Quick Analysis Formatting.mp4

6.0 MB

~Get Your Files Here !/36. Tables/3. Quick Analysis Formatting.srt

852 B

~Get Your Files Here !/36. Tables/4. Quick Analysis Pivot Chart.mp4

6.3 MB

~Get Your Files Here !/36. Tables/4. Quick Analysis Pivot Chart.srt

1002 B

~Get Your Files Here !/36. Tables/4.1 Table.xlsx

14 kB

~Get Your Files Here !/37. Slicers/1. What is a Slicer.mp4

2.9 MB

~Get Your Files Here !/37. Slicers/1. What is a Slicer.srt

354 B

~Get Your Files Here !/37. Slicers/2. Applying the Slicer.mp4

9.0 MB

~Get Your Files Here !/37. Slicers/2. Applying the Slicer.srt

982 B

~Get Your Files Here !/37. Slicers/3. Slicer Setup.mp4

7.8 MB

~Get Your Files Here !/37. Slicers/3. Slicer Setup.srt

881 B

~Get Your Files Here !/37. Slicers/3.1 Slicer.xlsx

20 kB

~Get Your Files Here !/38. Sparklines/1. Sparklines.mp4

2.9 MB

~Get Your Files Here !/38. Sparklines/1. Sparklines.srt

1.2 kB

~Get Your Files Here !/38. Sparklines/1.1 Sparklines.xlsx

658 kB

~Get Your Files Here !/39. SheetVeryHidden/1. Very Hidden.mp4

7.8 MB

~Get Your Files Here !/39. SheetVeryHidden/1. Very Hidden.srt

1.2 kB

~Get Your Files Here !/39. SheetVeryHidden/1.1 Very hidden.xlsx

24 kB

~Get Your Files Here !/4. Mouse Selection Techniques/1. Mouse Selection Technique 1.mp4

6.7 MB

~Get Your Files Here !/4. Mouse Selection Techniques/1. Mouse Selection Technique 1.srt

774 B

~Get Your Files Here !/4. Mouse Selection Techniques/2. Mouse Selection Technique 2.mp4

6.6 MB

~Get Your Files Here !/4. Mouse Selection Techniques/2. Mouse Selection Technique 2.srt

714 B

~Get Your Files Here !/40. Pivot tables/1. Pivot Table Definition.mp4

4.5 MB

~Get Your Files Here !/40. Pivot tables/1. Pivot Table Definition.srt

807 B

~Get Your Files Here !/40. Pivot tables/2. Ways to create a Pivot Table.mp4

4.2 MB

~Get Your Files Here !/40. Pivot tables/2. Ways to create a Pivot Table.srt

482 B

~Get Your Files Here !/40. Pivot tables/3. Creating a Pivot Table.mp4

14 MB

~Get Your Files Here !/40. Pivot tables/3. Creating a Pivot Table.srt

1.9 kB

~Get Your Files Here !/40. Pivot tables/4. Calculation Features.mp4

10 MB

~Get Your Files Here !/40. Pivot tables/4. Calculation Features.srt

1.4 kB

~Get Your Files Here !/40. Pivot tables/5. Adding a chart to a Pivot Table.mp4

9.6 MB

~Get Your Files Here !/40. Pivot tables/5. Adding a chart to a Pivot Table.srt

1.3 kB

~Get Your Files Here !/40. Pivot tables/6. Display the Pivot Field List.mp4

1.5 MB

~Get Your Files Here !/40. Pivot tables/6. Display the Pivot Field List.srt

224 B

~Get Your Files Here !/40. Pivot tables/7. Defer Layout Update.mp4

3.9 MB

~Get Your Files Here !/40. Pivot tables/7. Defer Layout Update.srt

567 B

~Get Your Files Here !/40. Pivot tables/7.1 Pivot Table.xlsx

22 kB

~Get Your Files Here !/41. Macro's/1. What Is a Macro.mp4

4.8 MB

~Get Your Files Here !/41. Macro's/1. What Is a Macro.srt

825 B

~Get Your Files Here !/41. Macro's/2. Macro Setup.mp4

5.2 MB

~Get Your Files Here !/41. Macro's/2. Macro Setup.srt

706 B

~Get Your Files Here !/41. Macro's/3. Record a Macro.mp4

10 MB

~Get Your Files Here !/41. Macro's/3. Record a Macro.srt

1.6 kB

~Get Your Files Here !/41. Macro's/4. Macro Shortcut Key.mp4

3.0 MB

~Get Your Files Here !/41. Macro's/4. Macro Shortcut Key.srt

466 B

~Get Your Files Here !/41. Macro's/5. Running The Macro.mp4

3.7 MB

~Get Your Files Here !/41. Macro's/5. Running The Macro.srt

659 B

~Get Your Files Here !/41. Macro's/6. Saving a Macro.mp4

4.7 MB

~Get Your Files Here !/41. Macro's/6. Saving a Macro.srt

656 B

~Get Your Files Here !/41. Macro's/7. Edit The Macro With Visual Basic.mp4

8.3 MB

~Get Your Files Here !/41. Macro's/7. Edit The Macro With Visual Basic.srt

1.2 kB

~Get Your Files Here !/41. Macro's/7.1 Pivot Table.xlsx

22 kB

~Get Your Files Here !/42. Switch between Excel spreadsheets only/1. Control And Tab.mp4

5.9 MB

~Get Your Files Here !/42. Switch between Excel spreadsheets only/1. Control And Tab.srt

893 B

~Get Your Files Here !/43. Use Ctrl + Enter to fill an entire range/1. Control And Enter.mp4

6.1 MB

~Get Your Files Here !/43. Use Ctrl + Enter to fill an entire range/1. Control And Enter.srt

965 B

~Get Your Files Here !/43. Use Ctrl + Enter to fill an entire range/1.1 Tip 2 Working File Control and Enter.xlsx

682 kB

~Get Your Files Here !/44. Copy formula on clipboard to be used later/1. Clipboard Example 1.mp4

7.5 MB

~Get Your Files Here !/44. Copy formula on clipboard to be used later/1. Clipboard Example 1.srt

1.2 kB

~Get Your Files Here !/44. Copy formula on clipboard to be used later/2. Clipboard Example 2.mp4

5.9 MB

~Get Your Files Here !/44. Copy formula on clipboard to be used later/2. Clipboard Example 2.srt

845 B

~Get Your Files Here !/44. Copy formula on clipboard to be used later/2.1 Clipboard.xlsx

43 kB

~Get Your Files Here !/45. Finding and removing blanks/1. Finding And Removing Blanks.mp4

4.6 MB

~Get Your Files Here !/45. Finding and removing blanks/1. Finding And Removing Blanks.srt

698 B

~Get Your Files Here !/45. Finding and removing blanks/1.1 Blanks.xlsx

19 kB

~Get Your Files Here !/46. Snap objects to cell borders/1. Snap Objects To Cell Borders.mp4

6.6 MB

~Get Your Files Here !/46. Snap objects to cell borders/1. Snap Objects To Cell Borders.srt

1.4 kB

~Get Your Files Here !/46. Snap objects to cell borders/1.1 Alignment of Objects.xlsx

13 kB

~Get Your Files Here !/47. Sort according to a custom list/1. Sort Using a Custom List Criteria Example 1.mp4

4.4 MB

~Get Your Files Here !/47. Sort according to a custom list/1. Sort Using a Custom List Criteria Example 1.srt

716 B

~Get Your Files Here !/47. Sort according to a custom list/2. Sort Using a Custom List Criteria Example 2.mp4

5.4 MB

~Get Your Files Here !/47. Sort according to a custom list/2. Sort Using a Custom List Criteria Example 2.srt

750 B

~Get Your Files Here !/47. Sort according to a custom list/2.1 Sorting according to a custom list.xlsx

35 kB

~Get Your Files Here !/48. Enter bullets in Excel/1. Bullets.mp4

5.1 MB

~Get Your Files Here !/48. Enter bullets in Excel/1. Bullets.srt

1003 B

~Get Your Files Here !/48. Enter bullets in Excel/1.1 Bullets.xlsx

12 kB

~Get Your Files Here !/49. Autofill growth trend/1. Growth Trend.mp4

4.7 MB

~Get Your Files Here !/49. Autofill growth trend/1. Growth Trend.srt

1019 B

~Get Your Files Here !/49. Autofill growth trend/1.1 Growth trend.xlsx

10 kB

~Get Your Files Here !/5. Entering and Editing of Data/1. Entering Data In a Cell.mp4

4.3 MB

~Get Your Files Here !/5. Entering and Editing of Data/1. Entering Data In a Cell.srt

888 B

~Get Your Files Here !/5. Entering and Editing of Data/2. Edit Using The Formula Bar.mp4

1.4 MB

~Get Your Files Here !/5. Entering and Editing of Data/2. Edit Using The Formula Bar.srt

323 B

~Get Your Files Here !/5. Entering and Editing of Data/3. Edit Cell Content Directly In a Cell.mp4

3.9 MB

~Get Your Files Here !/5. Entering and Editing of Data/3. Edit Cell Content Directly In a Cell.srt

936 B

~Get Your Files Here !/5. Entering and Editing of Data/4. Inserting a Note in a Cell.mp4

3.9 MB

~Get Your Files Here !/5. Entering and Editing of Data/4. Inserting a Note in a Cell.srt

488 B

~Get Your Files Here !/5. Entering and Editing of Data/5. Inserting a Comment in a Cell.mp4

5.2 MB

~Get Your Files Here !/5. Entering and Editing of Data/5. Inserting a Comment in a Cell.srt

781 B

~Get Your Files Here !/5. Entering and Editing of Data/6. Delete Note and Comment.mp4

2.1 MB

~Get Your Files Here !/5. Entering and Editing of Data/6. Delete Note and Comment.srt

347 B

~Get Your Files Here !/5. Entering and Editing of Data/6.1 Notes and Comments.xlsx

157 kB

~Get Your Files Here !/50. Join the content of two or more cells/1. Joining Two or More Cells.mp4

4.6 MB

~Get Your Files Here !/50. Join the content of two or more cells/1. Joining Two or More Cells.srt

971 B

~Get Your Files Here !/50. Join the content of two or more cells/1.1 Joining cells.xlsx

11 kB

~Get Your Files Here !/51. IFERROR function/1. IFERROR Scenario.mp4

4.7 MB

~Get Your Files Here !/51. IFERROR function/1. IFERROR Scenario.srt

804 B

~Get Your Files Here !/51. IFERROR function/10. Flash Fill Example 1.mp4

4.6 MB

~Get Your Files Here !/51. IFERROR function/11. Flash Fill Example 2.mp4

3.5 MB

~Get Your Files Here !/51. IFERROR function/11.1 Flash Fill.xlsx

16 kB

~Get Your Files Here !/51. IFERROR function/12. Mode.mp4

5.9 MB

~Get Your Files Here !/51. IFERROR function/12.1 Mode.xlsx

12 kB

~Get Your Files Here !/51. IFERROR function/2. IFERROR.mp4

6.4 MB

~Get Your Files Here !/51. IFERROR function/2.1 IFERROR.xlsx

12 kB

~Get Your Files Here !/51. IFERROR function/3. Validation Scenario.mp4

1.8 MB

~Get Your Files Here !/51. IFERROR function/4. Conditional Validation.mp4

6.6 MB

~Get Your Files Here !/51. IFERROR function/4.1 Validation.xlsx

10 kB

~Get Your Files Here !/51. IFERROR function/5. Random Numbers.mp4

5.4 MB

~Get Your Files Here !/51. IFERROR function/5.1 Random numbers.xlsx

11 kB

~Get Your Files Here !/51. IFERROR function/6. Conditional Validation Scenario.mp4

2.5 MB

~Get Your Files Here !/51. IFERROR function/7. Step 1.mp4

3.7 MB

~Get Your Files Here !/51. IFERROR function/8. Step 2.mp4

4.3 MB

~Get Your Files Here !/51. IFERROR function/9. Step 3.mp4

5.4 MB

~Get Your Files Here !/51. IFERROR function/9.1 Conditional Validation.xlsx

14 kB

~Get Your Files Here !/6. Working With Sheets/1. Rename a Sheet.mp4

5.4 MB

~Get Your Files Here !/6. Working With Sheets/1. Rename a Sheet.srt

1.1 kB

~Get Your Files Here !/6. Working With Sheets/2. Hide and Unhide Sheets.mp4

4.5 MB

~Get Your Files Here !/6. Working With Sheets/2. Hide and Unhide Sheets.srt

826 B

~Get Your Files Here !/6. Working With Sheets/3. Deleting a Worksheet.mp4

1.1 MB

~Get Your Files Here !/6. Working With Sheets/3. Deleting a Worksheet.srt

410 B

~Get Your Files Here !/6. Working With Sheets/4. Selecting Different Sheets.mp4

6.0 MB

~Get Your Files Here !/6. Working With Sheets/4. Selecting Different Sheets.srt

982 B

~Get Your Files Here !/6. Working With Sheets/5. Copy a Sheet - Example 1.mp4

2.7 MB

~Get Your Files Here !/6. Working With Sheets/5. Copy a Sheet - Example 1.srt

413 B

~Get Your Files Here !/6. Working With Sheets/6. Copy a Sheet - Example 2.mp4

2.4 MB

~Get Your Files Here !/6. Working With Sheets/6. Copy a Sheet - Example 2.srt

527 B

~Get Your Files Here !/6. Working With Sheets/7. Copy a Sheet - Example 3.mp4

5.8 MB

~Get Your Files Here !/6. Working With Sheets/7. Copy a Sheet - Example 3.srt

843 B

~Get Your Files Here !/6. Working With Sheets/7.1 Master database.xlsx

10 kB

~Get Your Files Here !/6. Working With Sheets/7.2 Working with sheets.xlsx

24 kB

~Get Your Files Here !/7. Working with Rows and Columns/1. Hide and Un-hide Rows.mp4

1.4 MB

~Get Your Files Here !/7. Working with Rows and Columns/1. Hide and Un-hide Rows.srt

481 B

~Get Your Files Here !/7. Working with Rows and Columns/2. Hiding and Un-Hiding of Columns.mp4

3.9 MB

~Get Your Files Here !/7. Working with Rows and Columns/2. Hiding and Un-Hiding of Columns.srt

485 B

~Get Your Files Here !/7. Working with Rows and Columns/3. Insert and Delete Columns.mp4

5.6 MB

~Get Your Files Here !/7. Working with Rows and Columns/3. Insert and Delete Columns.srt

741 B

~Get Your Files Here !/7. Working with Rows and Columns/4. Inserting and Delete Rows.mp4

4.6 MB

~Get Your Files Here !/7. Working with Rows and Columns/4. Inserting and Delete Rows.srt

576 B

~Get Your Files Here !/7. Working with Rows and Columns/5. Resizing Columns.mp4

8.6 MB

~Get Your Files Here !/7. Working with Rows and Columns/5. Resizing Columns.srt

1.5 kB

~Get Your Files Here !/7. Working with Rows and Columns/6. Row Height.mp4

6.0 MB

~Get Your Files Here !/7. Working with Rows and Columns/6. Row Height.srt

848 B

~Get Your Files Here !/7. Working with Rows and Columns/6.1 Rows and columns.xlsx

21 kB

~Get Your Files Here !/8. Copy and Paste & Moving and Insertion of Text/1. Copy and Paste.mp4

5.4 MB

~Get Your Files Here !/8. Copy and Paste & Moving and Insertion of Text/1. Copy and Paste.srt

1.1 kB

~Get Your Files Here !/8. Copy and Paste & Moving and Insertion of Text/2. Moving and Insertion of Text.mp4

5.6 MB

~Get Your Files Here !/8. Copy and Paste & Moving and Insertion of Text/2. Moving and Insertion of Text.srt

1.1 kB

~Get Your Files Here !/8. Copy and Paste & Moving and Insertion of Text/2.1 Copy moving and insertion of text.xlsx

13 kB

~Get Your Files Here !/9. Autofill/1. Autofill.mp4

8.0 MB

~Get Your Files Here !/9. Autofill/1. Autofill.srt

1.3 kB

~Get Your Files Here !/9. Autofill/2. Custom list.mp4

9.6 MB

~Get Your Files Here !/9. Autofill/2. Custom list.srt

1.3 kB

~Get Your Files Here !/9. Autofill/2.1 Autofill.xlsx

20 kB

~Get Your Files Here !/Bonus Resources.txt

357 B