spreadsheet basics assignment

Basic tasks in Excel

Excel is an incredibly powerful tool for getting meaning out of vast amounts of data. But it also works really well for simple calculations and tracking almost any kind of information. The key for unlocking all that potential is the grid of cells. Cells can contain numbers, text, or formulas. You put data in your cells and group them in rows and columns. That allows you to add up your data, sort and filter it, put it in tables, and build great-looking charts. Let’s go through the basic steps to get you started.

Create a new workbook

Excel documents are called workbooks. Each workbook has sheets, typically called spreadsheets. You can add as many sheets as you want to a workbook, or you can create new workbooks to keep your data separate.

Click File , and then click New .

Under New , click the Blank workbook .

Enter your data

Click an empty cell.

For example, cell A1 on a new sheet. Cells are referenced by their location in the row and column on the sheet, so cell A1 is in the first row of column A.

Type text or a number in the cell.

Press Enter or Tab to move to the next cell.

Apply cell borders

Select the cell or range of cells that you want to add a border to.

On the Home tab, in the Font group, click the arrow next to Borders, and then click the border style that you want.

For more information, see Apply or remove cell borders on a worksheet  .

Apply cell shading

Select the cell or range of cells that you want to apply cell shading to.

For more information about how to apply formatting to a worksheet, see Format a worksheet .

Use AutoSum to add your data

When you’ve entered numbers in your sheet, you might want to add them up. A fast way to do that is by using AutoSum.

Select the cell to the right or below the numbers you want to add.

Click the Home tab, and then click AutoSum in the Editing group.

AutoSum adds up the numbers and shows the result in the cell you selected.

For more information, see Use AutoSum to sum numbers

Create a simple formula

Adding numbers is just one of the things you can do, but Excel can do other math as well. Try some simple formulas to add, subtract, multiply, or divide your numbers.

Pick a cell, and then type an equal sign (=).

That tells Excel that this cell will contain a formula.

Type a combination of numbers and calculation operators, like the plus sign (+) for addition, the minus sign (-) for subtraction, the asterisk (*) for multiplication, or the forward slash (/) for division.

For example, enter =2+4 , =4-2 , =2*4 , or =4/2 .

Press Enter.

This runs the calculation.

You can also press Ctrl+Enter if you want the cursor to stay on the active cell.

For more information, see Create a simple formula .

Apply a number format

To distinguish between different types of numbers, add a format, like currency, percentages, or dates.

Select the cells that have numbers you want to format.

Click the Home tab, and then click the arrow in the General box.

Pick a number format.

If you don’t see the number format you’re looking for, click More Number Formats . For more information, see Available number formats .

Put your data in a table

A simple way to access Excel’s power is to put your data in a table. That lets you quickly filter or sort your data.

Select your data by clicking the first cell and dragging to the last cell in your data.

To use the keyboard, hold down Shift while you press the arrow keys to select your data.

Click Tables , move your cursor to the Table button to preview your data, and then click the Table button.

To filter the data, clear the Select All check box, and then select the data you want to show in your table.

To sort the data, click Sort A to Z or Sort Z to A .

For more information, see Create or delete an Excel table

Show totals for your numbers using Quick Analysis

The Quick Analysis tool (Excel 2016) let you total your numbers quickly. Whether it’s a sum, average, or count you want, Excel shows the calculation results right below or next to your numbers.

Select the cells that contain numbers you want to add or count.

Click Totals , move your cursor across the buttons to see the calculation results for your data, and then click the button to apply the totals.

Add meaning to your data using Quick Analysis

Conditional formatting or sparklines can highlight your most important data or show data trends. Use the Quick Analysis tool (Excel 2016) for a Live Preview to try it out.

Select the data you want to examine more closely.

Explore the options on the Formatting and Sparklines tabs to see how they affect your data.

For example, pick a color scale in the Formatting gallery to differentiate high, medium, and low temperatures.

When you like what you see, click that option.

Learn more about how to analyze trends in data using sparklines .

Show your data in a chart using Quick Analysis

The Quick Analysis tool (Excel 2016) recommends the right chart for your data and gives you a visual presentation in just a few clicks.

Select the cells that contain the data you want to show in a chart.

Click the Charts tab, move across the recommended charts to see which one looks best for your data, and then click the one that you want.

Note:  Excel shows different charts in this gallery, depending on what’s recommended for your data.

Learn about other ways to create a chart .

Sort your data

To quickly sort your data

Select a range of data, such as A1:L5 (multiple rows and columns) or C1:C80 (a single column). The range can include titles that you created to identify columns or rows.

Select a single cell in the column on which you want to sort.

To sort by specific criteria

Select a single cell anywhere in the range that you want to sort.

On the Data tab, in the Sort & Filter group, choose Sort .

The Sort dialog box appears.

In the Sort by list, select the first column on which you want to sort.

In the Sort On list, select either Values , Cell Color , Font Color , or Cell Icon .

In the Order list, select the order that you want to apply to the sort operation — alphabetically or numerically ascending or descending (that is, A to Z or Z to A for text or lower to higher or higher to lower for numbers).

For more information about how to sort data, see Sort data in a range or table  .

Filter your data

Select the data that you want to filter.

On the Data tab, in the Sort & Filter group, click Filter .

To select by values, in the list, clear the (Select All) check box. This removes the check marks from all the check boxes. Then, select only the values you want to see, and click OK to see the results.

For more information about how to filter data, see Filter data in a range or table .

Save your work

Click the Save button on the Quick Access Toolbar , or press Ctrl+S.

If you’ve saved your work before, you’re done.

If this is the first time you've save this file:

Under Save As , pick where to save your workbook, and then browse to a folder.

In the File name box, enter a name for your workbook.

Click Save .

Print your work

Click File , and then click Print , or press Ctrl+P.

Preview the pages by clicking the Next Page and Previous Page arrows.

The preview window displays the pages in black and white or in color, depending on your printer settings.

If you don’t like how your pages will be printed, you can change page margins or add page breaks .

Click Print .

Activate and use an add-in

On the File tab, choose Options , and then choose the Add-Ins category.

Near the bottom of the Excel Options dialog box, make sure that Excel Add-ins is selected in the Manage box, and then click Go .

In the Add-Ins dialog box, select the check boxes the add-ins that you want to use, and then click OK .

If Excel displays a message that states it can't run this add-in and prompts you to install it, click Yes to install the add-ins.

For more information about how to use add-ins, see Add or remove add-ins .

Find and apply a template

Excel allows you to apply built-in templates, to apply your own custom templates, and to search from a variety of templates on Office.com. Office.com provides a wide selection of popular Excel templates, including budgets.

For more information about how to find and apply templates, see Download free, pre-built templates .

Need more help?

Want more options.

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Microsoft 365 subscription benefits

Microsoft 365 training

Microsoft security

Accessibility center

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Ask the Microsoft Community

Microsoft Tech Community

Windows Insiders

Microsoft 365 Insiders

Was this information helpful?

Thank you for your feedback.

Excel Beginner Exercises

In this article, I’m going to walk you through a couple of Excel exercises that are perfect for beginners. We will slowly ramp up the difficulty from beginner to advanced so if things are too easy for you, just scroll down a bit.

Getting started with formulas

‘Formulas?!’ You may be thinking. ‘That’s way too advanced for a first Excel beginner exercise.’ It’s not really. Let me explain why: formulas and functions are the bread and butter of Excel. If you want to work with Excel, it is wise to at least know what a formula looks like and why a formula is handy. That’s why we’re starting with this. Don’t worry, they are really not as complicated as they sound.

So let’s jump into it. We will be calculating the result of 32+57. However, we won’t be doing that ourselves, we will be making Excel do the hard work for us.

To start with a formula in Excel, we have to fill in the equals sign = into a cell. After that, we add our formula, so 32+57 in this case. The resulting cell content becomes =32+57 .

Note: all of our exercises have a Show answer button in the top-right that you can click if you cannot figure out what the answer has to be. After clicking Show answer , you can click on the cell to see the formula that was used in the formula bar. You can also reset the editor back to its default contents using the Reset button.

I hope the number 89 is showing in cell A1 of the spreadsheet editor above. The cool thing about this is that you can substitute the + for a minus – and it will also work. Or you can use the asterisk * to multiply. Or the slash / to divide. You can try all of these different calculations in the editor above if you want.

And just like that, you have learned how Excel formulas work! You can now get rid of your calculator 😉

Using Excel beginner functions: SUM

Now that we’ve seen how to include formulas in Excel spreadsheets, we can get to the real deal: functions. Functions are basically formulas with names. It’s easiest to understand with an example:

The SUM function will sum the values that you give it. We can recreate the formula that we created in the exercise above ( =32+57 ), but using the SUM function. That would look like this:

=SUM(32,57)

If you write this in a cell, it will show 89 . Exactly as you may expect. But you can add more numbers (separated by commas) to the function: =SUM(32,57,1) will result in 90, for example.

In this next exercise, we will combine the SUM function with another interesting Excel feature: references. So what are references? Once again, an example will explain this very quickly. Look at the following formula:

=SUM(A1,A2)

What do you think the result will be? The answer is: it depends. That’s because the formula uses references to cells A1 and A2 .

We know the SUM function will sum the values that you give it, but in this case we give it references to cells. When you do that, it will instead sum the contents of the cells that you reference. So the result will be different depending on the values in cells A1 and A2 . If cell A1 contains 1 and cell A2 contains 2 , then the result will be 3 .

These references can be super handy because they update automatically if the contents of the cells change. Whenever you edit the value in cell A1 , the result of =SUM(A1, A2) will also automatically update! And that’s why references are so ridiculously useful.

Now, let’s get to the exercise. We will be using the SUM function to calculate our total monthly income after expenses.

Calculating income using SUM

I hope that wasn’t too difficult. Or if it was a little difficult, that when you looked at the answer, it made sense.

Note about the answer: if you looked at the answer to the above exercise, you saw a notation that you may not have seen before. =SUM(B2:B5) . The colon : is used to mean a cell range . In this case, that means cells B2 up to and including B5 . So it is equivalent to using =SUM(B2,B3,B4,B5) . In Excel, there are often multiple ways of solving the same problem. I’d encourage you to use the solution that is most intuitive to you.

A step up: Average

Calculating the average of a group of numbers is quite simple: you sum them all up and divide by how many number you have. For example, the average of the number 1, 2, 3, 4 and 5 is: 1 + 2 + 3 + 4 + 5 divided by 5, because there are 5 numbers.

You could do this in Excel by typing =SUM(1,2,3,4,5)/5 into a cell. But there is an easier way. You can simply use the AVERAGE function. Let’s do so in an Excel exercise.

Note: you may have noticed by now that both of these functions are written in all-caps. That’s just the way function names in Excel are. So it may look like I’m screaming SUM at you, but that’s just how it is written.

More practical: Concatenate

We’ve seen functions that use numbers, now let’s look at another type of function: text functions. They are functions that take text as input or that result in text output (or usually both).

Before we get to the exercise, you need to know something about text in Excel formulas. Texts in Excel formulas are almost always surrounded by double quotes “. That’s just the way to let Excel know that it is a text.

Concatenate first and last names exercise

For the fourth of our Excel beginner exercises, we will be combining the contents of two cells. The first cell will have a first name, the second cell will have a last name in it. We would like to fill the third cell with the first name, then a space and then the last name.

We can do this using the CONCATENATE function. The CONCATENATE function looks like this: =CONCATENATE("text1","text2","text3") . If we would run this function, it would result in text1text2text3 . So it just combines the texts that you give it.

More Excel Exercises

That was it for our Excel beginner exercises. I hope you’ve learned something new today. If you just can’t get enough of these types of exercises, we have an Excel exercises page filled to the brim with exercises to dig your teeth into.

5 thoughts on “Excel Beginner Exercises”

• Pingback: How to Learn Excel Fast: 3 Principles to Learn Excel Quickly

Helpful and clear for beginners.

Written with very clear instructions except with the CONCATENATE. Unfortunately I cannot figure this simple formula.

This is awesome

Leave a Comment Cancel reply

Save my name, email, and website in this browser for the next time I comment.

Learn to automate and grow your business with spreadsheets

• Error Troubleshooting
• Free PDF Cheat Sheet
• Ultimate Cheat Sheet spreadsheet
• Microsoft Excel Templates
• Google Sheets Templates
• Full dashboards course
• Basic dashboard tutorial
• Hire an expert
• All Excel Lessons
• Excel Templates
• Excel Formulas
• Excel Formatting
• Excel Error Troubleshooting

Beginner’s tutorial for Google Sheets

In this tutorial, I am going to teach you how to use Google Sheets from the ground up. You will learn all of the important things that you need to know to work with Google Sheets in the professional world, from how to create and format sheet, to using formulas and performing mathematical operations.

This lesson will get you up to speed on a lot of really important Google Sheets concepts, that you should know if you are going to be working in Google Sheets often.

Throughout the tutorial, you will find links to more in-depth lessons for some of the important topics, so feel free to expand your knowledge on these subjects and formulas.

After completing this beginner's course, take your skills to the next level with the free dashboards and data analytics course .

And don't forget to get your free Google Sheets cheat sheet

You may also be interested in learning the most essential formulas in Google Sheets. Check out this template / tutorial on using the best formulas in Google Sheets .

Below you will find a table of contents that shows everything that you will learn in this article / video. Timestamps are also included so that you can easily navigate through the video. These concepts are taught while building a single spreadsheet that displays test grades, and so you can simply follow along to learn each concept.

Table of contents for the VIDEO tutorial

0:00 Introduction / Creating a new sheet 1:13 About cells, cell addresses, rows, columns 2:03 Selecting multiple cells i.e. "Ranges" 2:37 Typing ranges and references 3:04 Navigating through the cells 3:34 Selecting rows and columns 5:30 Selecting non-adjacent cells, rows, and columns 6:10 Adjusting column width and row height 7:46 Adjusting multiple columns or rows at once 8:57 Entering text and numbers (Values) into cells 11:09 Cell formatting: Fill color, text color, font size, font style, alignment, wrap 13:04 Autofit column width (Automatically adjust width) 15:20 Copying and pasting cells (Without formulas) 16:47 Entering formulas (Division) 17:30 Changing the format of the cell values (Percentage) 18:05 Copying and pasting formulas 19:18 Using autofill / fill down to copy formulas 20:19 Fill right 21:29 Deleting cell contents 22:19 Freezing rows and columns 23:29 Adding new rows and columns 24:36 Deleting columns and rows 25:08 Absolute and relative cell references (Locking references) 27:37 Mathematical operators (Addition, subtraction, multiplication, division) 28:14 Quick selection shortcuts, and fill down / fill right shortcuts 30:01 Using ARRAYFORMULA to extend formulas 31:43 Cell references (Referring to a single cell) 32:30 Adding new tabs 32:47 Referring to cells from another sheet 33:30 Renaming tabs 34:29 Copying formatting with "Paint Format" 35:05 Referring to an entire column with a single formula 36:17 Moving cells, rows, and columns 38:08 The 3 cursor positions (Select, move, and fill) 39:08 Cutting cells, rows, and columns 40:05 Duplicating tabs 40:31 Deleting tabs 40:58 Using the IF function (If / Then statement)

Table of Contents

How to create a new blank Google spreadsheet

To create a new, blank Google spreadsheet, follow these steps:

• Login to your Google / Gmail account
• Go to drive.google.com
• Click the big button on the top left that says "New"
• Click "Google Sheets

By following the steps above, a blank Google spreadsheet will open. Change the name of the sheet or edit any of the cells to save the spreadsheet in your Google Drive.

About cells, cell addresses, rows, columns

Every cell in a spreadsheet has an address. With a cell address the column is stated first, and then the row. For example, cell C5 is in column C, and in row 5.

To select a cell, click your mouse one time on the cell that you would like to select.

You must select a cell before you enter text or numbers into it, or before you change the formatting of that cell.

Select multiple cells i.e. "Ranges"

You can also select multiple cells at once in a Google spreadsheet, or in other words you can select a range of cells.

To select a range of cells, follow these steps:

• Click once in the middle of the cell that is at the top left of the range that you would like to select, and hold your click
• Drag your cursor right, downwards, or both, and then release your click when you have highlighted all of the cells that you want to select

Type / notate ranges and references

To use formulas, you will need to know how to type references to cell ranges.

To type the reference to a range of cells, type the reference of the first cell (at the top left of the range), then type a colon ":", and then type the reference of the last cell (at the bottom right of the range).

For example, if you wanted to notate the range of cells that spans from cell A1, to cell D7, you would type A1:D7.

This reference can be read as "A1 through D7″.

Navigate through the cells

There are multiple ways that you can navigate to the cell that you want to select in your Google spreadsheet.

To navigate through the cells, do either of the following:

• Click once on the cell that you want to select, and use the vertical and horizontal scroll options to access the desired cell if needed)
• Or use the arrow keys on the keyboard to move from cell to cell in the direction that you specify.

Select rows and columns

In addition to being able to select cells and ranges of cells, you can also select entire columns or rows in a Google spreadsheet.

Select a column

To select a column, click on the top of the column that you want to select, on the letter that represents which column that it is, and you will have selected the entire column and all of the cells within it.

Select a row

To select a row, click on the left of the row that you want to select, on the number that represents which row that it is, and you will have selected the entire row and all of the cells within it.

Select multiple columns

To select multiple columns at once, click at the top of the first column that you want to select, hold your click, drag your cursor to the right, and release your click when you have selected all of the desired columns.

Select multiple rows

To select multiple rows at once, click at the left of the first row that you want to select, hold your click, drag your cursor downwards, and release your click when you have selected all of the desired rows.

Select non-adjacent cells, rows, and columns

You can also select multiple cells that are not right next to each other in Google Sheets.

Select non-adjacent cells

To select non-adjacent cells, click once on the first cell that you want to select, then hold "Ctrl" on the keyboard, and then click on the other cells that you want to select.

You can do this same thing with rows and columns.

Select non-adjacent columns

To select non-adjacent columns, click once on the first column that you want to select, then hold "Ctrl" on the keyboard, and then click on the other columns that you would like to select.

Select non-adjacent rows

To select non-adjacent rows, click once on the first row that you want to select, then hold "Ctrl" on the keyboard, and then click on the other rows that you would like to select.

Adjust column width and row height

You can easily adjust the width of columns , and the change the height of rows in your spreadsheet.

Adjust column width

To adjust the width of a column, follow these steps:

• Hover your cursor at the top right of the column that you want to adjust (over the line that separates that column and the column beside it), where the double arrows that point left and right appear
• Click your mouse and hold the click, then drag your cursor left (to shrink) or right (to expand), and release your click when the column is the desired width.

Adjust row height

To adjust the height of a row, follow these steps:

• Hover your cursor at the left of the row that you want to adjust (over the line that separates that row and the row below it), where the double arrows that point up and down appear
• Click your mouse and hold the click, then drag your cursor upwards (to shrink) or downwards (to expand), and release your click when the row is the desired height.

Note that if there is text in any of the cells within a row, the font size will also determine the row height.

Adjust multiple columns or rows at once

You can also adjust the width of multiple columns or rows at once in Google Sheets.

Adjust width of multiple columns

To adjust the width of multiple columns at once, select the columns that you want to adjust, then adjust the width of one of the select columns, and the changes will apply to all of the select columns.

Adjust height of multiple rows

To adjust the height of multiple columns at once, select the rows that you want to adjust, then adjust the height of one of the select rows, and the changes will apply to all of the select rows.

Enter text and numbers into cells (Entering values)

There are multiple ways that you can enter text and numbers into the cells of a spreadsheet.

To enter a value into a cell, select the cell that you want to enter text or numbers into, then do any of the following:

• Start typing, then press enter after typing the desired values
• Or double click on the cell, then start typing (Press enter when done)
• Or click your cursor into the formula bar, then start typing (Press enter when done)

If you choose to simply start typing when a cell is selected, your new text will replace the old text after pressing enter, where the other two methods will allow you to modify existing text.

Cell formatting

Each cell, row, or column can be formatted individually in Google Sheets. Formatting the cells by using color , and different font styles will make your sheet very organized, and professional.

To format a spreadsheet cell, first select the cell or range of cells that you want the formatting changes to apply to, and then apply the formatting that you want.

Change the fill color (Background Color)

To change the background color of a cell, select the cell that you want to format, click the "Fill color" menu on the top toolbar (looks like a spilling paint bucket), and then select the color that you want.

Below is an example of the color palette in Google Sheets, which you will see when opening any of the color selection menus.

Set the font

To change the font in a cell, select the cell that you want to format, click the "Font" drop-down menu on the top toolbar, and then select the font that you want.

Change the text color

To change the color of the text in Google Sheets, select the cell or cells that you want to modify, click the large letter "A" on the top toolbar to open the "Text color" menu, and then select the color that you want your text to be.

Change the font size

To change the size of the font in Google Sheets, select the cell or cells that you want to modify, click the "Font size" drop-down menu on the top toolbar (directly to the right of the "Font" selection), and then select the size of font that you want to use.

Set the font style

To change the styling of the font in Google Sheets (bold, italic, etc.), select the cell or cells that you want to modify, and then click "bold" or another desired font style on the top toolbar.

Align the text / values

To change the alignment of the cell contents in Google sheets, select the cell or cells that you want to align, then open the alignment menu on the top toolbar and either select, "Left", "Center", or "Right".

Wrap text in the cells

In a spreadsheet you can "Wrap" text , so that when the text reaches the end of the cell it will continue on a new line.

To wrap the text inside cells, select the cell or cells that you want to wrap, then open the "Text Wrapping" menu on the top toolbar, and then select "Wrap".

Automatically adjust column width

