INTRODUCTION TO MICROSOFT EXCEL

1. Open your Microsoft excel.

2. Click on “Welcome to excel” template on your excel.

.

3. If you don’t see it click on “New” at the left hand-side of your excel, make sure your network is on and then click on the search button and download “Take a tour” in excel .

4. Go ahead and open it, and then click on “Create” to open a new worksheet.

STEP1. HOW TO ADD NUMBERS IN EXCEL.

1. Using the first table, we want to sum the amount for fruits. Select the yellow cell under the “Amount” for “Fruits” (i.e the first table from your left).

2. Type the formula:  =SUM(D4:D7) and then press enter.

3. When you are done you will see the result of 170.
4. Another way to add using a shortcut key. Select the yellow cell under the “Amount” for “Meat” table.

5. Press “Alt” and “=” on your keyboard, first. Then, press enter.

6. Now to add only the numbers greater than 50, We use the formula Sumif. Select the last yellow cell.  Type =SUMIF(D11:D15, “>50”) and then press enter. The result is 100.

7. Same thing applies to the last right table, only that in this case, we want it to return us with 160 and less than 100. We use the formula: =SUMIF(G11:G15, “>50”) and then press enter. The result is 100.

STEP 2:  HOW TO FILL CELLS AUTOMATICALLY IN EXCEL

1. When you click on the cell with the number 100, you will see the formula used. To copy the formula,

2. Reset your cursor on the lower-right corner of the cell until it becomes a cross.

3. Click the cross and drag down the three cells. Excel will automatically fill the cells with the total: 110, 120, and 130. People call this “Filling down”.

4. Click the yellow cell with 200, and fill again but this time drag the fill handle to the right to fill the cells. This is known as “Filling right”.

STEP 3. HOW TO SPLIT DATA STUFFED INTO ONE COLUMN.

1. In the cells under “First Name”, type the first names that are in the email columns: Nancy, Andy and so on.

2. When you see the faded list of suggestions, press enter right away. The list of suggestion  is called flash fill. Flash fill detects suggestion to fill the cells with. When you see the faded list that’s your cue to press enter.

3. Try another way to flash fill: click the cell with “smith”.

4. Click on “Home” at the top-left of the excel, then click on “Fill” a menu will drop down, click on “Flash fill”.

5. Or try a shortcut by clicking on ”Smith” and pressing  ctrl E on your keyboard.

SPLIT A COLUMN BASED ON DELIMITER 

1. Click and drag to select the cells from “Nancy” all the way down to “Yvonne”. 

2. Click on “Data tab”.

3. Click on “Text to column”.

4. Select “Delimited” and then click on “Next”

5. Make sure that comma is check ed, and then click “Next”

6. Click the “General” option .

7. Finally, click inside the “Destination” box and type and select where you want it to be. In this case, $D$32. Then click finish.

8. It will help us split it into first name, last name and company name.

STEP 4. TRANSPOSING DATA IN EXCEL

1. Click and drag to select the two rows of cells from item to 20.

2. Now you’ll copy the cells. Press ctrl c.

3. Click the yellow cell.

4. On the “Home tab”, click the arrow under the “Paste” button.

5. Click on “Paste special”

6. Click on “Transpose” checkbox and then click on “OK”.

HOW TO TRANSPOSE WITH A FORMULA

1. To transpose this data. You need to select some blank cells where you want the data to be transposed into. Since the data on the right has 6 columns and 2 rows, you need to select the opposite 2 columns and 6 rows. Do this by selecting the yellow cells.

2. This is kind of tricky, so pay close attention. With those cells still selected, type the following: = TRANSPOSE(C33:H34)……but don’t press enter.

3. Press ctrl + shift + enter.

STEP 5. SORT AND FILTER IN EXCEL

1. Let’s say you want the “Department” in alphabetical order. Right-click on it and select “sort” and then, click on “Sort A to Z”.

2. Or click on any cell.

3. Go to “Home tab”, click on it and select “Sort and filter”.

4. A menu will dropdown , select  “Sort A to Z” or “Sort Z to A”. Any one of your choice.

5. For the values in the cell. Right-click on a value in the cell.

6. Click on “Sort” and “select “Sort Largest to smallest”.

7. Or select a value in the cell, and go to “Home tab”, and click on “Sort and filter” and then select “Sort Largest to smallest”.

STEP 6. TABLES IN EXCEL

1. Highlight the data by clicking at the top right-end and dragging all the way down.

2. Or simply click on any of the cells.

3. Go to insert tab.

4. Go to tables.

5. Click “OK” to create table.

STEP 7: DROPDOWN IN EXCEL

This helps you group data in different kinds of departments. To do this, 

1. Highlight the cells from “Department” column, from top to button.

2. Go to “Data tab” and click on “Data validation”.

3. If you can’t find it on your excel. Quickly go to “File tab”.

4. Scroll down click on “More” and select “options”.

5. Then go to “Customized Ribbon”.
6. Go to all command and search for “Data validation” and press “OK”.

7. Then click on the “Data validation”.

8. Click on “Any value” and select “Lis
9. In the source box, type, Produce, Meat, Bakery. Make sure to separate them with a comma. And then press “OK’.

10. Now click the yellow cell next Apple, and you’ll see the dropdown.

STEP 8:  HOW TO ANALYZE DATA IN EXCEL

1. Click and drag to select all cells.

2. Click the button in the lower-right corner.

3. Click on “Formatting” to add Data labels on your data.

4. Click on “clear” to  clear it off.

STEP 9: CHART IN EXCEL

1. Click anywhere in the data to the right.

2. Go to the “Insert tab”

3. Click on “Recommendation chart” select the third one and press “ok”.

4. Select the chart and the chart tool ab will appear at the top of the excel window.

5. Click on the brush-like tool to change to whatever chart you want.
6. Click on the plus sign tool to add chart elements like: Axes, Data labels, Gridlines. E.t.c.

STEP 10: PIVOT TABLES IN  EXCEL

Pivot tables help us summarise data.

1. Highlight the table by clicking and dragging down.

2. Go to “Insert tab”

3. Click on “Pivot table”.

4.  Click on where you want it to be either or existing sheet. Here we use  “New sheet” checkbox. And press “OK”

5. A new worksheet will open.

6. Select Product and Amount at the pivot table field.