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

February 17, 2022

Edit Excel Formulas in WORD – Spreadsheet Tips and Tricks

February 8, 2021

51: Oz du Soleil & the Global Excel Summit 2021

January 29, 2021

Global Excel Summit 2021

January 22, 2021

50: Randy Austin – Excel for Freelancers

January 8, 2021

49: Theresa Estrada – Microsoft Principal Program Manager Lead

May 26, 2020

All Excel LOOKUPs Explained
  • 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.

    >