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...
Category: Advanced
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...
Enable Solver in Excel
This post details how to enable solver in Excel. Solver is an add-in for Excel that solves optimization problems for you. All you need to...
