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 ...

It’s January and you’ve gone and done it: You’ve resolved to keep better track of your personal finances. But deep down, you’re not sure where to start. Sure, you can buy accounting software, sign up ...

Drop-down lists in Microsoft Excel (and Word and Access) allow you to create a list of valid choices that you or others can select for a given field. This is especially useful for fields that require ...

Simplify your hiring and employee promotions by creating a salary scale spreadsheet. Rather than negotiating salary rates and increases based on individual circumstances, standardize the process with ...

If you resolved on Jan. 1 to keep better track of your personal finances, are you sure where to start? Sure, you can buy accounting software, sign up for a service or poke around your bank’s online ...