Excel

Leveraging Excel to deliver analytics. Averages Chart – Bar Chart Chi-Squared: Validate Results Combine Worksheets Convert Column Headers to Rows Cumulative Frequency Database Reporting Designing Data Tables Images-Batch-Rename Merging Worksheet Data Optimization Power Query Introduction Power Query Transformations Power Query Transformations (Advanced) Print Headers with Page Numbers and Last Edited Dates Repeat Headers when Printing…

Excel: Tables – Conditional-Formatting, Filters, and Charts

Table features: Conditional-Formatting, Filters, and Charts. In this article, I’ll illustrate powerful Excel features provided with tables such as: Conditional-Formatting, Filters, and Charts. First, I’ll begin with a simple data set. You’ll notice some of the values are truncated, so I’ll click the top-left cell to select all cells, then double-click the dividing line between…

Excel: Statistics

Using statistic formulas to deliver key metrics. Beginning with a simple set of test sales data, I employed some simple statistic Excel formulas to display metrics regarding the data. In addition to using Conditional Formatting to show revenue values in both the high (green) and low (red) ranges, I also show for all the values…