Welcome to Analyze 6

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!

  • excel dynamic crosstab technique
    Master dynamic crosstabs using SUMIF or VLOOKUP in Excel with this tutorial