1 / 6

Excel Review

Excel Review. Shortcuts, Formulas/Functions, Data Handling. Resources . DGHI Excel page https://globalhealth.duke.edu/excel Location for info on classes and useful resources. Duke Lynda site http://www.lynda.com/member.aspx

takara
Download Presentation

Excel Review

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 Review Shortcuts, Formulas/Functions, Data Handling

  2. Resources DGHI Excel page https://globalhealth.duke.edu/excel Location for info on classes and useful resources. Duke Lynda site http://www.lynda.com/member.aspx Free online learning tutorials with comprehensive lessons on Excel.

  3. Tables and Ranges • Starting in Excel 2007 tables are available to replace ranges when referencing cells • Create Excel Table • Overview of Excel Tables

  4. Keyboard Shortcuts • Key stroke combinations to quickly move within a worksheet without needing the mouse. • Excel Keyboard Shortcuts

  5. Data Importing • Data can be imported into Excel from: • CSV • Tabbed • Other, non delimited data • Text To Columns • Connect to other workbook • Connect to data sources • http://www.bls.gov/web/ximpim/ippsbeam.htm

  6. Formulas and Functions • Sample Formula • =(A1+B2) / C3 • = ((4+90)^3 )* B5 • Sample Function • =COUNTIF(A2:A5,”apples”) • =MAX(C5:C770) • =VLOOKUP(1,A2:C10,2)

More Related