Category Archives: News

How to Split Bills and Share Expenses Using a Free Excel Spreadsheet

Settle Bill Small

You know the problem well: You are sharing a household, going to dinner with a group, or going on a trip with friends… Now, you have to keep track of who paid for what, who owes who, and how to settle all your IOUs with as few payments as possible… Some folks will pay with cash, some use credit cards, and when the bill arrives, it’s a huge hassle to split it up. Fortunately, Excel here to save the day – here, you can download a completely free and easy spreadsheet that will track expenses, who paid, who owes whom, and how much. Tally it all up, and settle up your debts all at once!

Continue reading How to Split Bills and Share Expenses Using a Free Excel Spreadsheet

Excel Web Resource Links Are Up!

I’m working hard to make Excel Tactics a great resource for Excel tricks and tutorials, but there are other great sites and forums that can also be great resources to help you master your spreadsheets. I’ve put together a page of Web Resources to help you on your way.

I’ve included some pages with introductory videos to walk you through Excel basics. There are also a few fantastic forums where you can get your questions about specific problems answered on the fly by volunteer pros (including yours truly). Finally, there’s an index of handy macros and VBA snippets that address common tasks. Take a look and see what you’re missing! I’ll add more resources to the list as I find them. If you want to stay up to date with the latest links, join the newsletter to get an e-mail when I post them!

Welcome to Excel Tactics!

There’s a lot to say about what I have planned, but I won’t try to cover it all here. Excel Tactics is for you. I hope it will become a reliable resource for tips, tricks, reference, and tutorials to help solve problems with in Excel. I intend to open your mind about dynamic formulas like VLOOKUP and remove the intimidation from PivotTables and What-If scenarios. The most powerful tools in Excel will be at your disposal.

Saving time is just as important when working with Excel, and there are shortcuts that could save hours of time when scrubbing errors from data, performing data mining operations, and simply navigating your worksheets. Keyboard shortcuts, order of operations, and formula automation can be the difference between manually pounding away and letting Excel do the work for you.

Stay tuned!