1 / 25

Excel 2010 Take it to the Top

Excel 2010 Take it to the Top. Freda Williams and Susan Dreschel, Cherokee County School District. Why A Spreadsheet?. Incredibly powerful More flexible with formulas, lists, sort and filter options Pull in data from other programs Analyze and share information Make informed decisions

nicki
Download Presentation

Excel 2010 Take it to the Top

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 2010Take it to the Top Freda Williams and Susan Dreschel, Cherokee County School District

  2. Why A Spreadsheet? • Incredibly powerful • More flexible with formulas, lists, sort and filter options • Pull in data from other programs • Analyze and share information • Make informed decisions • Interfaces well with other Office Products and other spreadsheets

  3. Excel 2010 • Lots of new features • Access anywhere – even your iPhone • Share Excel with others – simultaneously! • Emphasis on better spreadsheets, tables and charts • More professional look and feel • Better analysis = smarter decisions • Intuitive and Real Time!!

  4. Excel – 25 years old! Celebrate 25 years of Excel with us! Excel - our beloved app - has reached the ripe old age of 25. In internet years, that's like 200 years old! To celebrate we're kicking off what we hope will be a fun contest centered on fond memories of Excel. The contest is being run on the Excel Facebook page, so check there for more details on how to enter and get involved.

  5. Terminology • Workbook – • Worksheet (1,048,576 rows and 16,384 columns) A - XFD • Row • Column • Cell • Cell Address

  6. Terminology, continued • Cursor (4) • White Plus - select • Black Plus – fill (fill series) • I-Beam - text edit mode • 4-sided arrow = move • Selected Cell(s) • Range – selection or named • Formula Bar

  7. Interface • Screen Resolution • Different views • File Menu -- Office Button • Ribbon - commands organized in like groups (Home, Insert, Page Layout, Formula, etc.) • Minimize the ribbon by double clicking

  8. Interface,continued • Quick Access Toolbar - Customizable • Key Tips – Alt (screen reminders) • Control + X// +C// +V • Home, End, Control + Home, etc. • Context Menu - right click • Mini Toolbar -- accessed through Excel Options • Select cell(s) and right click

  9. Formatting Cells (change the appearance, cell style) • Number • Alignment • Font • Border • Fill • Protection • Merge and Center • Adjust row and column sizes • Fit to Column . . . • Text Wrap

  10. Formulas and Functions • Must begin with = • Sum • Average • Count • Today • IF • MIN/MAX • Show Formulas

  11. Formula Bar • Name Box • Function Wizard • Bar for entering

  12. Multiple Worksheets • Rename Worksheet • Rearrange Worksheets • Change Colors • Add/Delete/Move/Copy • Protect Worksheet

  13. Print Options • ALWAYS Print Preview –ALWAYS!! • Show/Set Margins • Page Setup • Set/Clear Print Area

  14. Excel Charts 101 • 1. Area selected must be a rectangle • 2. No blank rows or columns in selection area • 3. Upper left corner must be blank (2003 vs. 2007) • 4. Watch out for Totals!!

  15. More Charting Tips: • Choose Chart Type carefully • Move Chart Location • Check Chart Layout • Modify chart elements • Graphing non-contiguous data • Copy into other programs

  16. Homework for next week Create a Gmail account, if you do not already have one . . . And now for your TEST!!

  17. Excel for Administrators -Second Session: Tips and Tricks – Windows 7 • Windows Search • Stickier Sticky Notes • Calculate More • Get Snipping • New Keyboard Shortcuts: • Presentation Mode = Win + P • Cut the Clutter = Win + Home • Launch Shortcuts = Win + 1, 2, 3, etc.

  18. Excel for Administrators -Second Session: Review from First Session: • Terminology • Interface • Formatting Cells • Formulas and Basic Functions • Managing Worksheets • Printing Options • Basic Charts

  19. Excel for Administrators -Second Session: • Managing and Controlling Data • Formatting Data • Protecting Data • Importing Data from Other Sources • Analyzing Data

  20. Managing & Controlling Data • Freeze panes • Hide/Unhide column(s) • Add/delete columns and rows • Sorts and custom sorts • Filters

  21. Managing & Controlling Data • Conditional Formatting • Format as table • Find and Replace • Concatenate • Text to Column • Paste Special/ Transpose/ Paste Link

  22. Using Formulas/Functions • Review • SUM, AVERAGE, COUNT, MAX, MIN • IF • COUNTIF • SUMIF

  23. Using Data • Using Excel for SIP Data (pasting links) • Using Google Docs to pull parent information into Excel and Outlook Distribution List

  24. Google Documents (Docs) • 1. Create an online survey • 2. Pull results into Excel • 3. Export Excel (97 – 2003) file into Outlook Contacts and Distribution List

  25. Analyzing Data • Pivot Tables • Organize, summarize and analyze large amounts of data • Updates and revisions are easy and immediate • Pivot Charts – table data in graphic format

More Related