Are you looking for Excel examples? Are you looking for clear explanations that help you master many more Excel features quickly and easily? You can find related examples and features (300 Examples) on the right side of each chapter.
Our 15 most popular examples:
- Find Duplicates: This example teaches you how to find duplicates (or triplicates) in Excel.
- Drop-down List: Drop-down lists in Excel are helpful if you want to be sure that users select an item from a list, instead of typing their own values.
- Percent Change: The percent change formula is used very often in Excel. For example, to calculate the Monthly Change and Total Change.
- Regression: This example teaches you how to perform a regression analysis in Excel and how to interpret the Summary Output.
- Loan Amortization Schedule: This example teaches you how to create a loan amortization schedule in Excel.
- 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.
- Histogram: This example teaches you how to create a histogram in Excel.
- Random Numbers: Excel has two useful functions when it comes to generating random numbers. The RAND and RANDBETWEEN function.
- Remove Duplicates: This example teaches you how to remove duplicates in Excel.
- Count Unique Values: This example shows you how to create an array formula that counts unique values.
- Lock Cells: You can lock cells if you want to protect cells from being edited.
- Time Sheet: This example teaches you how to create a simple timesheet calculator in Excel.
- 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.
- Budget: This example shows you how to create a budget in Excel.
- Calendar: This example describes how to create a 2016 calendar in Excel (or 2017 calendar, 2018 calendar, etc). If you are in a hurry, simply download the Excel file.
Check out all 300 examples.