ExcelDemy.com Blog

0

15 Best Online Excel Training for Basic & Advanced Users with Certification

“Note: Are you a basic Excel user? Or an advanced level user? And searching for the best online Excel courses? And don’t want to spend the top dollars on the training? You’re at the...

Database creation steps in Excel image 8 0

Create Database in Excel in 8 Easy Steps

Want to create database in Excel? Do you find MS Access as complex tool to use as a database? Read this article. How to create database in Excel Unfortunately, they don’t teach the hardcore...

Sequencing problems, Solution, Excel Solver 2

Deal with Sequencing Problems Using Excel Solver!

It is well known that sequencing problems are notoriously difficult to solve. There are two kinds of sequencing problems:  traveling salesperson problem and shop scheduling problem.  Today I’d like to introduce on how to...

How to assign work using Evolutionary engine Image 2.1 0

How to Assign Work Using Evolutionary Engine?

Previously, I have made a brief introduction on the Evolutionary engine when discussing GRG engine. Today, I’d like to show you how to use Evolutionary Engine to solve a problem in real life. 1....

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