Category: Advanced

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...

High-Low-Close Chart

Here is a chart for showing an interval of distribution and avarage value together in nice and compact style. With a little formatting, you can...

Talking Excel

Did you know that you can get Excel to talk to you? You can make excel read out loud what ever you entered by adding...

Save As Single File Webpage (MHTML)

There are several ways to protect your files or having them viewed on web browsers. But MHTML format makes both possible at once. When you...

Power Pivot

Power Pivot takes the power of relational database queries to your desktop. Only requirement is Excel 2010 or 2013. And knowing how to use it...