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 Changes Last Digit to Zero
When you paste or type a number with a certain length into Excel, Excel changes last digit to zero. This happens when the number is...
Get Rid of GetPivotData
Almost everybody I know wants to get rid of GetPivotData function. Because when you are writing a formula and use a cell reference from a...
Don’t Count Columns for Vlookup
If you are using Vlookup function like everybody, you are likely to count columns while writing your formula. Don’t count columns for Vlookup anymore, because...
How to Repair a Virus Infected Excel File?
Microsoft Excel, a spreadsheet application, offers Calculation, Graphing tools, Pivot tables, Macro programming language called Visual Basic for Applications (VBA), etc. it has become an...
Task Manager with Conditional Formatting
This task manager with conditional formatting will show you practical ways of using conditional formatting other than comparing numbers, etc. It is lightweight and very...
Print Comments in Excel
If you want to print comments in Excel, you probably realized that comments are not visible on printed worksheets by default. You need to adjust...
