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...
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...
Group Data in Excel
You can group data in Excel to use worksheet space more efficiently. Grouped columns and rows can be collapsed and expanded easily to hide or...
Hide/Show Sheet Tabs
You can hide/show sheet tabs in Excel to prevent users seeing and accessing sheets that you don’t want them to.
