advanced excel Resources

Excel has some powerful tools that you can use to carry out a What-if analysis. We sat down with one of our Excel Experts, Jens, to ask him about three particular data analysis tools and to see whether he would demonstrate how to use them for us. Good morning Jens, you talk a lot about […]

If you’ve used Excel for some time, you may want to learn more about the different logical functions such as IF, AND and OR. This post describes how these functions can be combined to perform very useful composite logical operations. IF Function The IF function will carry out one of two actions. One action is […]