MM0019 - 06/04/20 - Chris's Data Analysis Secret Weapons

There is no doubt, VBA is great!  But, Excel has a number of excellent data analysis tools that few people use, and avoid the need to deploy VBA at all.  Chris calls them his secret weapons.  Let's check out a few in this stream.

Topics

  •  | Quickly Delete Columns
  •  | Discussion: VBA vs. Formulae
  •  | Formula To Calculate Bet Returns
  •  | IF
  •  | Name A Range - Shorthand
  •  | SUMIF
  •  | SUMIFS
  •  | COUNTIFS
  •  | DSUM
  •  | Workbook Structure For Data Analysis
  •  | Data Table Example
  •  | Testing A Data Table
  •  | Discussion: VBA vs. Worksheet Techniques
  •  | Dealing With Additional Data Rows
  •  | Typical VBA Learning Journey
1 Lesson