In your spreadsheet, if you want you can automatically adjust the width of the columns (autofit) so that the columns fit the text inside them. This feature is called "Fit to data", and although it can be accessed via menus, the easiest way to use it is by using the shortcut described below.

To automatically adjust column width, follow these steps:

• Select the column or columns that you want to adjust
• Hover your cursor at the top right of any of the select columns, over the barrier that separates the column to be adjusted and the column to the right of it, where the the double arrows that point left and right appear
• Double click your mouse, and all of the selected columns will adjust to fit the longest string of text in each column

Copy and paste cells

Copying and pasting cells makes completing spreadsheet tasks much faster and easier. First let's go over simple copying and pasting, and then later I'll show you what happens when you copy and paste cells that have formulas in them.

The easiest way to copy and paste, is by using the keyboard shortcuts that are described and displayed, below.

To copy and paste cells, follow these steps:

• Select the cell or range of cells that you want to copy
• Hold the "Ctrl" key on the keyboard, and then press "C", to copy the cell
• Select the cell where you want to paste your selection
• Hold the "Ctrl" key on the keyboard, and then press "V", to paste the selection

After copying a cell, you will see a dotted line appear around the cell that has been copied (or the range that was copied).

When you copy and paste a cell that does not have a formula in it, Google Sheets will copy the contents and formatting of the cell, exactly.

If you want to copy and paste only values , without transferring formulas or formatting, hold "Ctrl" on the keyboard and then press "C" to copy the selection like normal, but then hold "Ctrl" AND "Shift" on the keyboard, and then press "V" to paste only values.

The shortcut Ctrl + Shift + V will paste only values in Google Sheets.

How to enter formulas

Formulas allow you to do a wide array of very useful tasks in a spreadsheet.

To enter a formula in a Google spreadsheet, follow these steps:

• Select the cell that you want to enter a formula into
• Type an equals sign
• Type a formula or function, such as =A2/B2 (Cell A2 divided by cell B2)

Change the format of the cell values (i.e. Percentage)

Another way that you can change the formatting of the cells in a spreadsheet, is by changing the formatting of the values (contents of the cell such as text or numbers).

