The Excel Trainer
  • Live Training
  • Free Tutorials
  • Newsletter
  • Partners
  • Contact Mike
Select Page

Business Intelligence with Excel: Resources

Pivot Tables

  • Getting Started with Pivot Tables (video)
  • Displaying Percentage in a Pivot Table (PDF)
  • Sorting a Pivot Table (PDF)
  • Group By Dates (video)
  • Grouping Dates By Week (video)
  • Pivot Charts (video)
  • Calculate Differences in a Pivot Table (Video)
  • Create a Pivot Table From Multiple Tables (Video)
  • How to Stop Pivot Table Grouping Affecting Another Pivot Table (Video)
  • Applying Conditional Formatting to a Pivot Table (PDF)

Reports

  • Conditional Formatting
  • Win Loss Sparkline Charts
  • Excel 2016 – Dashboard Basics – From Microsoft
  • Creating a Heat Map
  • Power Pivot and Power Query – Links

© 2012-2021 - theexceltrainer.co.uk    Privacy Policy