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

Project Description

Describe Your Productivity Improvements

After going through the course, describe how you or your team was able to take advantage of what you've learned to improve your Excel productivity.

Download-able files from the course are included below.

Student Projects