To change the formatting of the values in a Google spreadsheet (For example: "Plain text", "Number", "Currency, "Percent"), follow these steps:

• Select the cell or range of cells that you want to apply the formatting to
• On the top toolbar, open the "More formats" menu (Button that says "123")
• Select the format that you want the cell values to be in, such as "Percent"

Copy and paste formulas

We already went over what happens when you copy and paste cells that have normal values entered into them, such as text and numbers, but now let's go over how to copy and paste formulas in your spreadsheet.

To copy and paste formulas in a Google spreadsheet, follow these steps:

• Select the cell that contains the formula which you want to copy
• Hold "Ctrl" on the keyboard and then press the "C" key, to copy the cell
• Select the cell where you want to copy the formula to
• Hold "Ctrl" on the keyboard and then press the "V" key to paste the selection / formula

When you copy and paste a formula, the references to cells / cell ranges will adjust when the formula is pasted into a new cell.

When you copy and paste the formula to the right or left, the column references will change.

When you copy and paste a formula up or down, the row references will change.

For example, as shown in the image above, when the division formula was copied from cell C2 and then pasted into cell C3, the formula changed from =A2/B2 to =A3/B3.

In most cases you will want your formula references to change when you copy and paste, but in some cases you will want to stop this from happening, and I will show you how to do this later.

Use autofill / fill down to copy formulas

Copying and pasting is not the only way to copy formulas into other cells. You can also use "Autofill" to quickly copy formulas . Autofill will allow you to fill formulas downwards, or to the right. Let's go over using "Fill down".

To use autofill / fill down to copy your formulas downwards, follow these steps:

• Select the cell that contains the formula that you want to copy
• Hover your cursor at the bottom right corner of that cell, until the cross / plus sign (+) appears (this is called the "fill handle")
• Click your mouse, hold the click, and then drag your cursor downwards
• Release your click when you reach the last cell that you want the formula to be copied into

Just like with copying and pasting your formulas, using autofill will adjust your cell references when the formula is copied into new cells.

Fill formulas to the right

You can also use autofill to copy formulas to the right.

To use autofill / fill right to copy your formulas to the right, follow these steps:

• Hover your cursor near the bottom right corner of the selected cell, until the cross / plus sign (+) appears (Named the "fill handle")
• Click your mouse, hold the click, and then drag your cursor to the right

Delete cell contents

To delete the contents of a spreadsheet cell, select the cell or range of cells that you want to delete the contents of, then press the "Delete" key on the keyboard.

This content was originally created by SpreadsheetClass.com

Freeze rows and columns

You can freeze rows and columns in Google Sheets, so that when you scroll, the frozen columns will remain in view at the left side of the spreadsheet, and the frozen rows will remain in view at the top of the spreadsheet.

To freeze rows and / or columns in your spreadsheet, follow these steps:

• On the top toolbar, click "View"
• Hover your cursor over "Freeze"
• Select the number of columns or rows that you want to freeze

Add new rows and columns

You can choose to add rows at the bottom of your Google spreadsheet, or you can also add rows or add columns to a specified location.

To insert rows at the bottom of the sheet, follow these steps:

• Scroll down to the bottom of the sheet
• Specify the number of rows to add (Default is 1,000)
• Click "Add"

To insert a new row at a specified location, follow these steps:

• Right-click a row that is either directly above or below the location where you want to add a row. (Select multiple rows before right-clicking, if you want to add multiple rows)
• Click "Insert 1 above" or "Insert 1 below"

To insert a new column at a specified location, follow these steps:

• Right-click a column that is either directly to the left or the right of the location where you want to add a column. (Select multiple columns before right-clicking, if you want to add multiple columns)
• Click "Insert 1 left" or "Insert 1 right"

Delete columns and rows

To delete rows in Google Sheets, select the row(s) that you want to delete, right-click on the selected row, then click "Delete row"

To delete columns in Google Sheets, select the column(s) that you want to delete, right-click on the selected column, then click "Delete column"

Absolute and relative cell references (Locking references)

If you want to "lock" your cell references in your formula, so that they do not change when you copy and paste the formula into other cells, there is an easy way to do this in Google Sheets.

To lock the references in your formula, type a dollar sign before the column letter or the row number that you want to remain the same when you copy and paste your formula.

For example, the formula shown above =A3/B$1 has a dollar sign before the row number of the reference to cell B1, which means that as the formula is copied and pasted downwards, the row reference will not change, and the formula will continue referring to cell B1.

As you can see in the example above, the "Total Points Possible" is listed in a single cell (B1), and this cell is referred to by each formula that was copied and pasted downwards, because of where the dollar sign is placed.

Relative references

Relative references WILL change when formulas are copied. These are normal references that do not contain dollar signs, such as =A1.

Absolute references

Absolute references do NOT change when formulas are copied. These references contain a dollar sign before the specified row / column, such as =$A$1.

Mathematical operators (Addition, subtraction, multiplication, division)

In Google Sheets, there are actual functions for performing mathematics in your spreadsheet (i.e. = ADD or SUBTRACT), but these functions are not used very often, due to the existence of mathematical operators.

To do math in a Google spreadsheet, use the following mathematical operators:

• Addition: To add, use a plus sign (+). For example: =1+2 or =A1+B1
• Subtraction: To subtract, use a minus sign (-). For example: =2-1 or =B1-A1
• Multiplication: To multiply, use an asterisk (*). For example: =5*7 or =C1*D3
• Division: To divide, use a forward slash (/). For example: =35/7 or =K2/D3

Keyboard shortcuts

There are several keyboard shortcuts in Google Sheets that will make your spreadsheet work much faster and easier. Some of the most useful shortcuts are those that help you select cells quickly, and those that help you fill formulas quickly.

Select cells to bottom of column shortcut

To select all of the cells to the bottom of a column (or to the bottom of the data if the cells are not blank), starting at a specified cell, follow these steps:

• Select the cell that is at the top of the range that you want to select
• Hold "Ctrl" on the keyboard
• Press the down arrow key

This will select all of the cells below the current cell… to the bottom of the column if the cells are blank, or to the bottom of the data / non-empty cells if there is data in the cells.

Autofill shortcuts

In addition to being able to use the fill handle / autofill to fill formulas downwards and to the right, Google Sheets provides shortcuts for these features as well.

Use the selection shortcut described above to help you select ranges quickly before using the autofill shortcuts.

Fill down shortcut

To use the keyboard shortcut to fill formulas down in your Google spreadsheet, follow these steps:

• Select the range that you want to fill formulas with, where the top cell in the selected range contains the formula that you want to copy downwards
• Press the "D" key

This will quickly fill / copy the formula in the top cell of the selected range, down to the bottom of the selected range, without having to take the time to drag the fill handle.

Fill right shortcut

To use the keyboard shortcut to fill formulas right in your Google spreadsheet, follow these steps:

• Select the range that you want to fill formulas with, where the cell that is farthest to the left in the selected range, contains the formula that you want to copy to the right
• Press the "R" key

Extend formulas by using a single formula

There is another easy way to apply your formulas to an entire range, column, or row in Google Sheets, by using ARRAYFORMULA to extend the functionality of a formula throughout multiple cells, by using a single formula in a single cell.

For the example below, we will use a division formula.

To extend a formula through a range by using a single formula, follow these steps:

• Select the cell that contains the formula that you want to extend downwards or to the right
• Type =ARRAYFORMULA( to begin the ARRAYFORMULA function
• Type a formula like you normally would, but then change the cell references to column references, for example this division formula =ARRAYFORMULA(A3:A/B$1)

This formula will apply the division formula to the entire column, starting at row 3.

Notice that the reference to cell B1 (B$1) was kept as a single cell reference with a dollar sign listed before the row, which allows the formula to continue referring to cell B1 as the formula is extended downwards.

Cell references (Referring to a single cell)

The simplest formula is a cell reference, which refers to the value that is in a single cell, and displays it in another cell.

To refer to a cell in your spreadsheet with a formula, follow these steps:

• Select the cell that you want to enter your formula / cell reference into, such as cell D2
• Type an equals sign (=)
• Type the address of the cell that you want to refer to, such as B2. The full formula will now look like this: =B2
• Press "Enter" on the keyboard

If entered into cell D2, the formula above will display the value that is in cell B2, inside of cell D2.

Add new tabs

To add new tabs to your Google spreadsheet, click the plus sign on the bottom left, to the left of the tabs names.

Refer to cells from another sheet

You can also refer to cells from other tabs if you want.

To refer to a a cell from another tab, follow these steps:

• Select the cell that you want to enter your formula / cell reference into
• Type the name of the tab that contains the cell that you want to reference. If the tab name contains a space, you must put the tab name inside of apostrophes, like this ='Sheet 1′
• Type an exclamation point (!)
• Type the address of the cell that you want to refer to, such as B2.The full formula will now look like this: ='Sheet 1′!B2

Again, note that you must include an apostrophe before and after the tab name, if the tab name contains a space in it.

You may include the apostrophes with tab names that do not contain a space and the formula will still function properly.

Rename tabs

To rename a tab in Google Sheets, right-click on the tab that you want to rename, and then click "Rename" (Or simply double-click on the tab name), type the new tab name, then press "Enter" on the keyboard.

Copy formatting with "Paint Format"

If you only want to copy the formatting of one cell / range to another, without copying the values or the formulas, you can do this with the "Paint format" feature.

To copy formatting from one cell or range to another cell or range, follow these steps:

• Select the cell or range of cells that contain the formatting that you want to copy
• On the top toolbar, click the "Paint format" button, which looks like a paint roller
• Select the cell that you want to transfer the formatting to, and if you had selected a range of cells before clicking "Paint format", then click the cell that is at the top left of the range that you want to transfer the formatting to

Refer to an entire column with a single formula

In addition to being able to refer to cells, you can also refer to range , rows, and columns in Google Sheets, by using the ARRAYFORMULA function.

To refer to a range of cells with a single formula, follow these steps:

• Select the cell where you want to enter your formula / begin your reference, such as cell D2
• Type =ARRAYFORMULA(
• Type the range that you want to refer to, such as B2:B. The full formula should now look like this =ARRAYFORMULA(B2:B)

If entered into cell D2, the formula above will display the values that are in column B, inside of column D, starting at row 2.

Move cells, rows, and columns

To move a cell, row, or column in Google Sheets, follow these steps:

• Select the cell, row, or column that you want to move
• Hover your cursor near the top of the cell or column that you want to move, or at the right of the row that you want to move, and your cursor will turn into hand, when your cursor is in the correct position
• Click your mouse, hold your click, and drag your cursor to the location that you want to move the selection to
• Release your click when your cursor is hovering over the place that you want to move the selection to

The 3 cursor positions (Select, move, and fill)

As a quick review, let's go over the 3 different positions that your cursor can be in before clicking within a cell, and what these 3 different positions are for.

• Select: Click in the middle of the cell, where the pointer displays, to select the cell
• Move: Click near the top of the cell, where the hand appears, to move the cell
• Fill: Click at the bottom right corner of the cell, where the cross / plus sign appears, to use autofill

Cut cells, rows, and columns

Cutting and pasting cells, rows, and columns has the same effect that moving them does.

To cut and paste a cell, row, or column, follow these steps:

• Select the cell, row, or column that you want to cut and then paste into another location
• Hold "Ctrl" on the keyboard, and then press "X" to cut the selection
• Select the cell, row, or column where you want to paste the selection
• Hold "Ctrl" on the keyboard, and then press "V" to paste the selection

Duplicate tabs

To duplicate a tab in Google Sheets, right-click on the tab that you want to duplicate, and then click "Duplicate"

Delete tabs

To delete a tab in Google Sheets, right-click on the tab that you want to delete, and the click "Delete"

Use the IF function (If / Then statement)

The IF function is a very common and very useful function in Google Sheets. With the IF function, you set a condition, and then you specify what value or formula to use if the condition is met (TRUE), and what value or formula to use if the condition is not met (FALSE).

In the example below, we will use the IF function to check whether or not a student's grade is passing, where the formula will display the word "Yes" if the score is at or above 60% (0.6), and where the word "No" will display if the score is below 60%.

To use the IF function to create and IF / THEN statement in Google Sheets, follow these steps:

• Select the cell that you want to enter your formula into
• Type a "condition" that compares two values / cells, such as B3>=0.6 (i.e. if cell B3 is greater than or equal to 0.6)
• Type a comma, and then enter the value (or cell reference) that you want to display if the condition is TRUE, such as "Yes"
• Type a comma, and then enter the value (or cell reference) that you want to display if the condition is FALSE, such as "No" . The full formula should now look like this: =IF(B3>=0.6, "Yes", "No")

The formula above will display the word "Yes" if the score in cell B3 is greater than or equal to 0.6, and will display the word "No" if the score in cell B3 is less than 0.6.

Related Posts:

• Build a Google Sheets dashboard in 3 simple steps
• Google Sheets Skills Test (Can you complete these projects?)
• How to build a dashboard in Google Sheets (Free Course)
• Fast & Simple dashboard tutorial in Google Sheets…
• Hire an expert Google Sheets developer
• 23 Best formulas for Google Sheets (+ Examples)

Welcome to Spreadsheet Class!

My name is Corey, I have been building spreadsheets for companies for over 7 years, I was a data specialist at an online school for 5 years, and I created this website to help people learn how to use spreadsheets.

Related posts

Google Sheets for Beginners

Use Google Sheets to create a budget for a celebration and perform calculations.

Example outcome

LEARN EXCEL - FREE ONLINE EXCEL TRAINING

26 Lessons, 12+ hours of Free Excel Training (Videos)

Absolutely FREE | No Sign-up Needed | Scroll Down and Start Learning

If you’re an Excel beginner (or an intermediate) and want to learn Excel, this is the perfect place for you to start.

This page gives you access to a completely FREE Online Excel Training (26 video lessons with 12+ hours of learning).

You don’t need to sign-up or do anything to get access to the course. Just scroll down and start watching the videos to learn Excel.

To make the most of this free training, please go through these Excel training videos in the sequence in which they have been listed. I have also divided these into 7 modules.

NOTE: In case the video looks a bit blurry, you can change the video quality to 720p (by clicking on the settings gear icon on the bottom right of the video screen)

In case you’re an intermediate or advanced user, feel free to pick the lessons you want to watch.

Also, in case you have any questions or any feedback for me, kindly leave it in the comments area (at the bottom of this page).

In case you find the videos useful and would like to support me, you can buy me a coffee ☕

Modules Covered in this Free Excel Training

Module 1 - excel basics (for beginners).

This video is meant for Excel beginners. In this video, I will show you the different parts of Excel working area.

In this video, you’ll learn about the following topics:

• Structure of the Excel working area,
• How to navigate in Excel,
• Ribbons and tabs,
• Quick Access Toolbar (QAT)
• Dialog Box & Task Panes,
• Customizing ribbons and QAT,
• What is an active cell
• How to use ALT shortcuts

Related Excel Articles:

• Creating Groups in Quick Access Toolbar

Once you know are comfortable with the layout of Excel, the next step is to learn how to enter and edit data in Excel.

You can enter three types of data in Excel – numeric, text, and formulas.

To enter data in any cell, just select the cell and start typing. Once done, press enter to move to the cell below. In case you are entering dates, enter it in a format that Excel recognizes as a date (such as 01-01-2020 or 01 Jan 2020 or 01/01/2020).

This video will show you how to enter data in Excel and edit already added data (such as deleting data, modifying existing data and replacing data).

Apart from this, it also covers the auto-fill in Excel as well as number formatting. 

• Fill Numbers in Cells without dragging
• 10 Excel Data Entry Tips for Beginners
• Excel Data Entry Forms  (Advanced)
• Custom Number formatting in Excel  (Advanced)

Click here to download the example Excel file

This video covers the basics of data formatting in Excel.

You can format data in Excel to make it look better and to highlight some data points. For example, if you have data-set and you want to highlight the negative numbers, you can simply highlight it in red color to it.

Here are some of the common formatting I use to make my data look better and more readable

• Applying borders to all cells
• Making headers bold
• Giving a background cell color to headers.
• Center align the headers

You can find these options in Home tab in the Font category.

• 5 Useful Excel Formatting Shortcuts
• How to Remove Cell Formatting in Excel

In this video of this Free Online Excel Training, you’ll learn how to work with cells and ranges in Excel.

Since a worksheet in Excel is made up for cells, if you want to become proficient in Excel, you need to know how to best work with cells and ranges.

And this video will teach you exactly that.

It covers the following topics:

• Cell address nomenclature
• Selecting cell/ranges in Excel
• Copying and moving cells/ranges in Excel
• Using paste special
• Selecting special cells
• Using find and replace to select cells
• Adding comments and
• Using quick analysis
• Find and Replace in Excel
• How to move Rows / Columns in Excel
• Insert New Columns in Excel
• Excel AUTOFIT: Make Rows/Columns Fit the Text Automatically

In this video of this Free Online Excel Training, you’ll learn how to manage worksheets in Excel.

• Navigating through worksheets in Excel
• Changing worksheet name and color
• Adding/deleting worksheets
• Hiding/Un-hiding worksheets
• Moving/copying worksheets
• Comparing worksheets side by side
• Splitting worksheet into panes
• Freeze panes
• Saving and opening workbooks
• Freeze Panes in Excel
• Hide Worksheets in Excel

In case you’re looking for advanced Excel training, please check out my other Free Online Excel training. I currently have the following three courses: Dashboard Course , VBA course , Power Query Course .

Module 2 - EXCEL ESSENTIALS

In this video of this Free Online Excel Training, you’ll learn how to use Excel tables.

Excel tables are amazing, especially if you plan to work with a lot of data/ dashboards /models. 

In this video, I cover the following topics:

• Creating an Excel Table
• Excel Table features
• Structured references
• Table slicers

Note that table slicers became available only from Excel 2013 version onward.

• Overview of Excel Tables
• How to Remove Table Formatting in Excel

In this video of this Free Online Excel Training, you will learn about tools that can help you when working with data in Excel.

In this lesson, I cover the following topics:

• Autofill : This allows you to quickly fill data in contiguous cells. For example, you can have ‘Jan’ and ‘Feb’ in two adjacent cells and then you can use Autofill to get the other month names
• Custom Lists : Custom lists allows you to create your own lists that you can use in Autofill. For example, if you have 20 names, you can create a custom list and then use Autofill to get all the names by just dragging the mouse
• Flash Fill : Flash fill is a new feature in Excel 2013 and allows you to identify a pattern in data and perform data slice and dice based on the pattern
• Fill Handle in Excel
• Flash Fill in Excel
• Create your own sorting criteria (with custom lists)
• Separate First and Last Name in Excel  (Using Flash Fill)

In this video of this Free Online Excel Training, you will learn all about number formatting in Excel.

This video covers the following topics:

• How to access number formatting options
• Using number formatting options using a dialog box
• Using custom number formatting

Remember that formatting a number in Excel only changes how it’s displayed, but the underlying value remains the same.

• Custom Number Formatting
• Format Numbers as Text in Drop Down Lists
• Convert Text to Numbers
• Make Negative Numbers Red

MODULE 3 - EXCEL FORMULAS

In this video of this Free Online Excel Training, you will learn how to get started with Excel formulas.

• Constituents of Excel formula
• Operators in formulas
• Entering a formula in Excel
• Editing a formula
• Absolute/relative cell references
• Copying/pasting formulas in Excel, and
• Formula auditing and debugging.
• Excel Formula Debugging
• 100+ Excel Functions  (explained with examples)
• Absolute, Relative, and Mixed Cell References in Excel
• Excel Formulas Not Working: Possible Reasons and How to FIX IT!
• Function vs Formula in Excel

In this video of this Free Online Excel Training, you will learn about the following logical formulas:

• AND function
• OR function
• NOT function
• TRUE function
• FALSE function
• IF function
• IFERROR function
• IS function
• Avoid Nested IF with VLOOKUP
• Using IFERROR with VLOOKUP

In this video of this Free Online Excel Training, you will learn about the MATH formulas

• INT function
• MOD function
• RAND function
• RANDBETWEEN function
• ROUND function
• SUM function
• SUMIF function
• SUMIFS function
• SUMPRODUCT function
• Random Team Generator Template

In this video of this Free Excel Training, you will learn about the following LOOKUP and REFERENCE formulas:

• VLOOKUP function
• HLOOKUP function
• INDEX function
• MATCH function
• OFFSET function
• INDIRECT function
• ROW function
• ROWS function
• COLUMN function
• COLUMNS function
• VLOOKUP Vs INDEX MATCH
• VLOOKUP with multiple criteria
• Case sensitive VLOOKUP
• Use VLookup to Get the Last Number in a List in Excel
• Lookup the Second, the Third, or the Nth Value in Excel
• Find the Last Occurrence of a Lookup Value a List in Excel

In this video of this Free Excel Training, you will learn about the following STAT formulas:

• AVERAGE function
• AVERAGEIF function
• AVERAGEIFS function
• COUNT function
• COUNTA function
• COUNTBLANK function
• COUNTIF function
• COUNTIFS function
• LARGE function
• SMALL function
• RANK function
• MAX function
• MIN function
• Weighted Average in Excel
• Standard Deviation in Excel
• AVERAGEIFS in Excel

In this video of this Free Excel Training, you will learn about the following TEXT formulas:

• LEFT function
• RIGHT function
• MID function
• LEN function
• LOWER function
• PROPER function
• UPPER function
• FIND function
• REPLACE function
• SUBSTITUTE function
• TEXT function
• Word Count in Excel
• Split Cells in Excel
• Extract a Substring in Excel
• Concatenate Excel Ranges
• Find Position of the Last Occurrence of a Character in a String in Excel

In this video of this Free Excel Training, you will learn about the following DATE and TIME formulas:

• DAY function
• HOUR function
• MINUTE function
• DATE function
• DATEVALUE function
• TODAY function
• NOW function
• WEEKDAY function
• NETWROKDAYS function
• NETWORKDAYS.INTL function
• WORKDAY function
• WORKDAY.INTL function
• Calculate Number of Days between two dates
• Calculate Time in Excel (Time Difference, Hours Worked, Add/ Subtract)
• Excel DATEDIF Function
• Excel Holiday Calendar Template
• Calculate Age in Excel
• Insert Date and Time Stamp in Excel
• Convert Time to Decimal Number in Excel
• How to Remove Time from Date/Timestamp in Excel

In this video of this Free Excel Training, I will show you some advanced formula examples that involves using one or more than functions.

I cover the following topics this video:

• Compare Lists, Get Unique List
• Get the Closest Match
• Get Last Value in the List
• Find Last Occurrence of an Item in a List
• 2 Way and 3 Way Lookup using Index/Match
• Count the Number of Words
• Extract Username from Email Id
• Find the First Monday of the Month
• Extract Data using Drop Down List
• Compare two columns in Excel
• Extract Username from Email
• INDEX MATCH (Examples)
• How to Compare Two Excel Sheets (for differences)
• 20 Advanced Excel Functions and Formulas (for Excel Pros)

MODULE 4 - DATA ANALYSIS

In this video of this Free training, you will learn about using Named Ranges in Excel.

• Creating Named Ranges
• Managing Named Ranges
• Important Keyboard Shortcuts
• Creating Dynamic Named Ranges using OFFSET and INDEX formulas
• Named Ranges in Excel
• Picture Lookup in Excel
• Excel OFFSET Function

In this video of this Free training, you will learn about using data validation and drop-down lists.

• Data Validation Criteria
• Input Message
• Customizing Error Messages
• Circle Invalid Entries
• Advanced Data Validation Tricks (such as Create Dependent Validation, Make Sub Headings in Validation, Disguise Numbers as Text, Creating Dynamic Drop Down List)
• Drop Down list in Excel
• Dependent Drop Down List in Excel
• Extract Data from Drop Down List Selection in Excel .
• Select Multiple Items from a Drop Down List in Excel .
• Creating a Dynamic Excel Filter Search Box .
• Display Main and Subcategory in Drop Down List in Excel .
• How to Insert Checkbox in Excel .
• Using a Radio Button (Option Button) in Excel

In this video of this Free training, you will learn about data sorting and filtering in Excel. It covers the following topics:

• Data Sorting
• Multi-Levels of Sorting
• Data Filtering
• Advanced Filtering
• Filtering and Sorting in Excel Data Tables
• Data Sorting in Excel
• Multiple Level Data Sorting in Excel
• Sort Worksheets in Excel (VBA)
• Sort Data in Alphabetical Order Automatically
• Sort by Color in Excel
• Sort Data using VBA
• Delete rows based on cell value in Excel

In this video of this Free training, you will learn about the amazing conditional formatting.

• Introduction to Conditional Formatting
• Using Formula in Conditional Formatting
• Advanced Examples (Highlight Every Nth Row, Creating Dynamic Search)
• Conditional Formatting in Excel
• Find Duplicates using Conditional Formatting
• Search and Highlight Data Using Conditional Formatting
• Highlight Every Other Row in Excel
• Highlight Blank Cells in Excel
• Creating Heat Maps in Excel

Here are some additional tutorials about Data Analysis:

• One Variable Data Table
• Two Variable Data Table
• Goal Seek in Excel
• Scenario Manager in Excel
• Using Solver in Excel

MODULE 5 - INTRODUCTION TO EXCEL CHARTING

In this video of this Free training, you will learn about  Excel charting  and how to make useful charts quickly. 

Excel has a lot of inbuilt charts that you can use instantly to visualize your data. And there are many combination charts and advanced charts you can create to pack a lot of information in a single chart.

• Excel Chart Types
• Chart Editing
• Formatting Chart Elements
• Combination Charts
• Handling Gaps in Charts
• Combination Charts in Excel
• Add Trendlines in Excel Charts
• Add Secondary Axis to Charts in Excel
• Excel Area Chart

In this video of this Free Online Excel training, I will show you how to use some tricks to create advanced charts in Excel.

The following advanced charts are covered in this video:

• Multi-Category Charts
• Gauge Chart
• Thermometer Chart
• Milestone Chart
• Water Fall Chart
• Gantt Chart
• Chart with Trend Arrows in Data Labels
• Actual Vs. Target Values
• Spotting Data in a Scatter Chart in Excel
• Dynamic Target Line in Excel Bar Charts
• Sparklines in Excel
• Step Chart in Excel
• Sales Funnel Chart in Excel
• Waffle Chart in Excel
• Pareto Chart in Excel
• Histogram in Excel

In this video of this Free Excel training, I will show you how to create dynamic charts in Excel.

Dynamic charts allow you to change the chart based on user selection. For example, you can update the chart as soon as you change the scroll bar or click a button.

This video covers two detailed examples of creating dynamic charts from scratch

Example 1  – Creating a dynamic chart that updates as soon as you use the  scroll bar  to change the year value. Example 2  – Creating a dynamic chart that plots the data on a scatter chart based on the column you select. There is a  drop-down list  that allows you to select which data series should be plotted on the X-axis and which should be plotted on the Y Axis

• Creating Dynamic Chart Range in Excel
• Dynamic Chart with Selection Box
• Dynamic Target Line in Bar Charts
• Creating Dynamic Chart Titles

MODULE 6 - PIVOT TABLE

In this video of this Free training, I will show you how to create and use Pivot Tables in Excel. 

The video covers the following topics:

• Introduction to Pivot Tables
• Creating a Pivot Table in Excel
• Formatting the Pivot Table
• Grouping data in an Excel Pivot table
• Calculated Field/Items in Pivot Table
• Pivot Table Slicers
• Pivot Charts

Pivot Tables are amazing as it allows you to quickly summarize a huge amount of data with a few clicks. Even if you’re using Excel for the first time, you can quickly get a hang of it. In this video, I try to cover a lot about the Pivot Table. In case you want to learn more,  click here to check out all my Pivot Table tutorials .

This is a fairly long video, and if you want to deep dive into any of the topics covered in this video, have a look at the recommended articles section.

• Creating a Pivot Table in Excel – A Step by Step Tutorial
• Preparing Source Data For Pivot Table
• How to Filter Data in a Pivot Table in Excel
• How to Group Dates in Pivot Tables in Excel
• How to Group Numbers in Pivot Table in Excel
• How to Apply Conditional Formatting in a Pivot Table in Excel
• Using Slicers in Excel Pivot Table – A Beginner’s Guide
• How to Add and Use an Excel Pivot Table Calculated Field
• How to Refresh Pivot Table in Excel
• Delete a Pivot Table in Excel
• Pivot Cache in Excel – What Is It and How to Best Use It

MODULE 6 - EXCEL EXTRAS

In this video of this Free Excel training, I will show you how you can lock cells or protect worksheets and workbooks in Excel.

You can protect cells, worksheets, and workbooks in Excel with a password (or without one). Once a worksheet is protected, you’ll need to enter the password to access it (in case a password has been applied).

Note that Excel in-built security feature is not very strong and you can easily open worksheets/workbooks that have been locked. However, if you want to quickly protect it before sending it to your manager/client (so they don’t end up changing anything by mistake), it works well.

• Lock cells in Excel
• Lock formulas in Excel

In this video, I will give you a quick introduction to  Excel macros  and the  VB Editor  in Excel.

By recording a macro in Excel, you can easily automate a lot of tasks. And the best part is that you don’t need to know any coding or VBA to do this. When you record a macro, Excel simply follows whatever you do in the workbook and create a code for it. Now you can run this code and Excel will automatically follow all the steps you showed it.

If you’re a VBA beginner, recording a macro and understanding the code using it can be a great way to learn.

This video lesson covers the following  VBA topics :

• How to  record a macro  in Excel
• Absolute and Relative Cell References
• Introduction to the Visual Basic Editor.
• Working with Cells and Ranges in Excel VBA (Select, Copy, Move, Edit)
• Working with Worksheets using Excel VBA
• Using Workbook Object in Excel VBA (Open, Close, Save, Set)
• Understanding Excel VBA Data Types (Variables and Constants)
• Excel VBA Loops – For Next, Do While, Do Until, For Each (with Examples)
• If Then Else Statement in Excel VBA (explained with examples)
• For Next Loop in Excel VBA – A Beginner’s Guide with Examples
• How to Assign a Macro to a Button in Excel

Here are some additional useful basic Excel tutorials:

• Clean Data in Excel
• Excel Interview Questions (with answers)
• Working with Gridlines in Excel
• Inserting a Watermark in the Worksheet
• Setting the Print Area in Excel
• Best Excel Books

ABOUT THE INSTRUCTOR

I am Sumit Bansal, your instructor for this Excel Training. I have been training people in basic/advanced Excel and dashboards for more than 10 years now.

I have also been honored with the Microsoft Excel MVP status for my expertise in Excel.

Learning Excel becomes a cake walk when you do it the right way. First you need to get all the basics in place, and then you can learn to do advanced stuff in Excel.

In this Excel course, I’ve focussed on giving you a structured and comprehensive learning experience. It makes sure you have a rock-solid foundation and then covers advanced Excel concepts that will make you an Excel Wizard.

When you’re done with the course, I guarantee you’ll be able to do a lot more in Excel in a fraction of the time.

FAQs about this FREE Online Excel Training

Yes, it is! You can just scroll up and start watching the videos and  learn Excel .

You don’t need to sign up for anything or pay for anything. This training is completely free and covers most of the Excel topics you need to get started and become a pro.

You get to watch each and every lesson absolutely free (and as many times as you want).

All you need is a decent internet connection.

No, you can only watch the videos online. These videos can not be downloaded.

However, this FREE Excel training is available to watch as many times as you want.

I have used the  Excel 2013  to record these videos.

Almost everything covered in this free course will work for all the Excel versions (2007, 2010, 2013, 2016, and the upcoming 2019) .

There are a few things missing in the prior versions, and I call it out in the videos (for example, flash fill is only available in versions after 2013)

My name is Sumit Bansal and I am your instructor throughout this FREE online Excel training.

I have practically been in a relationship with Excel since 2007. My aim in this course is to give you the best possible Excel learning (absolutely free).

I have been highly passionate about learning and teaching Excel and have trained thousands of Excel enthusiasts to use Excel the most efficient way.

I have also been recognized as an Excel MVP by Microsoft for my passion to learn and teach people on using Excel the right way.

591 thoughts on “FREE Online Excel Training (12+ Hours) | Learn Excel (Basic/Advanced)”

Dear Sumit, I truly appreciate all what you have done in these videos. Indeed you are an incredible and wonderful person, which of course in today’s world is rare. It is not everyone who would share their knowledge for free in this generation, thus i am sincerely grateful. Keep the good work

Thank you so much for the kind words Marion

dear, how to draw a pair of lines to the x-axis and y-axis from a point along a curve?

Where are the links??? I click on a heading, get the description, but there are no ACTUAL links to watch the video!

The videos are embedded. Check your browser settings and/or disable ad blockers if you don’t see them.

Señor Bansal!

Thank you for your shared knwoledge!

Very hepful to increase my knwoledge on Excel.

Very strightforward and very good pace!.

Fidel (Monterrey México)

Good explanation

The material and videos are excellent, thanks. I do have a problem when downloading the example file for practice. It downloads but the data is missing will you please help.

Hello Deepak here and I am a beginner

Will we get certificate

Sir theory is not give me

Highly Beneficial

mene ap se excel ki training leni hai

Dear Mr Bansal

I want to take this opportunity in thanking you for offering your services free to all. I am very grateful to you. Not very many people will offer their services for free in this day and age. May you be abundantly blessed Sir.

Thank you once again

Fantastic! I’ve been a programmer for 30+ years and this is a wonderful site for a refresher or a quick reminder of how to do things in Excel.

Want to learn.

Seekhna chahta hu

Very much interested in the courses

How do I start the course on my smart phone

Apne phone me ms excel kaise suru karu

Can I get a certificat when I will finish this cours?

Thank you Sumit for your efforts for making these courses completely FREE of cost. Absolutely great videos and your style of teaching is amazing and easy to follow. Thank you for sharing your knowledge with everyone.

Would like to learn

would like to start

Sir you are teaching in a very simple and cool way . I liked it very much. Iam sure no would have any doubts after hearing. Thank You soo much for providing this free course.

it is really helpful to us

It is really amazing to see this.Throug this platform we surely increase our knowledge about excel

It is really helpfull

I get the training best however I need certificate after completing the training for cpd. how can I get it?

Wow I love learning opportunities as this hope to really know this Excel.

BEST BEST BEST TRAINING

Dear Sumit Bansal,

I am trying to learn Microsoft Excel. I have been using it for years but know very little about it full power. I am watching your videos on YouTube. In the video “10 Advanced Excel Charts and Graphs (Creating from Scratch) | FREE Excel Course” in the session on “Milestone” charts when I enter the data as shown in the video I get a “#FIELD!” error. Do you have a solution for this?

it was good and understandable excel course.

Really helping a lot.. thank u

Was very helpful

Thank you so much sir you helped us alot

I just purchased Microsoft Home@Student and one of the things I wanted to do was learn Excel. I’m only on the third lesson so far but I find your instruction clear and logical in it’s presentation. Thank you for all the time and work you’ve put into making it.

Do you get a certificate upon completion?

how i join class?

Really helpful sir

Thanku so much ❣️❣️❣️

I have been struggling to learn excel but with these videos definitely will get a better result, at the movements, Just would like to say to you ” well done and Good job “. Thanks

I want do that. Anybody can cll me… How’s will be start.

How do I get the certificate after completing the videos?

michael adeoye wonderful. May God bless your excel training.

Are you qualified? Have you got experience? I may have a Freelance job for you in our firm of Chartered Accountants & Property Tax Consultants in London UK

It was a helpful session.Thank you

So I get a certificate for Thai training?

Do I get a certificate for this training?*

Hi, I know Excel basics, may not be fluent. I need to learn online 1 to 1 and complete the course in 2 weeks max. Pls advise how can we do it, daily how much time required & what’s the charge

Do you receive a certification for completing the course?

Thank you so much, this is very helpful.

I am not receiving the tips ebook you are offering

I have used Excel for years and had no idea about all the functionality! You are a wonderful teacher and have made it so easy for me to grow my knowledge of Excel — Thank you for these wonderful videos and instruction! You’re Excel-lent!

Did u learnt online one to one or just by watching the videos ? How long it takes to complete the course

Can i get certificate for this?

Can I get certificate after I finished the course?

Thank you for the training

The best, simplest and eastist way of learning excel ….lot of thanks .

This is the best online course i have ever found. Thank You and best regards from Bosnia.

Do we get certificate at the end of this course?

Excel courses provide certificate & job

Hi Sumit. Wonderful contribution you are making. Kudos. Can we use these on our company LMS? We are not going to do that for Commercial purposes

Is it this course will provide me certificate?

Thank you is what I can say only. I have not still started but I am aware about excel and topics, this is a true help to everyone, great work sir.

This is truly the best Excel training I have come across and am actually learning and utilizing what’s taught. The lay out and process is very well put together. Sumit’s style of teaching gives you exactly what you need w/o all the extra talk. No wasted time just good content clearly and usable. EXCELLENT WORK Sumit and THANK YOU!

yes I want to learn Microsoft excel

REALLY LOOKING FORWARD TO LEARNING EXCEL…

Interesting video. Thank u !!!

SO HOW DO IGET STARTED THEN HEHEHE IM SCROLLING DOWN AN DOWN AN DOWN WHER DO I ACTUALLY START THIS EXCEL COURSE FROM

Wow, I just loved this training. The wonderful thing is you can keep going back to refresh things you may have forgotten. Thank you!

Sir aapka smjhane ka way bot best hai kya Excel video hindi version mai avilabel hai….if yes please send me link on my email id…..sharma,[email protected]

I want to know everything in excel.

thank Trump Excel for so many help

Osm Guidance in this video, Thank you so much to learning lots of new features.

Dear Palak, Siri connected me to your excel Tutorial program and many thanks. I hope to learn the program soon though it is a bit too fast for me but you are very clear.

interedsted in excel

Interested in excel

I have not been able to access video, How do I do that? Do you also provide certificate after conplication of this course

Grate work Mr. Sumit, I planed to take up an online program in Data Analytics next semester but indeed hope these videos would help me a lot. Bravo my brother.

Is this really free

Does this course come with a certificate?

Do this course provide completion certificate.

May I download video

Can we get certificate?

Where are the exercises for each module to practice the lessons?

can i get the certificate?

I am interested for learning ms excel

I am interested learning in excel

Excellent video Sir I really very thank full to you for bringing useful videos that to free of cost. One can become a expert in excel by watching your video. Sir how you made thia video means which equipments you have used without showing the face only you have given voice. Because I am also a lecturer I want to teach online without showing the face

Need to be part

Sounds interesting

Watched the introductory video and it was amazingly comprehensive .. Would love to continue with d other modules..will i get a certificate after completion?!

This is an excellent online course for any level Excel users. Great Instructor! Above all these, its free for anyone! Thank you so much!

Can I get certificate after finishing the whole excel course?

Boy I never knew anywhere near all this was so available! You are a great instructor and make it all learnable, even if I do have to back up and replay often (at least in VBA course, your workbooks on Excel formulas are wonderful). I’m finally learning where before I’ve always just cussed VBA and Excel. Thank you Very Much for all your hard work!

How can I sign up for this free offer?

I’m interested in free training

Learning excel

I will strive to learn and excel and after some expertise, I would definitely spread it to those who are in need of it, obviously free. I think this could be one way to pay you back. My sincere regards to you Sumit Bansal.

sounds good will give it a go

Sumit, as I mentioned in an earlier comment, I am fully retired 5 years now. In my day was considered an advance Excel user – VBA programmer. But I must confess I have learned things in your tutorials I knew about but never mastered. You tutorials say things in simple terms. I just finished lesson 8: Number Formatting in Excel. I used this function often in my work but now have a better understanding of how to use the different formats of number, dates and times. Thank you for EXCELLENT tutorials. Can’t wait to learn more. Thanks again.

Will there be any certification given at the end of the course?

Can it be used better than tally for inventory management

this is a great Excel training program. I thanks Mr.Sumit Bansal give to opportunity develop our Excel side.

thank you , very helpful

It will be my joy to start this training and finish to become a pro in no distant time. Thanks for this offer and opportunity.

This video is helping a lot!

No problem.

very useful and I am are learning very short cut formulas for faster execution of work in excel

Thank you Sumit for making learning Excel for me a piece of cake. All this while, I was under confident when it has come to Excel. You entire Module is a collection of all the lessons and I do not have to go anywhere else to find video. I practice these everyday. Thank you once again. And yes I would like to treat you with coffee sometime as a gesture for your help!

How to login and start training..

Amazing! This is so useful, so clear. I wish I found you long time ago 🙂 Thank you so much.

Hi and thank you for all the content. I had a question regarding the countifs function. I had the quiz question how many times does the number 3 appear between the integers 300-400. I know the answer is 120 after looking into it further I was wondering if there’s a way to get to this answer using countifs, if so how? I thought it would look something like this =countifs(b1:b100, “3**”, b1:b100, “*3*”, b1:b100, “**3”) but clearly have it wrong.

I’m interested to do this course

I must appreciate you ,you have prepared all the videos and that available for all. Regarding printing I want to know how can I print bill format using data of various cells

Can’t wait to get started, an 81 year old.

Just like excel You are an Excellent instructor. Thanks for helping!

it is really helpful

I just love this free online excel.

EXCELLENT TRAINING

My,my,my…I know we still have kind souls, we have just lost our way a bit in the world today. Knowledge is no good unless you share it. I will be taking your course. I sincerely thank you for your kindness.

Is there a free certificate after completion

No there isn’t , but you can share the knowledge you’ll gain with your peers and employers as proof of your completion 🙂

I don’t know about this I am just doing first time so after i start I’ll comment

Thankyou so much Sir for providing us such a valuable course free of cost. Your Teaching style and way of explanation is Fabolous. It helps me alot.

Hello Sir, I am not able to play the videos. They seems to be freezed.

It may be your connection, try to hook to WiFi and try again. Hope that helps

Total how many hours does the course is?Can I get certificate?

I am now 65. I like to convey my thanks to you for your philanthropic activity as a teacher in real sense. I was a teacher and hope to be a student of you very soon. Live long.

Hi! Are these courses still available? I’ve clicked on several of the training courses and cannot access.

Yes they are, try to connect to WiFi and try again to access

Do you get a certificate for this course?

Hi I would like to attend this class

Hi, access anytime 24/7 for free 😉

simply excellent

Does this course provide certificate?

Waaw Mr. Sumit! This is a fantastic gift to all the human race. Bravo my brother. I planned to take up an online course in Data Analytics next semester,2020 and hope this would help me a lot. Thanks.

I’m a complete beginner hoping to start a data analysis Open University Course in October. Your service is invaluable to me and I will be studying for 2 hours a week until October. Many thanks for sending me emails. Kind regards, Jeanne

Will you provide Certificate after completion. How much time it will take to complete. I am in intermediate status.

We will get certificate?

Do we get a certificate for the course?

IS THIS COURSE PROVIDE CERTIFICATE ALSO

Thank you so much !!! I’m a Nutrition student in college and excel is extremely useful <3

Thank you so much Sumit for such a comprehensive course, I really appreciated it!

Great Job and I am learning every day as I watch one video per day.

Very nice way of give training with so much examples & practicality. I am v. much impressed.

Hi I would like to start study excel When the course start ? Thank you

When can I expect to start the free excel cour

Will a certificate be provided by the end of the course?

THANKS SO MUCH FOR THIS FREE COURSE I LOVE YOUR VOICE TOO❤❤❤

CAN I GET A CERTIFICATE FOR THIS COURSE?

thanks for this complete course on excel learned a lot…

Out of my tight schedule and extra working hours, I took out some time to complete this course and it helped me tremendously to manage and analyse my data, along with it I could save 2-3 hours per day. I am grateful to you for making it available free and help people like me who struggle working efficiently without good knowledge of excel. I have recommended this course to my colleagues now. Many many thanks again.

Want to learn excel

Hi sumit, thanks for giving such wonderful learnings at no cost. Will u please guide me for certification stages in excel and also best link to go for it. I would really appreciate ur response. Thanks in advance

is there a book covering this course? If not what books do you recommend to learn Excel for work?

It’s very useful course. Thank you sir.

Is there any assessment that I need to give after completing the training?

The courses offered and the way these are structured are meant to lay a firm and solid foundation to build upon. Everybody builds their own home on a foundation. When it is a good, properly laid, will make one’s home sitting on a solid foundation.

Mr. SB has taken time, mastered the Excel, excited by its capabilities, organised it and prepared to teach his students in a simple and direct way. With an average enthusiasm to learn, one can learn from these videos and lay a firm and solid foundation to one’s career, using this excellent program called Excel.

Like air we breathe, Sunshine we enjoy, moonlight we adore, his free teachings are GOD’s gift to any body that want learn a new skill.

The organisation, time, effort and passion has to be really appreciated.

I see lot of people asking for a pat in the back ( like looking for a certificate of completion ), this is a SELF-HELP course, and I am not sure I will have as much information given to me even if I attended a PAID COURSE.

And again, since I am learning this on my own to improve MY understanding of spreadsheet program, I can understand and appreciate why some persons want to squeeze a CERTIFICATE out of this as a ticket for a future job.

Mr. Bansal, Pranam to you, as a teacher who put in all this time into these video courses and offering it for free. I bow to you for your kind heart.

Goddess Saraswathi has blessed you, may her blessings be showered upon you into the future, so we all get at least a part of those blessings.

Is this course provide certificate also?

Will we be getting certificate after completion

Sir after completing this …can I have a certificate of this or not..

Sir I completed the course so would you please give me a certificate

Awesome course I learn lots of thing Thank you sir

It really lovely course thank you very much

Hi Sumit! Thank you for this! Question …is there a file to download to follow along with the videos ?

Nevermind! You don’t need it in these videos…I got it . I’m looking for tutorials on what to do say when you run a SQL query and have a huge data dump in excel . Will start with your videos here , thank u!

Very helpful course

Khupch chan information dili ahe purn upyukt asa course ahe excelcha.

hello i’m new here and i would like to learn excel then after i can learn more about computer.

Thank you soooooo much for the effort Really appreciated

I AM A BEGINNER IN EXCEL IS THIS A CERTIFIED COURSE AND HOW MANY COURSES ARE ALSO AVAILABLE

This is really good way to taught I really liked

hi, is this a certificated course?

Please I am interested in taking thefree Excel class

This is so user friendly. For someone who has never been able to use Excel, your training is just so simple and easy to understand.

Hi. I wanted to chat.

can you go to insert I am on a mackair

How to enroll ?

This is beautiful. I enjoyed the training and with this excel training, i can say that i now understand excel at some extent. Many thanks to the instructor.

sir all are very nice i love it

Thank you very much, this really helped me a lot

CAN YOU PROVIDE ME WITH A HARD COPY OF THE LECTURE WHICH YOU ARE SPEAKING SO THAT IT MAY BE EASY TO UNDERSTAND FOR A PERSON WHO IS NOT THAT PROFICIENT IN ENGLISH.

Am new how do i get started and do you anything to show that someone did this training.

sir after completion of this course i will get a trained certificate or not ?

Yes. I am interested in the free excel course

Sir please tell us some assignments so we can practice after every lecture

Thanks you so much ,sir. I am from Pakistan. I learned a lot from your videos. Kindly share me the procedure to get excel notes if you prepared according to the video you published. Thanks in advance

May i learn the Macros in this Excel Program as well

It is very helpful app

Worth watching these videos, it’s really very helpful.

Good effort. Contains are clear and crisp. Course is Advanced, I will highly recommend this to Computer teachers who wants to clarify their doubts in excel.

Sir can u tell us some assignments so we can practice after every lecture?

Does one get a certificate after completion?

It’s a very healp full to excell. I have to learnt data entry and number formatting with excell. In module 2 I learn to auto fill , custom list. And excell is spread sheet program include in the Microsoft office suite of applications it is also soft ware program .

I have watched your course “How to do a Picture Lookup in Excel – A Step-by-step Guide” and I still can’t get it to work. Is there any way to help me? I am desperate.

The language is so easy to understand the lesson.

Thank u sir it is very useful training I had been advance Excel classes but I had not more about Excel I had learn only basic concepts and also I had try job outside I didn’t found the same MIS executive job. May be if start watching this video daily I will learn more new about the excel thank you so much for providing this free of cost course.

It is very useful

First check it.

First check it

Are we getting any certification after the course completion.

Why is Trump name on this course? How is President Trump associated with this course? If he is not, why did you put his name on it?

It’s a common English verb. This course and the site has nothing to do with anything except Excel

I think this was an excellent video on excel I really appreciate the efforts who had made so easier to learn excel. Contains are clear and chrisp.i am impressed the way they present the advance excel. I will also recommend to my office staffs, senior’s, collegiate, friends and our business partners. Now after learning so many things through video I feel so confident and happy now I have to rush to take help of anybody, I will keep practicing and learn more and more to enhance my excel as a superb skill. Thanks you so much to all those who had given great platform to learn the Excel and various things…..

Hello, Thanks for training and good experience and thanks a lot .

Good experience and thank you for your help.

Great videos

I want to learn advance course

Thank you Sir, it is very useful for me to know about Excel as I am working on Excel in my office and it will be very useful for me.

best course

Hello sumit sir, I am writing this to Thank you for providing such great lessons. They are very few people left around us who provide education and great learnings for free. I am disappointed for finding this site a bit late. But I’m glad i am finally here and can get the best out of this learnings. Thankyou so much for your knowledge and efforts Sir.

Good knowledge …Data Entry,Data editing,Number Formating

Good knowledge & Information

HI Sumeet Sir, Can you please explain the basic difference between between Vlookup & Hlookup as both looks same and Syntex are also same just =vlookup has been changed to =Hlookup .

Hi I am an intermediate in excel…

Dear Sumeet Sir, Can you explain a bit more about Vlookup for the last example in the given where you were T is higher lower, Really I got confused ,It has been asked for T why it is giving data for jane ?

very well explained ,very useful

It is very well explained & has been very useful to me Thank you

I like all the videos and I have easily understood everything. Thank you

Hi is there a certificate once completed?

It is very useful. Excellent videos & courses and easy to understand.

Very nice coaching and class

Excellent courses

Thank you for the great work, Sumit – I’ve found it very useful and comprehensive.

I will give you tip at the end of the course.

Do they provide certificate?

This is amazing tutorial and excellent instructor, I loved, thank you so much it’s absolutely life saving.

This excel work is essential

This is what I was looking for to learn in my life.

It is really helpful. Thanks.

Very useful

so clear and very helpful

It should be useful

I enjoy and learn a lot from your Excel course. Wonder you have free online course for Microsoft word training just like this excel course.

Hi Sumit – i need to know how to become MVP in excel as I know it at advance level.

Excellent Videos

Excellent course

very useful for me.

thank you sumit

chindeh fally

for example : 3126.76 is the number I want this in the form ####.## how can I do this plz tell sir.

May God bless you my brother. Thanks for sharing your knowledge. My name is yunus be in touch 7624885184 (Kerala)

Thanks i learn alot think here

is it necessary to have certification of excel when you have an aim of pursuing a job in future?

Online excel learning

I am very interested to learn excel , well done good lesson it’s very useful for so many people’s thank you…

Thank you very much . This training has helped me a lot and I am so grateful. I have been looking for an Excel training , tried to buy from Udemy several times but could not complete the transaction due to some restrictions in their payment system which does not allow a credit card issued in a different country. What’s is point of having a credit card if the thing would not work across regions ? Well, this was before I came across your page and started learning . Having gone through several videos and other trainings, I can honestly say that your training is one of the best structured and delivered. Thanks a lot.

Module 3 lesson 9

as in the video to find out answer only to Average (Sum +Sum +Average) u select the Average with associated cells and click F9 but i my excel when i tried i am not able to get that answer. do we need to press shift+f9 or it is something else

Module 3, lesson 9. Mixed reference

I understood how to keep one number consistent while dividing or any other signs by adding ($) sign before the letter and after the letter but

in mixed reference moving from $A$12 to $B$12, considering different column (i.e from A to B) but same number cell i,e (12) in this case i tried on my excel but i am not able to move from A to B by removing the ($) sign before A by pressing only (F4).

Could you help.

Which course in excel

Please send me link, I am interested on it

very much interested to start the course, coz I like excel spreadsheet.

Do we have to sit in one go or we have can do per day per video

Thanks for your excellent tips on Excel.

Want to learn all the basics of xl

I finish my course can I get certificate.

I have learnt formulas in this online course… Usefull course

I was literally looking for an excel training opportunity for teacher professional development. I had my wallet out ready to pay. Your training is above and beyond structured and easy to follow. I would have paid hundreds of dollars for this training. Thank you for sharing your knowledge and talents!

I am very eager to learn this and don’t see the tutorials yet.

Can I get a Certificate after course completion

It’s very interesting And very useful

I am using excel. I need to improve…….

Thank you for the course Sir, it is really useful.

I found it very useful, really appreciating Mr.Sumit for your valuable contribution. Its very effective way of teaching in simple way to explain the logic’s and uses of each functions. Keep it up……

Good course

This courses is truly useful.

this may help a lot of people just by watching

Had learned a lot

I found this Course very useful for me and suggest to others also. Thank you.

Course Modules are very usfull

This course is Best and very helpful course

Best courses very helpful course

do we have any test after the course

Learn something new through online session

What about a sertificate after finishing for cv for work purpose

I find your tutorials quite useful for many excel formula. I have a unique situation. I would like to seek your help. Is there any way that I can reach out to you and share the soft data(Dummy) and seek solution. This is related to vlookup.

Hello. These courses sound great. However, nothing happens when click on any module. Is this because there may be high traffic? Do I need to access via google or IE? thanks

Great excel learning

I am using your free 26 lessons program to learn Excel. Thank you for the very informative videos. Is there anywhere I can do practice exercise?

Regards, Louloua

Thanks a lot sir for making it available now for free.

Excel learning

Which excel courses are paid in your site.

I have always wanted to learn excel so I am very interested in taking this course

I have always wanted to learn excel so I am very interested in taking this course.

did u started? is this really useful?

How do I get access to the worksheets used in the videos?

I thank Mr. Sumeet Bhansal for giving me such a lucid training where in got to know the easiness in understanding the excel formats quickly.

Do I get a certificate for this training?

Very Useful courses

Is there any certificate after completion?

Nicely Explained in Detail

How do I get the Free video?

Very useful course for the excel learner’s. Good Job… Thanks a lot…

Sir I know about excel a little bit I want to learn excel in deep.

Sumit, you have provided the clearest teaching I’ve found thus far online. I appreciate the downloads you provide with each lesson so that I can switch screens and practice while you are teaching. Also, you have organized these beautifully in small sections so that anyone can take a quick lesson in between other projects. EXCELLENT!

I was to change shape of chart element column chart. Please guide.

Sumit -the way you explained formulas its amazing. I am your fan nowonwards. thank you dear.

Thank you so much.. !

Cn we get certificate after complete the course?

Thank You for sharing your knowledge to us.This courses is very useful.

Hi Sumit, approximately how long will it take a beginner to complete this course? Thank you

great job. Thanks

I have one doubt in the Excel Sir like automating the data from one sheet to another sheet.

Dear Sir, I need help in conditional formatting. In a column A there are a number like for different row 302,213,556,070,111,560, … I would like to high lite the number for 302 value is red( either if it is 023 or 320 for all combination) ,556 is yellow(similar like all combination655,565) and 070is green( 007or700). Please help. Thank you.

It is a pleasure to have the opportunity of learning this courses free and I hope it will be a successful experience. Thanks

Dear Mr.Sumit, I need a small solution for my Xl Table I need to change the Data (Rate of Interest in the cells) in one column for a particular period in another column (01-04-2019 to 31-03-2020)only Kindly help me solve this problem Regards S D N Murthy

Hi, can you provide some sort of evidence if I complete the 12 hours course

It is Useful for me

It is very usefull for me

Hi Sumit, Can use google sheet for this training?

What I have seen so far (I’m on lesson 4) is absolutely amazing!

Really thankful for your knowledge sharing. It’s really helped me . Sreeraj C

Thanks for good knowledge sharing .

any certificate from your side after free training

Do we get a certificate or something to show that we have completed the course?

will I receive a certificate once I complete the course? Where is the company located? Is there a phone number where I can contact anyone if necessary? How long have your company been in business? What is the name of your company?

Since this is a free course available for all, you won’t be given a certificate. This site is run by Sumit Bansal (that’s me). I am an Excel trainer who shares tutorials and videos online. This isn’t a company, just me trying to help people learn Excel. You can reach out to me at [email protected]

are these courses really free? I will not be billed later on down the line will I?

Hello Kimberly… Yes, the course is free. You won’t be charged for anything. You don’t need to enter you credit card or any other detail. Just click on the video and watch.

Am I gonna get a certificate for the course

why do you want to give free lecture?

I need something for kitchen porter please if available

It’s not for a kitchen Porter course

Would like to know how helpful the course is

Is there any free online course work that can be done by the person on hands learning to be learning by doing ?

hi Sumit, This is really an awesome excel class and is it free training, really appreciate your effort and sharing. Many thanks.

Just wanted to say–Sumit, Big thank you for taking time for providing these free online training courses. God bless you

Thanks for commenting… Glad you are finding the videos useful!

Hi sumit..hope u r doing fine..would u able.to.send these same.sheets for practice

Thank you for putting this out there for free, bless your heart ❤️

Thanks for the kind wors Kristin… Glad you’re finding this Excel course useful!

Thanks for the courses. This courses is very useful for me.

Glad you’re finding the Excel course useful

one of the best excel course i have ever seen.

Just awesome Sumit, wasn’t expecting such detailed explanation of everything Excel.

This is the best course on the internet!! At the moment, I’m trying to learn how to take out the external links from excel and I found this post at the top of the search results. Then, I found this course just in the menu and it’s exactly what I’ve been wanting to do, like literally at the top of my list but just did not ever know when or where I could because of the time and just trying to learn so much such as Command Prompt and what that can do you for you.

Thanks heaps for this whole website, it’s the best!

Thanks for the tutorial video. Is there a video for Power BI.

Thanks for the Excel tutorial. It helped me a great deal at my present job.

Good afternoon., I want to be Expert in Excel. What can i do for…?

I just want to know can I get any certification for this Exel online tutorial

I need to develop a tactical crime analysis matrix using a spreadsheet. The matrix will contain 10 records(rows) and 16 variables (columns). I have a list of crimes. Would you please demonstrate a sample of this

Congratulations Sumit Bansal for this exceptional work! It is really fantastic to have access at this great content. I’m a fan of Excel. There are so many things you can do by just using excel properly! Do you mind if I make a post regarding your site on LinkedIn or on twitter? Thank you!

Thank you very much for giving me the opportunity. It’s amazing Vedio’s

I took this course before and I didn’t do well cause I was working full time I did’t have time to study.

Hi Sumit, i cannot see videos for Lesson 8 – Number Formatting in Excel,Lesson 9 — Excel Formula Basics and many more. Though i have viewed those videos in the past but they aren’t available currently. is there a restriction in the number of times that once can view a particular video lesson?

Hi Pooja… There was some minor update going on which prevented the videos from loading. You can watch these now. There is no restriction

Watched the first video and it’s wonderful. Thank you. However the second video doesn’t show. I will jump to the third and hope the 2nd returns. Thanks again

Hello Morgan, There was some minor update going on which prevented the videos from loading. You can watch all the videos now.

That’s great. Thank you. This is a great site

THANK YOU IT HELPED ME LOT TO USE EXCEL

Most valuable help I ever received from internet. Great Work

I have really found you to be clear and concise in your presentation. It is very easy to follow and is a great brush up for my rusty skills. Thanks you!!!

Thank you for doing this. Very selfless of you to share your knowledge for free.

Can i down load and go through later

There used to be a feature in excel that let you send the sheet to a list of people to add data in a sequence – is this still available?

I really want to build a carrier in Excel. I will be glad I get it here.

Can I zoom in on training to make it larger

it’s great to help & service to people.

We glad to have this guide for our reference to learn the Excel free. I have got this link when ‘am searching for some relevant topics, I’ve gone through it and the exact required knowledge is you shared.

Appreciated for your efforts keep rocking more like this.

Thank you in advance… I am working in excel from last 7 years, wanted to learn more 1) passionate about excel 2) need a better career growth, let me start with this, if require will take help further.

I have a small problem with vlookup i am getting few errors on few cell and i am unable to solve the issue can u pls help me

Hello I want to create a business cards alphabetical file Is there any tips you can give me to make it easier

Do i need to enrol to be part of this training-iam interested!!!

No, you don’t need to enroll. Just click on a video and start watching. It’s completely free to access

I am not able to download the EBook sir, can you pls help me

Really it’s awesome,, how generous you are in giving these crucial knowledge for free to who wants to learn excel. I feel you are doing charity on the behalf of excel. Sir I salute you . It’s bravo and majestic. God may bless you through your ahead intiatives. Thank you, sumit bansal

Hello sir, thankyou so much for free excel online training materials. This will gonna really helpful to people who want to learn excel online for free. I would like to know is there any Certificate available after compilation of this course?

A1 AHU – 9 A2 AHU – 15 A3 Boiler – 20 A4 Boiler – 33 A5 Boiler – 5 A6 Chiller – 8 A7 Chiller – 7 A8 Chiller – 9 A9 Chiller – 8 A10 Chiller – 9

How to count that How much AHU, Chiller & Boiler’s point in my sheet. I Have 1000 Data in sheet.

You can get it from pivot table, select d whole data, go to insert (top left side) you will get pivot table option.drag the name in column table and value in value table. ( just check in table value is in sum format or count format, accordingly you can change)

AHU – 9 AHU =LEFT(A1,FIND(“– “,A1,1)-2) AHU – 15 AHU =LEFT(A2,FIND(“– “,A2,1)-2) Boiler – 20 Boiler =LEFT(A3,FIND(“– “,A3,1)-2) Boiler – 33 Boiler =LEFT(A4,FIND(“– “,A4,1)-2) Boiler – 5 Boiler =LEFT(A5,FIND(“– “,A5,1)-2) Chiller – 8 Chiller =LEFT(A6,FIND(“– “,A6,1)-2) Chiller – 7 Chiller =LEFT(A7,FIND(“– “,A7,1)-2) Chiller – 9 Chiller =LEFT(A8,FIND(“– “,A8,1)-2) Chiller – 8 Chiller =LEFT(A9,FIND(“– “,A9,1)-2) Chiller – 9 Chiller =LEFT(A10,FIND(“– “,A10,1)-2)

hello sumit, thanks for your videos, they are really nice and it really helped me to learn from scratch.

Hey sir I wll be starting Excel training course great opportunity with me

Hi Sumit..The content and the communication are nothing less than excellent. Thanks.

I Want to Join.

Hello sir, I will start by thanking you greatly for this opportunity, the module are so powerful and I don’t want to miss a thing . I promise to recommend it to friends too.

After I finished the course can I have any certificate or what

Thank you very much dear Sumit 🙂

Thank you Summit, I do self-study and it gives me confident day by day.

Dear Sumit Sir,

Thanks a lot for this free excel training course. Never thought that i can learn so many things in this course. My confidence level has gone up now.

The way you explain the tutorials are very easy to understand.

You are Truly MVP. Hats off

I was looking for a way to learn Excel for free. I just lost my job and I see that most of the companies require knowledge of using Excel. I will let you know my results when I am done here!

Excel video

How can i enroll this course ?

Nothing to do enroll. All things are in front of your finger tips, start with praying to sumit bansal and keep going, rock on

Thanks Sumit for your excellentwell-paced method of teaching the basics in excel. I am an older adult who ‘missed the train’ on this kind of information. I was just asking my son for some assistance when I found your video. This has given me hope that I may be able to pursue your advanced Excel course if I master the basics. O I am so excited!

Really appreciable sir, you are extremely brilliant, and really doing good work for helping student in excel tutorial, each and everything you are making clear to student in each video even tiny things you are covering and your voice is so clear and very simple way to make understand. thank you so much

Thanku sir for this wonderful excel videos but sir i want certificate with this so can you provide certificate of this or not?

For certificate you can go through udemy! Course,, if you are willing to get certificate, thank you, rock on!

I’m looking for a procedure that will allow my to put a date and image on one tab, and show the image in a calendar on the calendar date tab on the images birthday

This is the most helpful teaching website regarding excel I have come across online. Your teaching style is really passionate, your way of explanation is very clear and you obviously deserve a load of respect and appreciation. It helps me a lot in better understanding excel, and also motivates me to dive deeper into further learning.

Excellent. Explanation is brilliant.

Thanks very much for tutorials, I like to know if there is a way to make just a cell behave as a normal calculator. i.e this cell should be capable of summing figures that appears in another cell, while keeping last cumulative figure visible. This other cell will be the key-in cell or active cell. Example: Cell 1: =2*5, Answer appears in Cell 2, Cell 1: =3*6.8, Answer is added to the previous value resulting from (2*5) and still appears in cell 2. Kindly share a video if this is possible. Thank you.

Excellent Course. Really useful. Thanks!

I have searched online and came across your youtube video tutorial on how to count color using function and macro module programing in excel. I am traying to count the highlighted cell that contains a specific numbers inside of the cell highlighted in color using your code. Can you help me to verify the changes that I have to make to count and add the cell value instead of adding “TotalCount = TotalCount +1” use “TotalCount = TotalCount + “Cell value”” ? What should I change to add the values inside of the cell instead of 1? Your or anyone’s help is deeply appreciated.

Hey! in lesson4, almost at the start of the video, you select a group of cells and address them together with the help of a colon, and as you type the no. 1, it appears in every cell. when I do the same, it isn’t happening. why?

highlight the cells you want to enter the information in, type the information then press CTRL+Enter

I would like to learn the importance of this course which helps me in resume as an addon and can be fast in computer operations with Latest knowledge

Excellent for beginners

Excellent platform and tutorials for beginners.

Yes, Sumit it is exciting to Join with your Free Excell training videos. I learnt a lot and appreciate your Teaching skills. It is so easy to understand each step as you move forward. Thanks and Blessings. Great work.

Hello I am reviewing your free excel training course. Does your course offer practice after watching the videos?

I am trying to give this to my employees. However, I would like to give them a practical test to be sure they went through all training modules. Could you help with this?

I tried to clean data by using the methods suggested by you in one of your lesson. But could not successfully clean certain data sets. How can I send it to you for your help?

how can send a query in excel

Thanks a lot. I receive more about Excel.

wonderful teaching and lessons.Thanks Lot. I learnt Lot

I receive more knowledge related Excel thinks you if you have other levees of excel send me linked

Can I get any kind of proof that I completed the modules at the end?

Thank uuuuuu

Excellent, learnt what I needed to. Easy to understand

I am unable to open the lessons???

I feel very happy not only to be enriched with learning Excel tips by you but also to be enjoyed by your way of imparting training.I express my thanks & gratitude to your contributions to us. But one fact is that I am unable to download ebook “Excel The Smart Way”. How can I be able to download the book? Please suggest me.

Cannot open your lessons for Excel Basics. Any direction appreciated. Thanks

Excellent Sumit! I truly wish to appreciate your way of teaching and effort you put in while creating these videos. I learnt a lot

is there any thing by which I can search old photos, through newly clicked photo. I have a folder in which I have approx 1000 photos and want to search old photos of same person i clicked today.

Hi, Im subscribed to a mail list for 31 videos ([Excel Video 8 of 31] today) buy i want to subscribe a friend but I dont see where he has to click to subscribe to the list. Can you tell me what he neds to do? thanks in advance

Thank you Sumit for giving us your time and teaching us Excel. I am subscribed to your YouTube channel. The Excel in two minutes series contains nine parts. I am unable to access parts five through nine because they are listed as private. If this is in Error will you correct it so I can view those videos please?

I have so many row and column and all Cell have Filled with Like ‘Pradeep’. and I want to remove all Single quotes from all cell

Thanks in advance .

You can do this with Find and Replace

Fantastic videos Mr. Sumit, very appreciate I feel like i am in a good value class of excel

Thanks for commenting Alkozai! Glad you found the videos useful 🙂

thank you soooo much!!! Very appreciate for all you have done.!!!

Thanks for commenting! Glad you found the videos useful

Thank you so much, very helpful videos. you are awesome.

Thanks for commenting Rachid! Glad you found the videos useful

I Click on the lessons and they do not open???

Can you try again Rose? If you still don’t see the videos, you can also access these from this link – https://www.youtube.com/playlist?list=PLm8I8moAHiH2kkq0S9XGvIbPODrHzXRp6

Thanks you summit for your knowledge.

Good Morning, I am having a problem with finding the video’s to watch. Can you help me with this Any suggestions? Thanks

Hello Courtney.. You can find the videos as soon as you click on the gray bar. If you still don’t see the videos, you can also access these from this link – https://www.youtube.com/playlist?list=PLm8I8moAHiH2kkq0S9XGvIbPODrHzXRp6

Thanks you Sumit for your knowledge.

Thanks for commenting Zayar! Glad you found the videos useful

Good morning. I am having the problem where no video pops up when gray bar is clicked. I tried ctrl+F5. It didn’t help. Any suggestions? Thanks.

You can also access these from this link – https://www.youtube.com/playlist?list=PLm8I8moAHiH2kkq0S9XGvIbPODrHzXRp6

Thank you Sumit for all your knowledge, so expertly delivered.

I am glad this excel training is free. Thank you very much for this helpful information!

Thanks for commenting Rachael! Glad you found the videos useful

Hi I have hundreds of rows and I want to multiple select rows over 10 columns with bold fonts only, I saw you video on filtering cells that contain bold font, do you have similar for rows with bold font instead of cells?

if want learn advance excel how much charge i pay

I need to learn more about excel

Hi… your videos are very detailed and very helpful…thank you for all your efforts in sharing your knowledge..

Would like to learn about complete advance excel.I feel it is difficult n little complicated

HI Sumit these are really useful videos. Do you have similar trainings for google sheets?

Do you provide a certificate of completion?

Do you get a certificate on completion of the course

Just seen 4 of them today intial ones and its superb, no need to go anywhere. Simply and Easiest way to learn excel from Sumit Bansal

I want to know If i want to create a data for my students in which i have name ,address,phone and email And categories them using Drop down feature according to their subject

And automatically update them in DIFFERENT EXCEL DATA AS PER SUBJECT

LIKE MASTER SHEET Having All Students

And different sheets having name and address according to subject like

Maths students Science students English students

hello, i used your video for the indirect drop downs and it was very helpful. The only problem that I am having is that some of them work and others do not. Is there an easy fix for this?

This is nice I m a engineer so plz teach me only chart, diagram,engineering related video

Thanks for the videos, your method of explanation is very superb. God bless you

As a beginner with Excel, I really enjoy your tutorials and it helps a lot…… thank you Mr Simit, Hope to learn more from you as I go along with more free tutorials.

Truly appreciate the time and effort you put in to this for free! Maybe add a donate button or something so people that want to can show their appreciation with moolah! I haven’t even watched one video yet just had to comment.

Today is Thursday, August 8, 2019 and I used these videos to relearn how to use excel. They were extremely helpful. Even more happy this training was free.

Thank you Summit! (From CT)

You are a miracle. Created vids, summaries for free. More than just an average youtuber. Thank you so much. Greetings from Long Beach CA

Can you please upload a video on mail merge particularly with many-to-one option.

I chanced upon this website and felt the absolute need to thank you for sharing your knowledge.

After successful completion, will you give certificate to show when required?

Thank you so much for this course it is really helping me you are such a good person to do this for us all.

Thank you Sumit for an excellent training course!

Now I have a question, not about your course, but if you coluld solve this problem I would be grateful. Do you know how to get rid of the usernaume in comments? I know I could go via Alternative/Genereral/Microsoft Office/Username etc. but that does not solve the problem. If I put a space instead of my name, or my initials, it still writes “:” in bold character and I want a empty comment when I start writing in it.

I think it must be solved by VBA code? And I don’t know how to write it, so if you know, and if you can help me, I would appreciate that.

I think it is very annoying that I have to delete my name (or initials) in everey new comment I make. Must be a way to get around it?

Kind regards, Leif Norinder

Dear Sumit Bansal, I am really appreciate you concern to teach people without any interest. that is a really surprised me in this current mindset of the people. again thank you for your kindness.

This is so helpful- thank you so much!

Will I be graded/ receive a certificate of completion?

Hello Connie.. Since this is a free training, there is no certificate for completion or grading

I Got Stuck That You Just Told Us IN a Video… Kindly Tell Me How Can I Connect With You For Solution

Thank you Mr Summit. You are the bomb.

Glad you found the training useful!

By learning this course would I have completed advanced level or just basic or intermediate?

This course will make you an intermediate Excel user. If you’re looking for more advanced courses, check these – https://trumpexcel.com/learn-excel/

Hello Sumit, Can I share your youtube videos on my Facebook Page. I will write credit to your name and mention your website any other services you offer. Thanks.

Sure.. Feel free to share

As a student who needs additional time to truly grasp the concepts of Excel, this site is an absolute LIFE SAVER! Thank you so much Sumit!

Thank you for the kind words Mujeeb.. Glad you find the site useful 🙂

Cant believe so much detailed training and guidance for free. Thank you so much Sumit.

Glad you’re finding the training useful Darren 🙂

Thank you so much -your tutorials have been a great help!

Glad you’re finding the training useful Fran

Great job! One question, I am calculation the available FTE per month with Excel Leave Tracker Template, I have to use the # of work days, how I am going to calculate this value and use it in the summary table. Thank you

so nice easy to understand

Hello. Hira

Thank you so much for this structured and comprehensive Excel Tutorials which I found very informative, and the best part of it is that it is totally free. I really appreciate your time and effort giving an opportunity for those who need this materials, including myself. I believed this free Excel Tutorials will help me a lot to land my home-based job.

Thanks once again and God bless your knowledge and expertise.

This is awesome!!!!!!!!!!!!!!

Hello Sumit, I like how you have divided the course into different modules and videos. I have done accounting and finance in the past so I feel this is really needed for my growth and career. If I complete all these videos and practice, will I be able to operate basic to intermediate excel ?

Hello Shriya.. Glad you found the course useful. Yes, you would be able to handle basic to intermediate tasks in Excel after watching the videos and going through the practice files.

Thank you Sumit. Also wanted to ask you, I use Macbook so there are few things which are different in Excel in Macbook. If possible can you upload a video where you mention those few differences. For eg. I can’t find a dialogue box in Excel on Mac. Can you help me with that.

Thank you for the great help.

Wonderful! Thank you!

Sounds good to me!!

I want and NEED a good part-time office job but don’t have the computer skills that many jobs require and have liked working with numbers in the past.

Hello Lisa.. Good working knowledge of Excel should definitely help you get a job

You are a fantastic man to offer your services to educate those that need to learn about excel …. for free. How refreshing it is to hear you speak (not too fast, nor too slow) in a manner that is clear and understanding. Thank you most kindly.

Thank you so much for the kind words Fiona.. Happy you found the course useful 🙂

Hi, none of the videos are working… I tried several times in vain

Working alright at my end. You can also watch the course videos here – https://www.youtube.com/watch?v=UPABcYhugZk&list=PLm8I8moAHiH2kkq0S9XGvIbPODrHzXRp6

Hello Mr. Sumit,

I am unable to find “Developer tab” and “Customizing Ribbon and QAT” options in Excel 2007 . Kindly help me how can I access these options ?

Have a look at this – https://trumpexcel.com/excel-developer-tab/

Sorry, unable to find the ‘customize the ribbon’ toolbar in 2007 excel. I guess I need to upgrade excel with 2013 version.

Is this a certification course ? If not, then what should we do to get a certificate for our learnings ?

Hello Dhiraj.. This is a free course so no certificate is issued for completing it

Will I receive a certificate of completion for this training?

Hello Terri.. This is a free course so no certificate is issued for completing it

I created some data in Sheet 1, Cell A1 (in Excel 2016), and I linked these contents of Sheet 1 to Sheet 2, Cell A1. I created a link to enable the contents of Sheet 1 (Cell A1) to appear automatically in Sheet 2 so that whenever I change the contents of Sheet 1, the same automatically changes in Sheet 2. To quickly go back to Sheet 1 (where the original data is contained), I used DOUBLE-CLICK method and, as expected, Excel immediately moved back to Sheet 1, Cell A1.

However, when I use my laptop at home (also Excel 2016) and try to DOUBLE-CLICK when I am in Sheet 2 in order to quickly go back to Sheet 1, Cell A1, instead of linking me to Sheet 1, the cursor is just blinking in Sheet 2.

Question: How do I change the settings of my laptop at home to enable me jump from Sheet 2 to Sheet 1 upon double-clicking the link in Sheet 2, Cell A1, to enable me to go to the actual location of my data in Sheet 1? Thank you.

Hi Sir! Thank you for this three tutorial. Unfortunately, I don’t see any video to watch. What should I do?

When you click on the gray bars on the page above, you will get the video that you can watch. Are you not getting any videos when you click on the gray bar?

No, I don’t see any videos. Just a list of what we will learn in the section.

Can you please try now? Also, refresh the page (hold the control key and then hit the F5 key). This should fix the issue

That’s perfect! Thank You Sumit.

Click on the link and then scroll down slowly, so you do not pass it up, until you see the box with the video area….

no. not getting any videos

Sumit You are truly an MVP. Your videos and instructions are fantastic, they are easy to understand, not cumbersome or a burden to watch and your instruction is simple and precise. I have used Excel for a very long time but each time I need an answer you are my go to search and instructor and it goes without saying I always find what I am looking for. Are you as good in other aspects of the MS Suite or Master of one? Let me know. Thanks for your support. Paramveer Sidhu

Thank you so much for the kind word Paramveer 🙂 I only focus on MS Excel. While I use most of MS apps, I am not as deep into it as I am in Excel.

Are you on linkedin?

Wonderful learning tool for work experience

Hi Sumit Bansal,

I don’t find any video link in this page…

Video links?

Hi, the links to your videos disappear. Could you please fix it?

Where are the links to start the course – videos??

Click on the link and then scroll down slowly, so you do not pass it up, until you see the box with the video area….

Bro where is the link to videos????

Your website provides excellent insight in Excel which is very useful for every type of end user.

I am struggling with an issue, I am unable to resolve myself and I hope you can give me right direction: In my first worksheet “dataentry” I have a column A and B, where column A is a dropdown list with numbers and column B is a dependent dropdown list related to column A. On my second worksheet “datalists” I created the value lists related to column A and B. The problem lies in the fact that on the “datalist” worksheet Column A defines the value list which should be displayed when selecting the value for Column A on the “dataentry” but that I want to see the full description from Column B from the “datalist” sheet in my dropdown list. Similarly, on the “datalist” worksheet Column C defines the value list which should be displayed when selecting the value for Column B on the “dataentry” but that I want to see the full description from Column D from the “datalist” sheet in my dropdown list.

I hope I made my problem clear and really hope you are able to help me out here.

Thanks in advance!

really helpful pls post some course on advance excel such as vlookup & hlookup, data validation

Do they give a certificate on completion of course too?

I enjoy your courses, you make learning Excel easy !!

Need your support on power query. I have gone through the video of merging multiple workbooks into one workbook. That was an interesting feature. However need to know one thing. In case we have two worksheets on three workbooks with similar names, is it possible to merge into one having the end result as a combined workbook with two worksheets

Thank you Sumit. Your sessions are awesome and its a great learning for all of us

do i get any certificate after completing this course?

I have 1 to 20different amount & m No10fdeleted how to shift up 11 to 20 up

Thank You Sumit, you have a heart for people and an understanding of their needs, I honour you for the gift that you are sharing with us, I pray blessings over any venture that you set your heart on.

Great Job Sumit

Thanks a lot Sumit

its a really helpful for people who will not spend money to learn that course.. thank you so much sir…. if it is possible please make these videos to downloadable ….

Thanks sumit … all videos are great and very helpful…. And again thank you so much, making this course free so that more people engaged to learn excel.

Thank you so much, making this course free will get more people engaged to learn excel the right way

Great learnng excell.

thank you so much, you are very generous.

Where can I download the videos used in the course? Thanks

You can’t download them…

Thank you Sir, I am delighted with your work. Your hard work and dedication have brought positive changes in learning excel. Though i could not yet prepared excel sheet for fetching the fund mutual fund units from nse mf fund for my portfolio. I am trying to prepare requisit worksheet in excel 2007. Thanks again.

When you click on the gray bars on the page above, you will get the video that you can watch

I can’t find any links to the videos. When I click on a grey bar, it expands with a detail of the contents of the lesson, but I can’t see any video or link to same.

Just discovered the cause of this problem: my Adguard blocker was stopping the display of the video. AOK now. Thanks.

Aha! My adblocker was preventing the videos from appearing. When I turned it off, the videos appeared. Thank you.

Leave a Comment Cancel reply

BEST EXCEL TUTORIALS

Best Excel Shortcuts

Conditional Formatting

Excel Skills

Creating a Pivot Table

Excel Tables

INDEX- MATCH Combo

Creating a Drop Down List

Recording a Macro

© TrumpExcel.com – Free Online Excel Training

Privacy Policy  | Sitemap

Twitter | Facebook | YouTube | Pinterest | Linkedin

FREE EXCEL E-BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

• Ablebits blog
• Excel formulas

Basic Excel formulas & functions with examples

The tutorial provides a list of Excel basic formulas and functions with examples and links to related in-depth tutorials.

Being primarily designed as a spreadsheet program, Microsoft Excel is extremely powerful and versatile when it comes to calculating numbers or solving math and engineering problems. It enables you to total or average a column of numbers in the blink of an eye. Apart from that, you can compute a compound interest and weighted average, get the optimal budget for your advertising campaign, minimize the shipment costs or make the optimal work schedule for your employees. All this is done by entering formulas in cells.

This tutorial aims to teach you the essentials of Excel functions and show how to use basic formulas in Excel.

The basics of Excel formulas

Before providing the basic Excel formulas list, let's define the key terms just to make sure we are on the same page. So, what do we call an Excel formula and Excel function?

• Function is a predefined formula already available in Excel. Functions perform specific calculations in a particular order based on the specified values, called arguments, or parameters.

For example, instead of specifying each value to be summed like in the above formula, you can use the SUM function to add up a range of cells: =SUM(A2:A4)

Clicking the function's name will turn it into a blue hyperlink, which will open the Help topic for that function.

Tip. You don't necessarily have to type a function name in all caps, Microsoft Excel will automatically capitalize it once you finish typing the formula and press the Enter key to complete it.

10 Excel basic functions you should definitely know

What follows below is a list of 10 simple yet really helpful functions that are a necessary skill for everyone who wishes to turn from an Excel novice to an Excel professional.

The first Excel function you should be familiar with is the one that performs the basic arithmetic operation of addition:

In the syntax of all Excel functions, an argument enclosed in [square brackets] is optional, other arguments are required. Meaning, your Sum formula should include at least 1 number, reference to a cell or a range of cells. For example:

=SUM(B2:B6) - adds up values in cells B2 through B6.

=SUM(B2, B6) - adds up values in cells B2 and B6.

If necessary, you can perform other calculations within a single formula, for example, add up values in cells B2 through B6, and then divide the sum by 5:

=SUM(B2:B6)/5

To sum with conditions, use the SUMIF function: in the 1st argument, you enter the range of cells to be tested against the criteria (A2:A6), in the 2nd argument - the criteria itself (D2), and in the last argument - the cells to sum (B2:B6):

=SUMIF(A2:A6, D2, B2:B6)

Useful resources:

• Excel Sum formula examples - formulas to total a column, rows, only filtered (visible) cells, or sum across sheets.
• Excel AutoSum - the fastest way to sum a column or row of numbers.
• SUMIF in Excel - formula examples to conditionally sum cells.
• SUMIFS in Excel - formula examples to sum cells based on multiple criteria.

The Excel AVERAGE function does exactly what its name suggests, i.e. finds an average, or arithmetic mean, of numbers. Its syntax is similar to SUM's:

Having a closer look at the formula from the previous section ( =SUM(B2:B6)/5 ), what does it actually do? Sums values in cells B2 through B6, and then divides the result by 5. And what do you call adding up a group of numbers and then dividing the sum by the count of those numbers? Yep, an average!

The Excel AVERAGE function performs these calculations behind the scenes. So, instead of dividing sum by count, you can simply put this formula in a cell:

=AVERAGE(B2:B6)

To average cells based on condition, use the following AVERAGEIF formula, where A2:A6 is the criteria range, D3 is he criteria, and B2:B6 are the cells to average:

• Excel AVERAGE - average cells with numbers.
• Excel AVERAGEA - find an average of cells with any data (numbers, Boolean and text values).
• Excel AVERAGEIF - average cells based on one criterion.
• Excel AVERAGEIFS - average cells based on multiple criteria.
• How to calculate weighted average in Excel
• How to find moving average in Excel

MAX & MIN

The MAX and MIN formulas in Excel get the largest and smallest value in a set of numbers, respectively. For our sample data set, the formulas will be as simple as:

=MAX(B2:B6)

• MAX function - find the highest value.
• MAX IF formula - get the highest number with conditions.
• MAXIFS function - get the largest value based on multiple criteria.
• MIN function - return the smallest value in a data set.
• MINIFS function - find the smallest number based on one or several conditions.

COUNT & COUNTA

If you are curious to know how many cells in a given range contain numeric values (numbers or dates), don't waste your time counting them by hand. The Excel COUNT function will bring you the count in a heartbeat:

While the COUNT function deals only with those cells that contain numbers, the COUNTA function counts all cells that are not blank , whether they contain numbers, dates, times, text, logical values of TRUE and FALSE, errors or empty text strings (""):

For example, to find out how many cells in column B contain numbers, use this formula:

=COUNT(B:B)

To count all non-empty cells in column B, go with this one:

=COUNTA(B:B)

In both formulas, you use the so-called "whole column reference" (B:B) that refers to all the cells within column B.

• Excel COUNT function - a quick way to count cells with numbers.
• Excel COUNTA function - count cells with any values (non-empty cells).
• Excel COUNTIF function - count cells that meet one condition.
• Excel COUNTIFS function - count cells with several criteria.

Judging by the number of IF-related comments on our blog, it's the most popular function in Excel. In simple terms, you use an IF formula to ask Excel to test a certain condition and return one value or perform one calculation if the condition is met, and another value or calculation if the condition is not met:

For example, the following IF statement checks if the order is completed (i.e. there is a value in column C) or not. To test if a cell is not blank, you use the "not equal to" operator ( <>) in combination with an empty string (""). As the result, if cell C2 is not empty, the formula returns "Yes", otherwise "No":

• IF function in Excel with formula examples
• How to use nested IFs in Excel
• IF formulas with multiple AND/OR conditions

If your obviously correct Excel formulas return just a bunch of errors, one of the first things to check is extra spaces in the referenced cells (You may be surprised to know how many leading, trailing and in-between spaces lurk unnoticed in your sheets just until something goes wrong!).

There are several ways to remove unwanted spaces in Excel, with the TRIM function being the easiest one:

For example, to trim extra spaces in column A, enter the following formula in cell A1, and then copy it down the column:

• Excel TRIM function with formula examples
• How to delete line breaks and non-printing characters
• How to remove non-breaking spaces (&nbsp;)
• How to delete a specific non-printing character

Whenever you want to know the number of characters in a certain cell, LEN is the function to use:

Wish to find out how many characters are in cell A2? Just type the below formula into another cell:

Want to get the total count of characters in a range or cells or count only specific characters? Please check out the following resources.

• Excel LEN formulas to count characters in a cell
• Count the number of characters in cells and ranges

AND & OR

These are the two most popular logical functions to check multiple criteria. The difference is how they do this:

• AND returns TRUE if all conditions are met, FALSE otherwise.
• OR returns TRUE if any condition is met, FALSE otherwise.

While rarely used on their own, these functions come in very handy as part of bigger formulas.

For example, to check the test results in columns B and C and return "Pass" if both are greater than 60, "Fail" otherwise, use the following IF formula with an embedded AND statement:

=IF(AND(B2>60, B2>60), "Pass", "Fail")

If it's sufficient to have just one test score greater than 60 (either test 1 or test 2), embed the OR statement:

• Excel AND function with formula examples
• Excel OR function with formula examples

CONCATENATE

In case you want to take values from two or more cells and combine them into one cell, use the concatenate operator (&) or the CONCATENATE function:

For example, to combine the values from cells A2 and B2, just enter the following formula in a different cell:

=CONCATENATE(A2, B2)

To separate the combined values with a space, type the space character (" ") in the arguments list:

• How to concatenate in Excel - formula examples to combine text strings, cells and columns.
• CONCAT function - newer and improved function to combine the contents of multiple cells into one cell.

TODAY & NOW

To see the current date and time whenever you open your worksheet without having to manually update it on a daily basis, use either:

=TODAY() to insert the today's date in a cell.

=NOW() to insert the current date and time in a cell.

• How to insert today's date in Excel - different ways to enter the current date in Excel: as an unchangeable time stamp or automatically updatable date and time.
• Excel date functions with formula examples - formulas to convert date to text and vice versa, extract a day, month or year from a date, calculate the difference between two dates, and a lot more.

Best practices for writing Excel formulas

Now that you are familiar with the basic Excel formulas, these tips will give you some guidance on how to use them most effectively and avoid common formula errors.

Do not enclose numbers in double quotes

Any text included in your Excel formulas should be enclosed in "quotation marks". However, you should never do that to numbers, unless you want Excel to treat them as text values.

For example, to check the value in cell B2 and return 1 for "Passed", 0 otherwise, you put the following formula, say, in C2:

=IF(B2="pass", 1, 0)

Copy the formula down to other cells and you will have a column of 1's and 0's that can be calculated without a hitch.

Now, see what happens if you double quote the numbers:

=IF(B2="pass", "1", "0")

Don't format numbers in Excel formulas

Match all opening and closing parentheses, copy the same formula to other cells instead of re-typing it.

Note. After copying the formula, make sure that all cell references are correct. Cell references may change depending on whether they are absolute (do not change) or relative (change).

How to delete formula, but keep calculated value

When you remove a formula by pressing the Delete key, a calculated value is also deleted. However, you can delete only the formula and keep the resulting value in the cell. Here's how:

• Select all cells with your formulas.
• Press Ctrl + C to copy the selected cells.
• Right-click the selection, and then click Paste Values > Values to paste the calculated values back to the selected cells. Or, press the Paste Special shortcut: Shift+F10 and then V .

Make sure Calculation Options are set to Automatic

If all of a sudden your Excel formulas have stopped recalculating automatically, most likely the Calculation Options somehow switched to Manual . To fix this, go to the Formulas tab > Calculation group, click the Calculation Options button, and select Automatic .

This is how you make and manage basic formulas in Excel. I how you will find this information helpful. Anyway, I thank you for reading and hope to see you on our blog next week.

You may also be interested in

• How to make formulas in Excel
• Microsoft Excel formulas with examples
• Excel formulas not working, not updating, not calculating

Table of contents

411 comments

A VERY BIG THANKS .

I need the Excel formula number combination

One hundred and ten units (HTF) : 345,345,678,890,567

Summary of analysis results from 5 data If there is no incorrect information 036-037-046-047-056-057-058-158-258-358 368-369-378-379-458-468-469-478-479-558 568-569-578-579-588-589 (26 sets / total 26 sets)

Sorry, I have no idea exactly what the task is. It's hard to tell exactly what you're asking for as it's currently written.

For me personally It's clear that actually "seeing" something written down is easier to understand and remember than "hearing" it, but both together is even better.

Post a comment

• Skip to content
• Select language
• Skip to search

The web browser you are using is out of date, please upgrade .

Please use a modern web browser with JavaScript enabled to visit OpenClassrooms.com

Master the Basics of Spreadsheets

Free online content available in this course.

course.header.alt.is_video

course.header.alt.is_certifying

Last updated on 12/9/22

Course introduction

Hi, I'm Emily! I've been harnessing the power of spreadsheets for the last twenty years and have taught many others how to as well.

Whether you plan to use Excel, LibreOffice Calc, Numbers on Mac, or Google Sheets on Drive, follow this course to master the basics of spreadsheets. I'll take you through all the main features they have to offer and teach you how to enter, format, analyze, and visualize basic data.

In Part 1 of this course, we'll take a tour of a spreadsheet and cover basic fundamental features  like entering and copying data. You can skip ahead to the quiz if this isn't your first time using one!

In Part 2, we'll look at how to format your data and the layout of your spreadsheet. One helpful feature we'll cover is conditional formatting, which highlights data automatically.

In Part 3, we will go over  basic data analysis features including filtering, sorting, formulas and functions, and VLOOKUP.

In Part 4, we'll introduce you to  data visualization,  including how to create  pivot tables and charts.  You'll also learn how to share them as a PDF or publish them to the web.

If you want to be organized or start making sense of your data, then you are in the right place! Let's get started!

Only Premium members can download videos from our courses. However, you can watch them online for free.

Microsoft Excel Tutorials : Including Free Practice Exercises!

Right below you find +100 excel-tutorials. all tutorials are super practical and include free exercises. simply download the included sample file and start practicing your excel skills today.

More results...

Excel Line Spacing: How to Adjust Line Spacing (2024)

Excel Line Spacing: How to Adjust Line Spacing (2024) Sometimes, you may need to input a long text into your Excel spreadsheet. When you do, you need to make sure that it's organized and presentable, not only for your sake but for others as well😊 One of the many ways to do that [...]

How to Calculate MEDIAN IF in Excel (“MEDIANIFS” Formula)

How to Calculate MEDIAN IF in Excel ("MEDIANIFS" Formula)Excel is a powerful tool that can help you easily analyze and manipulate data.One of the most useful functions in Excel is the median function, which helps find the middle value in a set of data.However, what if you only want to find the median of [...]

How to SUM by color in Excel: Step-by-Step Guide (2024)

How to SUM by color in Excel: Step-by-Step Guide (2024) Most of you know how to get the Excel SUM. It's one of the most basic Excel functions. What most people don't know is that you can get the Excel SUM by color, too 🤩 There is no built-in function for this but [...]

How to do RANK IF in Excel to Rank With Condition (2024)

How to do RANK IF in Excel to Rank With Condition (2024) Ranking values in Excel is something very common. And with the RANK function, that’s not even a problem. However, if you want to perform a conditional (or criteria-based) ranking in Excel, this might be a little problem at first 😣 That’s [...]

Excel Not Responding – Here is How to Fix it (2024)

Excel Not Responding - Here is How to Fix it (2024) Excel is a powerful tool used by millions of people around the world to handle data 💪🏻 However, it is common for Excel users to get issues with Excel files such as the Excel not responding error. This is such a frustrating [...]

“Reference isn’t Valid” Excel Error: How to Fix (2024)

"Reference isn't Valid" Excel Error: How to Fix (2024) When you're working in Excel to organize and analyze your data, you may encounter different types of Excel errors ⚠️ Getting Excel errors is so frustrating because it hinders you from getting work done 😩 The "Reference isn't Valid" error is one of the [...]

Excel Ran Out of Resources – How to Fix it Step-by-Step (2024)

Excel Ran Out of Resources - How to Fix it Step-by-Step (2024) Microsoft Excel is an amazing tool that we can use to do our calculations. But, sometimes you get a headache with Excel when there are errors 😞 Most of the time you have to sort out these issues by yourself because [...]

How to use the Excel functions TRUE & FALSE (Boolean)

How to use the Excel functions TRUE & FALSE (Boolean) Written by co-founder Kasper Langmann, Microsoft Office Specialist. There are many functions in Microsoft Excel that are conditional by nature. They are based upon logical tests that result in either a TRUE or FALSE outcome. For example, you might manage a sales team. You [...]

How to Switch X and Y Axis in Excel (Flip Chart Axes)

How to Switch X and Y Axis in Excel (Flip Chart Axes) Written by co-founder Kasper Langmann, Microsoft Office Specialist. Knowing how to switch the x-axis and y-axis in Excel will save you a lot of trouble.  Microsoft Excel is powerful spreadsheet software that will let you store data and make calculations on [...]

How to Print Labels From Excel: Step-by-Step (2024)

How to Print Labels From Excel: Step-by-Step (2024) Mail Merge is one awesome feature that will help you create mass letters and email messages. But you can also use it to create and print mailing labels for your mailing list 😀 All you need to do is to prepare your label data in [...]

The 9 Best Project Management Templates for Excel (Free)

The 9 Best Project Management Templates for Excel (Free) Project managers are known for their decisiveness and time management. A project's success depends on how a project manager identifies, plans, and employs the resources available for any given project (especially the timespan). If you, too, have a complicated project ahead of you that [...]

Free Excel Dashboard Templates (My Top-6)

Free Excel Dashboard Templates (My Top-6) Excel dashboards are the difference between good and great data presentation. A well-built dashboard can breathe life into the most boring and mundane subjects. Simple Excel dashboards are easy enough to build if you follow a proper tutorial like ours here. But to truly wow your [...]

How to Create Macros in Excel: Step-by-Step Tutorial (2024)

How to Create Macros in Excel: Step-by-Step Tutorial (2024) Get ready to have your mind blown! 🤯 Because in this tutorial, you learn how to create your own macros in Excel! That’s right! And you don't need to know VBA (Visual Basic for Applications)! Instead, you will use the Excel macro recording feature [...]

How to Recover an Unsaved Excel File (5 Free Solutions)

How to Recover an Unsaved Excel File (5 Free Solutions) Losing an unsaved Excel file is a real pain🤕 Whether you lose an entire Excel spreadsheet or just the latest round of edits, it can take a lot of time to fix the problem. But don’t worry! In this guide, I’ve compiled the [...]

How to Insert a Checkbox in Excel (4 Uncomplicated Steps)

How to Insert a Checkbox in Excel (4 Uncomplicated Steps) If you want to collect user input in your spreadsheet there's no better way than the checkbox. User-friendly, slick-looking, and easy for you to work with. Well... After you learn it at least. If you're having a hard time understanding the ins [...]

How to Remove Blank Rows in Excel (3 Easy Methods)

How to Remove Blank Rows in Excel (3 Easy Methods) Choosing the right method to remove blank rows in Excel is crucial - a wrong move can lead to lost data. Method 1: Remove all rows that contain only blank cells Method 2: Remove all rows that contain one or more blank cells Method [...]

How to Use VLOOKUP in Excel: 4 Easy Steps (For Beginners)

VLOOKUP is one of the most well-known Excel functions – and not without reason. VLOOKUP’s ease of use and simplicity when “looking up” data is unparalleled in Excel. In this tutorial you'll learn how to create and troubleshoot a VLOOKUP.

How to Add Axis Labels in Excel Charts (X and Y Titles)

How to Add Axis Labels in Excel Charts (X and Y Titles) An axis label briefly explains the meaning of the chart axis. It's basically a title for the axis. Like most things in Excel, it's super easy to add axis labels, when you know how. So, let me show you 💡 If [...]

How to Use INDEX MATCH With Multiple Criteria in Excel

In this tutorial, you'll learn to use the MATCH INDEX functions with multiple criteria by following 5 easy steps. In the end, you'll have built a tool to search through your spreadsheet for information that you define. Don't miss this one!

How to Create a Drop-down List in Excel (in 60 Seconds)

The drop-down list is a great way to look like a superuser and impress your co-workers and boss. At the same time, it’s a very user-friendly asset in almost all custom-made Excel sheets. In this tutorial, we're going to show you the 5 steps to create a drop-down in 1 minute or less. We call it the “1 Minute Drop-Down”.

How to Count Duplicates in Excel (Words & Values)

How to Count Duplicates in Excel (Words & Values) Counting duplicates in Excel is a common task you may need to do multiple times for a data set. Excel offers a variety of ways you can use to count and remove duplicates values in your data set from conditional formatting to using VBA [...]

How to Cut Off Text in Excel (Keep Text in Cell)

How to Cut Off Text in Excel (Keep Text in Cell) When working with large data sets, you might often come across text that exceeds the boundaries of the cell and trespasses into those adjacent to it. Truncating text within a cell while keeping the content intact is often necessary to keep your [...]

How to Make a Frequency Table in Excel (Easy Method)

How to Make a Frequency Table in Excel (Easy Method) Knowing how to create a frequency table is an essential skill when comparing and analyzing data. As the name suggests, the frequency table lets you see the distribution of values in your data set by showing the number of times each value repeats [...]

How to Delete Hidden Rows in Excel (The Right Way)

How to Delete Hidden Rows in Excel (The Right Way) Hidden rows can be a reason for confusion and mistakes when working with a large data set. Regardless of why and how you hid the rows, they can be a pain to deal with when making data analysis. You need to know how [...]

How to Add Line of Best Fit in Excel (Easy Method)

How to Add Line of Best Fit in Excel (Easy Method) If you want to identify trends and patterns in your data set and make predictions based on them, adding a line of best fit in Excel is your way to go. It plays a pivotal role in data analysis and visualization and [...]

How to Switch Between Sheets in Excel (FAST!)

How to Switch Between Sheets in Excel (FAST!) Excel allows users to have 255 sheets in a single workbook. That’s a big number 🤯 Microsoft Excel is undisputedly the king of spreadsheets for storing and managing data. However, besides storing data, switching between these many sheets frequently might get very exhausting [...]

How to Create an Org Chart in Excel (That Looks Great)

How to Create an Org Chart in Excel (That Looks Great) Creating a visually appealing org chart can take your Excel data to a whole different level. It improves the overall look of your organizational structure. A well-structured org chart can help clarify roles, and reporting lines within the team. It makes understanding [...]

How to Import Data Into Excel (Without Errors)

How to Import Data Into Excel (Without Errors) Importing data in Excel is an essential task one needs to be familiar with when working with large data sets whether for academic research, personal projects or business reports 📑 The import process is quite simple but Excel often throws errors while importing. These errors [...]

How to Create a Schedule in Excel (Daily, Weekly & Work)

How to Create a Schedule in Excel (Daily, Weekly & Work) Creating a schedule in Excel is an efficient way to manage your time and ensure you meet your period goals and fulfil work commitments 🧐 Excel’s powerful features let you create outstanding customized schedules tailored specifically to your needs. You can make [...]

Calculate Yield to Maturity (Excel Formula YIELDMAT)

Calculate Yield to Maturity (Excel Formula YIELDMAT) The Yield to Maturity is a very valuable financial metric used to assess the returns offered by debt instruments until maturity. It is widely used in the world of finances and trading. The concept is somehow technical but very interesting. In this tutorial, I will walk [...]

Excel Practice Exercises PDF with Answers

To solve the following exercises, you will need to know about the SUM , AVERAGE , IF , VLOOKUP , INDEX , MATCH , ROUNDUP , UNIQUE , COUNTIF , LEFT , SEARCH , MID , RIGHT , LEN , FIND , SUBSTITUTE , AND , and SUMIF functions and the Data Bars feature of Excel. You can use Excel 2010 or later, except for the UNIQUE function, which is only available in Excel 2021 .

Download the Practice Files

You can download the PDF and Excel files by filling out this form:

Eleven Practice Exercises with Solutions.pdf [/wpsm_box] [wpsm_box type="download" float="none" textalign="left"] Eleven Practice Exercises.xlsx [/wpsm_box] -->

Problem Overview

Here is a snapshot of the first two problems. The solutions to all problems are given in a separate sheet.

• Exercise 01 – Class Performance Evaluation . You will find these values –
• The total number for each student,
• Their average on those subjects,
• Based on the average score, you will return a GPA. For GPA calculation, less than 60 is B and higher is A .
• You need to find the employee salary in the lookup table on the right side.
• Exercise 03 – Lookup Values (Any Direction) .
• Here your task is the same as the second task. However, this time the lookup range is on the right side. Therefore, you cannot use the VLOOKUP function here.
• You will need to round the sales generated values in this exercise.
• You will need to add the first name and last name.
• Your task is to create a Data Bar for the salary values and hide the salary values.
• Firstly, you need to find the unique values in a list of names.
• Then, you will find how many times that value occurred in that lis
• You need to separate the three parts of a name from a given list.
• You will need to find the total sales for a particular country.
• Your objective is to ensure that users cannot type less than 0 in a column.
• Your target is to determine whether a date is between two dates or not.

Here is a screenshot of the solutions to the first two problems.

What is ExcelDemy?

Rafiul Haq worked as an Excel and VBA Content Developer in Exceldemy for over two years and published almost 200 articles for the website. He is passionate about exploring new aspects of Excel and VBA. He received his Bachelor of Science in Mechanical and Production Engineering (MPE) from the Islamic University of Technology. Rafiul furthered his education by obtaining an MBA in Finance from the Institute of Business Administration (IBA) at the University of Dhaka. Apart from creating... Read Full Bio

You really help me alot thanks

Hello, Aleem!

Thanks for your appreciation. stay in touch with ExcelDemy .

Regards ExcelDemy

Thanks a lot

Dear Rashmi ,

You are most welcome.

This is very helpful. You are God send

Thanks for your appreciation.

Leave a reply Cancel reply

ExcelDemy is a place where you can learn Excel, and get solutions to your Excel & Excel VBA-related problems, Data Analysis with Excel, etc. We provide tips, how to guide, provide online training, and also provide Excel solutions to your business problems.

Contact  |  Privacy Policy  |  TOS

• User Reviews
• List of Services
• Service Pricing

• Create Basic Excel Pivot Tables
• Excel Formulas and Functions
• Excel Charts and SmartArt Graphics
• Advanced Excel Training
• Data Analysis Excel for Beginners

Advanced Excel Exercises with Solutions PDF

How-To Geek

Excel for beginners: the 6 most important tasks to know.

Your changes have been saved

Email Is sent

Please verify your email address.

You’ve reached your account maximum for followed topics.

How to Add Emulated Games to Your Steam Deck Library With EmuDeck

Younger gamers are ignoring classic games, so i asked them why, the xbox 360 storefront is closed, but you can still buy digital games, quick links, entering data in excel, managing spreadsheets, adding and removing columns and rows, formatting numbers, formatting fonts and cells, performing quick calculations.

If you've never spent time using Microsoft Excel, it can feel a bit overwhelming at first. We'll teach you the basic tasks you need to know to use this popular spreadsheet application.

From entering data and formatting numbers to adding cell borders and shading, knowing these essentials will ease the stress of learning to use Excel.

You have two easy ways to enter data in the cells of an Excel sheet.

Related: All the Best Microsoft Excel Keyboard Shortcuts

First, you can click the cell and type your data into it. Second, you can click the cell and type the data into the Formula Bar which is at the top of the sheet.

You can also copy data from another location and paste it in your sheet . Once you copy it, select the cell in your sheet and paste it by doing one of the following:

• Use the keyboard shortcut Ctrl+V on Windows or Command+V on Mac.
• Click "Paste" in the Clipboard section on the Home tab.
• Right-click the cell and pick "Paste" in the shortcut menu.

For more ways to paste like multiplying numbers as you do, look at our how-to on using Paste Special in Excel .

You can add many sheets to your Excel workbook. This is handy for handling projects that require separate spreadsheets.

Related: How to Change the Color of the Worksheet Tabs in Excel

To add a sheet, click the plus sign on the far-right side of the sheet tab row. This adds a spreadsheet to the right of the active one.

Alternatively, go to the Home tab, select the Insert drop-down box in the Cells section of the ribbon, and pick "Insert Sheet." This adds a spreadsheet to the left of the active one.

When you add a sheet, it has a default name of Sheet with a number. So, you'll see Sheet1, Sheet2, and so on. To rename a sheet, double-click the current name or right-click and pick "Rename." Then, type the new name and press Enter or Return.

To rearrange sheets, select one and drag it left or right to the spot where you want it. Then, release.

To color the tab for a sheet , right-click the tab, move to Tab Color, and select a color in the pop-out menu. This is a great way to spot certain sheets at a glance or color-code them for specific tasks.

To remove a sheet , right-click and choose "Delete." If the sheet contains data, you'll be asked to confirm that you want to delete the sheet and the data. Select "Delete" to continue or "Cancel" to keep the sheet.

You may discover that you need an additional column or row within your data set. Or, you might decide to remove a column or row you no longer need.

Related: How to Add and Remove Columns and Rows in Microsoft Excel

Add a Column or Row

You can insert a column or row a couple of different ways.

• Right-click a column or row and choose "Insert" from the shortcut menu. 
• Select a column or row and go to the Home tab. Open the Insert drop-down box in the Cells section and pick "Insert Sheet Rows" or "Insert Sheet Columns."

Both of the above actions insert a column to the left of the selected column or a row above the selected row.

Remove a Column or Row

To remove a column or row, you can use similar actions. To select a column, click the column header which is the letter at the top. To select a row, click the row header which is the number on the left.

• Right-click the column or row and choose "Delete" from the shortcut menu. 
• Select the column or row and go to the Home tab. Open the Delete drop-down box in the Cells section and pick "Delete Sheet Rows" or "Delete Sheet Columns."

For more, look at our tutorial for inserting multiple rows in Excel .

When you enter numbers in Excel , you can format them as ordinary numbers, currencies, decimals, percentages, dates, times, and fractions. 

Related: How to Use the Accounting Number Format in Microsoft Excel

Select a cell, go to the Home tab, and use the drop-down box in the Number section of the ribbon to pick the format. As you review the list of options, you'll see examples of how the data will appear. 

Pick the format you want, and you'll see your data update.

You can also choose the style for the number format you use. Click the small arrow on the bottom right of the Number section in the ribbon.

When the Format Cells box appears, go to the Number tab and select an option on the left.

On the right, you'll see a preview of the format with options below you can adjust. For example, you can choose the number of decimal places and how you want to display negative numbers .

After you make your selections, click "OK" to apply them to the value.

Along with formatting the data within a cell, you can format the cell itself. You may want to use a specific font style, apply a cell border , or add shading to a cell.

Related: How To Add and Change Cell Borders In Excel

Select the cell you want to change and head to the Home tab. You'll see several options in the Font section of the ribbon.

Font style and size : Use the drop-down boxes at the top to change the font style or size. You can also use the buttons to the right to increase or decrease the font size.

Bold, italics, and underline : Simply select one of these buttons to apply bold, italics, or underline to the font in a cell.

Border : Use the Border drop-down box to choose the type and style for the cell border.

Fill and font colors : Select the Fill Color drop-down box to pick a color for the cell or the Font Color box to pick a color for the font.

When you work with numbers in your sheet, it's common to perform calculations. Rather than delve into creating formulas in Excel, which is a bit more advanced, you can quickly add, average, or get the minimum or maximum number in a data set.

Related: 12 Basic Excel Functions Everybody Should Know

Go to the cell where you want to add the calculation. As an example, we'll sum the cells B2 through B6, so we pick cell B7.

Head to the Home tab and select the Sum drop-down box in the Editing section of the ribbon. You'll see the basic calculations you can perform. For our example, we select "Sum."

You'll then see Excel highlight the cells it believes you want to calculate. It also shows you the function and formula it'll use. Simply press Enter or Return to accept the suggestion and get the result.

Alternatively, you can start by selecting the cells you want to calculate. Then, choose the calculation from the Sum drop-down box. 

You'll see the result of the calculation below cells in a column or to the right of cells in a row.

As an Excel beginner, these basic tasks should get you off to a great start using the application. Once you master these actions, be sure to check out our additional Excel articles for things like creating a graph , using a table , and sorting or filtering data .

• Microsoft Office
• Microsoft Excel

Learning Center

Excel tutorials and practice tests.

Welcome to Automate Excel! Here you will find the best free Excel & VBA resources anywhere on the web. This page will direct you to all of our best content.

Scroll down the page to find detailed descriptions of our 100% FREE interactive tutorials, but you can use this top section to easily jump to our cornerstone resources.

Our VBA Tutorial and our VBA Code Generator as well as over 100 free VBA Code Examples .

Our VBA Formulas Tutorial and Excel Boot Camp as well as Formulas and Functions lists.

Our Excel ShortCut Training App , our popular ShortCut Coach Excel add-in and over 200 free Shortcuts .

Automate Excel and Steve Rynearson

Hi I’m Steve, The Chief Excel Officer at AutomateExcel. I'm here to help you "Excel" at Excel.

Courses and Examples

Get started with excel.

To start, we recommend going through our one-of-a-kind, completely free interactive Excel Tutorials.  These tutorials cover: Excel Formulas & Functions, VBA, and Keyboard Shortcuts. You will be asked to create a formula, use a shortcut, or type a line of VBA code directly into our web apps, receiving immediate feedback.

The tutorials cover at least 80% of what most Excel users would ever need to know.  Beginners love our tutorials because they’re the fastest (and easiest) way to learn Excel or VBA. We also receive many emails from experienced Excel users who report learning new tricks and brushing up on knowledge.

Our tutorials are completely free, but you will need to create an account to save your progress.

Our interactive tutorials also contain practice tests that allow you to test what you've learned. The practice tests also let you define a custom set of questions in which to test yourself.

Testimonials

100% free and interactive, excel practice tests and tutorials, formulas and functions.

Learn 30 of Excel's most powerful functions with 60 interactive exercises and many more examples:

• Intro to Formulas
• Logical & Comparison
• Statistical

Also learn about other formula essentials including:

• Formula Shortcuts
• Comparisons and Boolean Values
• How to use Text in Excel

Keyboard Shortcuts

Learn 77 of Excel's most powerful shortcuts.

• Selecting Cells
• Rows & Columns
• Data & Other Tools

'Learn' section teaches you shortcuts. Then you can develop shortcut "muscle memory" with the Practice section and test your knowledge with the Test section

VBA for Excel

100 interactive exercises and many more examples, covering everything you need to become a VBA expert:

• Conditional Logic
• Adv Cell  References
• Msg & Input Boxes
• Adv Procedures

Learn VBA Tutorial

Excel automation examples.

Have a specific need? We have hundreds of pages with specific tutorials, walk-throughs, and examples. All of our examples are listed in easy to search lists:

Get Excel Help!

Do you have a problem you can’t solve?  Do you need an Excel Automation expert?  Learn more about our Excel / VBA consulting services:

Excel and VBA Consulting

More free help, free spreadsheets, tutorials and add-ins, premium excel & vba tools and tutorials.

Practice And Learn Excel Online For Free

Here you can practice dozens of Excel exercises with full solutions and explanations. If you are new to excel, please check out our  Excel Basics Tutorial!

The explanations can be found in the Answer tab in each of the exercises. Have fun 🙂

New! Excel Self Assessment – Test your Excel skills and understand what to learn next to be even better!

• Basic Math and Percentages Exercise

SUM Function

• SUM Tutorial and Practice
• SUM Function – Exercise 1
• SUM Function – Exercise 2
• SUM Function – Exercise 3

COUNT, COUNTA & COUNTBLANK Functions

• COUNT Tutorial and Practice
• COUNTA Tutorial and Practice
• COUNT & COUNTA Functions – Exercise 1
• COUNT & COUNTA Functions – Exercise 2
• COUNT, COUNTA & COUNTBLANK Functions – Exercise 3

AVERAGE Function

• AVERAGE Tutorial and Practice
• Average Function – Exercise 1
• Average Function – Exercise 2
• Average Function – Exercise 3

MIN/MAX Function

• MIN Tutorial and Practice
• MAX Tutorial and Practice
• MIN/MAX Function (combined with AVERAGE)
• MIN/MAX Function (combined with IF)

IF Function

• IF Tutorial and Practice
• IF Function – Exercise 1
• IF Function – Exercise 2
• IF Function – Exercise 3
• IF Function – Exercise 4

Nested IF Function

• Nested IF Tutorial and Practice
• Nested IF – Exercise 1

VLOOKUP Function

• VLOOKUP Tutorial and Practice
• VLOOKUP Function – Exercise 1
• VLOOKUP Function – Exercise 2
• VLOOKUP with Approximate Match – Exercise 3

HLOOKUP Function

• HLOOKUP Function – Exercise 1

SUMIF Function

• SUMIF Tutorial and Practice
• SUMIF Function – Exercise 1
• SUMIF Function – Exercise 2

COUNTIF Function

• COUNTIF Tutorial and Practice
• COUNTIF Function – Exercise 1
• COUNTIF Function – Exercise 2

SUMIFS Function

• SUMIFS Tutorial and Practice
• SUMIFS Function – Exercise 1
• SUMIFS Function – Exercise 2

COUNTIFS Function

• COUNTIFS Tutorial and Practice
• COUNTIFS Function – Exercise 1
• COUNTIFS Function – Exercise 2

Pivot Table

• Pivot tables Tutorial and Practice
• Pivot Table basics – Exercise 1

Practice Excel Exams and Tests

Want to test yourself? check out our Excel Practice Tests Page

Terms and Conditions - Privacy Policy

An Introduction to Microsoft Excel | Basics Knowledge + Components + Examples

- Written by Puneet

The truth is: before you go for a job interview, you must have basic knowledge of Microsoft Excel. From an accountant to a receptionist, human resources to administration departments all are using Microsoft Excel.

It is not only limited to large companies, small entrepreneurs and college students are using it for their day-to-day work. That’s something that you can’t skip.  To get a job, learning basic Excel tasks (at least some) is a must in today’s era, that’s a firm truth.

And, to help you with this I have compiled this guide. This guide will help you to learn all those basics using some examples. And some of the most important beginner’s tutorials. So, without further ado let’s get down to the business.

Latest Excel Tutorial

Top 10 Benefits of Microsoft Excel

Introduction to Microsoft Excel

There is a number of spreadsheet programs but of all of them, Excel is the most widely used. People have been using it for the last 30 years and throughout these years, it has been upgraded with more and more features.

The best part about Excel is, that it can apply to many business tasks, including statistics, finance, data management, forecasting, analysis, tracking inventory & billing , and business intelligence. Following are the few things which it can do for you:

• Number Crunching
• Charts and Graphs
• Store and Import Data
• Manipulating Text
• Templates/Dashboards
• Automation of Tasks
• And Much More…

The three most important components of Excel you need to understand first:

A cell is a smallest but most powerful part of a spreadsheet. You can enter your data into a cell either by typing or by copy-paste. Data can be a text, a number, or a date. You can also customize it by changing its size, font color, background color, borders, etc. Every cell is identified by its cell address, cell address contains its column number and row number (If a cell is on the 11th row and on column AB, then its address will be AB11).

2. Worksheet

A worksheet is made up of individual cells which can contain a value, a formula, or text. It also has an invisible draw layer, which holds charts, images, and diagrams. Each worksheet in a workbook is accessible by clicking the tab at the bottom of the workbook window. In addition, a workbook can store chart sheets; a chart sheet displays a single chart and is accessible by clicking a tab.

3. Workbook

A workbook is a separate file just like every other application has. Each workbook contains one or more worksheets. You can also say that a workbook is a collection of multiple worksheets or can be a single worksheet. You can add or delete worksheets, hide them within the workbook without deleting them, and change the order of your worksheets within the workbook.

Microsoft Excel Window Components

Before you start using it, it’s really important to understand what’s where in its window. So ahead we have all the major components which you need to know before entering the world of Microsoft Excel.

link to download

1. Active Cell

An Active Cell in Excel is a cell that is currently selected. It will be highlighted by a rectangular box and its address will be shown in the address bar. You can activate a cell by clicking on it or by using your arrow buttons. To edit a cell, you double-click on it or use F2 as well.

A COLUMN in Excel is a vertical set of cells. A single worksheet contains 16384 total columns. Every column has its own alphabet for identity, from A to XFD. You can select a column by clicking on its header.

A ROW in Excel is a horizontal set of cells. A single worksheet contains 1048576 total rows. Every row has its own number for identity, starting from 1 to 1048576. You can select a row by clicking on the row number marked on the left side of the window.

4. Fill Handle

Fill Handle a small dot present in the lower right corner of the active cell. It helps you to fill numeric values, text series, insert ranges, insert serial numbers, etc.

5. Address Bar

It shows the address of the active cell. If you have selected more than one cell, then it will show the address of the first cell in the range.

6. Formula Bar

The formula bar is an input bar, below the ribbon. It shows the content of the active cell, and you can also use it to enter a formula in a cell.

7. Title Bar

The title bar will show the name of your workbook, followed by the application name (“Microsoft Excel”).

8. File Menu

The file menu is a simple menu like all other applications. It contains options like (Save, Save As, Open, New, Print, Excel Options, Share, etc).

9. Quick Access Toolbar

A toolbar to quickly access the options which you frequently use. You can add your favorite options by adding new options to the quick access toolbar .

Starting from Microsoft Excel 2007, all the options menus are replaced with the RIBBON . Ribbon tabs are a bunch of specific option group which further contains the option.

11. Worksheet Tab

This tab shows all the worksheets which are present in the workbook. By default, you will see, three worksheets in your new workbook with the names Sheet1, Sheet2, and Sheet3 respectively.

12. Status Bar

Status Bar in Excel is a thin bar at the bottom of the Excel window. It will give you instant help once you start working in Excel.

Top 25 Excel Skills + Describe Your Excel Skills on Resume

HOW TO USE EXCEL

1. start excel application.

Once you install Excel in your system, you can open it from your Start menu. You can search from the search bar and add an icon on the desktop.

When you click on the Excel application icon, it loads add-ins and then opens the Excel application, showing you the Excel start screen.

2. Creating a New Workbook in Excel

Once you open the Excel application, it shows you the backstage from where you need to click on the “Blank Workbook” to open a new blank workbook.

As I said, it will instantly open a new workbook named “Book1”. You need to save the workbook which you have inserted.

3. Save a Workbook

Once you create a new workbook, it’s better to save it right away before you start working on it. To save it, click on the File > Save As .

From there, in the “Save As” dialog box , you need to enter the name and then click on the Save.

If you want to save the File to a different location, click “Browse” and locate the folder where you want to save the workbook.

4. Insert a New Sheet

There are three (more or less) worksheets by default in each workbook, but you can also insert new worksheets (sheets). And here are multiple ways for this. When you right-click on the sheet tab that you already have in the workbook, there’s an option “Insert”.

When you click this option, you get a dialog box to select the type of sheet to insert and then click OK to insert the sheet.

Apart from this, if you want to insert a worksheet, you can use the keyboard shortcut Shift + F11 .

5. Delete a Sheet

You can also delete a sheet you don’t need or don’t want to use further. For this, you must right-click and click the “Delete” option.

When you click on this option and delete a sheet or worksheet where you have data, Excel will show you a prompt to ask you for permission to delete it.

And you can also use a keyboard shortcut Alt > H > D > S for this.

6. Enter Data in a Cell

In Excel, you can enter data in a cell using multiple methods, but the easiest way to enter the data is to use the keyboard keys.

Just select the cell where you want to enter data and type what you want to enter. Once you enter the data, press the “Enter” key to move to the next cell downwards.

Or, if you already have data in the cell and you want to enter the data, you can use the F2 key. It will edit the cell, and you can enter the data.

7. Using Options from Ribbon

In Excel (starting from the Excel 2007 version), the majority of the options that you need to use are listed on the Ribbon. And further on the Ribbon, you have tabs.

On each Tab, there are buttons and drop-down lists to use the options. For example, on the Home Tab, you have basic options for formatting and options to work with worksheets, range, and cells.

8. Right-Click Menu

Like other applications, Excel has a right-click options menu listing some of the most important and useful options.

The right-click menu has a lot of options that you can use quickly from there instead of looking at Ribbon.

There is also a tiny search bar on the top of the menu, which you can use to search for the option you want. This search bar finds options for the entire application instead of only the right-click menu.

9. Cut, Copy, and Paste

When you select a cell or a range of cells, you can find cut, copy, and paste options on the right-click menu. You need to click the option to cut, copy, and paste.

Apart from this, you can also use the keyboard shortcuts:

• Ctrl + X – Cut
• Ctrl + C – Copy
• Ctrl + V – Paste

All these options can also be used from the Home Tab > Clipboard.

10. Opening Excel Options

In Excel, you have options to customize the application. When you go to the File > More > Option, Excel opens the options dialog box where you can find all the options to change.

There are further tabs in the options dialog box to explore and find the options you want to change.

11. Changing Font Style and Size

In Excel, you can change the font style and font size. That means you can change the default font to a different font you like. On the Home Tab, you have a drop-down to select the font style.

And next to that, there’s a drop-down to select the font size. From both drop-downs, you can edit the name and size by typing. If you know the font name you want to change or the size you want to apply, enter it by typing and hit enter to apply.

12. Change Cell Alignment

You can also change the alignment of the cell if required. On the Home Tab, you have the buttons for the alignment options. There are two options to align (centre, left, and right) and (top, middle, and bottom).

With these option buttons, you can apply borders to a single cell, range, or multiple ranges. But as I said, there are two options here, so you need to apply alignment in two ways.

13. Apply Border to a Range or a Cell

You can apply cell borders on a cell or a range of cells. Once you select a range or cell, you need to go to the Home tab and click on the Borders drop-down.

In this drop-down, you have all the options to apply the Border to the selected range. In the last option of the drop-down, you can click “More Borders” to apply custom borders.

14. Open Cell Format Options

Excel allows you to add a comment to a cell. A cell comment can have multiple usages, like a message for other users or an identification for a cell so that you can find it easily.

In the Review tab, click “New Comment” to add a new comment and then enter your comment in the input bar.

15. Adding Comments

16. replying to comments.

Once you add a comment, a user or even you can reply to those comments. It is like a conversation that you can have with the comments.

In the reply input bar, you can enter your reply, press Ctrl + Enter, or click the send button to send your response.

17. Adding Notes

Apart from comments, you also have notes to enter on a cell specifying additional information for the user.

In the review tab, click on the notes drop-down and then click on the new note to insert a recent note to the selected cell.

18. Entering a Function in a Cell

Function is one of the most powerful features in Excel. Select a cell first to enter a function and type (=). Once you enter =, you need to start typing the name of the function that you want to use.

Once you enter the function’s name, specify its arguments to get the desired result. For example, we have two arguments to define in the above function.

But if you see the second argument enclosed in square brackets, it’s optional.

19. Create a Basic Formula in Excel

In Excel, you can create a basic formula in a cell using the basic calculation operator (Addition, Subtraction, Division, and Multiplication).

Type the equal sign, and then you can start writing your formula. Let’s say you want to sum 10 and 20, then, you need to write a formula like (=10+20).

And if you want to refer to cells in the formula, you can also do that. In the same way, you can also do subtraction, division, and multiplication.

20. Creating a Named Range

As you have seen, each cell in a worksheet has a cell address. But Excel also allows you to specify a meaningful name for a range of cells or a single cell. It’s called a named range.

Select the range and click within the address bar for this. After that, enter the name you want to give and hit enter to create the named range. And then, you can use this named range within the formulas and functions.

BASIC EXCEL TUTORIALS

1. excel basics.

• Activating the Dark Mode in Excel
• Add a Button in Excel
• Add a Header and Footer in Excel
• Add Dollar Sign in Excel
• Alignment in Excel
• Automatic Rolling Months in Excel
• Automatically Add Serial Numbers in Excel
• Convert a Formula to Value in Excel
• Convert Negative Number into Positive in Excel
• Copy and Paste Column Width in Excel
• Copy and Paste Values Without Formatting in Excel
• Draw a Line in Excel
• Fill Justify in Excel
• Find and Replace in Excel
• Format Painter in Excel
• Freeze Panes in Excel
• Get the Scroll Bar Back in Excel
• Hide and Unhide a Workbook in Excel
• Increase and Decrease Indent in Excel
• Insert (Type) Degree Symbol in Excel
• Insert a Check Mark Symbol [Tickmark] in Excel
• Insert a Timestamp in Excel
• Insert an Arrow in a Cell in Excel
• Insert Bullet Points in Excel
• Insert Delta Symbol in Excel in a Cell
• Insert Text Box in Excel
• Keyboard’s Arrow Keys Not Working (Scroll Lock ON-OFF)
• Make a Copy of the Excel Workbook (File)
• Make First Row Header in Excel
• Merge – Unmerge Cells in Excel
• Rotate Text in Excel (Text Orientation)
• Save a File in Excel
• Save an Excel File on Mac (Workbook)
• Show Ruler in Excel
• Spell Check in Excel
• Zoom In or Zoom Out in Excel

2. Keyboard Shortcuts

• Absolute Reference (Excel Shortcut)
• Add Column (Excel Shortcut)
• Add Comments (Excel Shortcut)
• Add Indent (Excel Shortcut)
• Add New Sheet (Excel Shortcut)
• Align Center (Excel Shortcut)
• Apply Border (Excel Shortcut)
• Apply and Remove Filter (Excel Shortcut)
• Auto Fit (Excel Shortcut)
• AutoSum (Excel Shortcut)
• Check Mark (Excel Shortcut)
• Clear Contents (Excel Shortcut)
• Close (Excel Shortcut)
• Copy and Paste (Excel Shortcut)
• Currency Format (Excel Shortcut)
• Cut and Paste (Excel Shortcut)
• Delete Cell (Excel Shortcut)
• Delete Row(s) (Excel Shortcut)
• Delete Sheet (Excel Shortcut)
• Drag Down (Excel Shortcut)
• Edit Cell (Excel Shortcut)
• Fill Color (Excel Shortcut)
• Find and Replace (Excel Shortcut)
• Format Painter (Excel Shortcut)
• Freeze Pane (Excel Shortcut)
• Full Screen (Excel Shortcut)
• Group (Excel Shortcut)
• Hyperlink (Excel Shortcut)
• Insert Cell (Excel Shortcut)
• Insert – Add Row(s) (Excel Shortcut)
• Lock Cells (Excel Shortcut)
• Merge-Unmerge Cells (Excel Shortcut)
• Open Format Cells Option (Excel Shortcut)
• Paste Values (Excel Shortcut)
• Percentage Format (Excel Shortcut)
• Print Preview (Excel Shortcut)
• Save As (Excel Shortcut)
• Select Row (Excel Shortcut)
• Show Formulas (Excel Shortcut)
• Strikethrough (Excel Shortcut)
• Subscript (Excel Shortcut)
• Superscript (Excel Shortcut)
• Switch Tabs (Excel Shortcut)
• Transpose (Excel Shortcut)
• Undo and Redo (Excel Shortcut)
• Unhide Columns (Excel Shortcut)
• Wrap Text (Excel Shortcut)
• Zoom-In (Excel Shortcut)
• Apply Date Format (Excel Shortcut)
• Apply Time Format (Excel Shortcut)
• Delete (Excel Shortcut)
• Open Go To Option (Excel Shortcut)
• Range in Excel
• Add and Remove Hyperlinks in Excel
• Change Column Width in Excel
• Copy and Paste a Column in Excel
• Delete a Single Row or Multiple Rows in Excel
• Delete Blank Rows in Excel
• Delete Hidden Rows in Excel
• Deselect Cells in Excel
• Find a Name Range in Excel
• Lock Cells in Excel
• Make Cells Bigger in Excel
• Make Paragraph in a Cell in Excel
• Move a Row and Column in Excel
• Multiply in Excel using Paste Special
• Quickly Swap Two Cells in Excel
• Row Vs Column in Excel (Difference)
• Select Non-Contiguous Cells in Excel
• Select the Range in Excel
• Unhide Rows in Excel
• Use Column Numbers in Excel Instead of Alphabets
• Write (Type) Vertically in Excel

4. Worksheets

• Understanding an Excel Worksheet (Tips and Tutorials)
• Add a Worksheet in Excel
• Add Title to a Worksheet in Excel
• Change Tab Color in Excel (Worksheet Tab Background Color)
• Consolidate Data From Multiple Worksheets in a Single Worksheet in Excel
• Copy or Move a Sheet (Worksheet)
• Create a Hyperlink (Link) to an Another Worksheet
• Delete a Sheet (Worksheet) in Excel
• Group Worksheets in the Excel
• Quickly Lock a Sheet (Worksheet) in Excel
• Quickly Refresh a Sheet (Worksheet) in Excel
• Rename Sheet in Excel
• Select All the Worksheets (Sheets)
• Steps to Create a Duplicate Sheet or Worksheet in Excel
• Unhide an Excel Sheet or All the Sheets (Worksheet)
• Unprotect or Unlock a Sheet with a Password or Without a Password
• View Two Sheets Side by Side in Excel

5. Workbooks

• Excel Workbook (Create, Save, and Rename)
• Fix a Corrupt Excel File
• Link Workbooks with Each Other in Excel
• Open a Text File in Excel (.TXT)
• Protect and Unprotect (Without Password) a Workbook
• Recover Unsaved Excel Files When Excel Crashed
• Save Excel File (Workbook) as CSV (XLSX TO CSV)
• Save Workbook without Formulas
• Save, Save As, and Save as Copy a Workbook
• Share a Workbook with Others in Excel
• Understanding Excel’s Binary File Format (XLSB)
• Workbook Vs. Worksheet (Difference)

6. Conditional Formatting

• Complete Guide to Conditional Formatting
• Conditional Formatting Based on a Date
• Conditional Formatting Based on Another Cell
• Conditional Formatting Based on Another Column
• Conditional Formatting on Blank Cells
• Conditional Formatting to an Entire Column
• Multiple Conditions in Conditional Formatting
• Applying Color Scales using Conditional Formatting
• Compare Two Columns using Conditional Formatting
• Copy Conditional Formatting from Range to Another
• Data Bars in Excel using Conditional Formatting
• Find Duplicates in Excel using Conditional Formatting
• Formulas in Conditional Formatting
• Highlight IF a Cell Contains a Specific Text with Conditional Formatting in Excel
• Highlight Rows using Conditional Formatting in Excel
• Remove Conditional Formatting in Excel
• Stop IF True in Conditional Formatting
• Use Icon Sets in Excel (Conditional Formatting)
• Why Conditional Formatting Not Working in Excel

7. Printing

• Print in Excel
• Add Page Number in Excel
• Add Watermark in Excel
• Apply Print Titles in Excel (Set Row 1 to Print on Every Page)
• Center a Worksheet Horizontally and Vertically in Excel
• Center Across Selection in Excel
• Change Page Orientation in Excel
• Page Margin in Excel (Change and Set)
• Print a Graph Paper in Excel (Square Grid Template)
• Print Comments and Notes in Excel while Printing a Sheet
• Print Data on One Page in Excel
• Print Excel Sheets to a PDF
• Print Gridlines in Excel
• Print Preview in Excel
• Print Selected Cells Only in Excel
• Remove Pagebreak in Excel
• Set Print Area in Excel
• Types of Charts in Excel + Other Charting Tutorials
• Add a Horizontal Line in a Chart in Excel
• Add a Vertical Line in a Chart in Excel
• Add Secondary Axis in a Chart in Excel
• Advanced Excel Charts
• Bullet Chart in Excel
• Create WAFFLE CHART in Excel
• Dynamic Chart Range in Excel
• Dynamic Chart Title in Excel
• Excel Copy Chart Format
• Funnel Chart in Excel
• Gantt Chart in Excel
• Heat Map in Excel
• Histogram in Excel
• Interactive Charts in Excel
• Milestone Chart in Excel
• People Graph in Excel
• Pictograph in Excel
• Population Pyramid Chart in Excel
• SPEEDOMETER Chart in Excel
• Step Chart in Excel
• Thermometer Chart in Excel
• Tornado Chart in Excel

9. Formulas

• 3D Reference in Excel
• Add a Total Row in Excel
• Add Commas (Cell-Text)
• Add Hours to Time in Excel
• Add Leading Zeros in Excel
• Add Minutes to Time in Excel
• Add Month to a Date in Excel
• Add New Line in a Cell in Excel (Line Break)
• Add Seconds to Time
• Add Space (Single and Multiple)
• Add Years to Date in Excel
• Add-Subtract Percentage from a Number
• Add-Subtract Week from a Date in Excel
• Average But Ignore Errors
• Average Number but Exclude Zeros
• Average of the Percentage Values
• Average of the Time Values
• Average Only Non-Blank Cells
• Average TOP 5 Values in Excel
• Business Days in a Month
• Calculate Coefficient of Variation (CV) in Excel
• Calculate Compound Interest in Excel
• Calculate Cube Root in Excel
• Calculate Nth Root
• Calculate Percentage Variance (Difference) in Excel
• Calculate Simple Interest in Excel
• Calculate Square Root in Excel + Insert Symbol
• Calculate the Cumulative Sum of Values (Excel Formula)
• Calculate Time Difference Between Two Times in Excel
• Calculate VAT
• Capitalize First Letter in Excel
• Change Column to Row (Vice Versa) in Excel
• Change Text Case (Upper, Lower, Proper)
• Change Time Format in Excel
• Change to Sentence Case in Excel
• Check IF 0 (Zero) Then Blank in Excel
• Check IF a Cell Contains a Partial Text
• Check IF a Cell Value is a Number
• Check IF a Value Exists in a Range in Excel
• Combine Date and Time in Excel
• Combine IF and AND Functions in Excel
• Combine IF and OR Functions in Excel
• Combine VLOOKUP with SUMIF
• Compare Two Cells in Excel
• Compare Two Dates in Excel
• Compare Two Strings (Text)
• Concatenate (Combine) a Range of Cells in Excel
• Concatenate (Combine) Cells with a Comma in Excel
• CONCATENATE IF (Combine with Condition)
• Concatenate with a Line Break in Excel
• Conditional Ranking in Excel using SUMPRODUCT Function [RANKIF]
• Convert a Date into a Month and Year
• Convert an Excel Time Value into a Decimal Number (Hours)
• Convert Date into a Text
• Convert Date to Number in Excel
• Convert Minutes into Hours and Minutes (HH:MM)
• Convert Month Name to Number
• Convert Seconds to Hours and Minutes
• Convert Text to Date in Excel
• Convert Time to Decimals
• Convert Time Value into Minutes (Excel Formula)
• Convert Time Value into Seconds
• Convert to Julian Date
• Count Between Two Numbers (COUNTIFS) in Excel
• Count Blank (Empty) Cells using COUNTIF in Excel
• Count Cells Less than a Particular Value (COUNTIF) in Excel
• Count Cells Not Equal To in Excel (COUNTIF)
• Count Cells that are Not Blank in Excel
• Count Cells with Text in Excel
• Count Characters in Excel (Cell and Range)
• Count Days Between Two Dates (COUNTIF Date Range)
• Count Filtered Rows in Excel
• Count Greater Than 0 (COUNTIF) in Excel
• Count Rows (All, Blank, Non-Blank, and with Numbers)
• Count Specific Characters in Excel
• Count Total Number of Cells from a Range in Excel
• Count Unique Values in Excel
• COUNT Vs. COUNTA
• Count Words in Excel
• Count Years Between Two Dates in Excel
• Countdown Days
• Create a Date Range in Excel
• Create a Dynamic Hyperlink
• Create a Horizontal Filter in Excel
• Create a Star Rating Template in Excel
• Custom Date Formats in Excel
• DATEDIF Function in Excel
• Does Not Equal Operator in Excel
• Extract (Get) Year or Month from a Date in Excel
• Extract Last Word from a Cell
• Extract Only Numbers from a Text (String)
• Extract Text After and Before a Character in Excel
• Find the Lowest Value from a List of Numbers (N)
• Find the Smallest Value from a Range of Cells (Smallest Number)
• Flip the First & Last Names and Add a Comma Between
• Generate Random Groups
• Get Current Time (Excel Formula)
• Get Day Name from a Date in Excel
• Get Day Number of Year in Excel
• Get End of the Month Date in Excel
• Get File Name in Excel
• Get File Path (Excel Formula)
• Get First Day of the Month in Excel (Beginning of the Month)
• Get Month from a Date in Excel (Extract Month)
• Get Previous Sunday
• Get Quarter from a Date [Fiscal + Calendar] in Excel
• Get Sheet Name in Excel
• Get the Domain from the Email ID
• Get the Most Frequent Number(s) from an Array
• Get the Value from a Cell
• Get Total Days in Month in Excel
• Get Years of Service in Excel
• Greater Than (>) and Equal To (=) Operator
• Gross Profit (Margin and Ratio)
• Hide Formula in Excel
• Highlight Dates Between Two Dates in Excel
• How to use Arithmetic Operators in Excel
• If a Cell Value Starts with a Text or a Number
• IF Cell is Blank (Empty) using IF + ISBLANK in Excel
• IF Negative Then Zero (0) in Excel
• IFERROR with VLOOKUP in Excel to Replace #N/A in Excel
• Ignore All the Errors in Excel (Explained)
• Indirect with VLOOKUP
• Lookup for the Cell Address Instead of the Value
• Lookup Last Value from a Column or a Row
• Match/Compare Two Columns with VLOOKUP
• MAX IF in Excel
• Median with IF (Conditional Criteria)
• Military Time (Get and Subtract) in Excel
• Number of Months Between Two Dates in Excel
• OR Logic in COUNTIF/COUNIFS in Excel
• Perform Two Way Lookup in Excel
• Quickly Calculate Ratio in Excel
• Quickly Concatenate Two Dates in Excel
• Quickly Generate Random Letters in Excel
• Quickly Use AutoSum in Excel
• R1C1 Reference Style in Excel
• Random Date Generator (Excel Formula) in Excel
• Randomize a List (Random Sort) in Excel
• Remove Commas
• Remove Extra Spaces in Excel
• Remove First Character from a Cell in Excel
• Remove Line Break from a Cell
• Remove Parentheses in Excel (Brackets)
• Remove the Last Character from a String
• Remove Unwanted Characters
• Reverse VLOOKUP (Backward: From Right to Left ) in Excel
• Round a Number to Nearest 1000 in Excel
• Round Percentage Values
• Round to Nearest .5, 5. 50 (Down-Up) in Excel
• Running Total
• Separate Date and Time in Excel
• Separate Names in Excel – (First and Last Name)
• Split a Text using a Space Between
• Square a Number in Excel
• Substitute Multiple Values (Nested)
• SUBTOTAL with IF (Conditional SUBTOTAL)
• Sum an Entire Column or a Row in Excel
• Sum Greater than Values using SUMIF
• Sum IF Cell Contains a Specific Text (SUMIF Partial Text)
• Sum Not Equal Values (SUMIFS) in Excel
• Sum of Squares
• Sum Only Visible Cells in Excel
• Sum Random Cells in Excel
• Sum Time in Excel (Excel Formula)
• Sum Values Based on the Month (SUMIF)
• Sum Values Based on Year (SUMIF Year)
• Sum Values by Group
• Sum Values Less Than a Particular Value (SUMIF Less Than)
• Sum Values that are Greater than Zero (SUMIF)
• SUMIF / SUMIFS with an OR Logic in Excel
• SUMIF By Date (Sum Values Based on a Date)
• SUMIF Non-Blank (Sum Values for Non-Empty Cells)
• SUMIF with Wildcard Characters in Excel
• SUMIFS Date Range (Sum Values Between Two Dates Array)
• SUMPRODUCT IF to Create a Conditional Formula in Excel
• TRUE and FALSE in Excel (Boolean Values)
• Use SUMIF to Sum Blank Values or Empty Cells
• Using INDIRECT with SUM
• VLOOKUP Dates (VLOOKUP for a Date from Data)
• VLOOKUP from Another Sheet (Between Sheets)
• VLOOKUP MATCH Combination in Excel
• VLOOKUP with Multiple Criteria in Excel
• Weighted Average
• Wildcard Characters in Excel
• Wildcards with VLOOKUP in Excel
• XLOOKUP Return All Matches. Possible?
• XLOOKUP with Multiple Criteria
• Years Between Dates in Excel

10. Functions

• Excel Statistical Functions
• Excel String (Text) Functions
• Excel Time Functions
• Excel Date Functions
• Excel Financial Functions
• Excel Information Functions
• Excel Lookup Functions

11. Sorting

• Sort in Excel – An Easy-to-Follow Guide
• Perform a Custom Sort in Excel
• Reasons for Sorting Problems in Excel
• Sort by Color in Excel
• Sort By Date, Date and Time & Reverse Date Sort
• Sort by Last Name in Excel
• Sort by Month (Dates) in Excel
• Sort Horizontally in Excel
• Sort in Alphabetical Order (A to Z or Z to A) in Excel
• Sort Multiple Columns in Excel

12. Formatting

• 5 Best Fonts for Microsoft Excel
• Add Barcode in Excel (Install Font)
• Add Border in Excel
• Apply Accounting Number Format in Excel
• Apply Background Color to a Cell
• Apply Comma Style in Excel
• Apply Strikethrough in Excel
• AUTO FORMAT Option in Excel
• Change Border Color in Excel
• Change Date Format in Excel
• Clear Formatting in Excel
• Copy Formatting in Excel
• Default Font (Change Style, Size, and Color)
• Excel Cell Style
• Grey Out Cells in Excel
• Highlight Alternate Rows with Color Shade
• Highlight Blank Cells in Excel
• Highlight Top-Bottom N Values in Excel
• How to Hide Zero Values in Excel
• Insert Checkbox in Excel
• Insert Diameter Symbol in Excel
• Insert PI Symbol (π) in Excel
• Make Negative Numbers Red in Excel
• Merge Cells without Losing Data in Excel
• Excel Gridlines
• Remove Dashes in Excel

Recommended Books

Below are my two favorite Excel books for beginners which every person who is starting out with Excel should read.

• Excel 2016 for Dummies : This book covers everything you need to know to perform the task at hand. Includes information on creating and editing worksheets, formatting cells, and entering formulas […]
• Microsoft Excel 2016 Bible : Whether you are just starting out or an Excel novice, the Excel 2016 Bible is your comprehensive, go-to guide for all your Excel 2016 needs Whether you use Excel at work or […]

IN-DEPTH EXECL GUIDES

• Excel Pivot Table
• Excel Power Query
• Excel Keyboard Shortcuts
• Excel for Accountants
• VBA in Excel
• Excel Tips & Tricks

58 thoughts on “An Introduction to Microsoft Excel | Basics Knowledge + Components + Examples”

Thank you sir

Very helpful thanks 👍

Thank you so much

Good explanation sir

Thanks for u r valuable information….

Thanks Soo much wish I can have much knowledge about Microsoft Excel.

Thanks for sharing this important document.

Thanks for sharing this informative post

My name is Raunak jaiswal

This website is like a bliss for the candidates who are really keen to learn MS EXCEL and even for beginners who are struggling to understand it . A big thank you to the author.

Thanks for the valuable information regarding Microsoft Execl. found useful from every aspect of features of software.

Just now I have gone through your website and found very prized notes in excel, which are written in a lucid manner and can easily be understandable for everyone. I saved YOUR NOTES. Your patience is really appreciable. Please keep it up. Thanks

Very thoughtful and helpful content. Thank you so much for your work and time

This is very wonderful website for learning Excel components thank you very all team members of this site good work keep it up.

im satisfy with traning its really help full and undestanding iwant to learn more thank you

excel is so good it helps in data management

I’m using Office 2019 in my PC. You have recommended in your article “Excel 2016 for Dummies”.

I would like to know as to whether your recommended book is also suitable for Office 2019.

yes, for sure.

its best view in excel consequently step by step content .its so well for learn this web realy helped me.So more keep it up thanks

How can I link the data in a worksheet with the chart in another worksheet in the same workbook so the when I enter the data the charts appear automatically. It a budget workbook I designed

Well, that was “amazing” i’m greatful..

Thank you for this post it really helped me. Keep it up.

This article is really helpful. Thank you so much. Excellent post. This article is really very interesting and effective. I think its must be helpful for us. Thanks for sharing your informative.

Great post. Wonderful information and really very much useful. Thanks for sharing and keep updating Thank You so much for sharing this information. I found it very helpful. Thank you so much again.

Thank you for your inconvenience.

Thanks very much for ur valuable info abt excel….it will help the beginners who are trying out a job has a fresher…..

thanks for all

that is my question too …

Very helpful for children

very helpful

I satisfy on these notes, good!

how to find all cells together which are having manual numbers in a spreadsheet with lot of data where formulas are applied at most the places?

Honestly I really appreciate your work , you’re doing great work it,s help me to perform job tasks

Wow! i love this write-up, it’s of help to me.

It is very good

Sir Ms Excel Ka Hindi and English language me pdf note kaise milega

IT IS VERY GOOD

This is very helpful main points for ms excel . Thanks

Thanks for this.. This is very helpful .

thx good notes

thank you so much

I’m so glad you liked it. 🙂

Thanks for your clear explanation about excel and its functions

Hi, I believe the column is vertical while the row is horizontal

Thanks a lot.

thanks a bunch

You’re welcome.

Hi…isnt that the column is vertical set and rows are horizontal…

Thanks for the correction.

Thanks for sharing this informative post. It is very useful the beginners, who are new to excel.

You’re welcome. 🙂

Thanks you Sir

Thank you Sir

Leave a Comment Cancel reply