Lesson 4: Data Analysis Formulae For Excel VBA Business Simulations
Excel VBA simulations allow us to build simulated data sets at the click of a button. Now that's cool, but how do we know those datasets are accurate? It's vital to be able to quickly check the validity of a dataset. To do that, let's harness some of Excel's data analysis formulae. Not only will these help you with Excel business simulation, they will benefit your Excel practice more generally. Chris calls them his 'secret weapons'!
3 Lessons