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

You don't need to be an Excel whiz to leverage very simple spreadsheets that will make you much more efficient at your job. Here I share three of my very own spreadsheets and explain how I use them. I ...

One type of expense and income spreadsheet, the income statement, enables you to easily calculate the sales figures needed to reach a profit objective. Consider a scenario where you want to net $5,000 ...

While Excel is a powerful tool for organizing data and performing complex calculations, it’s easy to get lost in a sea of numbers and bland cells. At times, when you deal with large databases, your ...

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

I love productivity systems and apps and lately I’ve developed my own, which requires only a regular spreadsheet–Excel or Google docs will do–and it’s easier and more effective than any I’ve tried. It ...

The ease with which you can create a line graph in Excel on your PC or Mac will do much to dispel the misconception that the program is arcane and unapproachable. With just three clicks of a mouse (or ...

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

Many people have trouble keeping their checkbooks balanced. Now that debit cards have made it easy to have money electronically transferred out of your bank account without even having to write a ...

When you use MySQL to query a database, you have the ability to view results from that query on your screen or send them to a text file. If you insert tab characters into the output data stream, you ...

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