Excel

Tech MBA [Bi] / February 9, 2019

Please see my other Business Intelligence articles.

Leveraging Excel to deliver analytics.

CHARTS
Chart: Area	Chart: Bar	Chart: Bar – Clustered
Chart: Bar – Stacked	Chart: Bar – Vertical	Chart: Bubble
Chart: Histogram	Chart: Histogram – Frequency Polygon	Chart: Histogram – Relative Frequency
Chart: Line	Chart: Ogive	Chart: Pie
Chart: Stem & Leaf Plots	Chart: XY Scatter Plot	Chart: Venn Diagram
VLookUp	Chart: XY Scatter Plot (Distribution Shapes)

MEASURES
Chi-Squared: Validate Results
Central Tendency: Mean	Central Tendency: Median	Central Tendency: Mode
Cumulative Frequency	Quartile	Spread: Range
Spread: Standard Deviation	Spread: Variance	Spread: Z-Scores

POWER QUERY
Power Query Introduction	Power Query Transformations	Power Query Transformations (Advanced)

Combine Worksheets Convert Column Headers to Rows Database Reporting

MISCELLANEOUS
Designing Data Tables	Images-Batch-Rename	Merging Worksheet Data
Optimization	Print Headers with Page Numbers and Last Edited Dates	Repeat Headers when Printing
String Split	Solver	Tables: Conditional-Formatting, Filters, and Charts

Leave a comment