Welcome to Excel Easy

We offer a tutorial on how to use Excel. Below you can find an overview of all chapters. Want to learn much more about Excel? You can find related examples and features (300 Examples) on the right side of each chapter. We keep it easy!

Introduction

This section is for users with no knowledge of Excel.

Microsoft Excel is one of the most used software applications of all time. Hundreds of millions of people around the world use Microsoft Excel. You can use Excel to enter all sorts of data and perform financial, mathematical or statistical calculations.

1 Range: A range in Excel is a collection of two or more cells. This chapter gives an overview of some very important range operations.

2 Formulas and Functions: A formula is an expression which calculates the value of a cell. Functions are predefined formulas and are already available in Excel.

Basics

This section explains the basics of Excel.

1 Ribbon: The tabs on the ribbon are: File, Home, Insert, Page layout, Formulas, Data, Review and View. Excel selects the ribbon's Home tab when you open a workbook.

2 Workbook: A workbook is another word for your Excel file. When you start Excel, click Blank workbook to create an Excel workbook from scratch.

3 Worksheets: A worksheet is a collection of cells where you keep and manipulate the data. Each Excel workbook can contain multiple worksheets.

4 Format Cells: When we format cells in Excel, we change the appearance of a number without changing the number itself.

5 Find & Select: Learn how to use Excel's Find, Replace and Go To Special feature.

6 Templates: Instead of creating an Excel workbook from scratch, you can create a workbook based on a template. There are many free templates available, waiting to be used.

7 Data Validation: Use data validation in Excel to make sure that users enter certain values into a cell.

300 Examples

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.

35 popular examples:

1 Find Duplicates: This example teaches you how to find duplicates (or triplicates) in Excel.

2 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.

3 Vlookup: The VLOOKUP function is one of the most popular functions in Excel. This page contains many easy to follow VLOOKUP examples.

4 Histogram: This example teaches you how to create a histogram in Excel.

5 Regression: This example teaches you how to perform a regression analysis in Excel and how to interpret the Summary Output.

6 Percent Change: The percent change formula is used very often in Excel. For example, to calculate the Monthly Change and Total Change.

7 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.

11 Countif: The powerful COUNTIF function in Excel counts cells based on one criteria. This page contains many easy to follow COUNTIF examples.

12 Lock Cells: You can lock cells in Excel if you want to protect cells from being edited.

13 Standard Deviation: This page explains how to calculate the standard deviation based on the entire population using the STDEV.P function in Excel and how to estimate the standard deviation based on a sample using the STDEV.S function in Excel.

14 Count Unique Values: This example shows you how to create an array formula that counts unique values.

15 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.

17 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.

18 Transpose: Use the 'Paste Special Transpose' option to switch rows to columns or columns to rows in Excel. You can also use the TRANSPOSE function.

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

20 Time Sheet: This example teaches you how to create a simple timesheet calculator in Excel.

21 Offset: The OFFSET function in Excel returns a cell or range of cells that is a specified number of rows and columns from a cell or range of cells.

22 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.

23 If: The IF function is one of the most used functions in Excel. This page contains many easy to follow IF examples.

24 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.

25 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.

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

27 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.

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

29 Anova: This example teaches you how to perform a single factor ANOVA (analysis of variance) in Excel. A single factor or one-way ANOVA is used to test the null hypothesis that the means of several populations are all equal.

30 Compare Two Lists: This example describes how to compare two lists using conditional formatting.

31 Compound Interest: What's compound interest and what's the formula for compound interest in Excel? This example gives you the answers to these questions.

32 Sumif: The powerful SUMIF function in Excel sums cells based on one criteria. This page contains many easy to follow SUMIF examples.

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

34 Concatenate Strings: This example illustrates how to concatenate (join) strings in Excel. When joining text and a number, use the TEXT function to format that number.

35 Calendar: This example describes how to create a calendar in Excel (2019 calendar, 2020 calendar, etc). If you are in a hurry, simply download the Excel file.