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

Whenever you create a Microsoft Excel workbook, you should always take the necessary steps to make it accessible to everyone, especially if you plan to share your work with others. In this guide, I'll ...

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

One option for sharing reports with your team is to simply rattle off numbers. Think something like this: "We allocated 10% of operating budget to maintenance, 15% to hardware upgrades, 18% to ...

If you run a business and need to manage your accounts, a spreadsheet can help to record the data and carry out any necessary calculations on it. Spreadsheets can format numbers for currency or dates, ...

Understanding exactly how much money is flowing in and out of your bank accounts each month can make it easier to trim expenses, know if you have enough money to make certain purchases and feel ...

Dana Miranda is a Certified Educator in Personal Finance, creator of the Healthy Rich newsletter and author of You Don't Need a Budget: Stop Worrying about Debt, Spend without Shame, and Manage Money ...

Excel offers two methods for creating a spreadsheet on top of an image. If you want your entire sheet to display a tiled image, add it as a background and your data will automatically appear on top of ...

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

In my post today, I’m going to show you how to use GoogleDocs and Google Calendar to create a dynamic calendar for a course. This calendar can be displayed as a web page or embedded in a course web ...

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