Excel has been the main tool for presenting data in a digestible form almost forever. The wealth of facilities on top of the basic spreadsheet functions have helped to power Excel to this position, and to keep it there. As well as the bread and butter spreadsheet function, there are facilities for querying databases, filtering data, grouping, charting, pivoting, and many, many more. Even Microsoft have realised Excel's role, adding more data analysis/BI/BA functionality in the latest Excel releases, 2010, 2013 and Office 365. Even with all of this richness, it's still never enough is it? Sometimes it just doesn't do the thing(s) you need it to do now.You want to do something and it is not in the Excel tool-set? With VBA you can create custom functions, trap use action, format/modify data, even build a complete application.In this session, we are going to build such an application. It will be fast-paced and quite intensive, but all of the files will be made available afterwards.
No material found.