ExcelDemy.com Blog

How to make an Excel Add-in Image 11 1

How to Make an Excel Add-in [Narrated with an Example]

So, you mastered VBA (or not) and automated that extremely complicated operation that consumes all your time. Let’s call your invention SuperFunction. But what would you do if your boss tells you to do...

Excel Solver with a Case Study Image 1.2 0

Excel Solver with a Case Study [Rate Your Sports Team]

Ratings are numerical representations of competitive strength which is directly comparable. It is often applied directly to predict the game outcome between any two teams. The Sports rating systems have been around for almost...

Paste Special Command in Excel Image 1 0

What is and how to use paste special command in Excel

We are all familiar with Cut/Copy and Paste commands. They’ve been around since the early days of word processing, and they are universal across almost every Windows application. By pressing “Ctrl-V” or clicking “Paste”,...