1 / 24

Excel 101

Excel 101. Greg Schaffer Ry Mittlestadt. What we’re going to Cover. The working parts of Excel How to Navigate How to Sort Formatting Filters Lab. This is Excel. The Working Parts of Excel. Workbook Worksheet (also called a spreadsheet) Columns Rows Cells Name Box Formula Box.

michi
Download Presentation

Excel 101

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 101 Greg Schaffer Ry Mittlestadt

  2. What we’re going to Cover • The working parts of Excel • How to Navigate • How to Sort • Formatting • Filters • Lab

  3. This is Excel

  4. The Working Parts of Excel • Workbook • Worksheet (also called a spreadsheet) • Columns • Rows • Cells • Name Box • Formula Box

  5. The Working Parts of Excel Workbook

  6. The Working Parts of Excel Worksheet

  7. The Working Parts of Excel Columns

  8. The Working Parts of Excel Rows

  9. Cells The Working Parts of Excel

  10. The Working Parts of Excel Name Box

  11. The Working Parts of Excel Formula Box

  12. How to Navigate in Excel Tab = Move Right Enter = Move Down Keyboard Shortcuts Ctrl + ‘Home’ = Cursor back to Cell A1 Ctrl + PgDn = Next Sheet Ctrl + PgUp = Previous Sheet

  13. How to Format Data All data can be formatted so that it looks nicer and is easier to read. Formatting Data can be done three ways: • Column • Row • Cell

  14. How to Format Data • To Format the column or row, select the entire column or row and select ‘Format’ from the main toolbar, then select ‘Cells.’

  15. How to Format Data • This bring the ‘Format Cells’ dialog box. From this dialog box, you may format: • Numbers • Alingment • Font • Border • Patterns (colors)

  16. How to Format Data Formatting examples: Date Formatting: 1-1-02 becomes 1/1/2002 Currency Formatting: 2.35 becomes $2.35 We’ll explore this more in the lab…

  17. How to Sort Two types: • Simple sort • Sorts selection by first column • Advanced Sort • Allows you to specify which columns to sort the selection

  18. How to Sort Simple Sort note that the entire data range has been selected

  19. How to Sort Advanced Sort:Select ‘Data,’ then ‘Sort’ Sort dialog box: You select which columns to sort the selected data

  20. How to Sort • Critical that the correct data range has been selected.

  21. Filters • Why use a filter? • Select just the data you want to see fast • Filter within a Filter • Only Sales employees from the North region

  22. To Select Filters Select a Cell Data – Filter - AutoFilter

  23. Filters Filter drop down box for each heading Filter drop down box for department Allows you to select Accounting

  24. In Review • The working parts of Excel • Workbook • Worksheets • Columns • Rows • Cells • Name Box • Formula Box • How to Navigate • How to Sort • Formatting • Filters

More Related