ExcelDemy.com Blog

Regression Analysis with Excel Fig 3.4 0

Multiple Regression Analysis with Excel

Simple regression analysis is commonly used to estimate the relationship between two variables, for example, the relationship between crop yields and rainfalls or the relationship between the taste of bread and oven temperature.  However,...

10-power-pivot-workshop-intermediate 0

Best Online Excel Courses for Beginners & Advanced

In today’s labor market, it has become necessary to have as many skills as possible. One of the most important and useful skills that is required for most positions is excel and not just...

Database creation steps in Excel image 8 0

Create Database in Excel in 8 Easy Steps

Unfortunately, they don’t teach the hardcore Excel or MS Office tools in our respective schools and colleges. So, all the complicated functions and laws you read in your extremely awesome degree becomes a just...

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

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