In the previous article we discussed the SUBTOTAL function https://windsongtraining.ca/an-example-of-using-the-subtotal-function-in-excel/ https://windsongtraining.ca/an-example-of-us…unction-in-excel/. In this post we will look at the SUBTOTAL command found on the Data tab in the Outline group. Each Excel function provides a specific calculation. We use any of the over 500 functions that Excel provides by typing an = sign in a cell [...]
Microsoft Excel has a powerful and relatively new tool to add to the arsenal of data analysis tools that we are already accustomed to using, this is the Excel Data Model. Working together with Power Query and Power Pivot, the Data Model enables Excel users to work with much larger data sets than we could [...]
Excel's What-If Analysis tools allow us to change the values of inputs to a calculation and explore different possible results. In the following article we will consider a single, simple calculation and discuss how each of the three What-If Analysis tools: Goal Seek, Scenario Manager and Data Tables, can be applied. The commands for What-if [...]