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

You can easily create a graph in Google Sheets to get a visual display of your data. Once added, you can further customize the chart or graph so that it displays the information in the most ...

You can make a bar graph in Google Sheets to make the data in your spreadsheet more digestible, useful, and visually appealing. Once you select the data in your spreadsheet needed for a graph, you can ...

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