Google Sheets has come a long way in being a formidable alternative to Excel. While it may not have all of the same features as Excel, Google is adding to its functionality. Creating a pivot table with slicers is now a possibility in Google Sheets, ...
QuickBooks does a good job when it comes to recording sales and doing day-to-day accounting tasks. You may be content with the reports that come out of QuickBooks, too. But if you're looking for some more in-depth analysis to do of your own or to ma ...
Looking at numbers on a plain white spreadsheet can sometimes make it difficult to differentiate one row from another, especially from afar. It can also make the spreadsheet look a bit bland. That's why in this post I'll show you how in Excel you ca ...
There are many Excel calendars online but with this template, you can customize it to suit your needs and use the calendar for more than just one year. At a minimum, you can use the template to help generate a 12-month calendar for a specific ye ...
What is a tax-free savings account (TFSA)? A tax-free savings account (TFSA) is a very useful tool for Canadian investors to shield investment gains and dividend income from taxes. However, it can be challenging to keep track of the rules and jus ...
Forget using VLOOKUP or even INDEX and MATCH, Excel users can now use XLOOKUP! Knowing how to use VLOOKUP has become almost a basic skill for Excel users. If you're an intermediate or advanced user, you probably use INDEX & MATCH because of t ...
If you need to make an invoice and don't want to spend money on some overpriced software, you can do so easily in Excel with this template. Not only can you customize it to how you want it to look and feel and produce a professional-looking invoice, ...
For many users, the GETPIVOTDATA function in Excel is a nuisance and people are often looking for how to turn it off, rather than to actually use it. It can be a bit of a clunky formula, to say the least, but it can be very useful once you've learne ...
When using charts, sometimes you'll want to highlight items differently depending on if they're positive or negative, or may if they're above or below a benchmark or average. While you can apply conditional formatting to cells, it's not as easily do ...
Excel is a great tool for financial questions and analysis, and one popular one is whether someone is better off paying down their debt vs adding to their savings. There are temptations to both, but this is where Excel can help identify a clear win ...
