Excel for Beginners Part 1 - Theory.pptx

Excel for beginners

1. Microsoft Excel Basic Level Workshop Rafael Cota Rivas @rafaelcotar [email protected]

2. Objetive To participate in a practical Microsoft Excel workshop with a thorough review of its basic functions and tools.

3. Content Introduction What is Excel? Description of its elements. Displacements. Selection. Basic operations. Information in the status bar. Help. Documents organization. Create a workbook. Open an existing workbook. Save a workbook. Close all open workbooks and the application. Spreadsheet Format Cell format: Source. Cell content alignment. Edges. Numbers and text format. Row and column format. Row height. Auto adjust. Basic Editing Operations Copy information. Ways of pasting information. Cell filling and series creation. Deletion of content and cell formatting. Insertion of cells, rows and columns. Elimination of cells, rows and columns within a sheet. Undo, redo and repeat last actions.

4. Content Printing Preview. Page setup. To print. Header and footer. Selections for printing. Formulas Formula creation. Cell reference. Cell names and ranges. Graphics Creation and modification of graphics.

5. Excel screen elements When you first open Excel and start with a blank worksheet, this is what you'll see Name of the workbook Formula Bar Columns Rows Sheets Zoom Ribbon

6. Cell Cells contain labels, data, and formulas. To make worksheet data stand out, cells can be formatted to change the text or to add a fill color. Cells may also contain charts and images that explain the cell data.

7. Cell content Data entered into a worksheet is stored in a cell. Each cell holds only one piece of data at a time. A cell is the intersection point of a vertical column and a horizontal row. Each cell in the worksheet is identified by a  cell reference , which is a combination of letters and numbers such as A1, F456, or AA34.

8. The File tab

9. Practice Create a new Workbook Type your First name in Cell C3, and your Last name un cell D3. Type the year you were born in Cell E3. Put some titles in the Cells above the data you just entered. Make the size of each Column with data to fit its content Now put the titles in a Bold font format Now put the Background color of the titles in Black and the font color in White Now change the size of the titles font to 14pt and resize the column to fit its content How about if we center the titles in each cell? What if we want to make the title’s row bigger? Now change the name of the Sheet1 to “Cell practice”

10. Formula bar

11. Sheet tabs

12. Practice Type the following names and years in cells C4:E7 Benjamin Franklin 1706 Abraham Lincoln 1809 Franklin D. Roosevelt 1882 Now type Difference in Cell F2 Calculate the number of years between your birth and theirs Goto Cell F4 and type “=E3-E4” Calculate the number of years of the other two in cells F5 and F6 Calculate the SUM of years Save your Workbook with the name Practice-1

13. Practice Add a new Sheet to your Workbook Practice-1 and name it “Calculations” Select cells C2-F7 in your Cell practice Sheet Goto the Ribbon and select Home, then Copy Click on the Practice-1 Sheet and select Cell C2 Paste the Clipboard content Adjust the format until you’re comfortable with it Now add the numbers in Column E with Column F for each row, and put the result in Column G Divide the result by the number in Column F

14. 14