excel

Money

Travel Expense Calculator For Excel

1:30PM Angus Kidman | Keeping track of expenses on the road is always fiddly. Getting the discipline to enter the relevant information on your PC is something you’ll need to work on yourself, but if your office doesn’t already mandate an expense system, this Excel template will help simplify the process. More »
Work

Add Every Other Cell In A Column In Excel

2:00PM Angus Kidman | Want to find the total of every other cell in a column in Excel? You can manually select those cells by holding down Control and clicking, but a little formula magic can get the job done much faster. More »
Work

Right-Click For Fast Excel Sheet Navigation

3:00PM Angus Kidman | Using multiple worksheets in a single file is a common Excel technique, but getting to the sheet you want can be time consuming. Right-click to the rescue! More »
Work

OfficeTab Adds Tabs To Microsoft Office

6:00AM The How-To Geek | Windows only: Microsoft Office plug-in OfficeTab adds tabbed document support to Excel, Word, and PowerPoint—one can only wonder why Microsoft doesn’t include this feature by default. More »
Money

Plan Your Retirement With Excel’s Goal Seek Function

10:30PM Kevin Purdy | Excel journeyman know you can plug in numbers and get formula results from a spreadsheet. Lesser known, however, is the ability to figure out what numbers are need to get a certain result, which works perfectly for retirement planning. More »
Work

Use A Keyboard Shortcut For Excel Bulleted Lists

9:00AM Angus Kidman | Compared to Word, Excel has sloppy support for entering bulleted text (and the option to insert a bullet symbol isn’t even on the Home tab), but you can speed up the process with a keyboard shortcut. More »
Design

Design Floor Plans With Excel

6:00AM The How-To Geek | Rather than spend money on a commercial tool for designing floor plans, interior design, or laying out your landscaping, you can tweak Microsoft Excel to make an adequate replacement. More »
Work

Calculating The Week Number In Excel

3:00PM Angus Kidman | We’ve just past June 30, so it must be Week 26 of the year, right? The answer turns out to be “maybe”, especially if you’re running Excel. More »
Work

Make Excel Open Spreadsheets In A Separate Window

4:00AM The How-To Geek | If you spend a large part of your day dealing with boring, TPS-like reports, you’ve probably noticed that Excel 2007 won’t let you put spreadsheets side-by-side on your multi-monitor desktop. Luckily, there’s a fix for that. More »
Work

Save Time With Excel’s Double-Click Tricks

4:00AM The How-To Geek | If you have to deal with boring spreadsheets on a daily basis, every tiny little trick that saves you time is worth it—and the Pointy Haired Dilbert blog runs down a whole list of useful tricks. More »