1 / 51

Excel

Excel. Garry Storer IT Training Co- Ordinator IT Services. Excel Cells. A2. D10. Formatting Cells. Font. Allignment. Text / Number / Formula. FORMULA (always start with =). TEXT (left justified). N UMBER (right justified).

cara
Download Presentation

Excel

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Excel Garry Storer IT Training Co-Ordinator IT Services

  2. Excel Cells A2 D10

  3. Formatting Cells Font Allignment

  4. Text / Number / Formula FORMULA (always start with =) TEXT (left justified) NUMBER (right justified)

  5. Highlight Area, then type in numbers, with arrows, or tab in between

  6. Copy Cells

  7. Rules of Maths 9 + 1 x 1 = 19 Brackets () Ordinals x2 √ Division ÷ / Multiply x * Addition + Subtraction

  8. Right Click Zoom Status Bar

  9. Sum / Average 1. Click into the cell 2. Click Autosum 3. Highlight Area 4. Press Return

  10. Formulas Start with = Click cells and use operators

  11. Copying Cells

  12. Conditional Formatting

  13. Sort & Filter Highlight Cells

  14. Filter Highlight Cells

  15. Filter

  16. Filter

  17. Select Row or Column

  18. Pie Charts Highlight Cells

  19. Highlight Pie Segment

  20. COLUMN CHART CTRL + HIGHLIGHT HIGHLIGHT

  21. CHART COLUMN

  22. DESIGN LAYOUT FORMAT

  23. Trendline Right Click

  24. Cell references Absolute Cell References In spreadsheets such as Lotus 1-2-3, an absolute cell address identifies the location a cell or group of cells. Cell addresses are used in formulas, functions, charts, and other spreadsheet commands. An absolute cell address consists of the column letter and row number surrounded by dollar signs ( $ ). An example of an absolute cell address would be $C$4, $G$15, or $A$345. Note: An easy way to add the dollar signs to a cell address is to click on a cell address and then press the F4 key on the keyboard. An absolute cell address is used when you want a cell address to stay fixed on a specific cell.

  25. Transposing from Columns to Rows Highlight Cells + Copy

  26. IF Function

  27. Lookup

  28. Vlookup

  29. Excel Pivot Tables Garry Storer IT Training Co-Ordinator IT Services

  30. Pivot Tables

  31. Scenario 1 A project manager would like to know how much they have spent on their 2 projects A32520012 C26000212 They would like the figures to be broke down via Expenditure Category & Expenditure Type.

  32. Remove Display

  33. Remove Display

  34. Remove Display

  35. Remove Display

  36. Double Click Double Click

  37. Scenario 2 A project manager would like to know how many transactions there has been their 2 projects. A32520012 C26000212 They would like the figures to be broke down via the following groupings. Income & Recharge (Minus figures) £0-50 £50-100 £100-500 £500-5000 £5000+ The manager would like to know the percentage of the transactions in each grouping.

More Related