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...
Find Links in Excel
Do you see the warning about your Excel file having links to other files but you cannot find the links anywhere? This short article will...
Round Hours In Excel
There is a function you can use to round hours in Excel if you don’t want to display only full hours. Here is how to...
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...
