July 18

Watch Excel TV LIVE


Watch Excel TV LIVE

That’s Right, LIVE. Right here.

We broadcast 20 times a year, 5 times a quarter. Usually every other Tuesday night at 9:05pm Eastern time. But instead of trying to remember which week and which time… just check this page and watch it right here.

Episode 31 Dick Moffat from Dick Moffat’s Spreadsheet Blog https://dmoffat.wordpress.com/ The episode is scheduled for Tuesday July 14, 2015 at 9:05pm Eastern.  Should be fun

Comments are Closed

We close comments on this page because we reuse the page for each LIVE showing.  Like to leave a comment? Then go here

Loved this? Spread the word

About the Author

I am a healthcare consultant, currently based in Middle East, at an international professional services firm. My work largely revolves around project management, and statistical analysis. And my professional interests include developing my knowledge within the discipline of health analytics.

Jamani Arsalan

Related posts

All Excel LOOKUPs Explained

Read More

How to: Power Query File From Folder

Read More

2020 – I can’t wait!

Read More

Oz’s Excel Tip: Keep a Workbook for Random Data in Excel

Read More
  • Debate question:
    Over the years, most of us have used command buttons and various other controls on worksheets to trigger macros. It is common knowledge that ActiveX controls in particular are plagued with problems.

    Are user intefaces (UIs) created on worksheets in the era of the Ribbon obsolete?

    Custom Ribbon UIs are by design predictable, consistent and accessible. Seven years after the Ribbon was introduced, new Excel applications are still designed with legacy UIs. Is Ribbon customization with XML so painful to master? or is UI usability a lesser priority for Excel developers?

    What Makes a Design Seem ‘Intuitive’:

  • V-lookup should only be used if copy and pasting values. Index/match should be used in all other cases, because the column number parameter in V-lookup is static and doesn’t change (unless you use the columns function, which most don’t). If a co-worker or your boss is to ever use your file, they may end up inserting a column and throwing off what the V-lookup was supposed to return. The error can go unseen. Index Match avoids this error possibility.

    • Ryan, that’s a fresh perspective, and one that I agree with.
      90% of the time that I use VLOOKUP 1. it works, 2. I copy/paste-as-values 3. Done!

      If there’s going to be a lot of sorting, insertion and deletion, yes, VLOOKUP gets really fragile.

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

    Subscribe to our newsletter now!