Interactive Excel KPI Dashboard
Here is a super slick Interactive Excel KPI Dashboard I prepared with some slicer magic. It will be a good practice of creative use of...
Beat Excel! Get to next level in Excel!
-
-
Interactive Production KPI Dashboard
Here is a nice Interactive Production KPI Dashboard that shows various KPI’s side by side for different company locations for easy comparison. It is also...
-
Excel Crash Course
You may not be excel savy. You may not have required to use Excel all that much. But you would like to have a basic...
-
Weekly Production Report Template
Here is a Weekly Production Report Template for you (supports up to 52 weeks). This excel template is simple, clean and easy to use. All...
-
Personal Expense Manager
Recently a couple of people around me was asking for an expense manager. So I decided to make one and post it here. This way...
Excel Trim Function Doesn’t Work
On many occasions, Excel trim function doesn’t work when trying to trim numbers pasted into Excel. It can be very frustrating to manually delete all...
Pivot Table Field Name Is Not Valid
If you are receiving the message “ Pivot table field name is not valid ” when you are trying to create a pivot table, that...
Ungroup Pivot Table Fields
Excel pivot table groups your dates into years, quarters and months by itself when you drag them into a rows or columns. Many users don’t...
Evaluate Formula
Evaluate formula tool helps you figure out what is wrong with your formula. When you are confused about a formula in a worksheet, or is...
Add Chart Element
Many people does not know how to restore chart axis after accidentally delete it. In this article, I will show you how you can add...
Exclude Values in Sumif
Have you ever needed to exclude values in sumif function? This article will show you how to do it.
