#1 Excel tutorial on the net
You can find related examples and features on the right side of each chapterat the bottom of each chapter. Below you can find 100 popular examples.
1 Find Duplicates: This example teaches you how to find duplicate values (or triplicates) and how to find duplicate rows 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 make a histogram in Excel.
5 Regression: This example teaches you how to run a linear 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.
8 Loan Amortization Schedule: This example teaches you how to create a loan amortization schedule in Excel.
9 Random Numbers: Excel has two very useful functions when it comes to generating random numbers. RAND and RANDBETWEEN.
10 Remove Duplicates: This example teaches you how to remove duplicates in Excel.
11 If: The IF function is one of the most used functions in Excel. This page contains many easy to follow IF 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.
16 Countif: The powerful COUNTIF function in Excel counts cells based on one criteria. This page contains many easy to follow COUNTIF examples.
17 Budget: This example shows you how to create a budget in Excel.
18 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.
19 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.
20 Correlation: We can use the CORREL function or the Analysis Toolpak add-in in Excel to find the correlation coefficient between two variables.
21 Time Sheet: This example teaches you how to create a simple timesheet calculator in Excel.
22 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.
23 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.
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 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.
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: Use CONCATENATE, CONCAT, TEXTJOIN or the & operator in Excel to concatenate (join) two or more text strings.
35 Freeze Panes: If you have a large table of data in Excel, it can be useful to freeze rows or columns. This way you can keep rows or columns visible while scrolling through the rest of the worksheet.
36 Weighted Average: To calculate a weighted average in Excel, simply use SUMPRODUCT and SUM.
37 Index and Match: Use INDEX and MATCH in Excel and impress your boss. Instead of using VLOOKUP, use INDEX and MATCH. To perform advanced lookups, you’ll need INDEX and MATCH.
38 Delete Blank Rows: This example teaches you how to delete blank rows or rows that contain blank cells.
39 Sumproduct: To calculate the sum of the products of corresponding numbers in one or more ranges, use Excel’s powerful SUMPRODUCT function.
40 Merge Cells: Merge cells into one large cell to make clear that a label in Excel applies to multiple columns. Use CONCATENATE, TEXTJOIN or Flash Fill to merge cells without losing data.
41 Subtract: There’s no SUBTRACT function in Excel. However, there are several ways to subtract numbers in Excel. Are you ready to improve your Excel skills?
42 Percentage: Calculating percentages in Excel is easy. Percentage simply means ‘out of 100′, so 72% is ’72 out of 100’ and 4% is ‘4 out of 100’, etc.
43 Contains Specific Text: To check if a cell contains specific text, use ISNUMBER and SEARCH in Excel. There’s no CONTAINS function in Excel.
44 Pmt: The PMT function in Excel calculates the payment for a loan based on constant payments and a constant interest rate. This page contains many easy to follow PMT examples.
45 Calculate Age: To calculate the age of a person in Excel, use DATEDIF and TODAY. The DATEDIF function has three arguments.
46 Wrap Text: Wrap text in Excel if you want to display long text on multiple lines in a single cell.
47 Indirect: Use the INDIRECT function in Excel to convert a text string into a valid reference. You can use the & operator to create text strings.
48 Multiply: To multiply numbers in Excel, use the asterisk symbol (*) or the PRODUCT function. Learn how to multiply columns and how to multiply a column by a constant.
49 Subtotal: Use the SUBTOTAL function in Excel instead of SUM, COUNT, MAX, etc. to ignore rows hidden by a filter or to ignore manually hidden rows.
50 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.
51 CAGR: There’s no CAGR function in Excel. However, simply use the RRI function in Excel to calculate the compound annual growth rate (CAGR) of an investment over a period of years.
52 If Cell is Blank: Use the IF function and an empty string in Excel to check if a cell is blank. Use IF and ISBLANK to produce the exact same result.
53 Average: The AVERAGE function in Excel calculates the average (arithmetic mean) of a group of numbers.
54 Substring: There’s no SUBSTRING function in Excel. Use MID, LEFT, RIGHT, FIND, LEN, SUBSTITUTE, REPT, TRIM and MAX in Excel to extract substrings.
55 Count Characters: Learn how to count the number of characters in a cell or range of cells and how to count how many times a specific character occurs in a cell or range of cells.
56 Sum: Use the SUM function in Excel to sum a range of cells, an entire column or non-contiguous cells.
57 Compare Two Columns: To compare two columns, use IF, ISERROR and MATCH in Excel. You can display the duplicates or the unique values.
58 Divide: There’s no DIVIDE function in Excel. Simply use the forward slash (/) to divide numbers in Excel.
59 Remove Spaces: The TRIM function in Excel removes leading spaces, extra spaces and trailing spaces. Use the SUBSTITUTE function to remove all spaces or non-breaking spaces.
60 Move Columns: To move columns in Excel, use the shift key or use Insert Cut Cells. You can also change the order of all columns in one magic move.
61 Hide Columns or Rows: Sometimes it can be useful to hide columns or rows in Excel.
62 Check Mark: To insert a check mark symbol in Excel, simply press SHIFT + P and use the Wingdings 2 font. You can also insert a checkbox in Excel.
63 Insert Row: To quickly insert a row in Excel, select a row and use the shortcut CTRL SHIFT +.
64 Comparison Operators: Use comparison operators in Excel to check if two values are equal to each other, if one value is greater than another value, etc.
65 NPV: The correct NPV formula in Excel uses the NPV function to calculate the present value of a series of future cash flows and subtracts the initial investment.
66 Bullet Points: This page illustrates three ways to insert bullet points in Excel.
67 AverageIf: The AVERAGEIF function in Excel calculates the average of cells that meet one criteria. AVERAGEIFS calculates the average of cells that meet multiple criteria.
68 Box and Whisker Plot: This example teaches you how to create a box and whisker plot in Excel. A box and whisker plot shows the minimum value, first quartile, median, third quartile and maximum value of a data set.
69 Hyperlinks: Use the ‘Insert Hyperlink’ dialog box in Excel to create a hyperlink to an existing file, a web page or a place in this document. You can also use the HYPERLINK function.
70 Shade Alternate Rows: This example shows you how to use conditional formatting to shade alternate rows.
71 IRR: Use the IRR function in Excel to calculate a project’s internal rate of return.
72 Time Difference: Calculating the difference between two times in Excel can be tricky. Times are handled internally as numbers between 0 and 1.
73 Quick Analysis: Use the Quick Analysis tool in Excel to quickly analyze your data. Quickly calculate totals, quickly insert tables, quickly apply conditional formatting and more.
74 Strikethrough: This example teaches you how to apply strikethrough formatting in Excel.
75 Today’s Date: To enter today’s date in Excel, use the TODAY function. To enter the current date and time, use the NOW function.
76 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.
77 Forecast: The FORECAST.LINEAR function in Excel predicts a future value along a linear trend. The FORECAST.ETS function in Excel predicts a future value using Exponential Triple Smoothing, which takes into account seasonality.
78 Slicers: Use slicers in Excel to quickly and easily filter pivot tables. Connect multiple slicers to multiple pivot tables to create awesome reports.
79 Split Cells: To split the contents of a cell into multiple cells, use the Text to Columns wizard, flash fill or formulas.
80 Calendar: This example describes how to create a calendar in Excel (2023 calendar, 2024 calendar, etc). If you are in a hurry, simply download the Excel file.
81 Xlookup: If you have Excel 365, use XLOOKUP instead of VLOOKUP. The XLOOKUP function is easier to use and has some additional advantages.
82 Flash Fill: Flash fill is a great Excel tool. Learn how to use flash fill to automatically extract data, combine data, and much more.
83 Square Root: The square root of a number is a value that, when multiplied by itself, gives the number. The SQRT function in Excel returns the square root of a number.
84 Absolute Reference: An absolute reference in Excel refers to a fixed location on a worksheet. When you copy a formula, an absolute reference never changes.
85 Randomize List: This article teaches you how to randomize (shuffle) a list in Excel.
86 Circular Reference: A circular reference in Excel occurs when a formula directly or indirectly refers to its own cell. This is not possible.
87 Running Total: This page teaches you how to create a running total (cumulative sum) in Excel. A running total changes each time new data is added to a list.
88 AutoFit: You probably know how to change the width of a column in Excel, but do you also know how to automatically fit the widest entry in a column?
89 PDF: This page teaches you how to convert an Excel file to a PDF file.
90 Dependent Drop-down Lists: This page describes how to create dependent drop-down lists in Excel. Impress your co-workers with this cool trick.
91 Add or Subtract Time: Use the TIME function in Excel to add or subtract hours, minutes and seconds. To add up times in Excel, simply use the SUM function.
92 Frequency: The FREQUENCY function in Excel calculates how often values occur within the ranges you specify in a bin table.
93 Trendline: This example teaches you how to add a trendline to a chart in Excel.
94 Not Equal To: In Excel, means not equal to. The operator in Excel checks if two values are not equal to each other. Let’s take a look at a few examples.
95 Weekdays: Use WEEKDAY, NETWORKDAYS and WORKDAY to create cool weekday formulas in Excel. Are you ready to improve your Excel skills?
96 AutoFill: Use AutoFill in Excel to automatically fill a series of cells. This page contains many easy to follow AutoFill examples.
97 Entire Rows and Columns: This example teaches you how to select entire rows and columns in Excel VBA. Are you ready?
98 Combination Chart: A combination chart is a chart that combines two or more chart types in a single chart.
99 Copy a Formula: Simply use CTRL + c and CTRL + v to copy and paste a formula in Excel. Use the fill handle in Excel to quickly copy a formula to other cells.
100 Rank: The RANK function in Excel returns the rank of a number in a list of numbers. Use RANK.AVG to return the average rank if more than one number has the same rank.
Check out all 300 examples.
Award Winning Maths & English Tuition
See your child achieve real progress and unlock the joy of learning.
Book free trial
In centre and online tuition for children ages 4-16
Weekly tuition, smart learning tools and 20 years of success
Achieve real progress
From Reception to Year 11, we tailor our approach to every child to best support their entire learning journey.
Find out more
You’re in control
There’s no joining fee, you can cancel anytime and choose from centre or online tuition.
Build a membership that’s right for you.
Try for free
Our tutors are DBS checked, interviewed personally, employed and trained by us so you can be assured you’re in safe hands.
Meet our tutors
Learning a new way
Through smart technology and regular assessment we create an individual learning pathway that delivers maximum progress.
Find out more
Our tuition subjects
Discover what your child can achieve with a brilliant tutor and a curriculum tailored to their individual needs.
How it works
Explore Learning is trusted by parents, recommended by teachers and loved by kids.
See all results & reviews
*Based on the average Explore Learning member doing 1 hour of tutored or independent learning per subject per week
Our 10 year old daughter has shown significant progress in English and maths since her 121 online sessions started. Both her confidence and enthusiasm for learning have massively improved. .. We are so grateful for the support Explore are giving her in the lead up to her SATs in year 6. Thank you!
Our son has been doing online lessons during Years 8 and 9. He finds it engaging and really enjoys his sessions. Also, it’s helped him immensely at school. His maths teacher told us that only twelve other students had reached his level in maths, amongst 360 students in his year. She is planning for him to do further maths at GCSE. His English teacher said that he is at the top of his class. I don’t think any of that would have happened without the additional input of Explore Learning.
I am extremely happy with Explore Learning! My daughter Mila started a few years ago and then since Covid she has one to one online lessons. She has just successfully passed 11+ exams to the best Grammar Schools in our area and we could not be happier. Explore Learning plays a huge part not only in Mila’s academic achievements but also in building her confidence, curiosity and love for learning. Thank you so much!
How to find an Explore Learning tuition centre near me?
With nearly 100 centres throughout the UK, there’s bound to be a centre nearby. Book a free assessment at your closest tuition centre.
Group vs one-to-one: which is the best for my child?
We offer small group tuition in our tuition centres where a tutor will support your child and a couple of others at the same time. Children benefit from the company of their peers and celebrate each other’s success whilst they work on their own bespoke programme of work. Students work independently with the support of a tutor whenever they need it. This social environment is a great confidence booster and helps children feel that they are in a club whilst receiving personal tutoring.
Our online one-to-one tuition is a good solution for focused support, for children who are easily distracted and who need careful coaching to help build self-esteem and resilience. If you’re seeking a private English tutor or maths teacher this can be a good place to start. We will work on building the skills to transfer into a more social learning setting.
Is there a “right” age to start tutoring?
Children of all ages and abilities can benefit from the support of a tutor.
A tutor’s role is to spend a little more time developing and coaching the skills that a child is learning in the classroom. These are different for every child. Children aged five are learning how to communicate, follow instructions and develop concentration skills. Whilst a child starting secondary school might have specific areas of difficulty that they are looking for support with.
There are many different reasons that you may seek out a tutor and it’s reassuring to know that whatever age your child is, adding someone else to their circle of trusted people, cheering them on will also be a great thing.
How much does Explore Learning tutoring cost?
Tuition fees start from £109 per month at Explore Learning.