I am from China and this photo was taken in a classical garden. There are many similar gardens in China, attracting a lot of visitors every year, especially in spring and summer. I was major in Biotechnology. But I took a job as a SAS programmer because I prefer programming. Besides SAS, I also learned Excel VBA in my spare time. It is fantastic to be able to manipulate data, files and even to interact with the internet via programming. This will save me a lot of time. I am keen to learn new things.
In this article, I will show you two ways to create a financial planning calculator in Excel. Most of us need to determine the monthly payment or the amount of ...
This tutorial will demonstrate how to use Excel Solver to determine which projects should be undertaken. Companies need to know which projects should undertake ...
In this article, we will discuss 2 cases for solving transportation or distribution problems using the Excel Solver. It is well known that companies ...
I have written an article on how to determine the optimal product mix using Excel Solver. Today, I’d like to discuss how to schedule the workforce along with ...
In many situations, you may want to know how to calculate the optimal product mix in Excel. For example, companies often need to determine the amount of each ...
If you know the result of a formula, but you are not sure which input value the formula needs to get that result, you can use the Goal Seek Command. In this ...
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 ...
How to Do What-If Analysis Using Scenario Manager in ExcelIn this article, we’ll learn five quick and suitable steps on how to use scenario manager in Excel. ...
Today I’d like to introduce you to Excel's OFFSET Function with 3 real-life examples. At first, I will describe the formula syntax and then I'm going to ...
The article shows how to perform one and two-variable sensitivity analysis in Excel. Sensitivity analysis studies how different sources of uncertainty can ...
Today I want to talk about one of the most important Excel functions - INDIRECT function. Before doing that, I need to give you a brief introduction to the ...
Control charts are widely used to monitor process stability and control. In this article, I will show you how to make a Control Chart with Excel VBA and ...
ExcelDemy is a place where you can learn Excel, and get solutions to your Excel & Excel VBA-related problems, Data Analysis with Excel, etc. We provide tips, how to guide, provide online training, and also provide Excel solutions to your business problems.
Contact | Privacy Policy | TOS