1 / 14

Welcome to Advanced Excel

Welcome to Advanced Excel. Log onto computer Open Internet Explorer URL - http://dtsdtechtraining.wikispaces.com Open My Computer Go to Curriculum on dtsd files Drive (X:). Advanced Excel. DTSD C.A.R.A.T.S. Teacher Training Melanie Wiscount mwiscount@hershey.k12.pa.us.

leyna
Download Presentation

Welcome to Advanced 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. Welcome to Advanced Excel • Log onto computer • Open Internet Explorer • URL - http://dtsdtechtraining.wikispaces.com • Open My Computer • Go to Curriculum on dtsd files Drive (X:)

  2. Advanced Excel DTSD C.A.R.A.T.S. Teacher Training Melanie Wiscount mwiscount@hershey.k12.pa.us

  3. Students Using Technology Stillwater, MN School Transforming Education with Technology

  4. Objectives • Explore ways to create more intelligent spreadsheets using advanced elements such as: • Naming • Functions • Logical • Mathematical • Comments • Advance formatting • Macros • Clips

  5. Objectives • Move spreadsheets to a higher level by using: • Protection & locking • LookUp Tables • Auditing • Pivot Tables • Create a simple quiz in Excel

  6. Microsoft Excel • Spreadsheet software • Electronic spreadsheet organizes information into software defined columns and rows • Released in 1987 • Originally written for use on Macintosh Apple computers • Excel file have extension .xls

  7. Microsoft Excel Screen Microsoft Excel Open Excel

  8. Function Syntax =keyword(cellor cell range) No spaces Lowercase Always begin with =

  9. Absolute vs. Relative Addresses • Assume you enter the following formulae into cell C1: =A1+B1 • If you copy the formula from C1 and paste this formula into cell C2, Excel will automatically change the formula to reflect the new position =A2+B2

  10. Relative Addresses • If you paste this formula into a bunch of cells, Excel automatically adjusts the formula to reflect the relative position of the new formula to the original form.

  11. If the formula in cell C1 is copied & pasted in C2 & C3, the following will result Relative Cell Addresses

  12. Another Shortcut • When you type a formula, data, etc. into a cell and want to copy it to cells below or to the right, look for the tiny black box in the bottom right of that cell, click on that box and drag it down (or to the right)

  13. Absolute Cell Addresses • Sometimes you want the cell address to be “locked”. If you cut and paste it, the address will be same. • In order to create locked or absolute cell formulas, you enter $ in front of the row number and column letters • =$A$1+$B$1

  14. If the formula in cell C1 is copied & pasted in C2 & C3, the following will result Absolute Cell Addresses

More Related