Blog

Excel Errors

If there’s one thing that makes me tremble…it’s seeing a #REF! error in my excel file. But those aren’t the only errors you may come...

Formula Auditing

The Formula Auditing section in excel allows you to prevent & deal errors in your excel file. Learn all about the different options avail...

Give it a Name - Named Ranges

Named ranges are one of my favorite features in excel… yet I rarely see them being used properly. In this article, we’re going to...

The Power of Tables

One of the most powerful tools in excel is excel’s table feature… and shockingly, there are few people who I’ve seen really understand &...

Excel Formulas Cheat Sheet

learn about every excel formula available, and when to use them in this Excel Formulas Cheat Sheet.

4 common ways to paste in Excel

One of the most common functionalities that I use in excel is utilizing the paste feature. Most people think of a simple Copy & Paste...

Using the Template tab

Creating a Template tab makes it really easy for you to have a useful starting base no any new tabs that you add.

All the Excel Charts

Excel charts are one of the most powerful tools offered by excel. Learn about when to use each chart in this article.

PivotTable Profit & Loss

Creating a Profit Loss PivotTable has many benefits The Benefits of Creating a PivotTable Profit & Loss 1️⃣ Easily extend dates using...