Excel Material

Excel Presentation

Prepared by Tarek Nehad Raya Contact Center

Outlines • • • • • • • • • • • • • •

Introduction for Microsoft Excel Starting Microsoft Excel Excel Layout Inserting Worksheet Cells Formatting Sorting Data Merge Cells Sharing File Filtering Data Freeze Cells Hyperlink Creating Formulas Functions (Sum, Average, CountIf and SumIf) Charts

Raya Contact Center

Introduction into Microsoft Excel • Microsoft Excel it allows you to create professional spreadsheets and charts. It performs numerous functions and formulas to assist you in your projects.

Raya Contact Center

Starting Microsoft Excel Three Ways 1. Double click on the Microsoft Excel icon on the desktop.

2. Right Click on the place you need to save the file on --> New --> Microsoft Excel worksheet

Raya Contact Center

Starting Microsoft Excel 3. Click on Start --> Programs --> Microsoft Office --> Microsoft Office Excel

Raya Contact Center

Excel Layout

Work Sheet Raya Contact Center

Insert New Worksheet Two Ways 1. From Insert menu

Raya Contact Center

Insert New Worksheet

(Continued)

2. Right Click on worksheet --> Insert

--> Select Worksheet

Raya Contact Center

Adding Borders and Shading to Cells • Make sure you have the Formatting toolbar visible • Click on View --> Toolbars --> Formatting • Select cells you wish to format by left clicking on them and highlighting them • Click the The

button to shade a cell and/or to give a cell a border Raya Contact Center

Cell & Font Formatting Formatting toolbar • Font Formatting •

Cell Formatting Borders & Colors

Raya Contact Center

Cell & Font Formatting (Continued)

Right Click --> Format Cells

Raya Contact Center

Sort Data Click a cell in the column you would like to sort by. Two Ways 1. Select sort from Data menu

2. From Standard toolbar menu Raya Contact Center

Sort Data (Continued) Sort Warning

• Expand the selection: Will sort the data & change the corresponding data in the other columns • Continue with the current selection: will sort the current column without changing in other columns Raya Contact Center

Sort Data (Continued) Or if you have table as below and you need to sort more than column Ex: We will sort by the highest Salary & the old hiring date

Raya Contact Center

Sort Data (Continued) We will sort by the highest Salary & the old hiring date 1. Highlight on the whole table 2. Select sort from Data menu 3. Select the criteria you need to sort with

Raya Contact Center

Merge Cells We can merge 2 or more cells together through 1. highlighting the needed cells 2. Clicking on the merge

from the formatting toolbar

Raya Contact Center

Sharing • That use to share the excel file to be accessible from more than one user at the same time

Note: it’s recommended to not use for more than 10 users at a time

Raya Contact Center

Sharing (Continued)

• From File menu

Put Check mark to allow the others to update the sheet

Raya Contact Center

Filtering Data

1. Select the row you want to filter with 2. From the main menu select Data --> Filter --> AutoFilter

Raya Contact Center

Freeze Cells

• Select from the main menu Window --> Freeze Panes

• When freezing the cells you will freeze the all the cells which upper & left of the current cell you standing on &

Current Cell

Raya Contact Center

Hyperlink Two Ways 1. From the main menu select Insert --> Hyperlink

2. Use the shortcut Ctrl + K

Raya Contact Center

Hyperlink (Continued)

• We can link the cell to open another file by selecting the file as shown below Write the text you want to display it on the cell

Raya Contact Center

Hyperlink (Continued)

• Or we can select another worksheet in the current excel file

Raya Contact Center

Creating Formulas •

Click the cell that you want to enter the formula.

•

Select

from the toolbar

Raya Contact Center

Creating Formulas

(Continued)

Example: Sum the salaries for the employees 1. Click on the sign and select sum from the menu 2. Select the cells you need to sum

Raya Contact Center

Creating Formulas

(Continued)

You can follow the same steps for the Average, Count, Max and Min

Raya Contact Center

Creating Formulas (Continued) • Click the cell that you want to enter the formula. • Click the Function Button • Select the formula you want and step through the onscreen instructions

Raya Contact Center

Creating Formulas (Continued) Example: to count all “Yes” 1. Click on 2. Type the function you need Ex: COUNTIF 3. Select the Range you need to count 4. Put the criteria you want to count with

Raya Contact Center

Order of Operations Excel Uses Precedence

Operation

Operator

1

Exponentiation

^

2

Multiplication

*

2

Division

/

3

Addition

+

3

Subtraction

-

4

Concatenation (putting 2 strings together, like Moh & amed)

&

5

Equal To

=

5

Greater Than

>

5

Less Than

<

Raya Contact Center

Inserting A Chart 1. Select over the text you want to make your chart with

2. Click Insert --> Chart

Raya Contact Center

Inserting A Chart

(continued)

3. Select the type of chart you want

Raya Contact Center

Inserting A Chart

(continued)

4. Confirm or change your data range 5. Update the Chart Options

Raya Contact Center

Inserting A Chart

(continued)

6. Select if you want to put it into the current worksheet or into a new worksheet

Raya Contact Center

Thank You !!!

Raya Contact Center