If youre using excel for analysis of large datasets, id reccomend learning python, and the pandas library. It can also work with * excel/csv files, data visualisation (graphs, scatter diagrams etc)
* live stock prices, time series etc
* databases, (postgres/mysql/sqlite/oracle)
If you're getting good mileage out of vba and excel, I'd highly reccomend learning python, and the pandas library, as well as the numpy/scipy libraries
a link to general pandas tutorials : http://pandas.pydata.org/pandas-docs/sta...rials.html
heres a simple tutorial on creating excel charts with pandas http://pandas-xlsxwriter-charts.readthedocs.org/
and a tutorial on plotting time series data http://wrobstory.github.io/2013/04/panda...eries.html
* live stock prices, time series etc
* databases, (postgres/mysql/sqlite/oracle)
If you're getting good mileage out of vba and excel, I'd highly reccomend learning python, and the pandas library, as well as the numpy/scipy libraries
a link to general pandas tutorials : http://pandas.pydata.org/pandas-docs/sta...rials.html
heres a simple tutorial on creating excel charts with pandas http://pandas-xlsxwriter-charts.readthedocs.org/
and a tutorial on plotting time series data http://wrobstory.github.io/2013/04/panda...eries.html