Microsoft Excel Productivity

Brett Romero, Bitesize Business School

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
26 Lessons (2h 23m)
    • 1. Saving/Opening Files & Ribbon Menu

      10:23
    • 2. Getting Started With Formulas

      7:42
    • 3. Formulas Introduction

      10:47
    • 4. Concatenate

      2:52
    • 5. A Common Multi Column Summation Done Very Quickly

      2:28
    • 6. Calculating Time Spans

      2:05
    • 7. vlookup Exposed

      6:22
    • 8. Phone Numbers

      12:45
    • 9. Sorting

      6:06
    • 10. Removing Duplicates

      3:44
    • 11. How Does Excel Know Which Data Format To Choose?

      3:35
    • 12. Updating an Existing Chart's Data Source

      4:42
    • 13. Quick Analysis

      3:15
    • 14. Multi-Sheet View

      3:59
    • 15. Freezing Panes

      4:17
    • 16. Power of the Alt Key

      3:57
    • 17. Selecting Only Relevant Data

      3:46
    • 18. Shortcut Keys

      2:35
    • 19. Locking Cells & Showing All Formulas

      4:13
    • 20. Create an Organizational Chart Fast (then add it to PowerPoint)

      3:26
    • 21. Building A Functional Database

      6:42
    • 22. Hiding/Unhiding Single And Multiple Columns

      3:19
    • 23. Coloring Tabs For Better Grouping

      2:57
    • 24. Solving Complex Problems Easily

      11:23
    • 25. Sourcing Data Directly From The FED Into Excel

      7:07
    • 26. Power Query

      8:22