Today’s topic may seem like an unnecessarily basic one, but I can tell you that nine out 10 shared spreadsheets I receive from team members are unusable for analysis because they can’t be sorted. I’m ...

Microsoft announced in early 2012 that it would extend support for aging Visual Basic 6 runtimes and code syntax for the entire life cycle of Windows Vista, Windows Server 2008, Windows 7 and the ...

Visual Basic for Applications can make helpful items such as links appear on screen. You can open an external spreadsheet by clicking a link in an Excel spreadsheet. For instance, you might add an ...

Breakthroughs, discoveries, and DIY tips sent six days a week. Terms of Service and Privacy Policy. Let’s all come together and face it: spreadsheets can be scary ...