Microsoft Excel Productivity Premium class

Brett Romero, Bitesize Business School

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

      10:23
    • Getting Started With Formulas

      7:42
    • Formulas Introduction

      10:47
    • Concatenate

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

      2:28
    • Calculating Time Spans

      2:05
    • vlookup Exposed

      6:22
    • Phone Numbers

      12:45
    • Sorting

      6:06
    • Removing Duplicates

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

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

      4:42
    • Quick Analysis

      3:15
    • Multi-Sheet View

      3:59
    • Freezing Panes

      4:17
    • Power of the Alt Key

      3:57
    • Selecting Only Relevant Data

      3:46
    • Shortcut Keys

      2:35
    • Locking Cells & Showing All Formulas

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

      3:26
    • Building A Functional Database

      6:42
    • Hiding/Unhiding Single And Multiple Columns

      3:19
    • Coloring Tabs For Better Grouping

      2:57
    • Solving Complex Problems Easily

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

      7:07
    • Power Query

      8:22

About This Class

Microsoft Excel Training For The Ambitious

Microsoft Excel is the most in demand tool for mining and making sense of data. Anyone that can harness this power will be a sought after employee. If you are running a business, being proficient in Excel can help you see your business in a whole new light. 

Leading a team?  Boost their efficiency in minutes with this mega packed Excel Productivity course. 

Excel Productivity shows you have to work faster and smarter in Excel. You'll pick up great tips that will make working in Excel a pleasure. 

Some of the areas covered include: 

  • Conditional formatting
  • Various types of sorting
  • Days and years between dates
  • Removing duplicates
  • Viewing multiple sheets in a single view
  • and more

The best part is that the above list will keep growing with great Excel insider, productivity tips for working smarter and faster. 

39

Students

--

Projects

Brett Romero

Bitesize Business School

Combining the skills of an #entrepreneur#writer/#author and software engineer to deliver a unique perspective on creating profits.