Contents

Newest Features in Excel

  • The advent of “Relational DB” in Excel – PowerPivot!

Excel Formulae


Working with Graphs


“Back to the Basics” section

  • INDEX
  • VLOOKUP/HLOOKUP
  • MATCH
  • INDIRECT
  • ARRAY FORMULAE
  • DSUM

“Did you Know” series

A lot of the time, there are things that totally baffle you when you least expected them – limitations, extensions, workarounds, unavailability etc. And that’s exactly what I’d like to uncover in my ‘Did you know’ series!


VBA


Integration with other softwares

  • Dynamic Dashboard with MS Access
  • Automating MS Powerpoint slides from Excel
  • Automating Adobe PDF reports from Excel
  • Running SAS prompts from Excel
  • Executing R commands and output in Excel

Excel vs Other Data Softwares


Other Stuff

Advertisements