Everything you can do in ExcelI’ve summarized everything that you can do in excel, and where you can find each resource.
Excel ErrorsIf 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 AuditingThe 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 TablesOne 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 Sheetlearn about every excel formula available, and when to use them in this Excel Formulas Cheat Sheet.
4 common ways to paste in ExcelOne 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 tabCreating 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 ChartsExcel charts are one of the most powerful tools offered by excel. Learn about when to use each chart in this article.
PivotTable Profit & LossCreating a Profit Loss PivotTable has many benefits The Benefits of Creating a PivotTable Profit & Loss 1️⃣ Easily extend dates using...