Excel

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)

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

Enter your comment here...

Fill in your details below or click an icon to log in:

Email (required) (Address never made public)

Name (required)

Website

You are commenting using your WordPress.com account. ( Log Out / Change )

You are commenting using your Facebook account. ( Log Out / Change )

Connecting to %s