July 18

Watch Excel TV LIVE

6  comments

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


Tags


You may also like

51: Oz du Soleil & the Global Excel Summit 2021

51: Oz du Soleil & the Global Excel Summit 2021

Global Excel Summit 2021

Global Excel Summit 2021
  • 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’:
    http://www.uie.com/articles/design_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"}

    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.

    >