## How do I Divide in Excel?

https://youtu.be/fe34GZCrIwM Link to YouTube video How do I Divide in Excel? We've covered multiplication and subtraction in previous tutorials and videos, but how do we divide in Excel?  This is another commonly searched-for question on Google, and the technique is the same in Excel as it is in Google Sheets.  Once you're familiar with this technique you will have a much better understanding of how Excel works. So let's start off with a very simple calculation; 4 ÷ 2. The number 4 is in cell A1, and number 2 is in cell A2: To begin with, you need to understand that division in Excel is a kind of formula, and whenever you type a formula in Excel you must begin it with the equals symbol =, and the formula is after the equals sign.  Secondly, you need to know that the symbol for divide in Excel is not ÷, it is / (the forward-slash symbol).  So if we want the answer to this sum to be in...

## How do I multiply in Excel?

https://youtu.be/zw8P3eXVd40 Link to YouTube video How do I multiply in Excel? To an Excel expert, this is extremely easy - but it's a commonly searched-for question on Google, so let's get stuck in. Once you're familiar with this technique you will have a much better understanding of how Excel works. (The technique is exactly the same in Google Sheets). So let's start off with a very simple calculation; 4 x 2. The number 4 is in cell A1, and number 2 is in cell A2: To begin with, you need to understand that multiplication in Excel is a kind of formula, and whenever you type a formula in Excel you must begin it with the equals symbol =, and the formula is after the equals sign.  Secondly, you need to know that the symbol for multiply in Excel is not x, it is * (the star symbol).  So if we want the answer to this sum to be in cell A3, we click in cell...

## How do I lock cells in Excel?

https://youtu.be/lvzB9FK1z6o Link to YouTube video How do I lock cells in Excel? If you have created an Excel workbook with calculations in it that you don't want your colleagues to be able to accidentally delete or overtype, you will need to lock the relevant cells.  You may be surprised to hear that by default, all the cells in Excel are locked by default!  But if that is the case, then why can they be edited?  That's because it is a two stage process. So let's imagine you've made this sweet spreadsheet at work, and you want your colleagues to be able to update the cells A3 to B8 (the cells in white) but have the green cells locked down: As I said, by default all the cells are actually locked already, what you need to do now is select the cells that you want to be unlocked, i.e. in this case cells A3 to B8.  Highlight and select this cell range, then right-click and select...

## How do I subtract in Excel?

https://youtu.be/EQKOczg9l6I Link to YouTube video. How do I subtract in Excel? This is another very simple question to answer, but a commonly searched-for problem, so you're not alone if you're stuck on this.  The method is exactly the same if you want to know how to subtract in Google Sheets. Let's take a very simple example, we have 100 and we want to subtract 10.  The number 100 is in cell A1, and the number 10 is in cell A2: To begin with, you need to understand that subtracting in Excel is a kind of formula, and whenever you type a formula in Excel you must begin it with the equals symbol =, and the formula is after the equals sign.  So if we want the answer to this sum to be in cell A3, we click in cell A3 and type: =A1-A2 and then press ENTER on your keyboard: And there we have it, the answer to 100 minus 10 is now in cell A3: So in a...

## How do I merge cells in Excel?

Link to our YouTube video So how do I merge cells in Excel?  This is another basic technique in Excel that gets a lot of searches on Google, so you're not alone if you're struggling with this one! Let's say we have a table and we want to make one of the cells merge across the top of the subheader cells (like here we want the year to span across the whole table):   We need to highlight from cell A2 where the year is across to cell E2 by clicking in cell A2 and dragging the mouse across to highlight all the cells we wish to merge:   Then, in the default "Home" tab of the ribbon, click on "Merge and Centre":   And BAM, your cells are merged:   This only works how you'd expect if the rest of your cells are blank.  Excel only keeps the upper-leftmost data in a range if you have data in more than one of the cells, so use this with caution.  ...

## How do I Add a Column in Excel?

How do I add a column in Excel? Link to our YouTube video How do I add a column in Excel? - This is a really simple, but apparently it is a commonly searched for problem!  So if you've found this article because you can't add a column then you are not alone. First of all, select the entire column to the right of where you want to insert the new one.  For example, if you wanted to insert a column between columns B and C, then you would click in the grey area at the top of column C (see image below for where you need to click to select an entire column): Once you have selected the column, you then need to right-click in that same place to come up with a context menu, then click "Insert". And that's that, the new blank column appears, what was in Column C now becomes Column D: The exact same technique is used to insert new rows,...

## Combining Excel Workbooks

You may have several Microsoft Excel files that are used to control a particular area of your business, and you may be thinking to yourself, "how do I combine all these Excel workbooks into one?"  You can move or copy tabs (excel sheets) between workbooks very easily with a few clicks: Link to our tutorial on YouTube Step 1:  Open all the workbooks you want to combine. Doing this makes it possible to copy or move the tabs between the workbooks. Step 2:  Decide which of your workbooks is going to be your new "main" workbook. Or if you want to create a new "main" workbook, create a new blank workbook now, and save it with a filename such as "Workbooks combined.xlsx" or whatever is suitable to you. Step 3:  Now select a workbook which is not your "main" workbook. Now you have selected another workbook that is not your "main" workbook, you are ready to move or copy the relevant tabs over to your main...