Beat Excel!

Beat Excel! Get to next level in Excel!

Advanced

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

Basics

Excel Shortcut: Paste as Value

For me, this is the best Excel shortcut ever. I came across this one late in 2013 and been using it almost daily at work....

Formulas

Extract Text From String

If you need to extract text from string in Excel with a known character, there is an easy way of doing this with just one...

Basics

PDF to Excel

If you ever tried to copy data from PDF to Excel you sure have noticed that copied data are not quite usable when pasted into...

Basics / Featured

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