If you do a lot of driving and you need to expense it for tax purposes, then you know you need a good log to keep track of it. That's what the mileage log template will help you do. Along with tracking all your trips, it will let you do the follow ...
When you're doing financial analysis, it's helpful to add some context to growth numbers. That's where using a Compounded Annual Growth Rate (CAGR) is very useful. Rather than saying a company has grown 50% over 10 years, you could say instead that ...
If you're looking to hire someone and want to know whether they know how to code in Excel using Visual Basic (VBA), it's not too hard of a task to quickly evaluate whether they know it or not. The first step is to ask them to send you a sample of so ...
Knowing how to copy and paste is one of the most basic things you can learn to do in Excel. And while everyone is familiar with doing it, you might be surprised that there are several ways to do it, some more common than others. Using Ctrl + C an ...
If you’re looking for a way to compare worksheets in excel and find the differences between them, then this is the template for you. It will quickly highlight any changes between the worksheets and also note the differences. With just a push of a ...
Whether you’re managing multiple deadlines, have a lot of tasks, or just have an odd schedule, this task manager template can help you manage all of that. Visually you can see what’s coming up and what still needs to be done. It’s a good way to o ...
There are many different options for formatting data in a spreadsheet. And there are even more available if you use a custom number format in Excel. That flexibility is important because it can be a bit frustrating if, for example, you want negative ...
Excel can be a useful tool for tracking items, whether related to a meeting or a project. The action items template allows you to enter multiple fields related to an action item, including responsible person, department, expected completion, and tags ...
Pivot Tables are great tools, especially for quickly summarizing data and allowing you to avoid entering in complex formulas to do so. However, they aren't perfect and definitely have their quirks about them. Here are four things that most users are ...
This add-in is completely free and includes over 20 macros that I have worked on myself and that I hope will help you. Any feedback is welcome, as well as any suggestions for other macros you would like to see added. Disclaimer T ...
