New content every week on this site and on social media
Recent posts
How to Convert Date Formats in Excel
If you've ever downloaded data and received dates in the wrong format, it can be a challenge to fix. If your regional settings are month/day/year but in a spre ...
How to Create and Chart Bollinger Bands in Google Sheets and Excel
What are Bollinger Bands? Bollinger Bands are used in technical analysis to help calculate and measure volatility. There are three bands that are included i ...
Flip Your Data in Excel Without Sorting
Want to show your data in reverse order, and want to do so without having to sort it? Using just a formula, you can change the way your data looks. Instead of ...
Free Project Tracker Template in Excel
If you do work on a lot of different projects, this is a template that can make your life a lot easier. It's one that I use regularly that helps me accurately ...
How to Use the Filter Function in Excel
Did you know that you can filter data by just using a single function in Excel? There's no longer a need to use advanced filters or to manually select the data ...
Mortgage Payment Calculator Template
Are you planning to buy a home? With this mortgage payment calculator template, you can do different what-if scenarios to see what your monthly payment will be ...
Use VBA Code So a User Can Select a File or Folder Path
If you need to reference other files or folders within an Excel sheet, trying to predict what the path will be can be challenging. The easier option is to just ...
Use MAXIFS and MINIFS to Find Values Within a Range
Whether you're using VLOOKUP or XLOOKUP, one limitation you're going to face with those functions is that you can't search within a range or use multiple crite ...