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

0

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