Especially popular are the 9 chapters discussed above. Also very popular are the examples and features below. Happy learning!

1 Find Duplicates: This example teaches you how to find duplicate values (or triplicates) and how to find duplicate rows in Excel.

2 Histogram: This example teaches you how to make a histogram in Excel.

3 Regression: This example teaches you how to run a linear regression analysis in Excel and how to interpret the Summary Output.

4 Pareto Chart: A Pareto chart combines a column chart and a line graph. The Pareto principle states that, for many events, roughly 80% of the effects come from 20% of the causes.

5 Remove Duplicates: This example teaches you how to remove duplicates in Excel.

6 Gantt Chart: Excel does not offer Gantt as chart type, but it's easy to create a Gantt chart by customizing the stacked bar chart type.

7 Line Chart: Line charts are used to display trends over time. Use a line chart if you have text labels, dates or a few numeric labels on the horizontal axis.

8 Correlation: We can use the CORREL function or the Analysis Toolpak add-in in Excel to find the correlation coefficient between two variables.

9 Pie Chart: Pie charts are used to display the contribution of each value (slice) to a total (pie). Pie charts always use one data series.

10 Data Tables: Instead of creating different scenarios, you can create a data table to quickly try out different values for formulas. You can create a one variable data table or a two variable data table.

11 t-Test: This example teaches you how to perform a t-Test in Excel. The t-Test is used to test the null hypothesis that the means of two populations are equal.

12 Advanced Filter: This example teaches you how to apply an advanced filter in Excel to only display records that meet complex criteria.

13 Frequency Distribution: Did you know that you can use pivot tables to easily create a frequency distribution in Excel? You can also use the Analysis Toolpak to create a histogram.

14 Scatter Plot: Use a scatter plot (XY chart) to show scientific XY data. Scatter plots are often used to find out if there's a relationship between variable X and Y.

15 Anova: This example teaches you how to perform a single factor ANOVA (analysis of variance) in Excel.

16 Bar Chart: A bar chart is the horizontal version of a column chart. Use a bar chart if you have large text labels.

17 Goal Seek: If you know the result you want from a formula, use Goal Seek in Excel to find the input value that produces this formula result.

18 Sparklines: Sparklines in Excel are graphs that fit in one cell. Sparklines are great for displaying trends. Excel offers three sparkline types: Line, Column and Win/Loss.

Check out all 300 examples.