This is a site where I post tutorials and tips for some of the best Excel and Access data analysis techniques I have learned over the years. Use the search box (top right) or browse topics (right sidebar) to explore. Enjoy!
Click here to learn how to automate SQL in Excel solutions
Master dynamic crosstabs using SUMIF or VLOOKUP in Excel with this tutorial
Learn how to program an MS Access file from scratch with some SQL
Learn how to use Zoopla to customize this chart for any house in the UK
Download my Analyze 6 Cheat Sheet HERE!
Learn how to build seasonality into your forecasts with this simple formula (TS=T*SV*R)
Learn pivot table basics for data analysis by analyzing your bank account data
See how to lose weight with Excel here!
Use Excel VBA to scrape share price data from Yahoo! Finance
A fiscal regime modelling example in excel
Learn how to do cash flow analysis with your online banking data