How to Block Data Validation Override
You can setup a data validation list to limit entry to certain cells. But you will realize at some point that your data validation can...
Category: Advanced
Excel Gantt Chart
Here is an easy way of creating an Excel Gantt Chart which is pretty responsive and looks nice. It is actually a bar chart formatted...
Creating Top 10 List Without Pivot Table
There can be times that you need to create top 10 lists that can be filtered independently from other worksheets along with many other tables...
Finding 2nd Matching Value with Vlookup
There can be times that you need to look up for a value but not necessarily want the first matching value. Vlookup function cannot help...
Personal Expenses Manager 2
Here is another personal expenses manager is available for download. Be aware of your monthly and annual finances all the time with Personal Expenses Manager...
Excel Solver Example
Let Excel solve problems for you! I recently used Excel for comparing two alternatives. Then I decided to construct an Excel Solver example for you...
