17: Dave Bruns of ExcelJet.net

Dave Bruns of ExcelJet.net

Dave Bruns and his wife Lisa run the website ExcelJet.net.  A site that was designed to give people answers to their questions so that they can be productive and get back to work.  He adds content to the site weekly.  The site is known for its training classes.  Dave has 4 training classes on the site as of this writing:

  • Excel 101 – will give you a solid introduction in just over an hour, complete with practice worksheets.
  • Core Excel – will teach you how to use a spreadsheet with ease and confidence
  • Core Pivot – step-by-step course that will teach you everything you need to know to use this very powerful tool
  • Conditional Formatting – show you how to use conditional formatting communicate key insights with clarity and impact

Minimalist Guide to Excel Functions

Dave also discusses a portion of his site dedicated to making functions simple by breaking them down and seeing which functions accept which arguments.  And which arguments are optional and which are required.

2014-11-15_12-43-17

Excel Shortcuts

The panel discusses shortcuts.  Are you good at them?  Do you use them?  How do you use the finite space in your mind?  Do you fill it up with shortcuts?  The panel discusses the topic.

Find Dave on the internet…

What’s Next

First off…  hit one of the links above and go check out ExcelJet.net.  Next up, share this page and sign up for our Newsletter below.  That way you never miss the chance to see an episode LIVE.


Tags


You may also like

August 5, 2014

14: Jon Acampora, Excel MVP

June 19, 2014

07: ExcelIsFun Channel with Mike Girvin

June 19, 2014

01: Excel High Priestess Szilvia Juhasz

June 19, 2014

05: Mr. Excel, Bill Jelen

June 19, 2014

04: Chandoo Visits Excel TV

June 19, 2014

02: Microsoft MVP Coordinator Kari Finn
  • I have read the nesting ifs but the little knowledge I have of excel has prevented me of getting it to work.. can you do it for me? row T1 value is 8 or less, row X1 value is 1.1 or more.
    Could I get a quote from you to convert a excel program to a visual basic program?

  • {"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}

    Free Power User Quick Guide

    Discover The BEST Ways To Use Lookups And Conditional Calculations Quickly And Easily With This Reference Guide -- You Won’t Want This To Leave Your Side

    With so many ways to use Excel, it can be difficult to memorize all of the key functions, calculations, and techniques you can employ to meet your goal: simply get the job done.

    >