1 / 21

Excel: G etting Data Into Excel Graphs and Graphing Sorting and Filtering

Excel: G etting Data Into Excel Graphs and Graphing Sorting and Filtering. 15 April 2014. Getting Data Into Excel. Getting Data From the Web. Option 1: Find a Download button Data Sets Option 2: Cut and Paste Directly If you can past with special options, you can get even more of them

ling
Download Presentation

Excel: G etting Data Into Excel Graphs and Graphing Sorting and Filtering

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:Getting Data Into ExcelGraphs and GraphingSorting and Filtering 15 April 2014

  2. Getting Data Into Excel

  3. Getting Data From the Web • Option 1: Find a Download button Data Sets • Option 2: Cut and Paste Directly • If you can past with special options, you can get even more of them 1896 Summer Olympics • Option 3: • Cut and Paste to Notepad • Cut and Paste to Excel Pizza Hut

  4. Importing to Excel (Maybe) • Data -> (Get External Data) From Text • Use Delimited • Try Tab. Excel will show you what it finds • Import headers, totals, … • Worst case is that you delete them!

  5. Other tools • Komodo editor for line changes • Example: \r\n identifies line end in Windows • > Remember to show EOL Markers and White Space • PDF to Excel web sites and tools • Google for free trials (nitro)

  6. Text to Column • Want atomic entries • What if they are combined?

  7. Excel Graphing

  8. What Can You Chart? • Basic Model • Data laid out in rows and columns • Header row labels describing columns • Header column categories describing rows • Blank upper left cell sometimes needed • Not necessary, but easiest

  9. Creating a graph • Highlight your data • Insert the chart type you want • Move the chart where you want it

  10. Changing your Graph • Click on the border of the graph • All graph tools are now available

  11. Choices • How much data • One or more graphs • What type of graph • Labeling

  12. Really easy to overdo • Use to clarify, not obfuscate • Be gentle on the eyes • Need to print? • Use differentiable colors and symbols

  13. Graphing Tricks • Second axis • Click on series • Right click • Format Data Series • Scatter plots • Include the labels and you get 2 series • Exclude the labels and you get an x-y scatter • Format axis to change range

  14. Tips, continued • Want to highlight one point on a line graph? • Create it as a series by itself • Include markers on all the data • Change the other series NOT to have markers • Restructure your data to get the graph you want

  15. Getting Graphs to the Web • Save spreadsheet as web page • Save as Web Page (htm or html) • NOT Single File Web Page • Spreadsheet only (not workbook) • Move one of the .png files to your web folder • Throw away the rest

  16. Sorting and Filtering

  17. Sorting • Formulas • Cannot sort a table with ONLY formulas • Custom sort (preferences on Macs)

  18. Filtering • Filtering (simple and advanced) • Headers must be used • In place hides, copy deletes • Strings do not use “

  19. Advanced Filter • Rows are OR • Columns are AND • Can repeat a column name • comparator value • Can show all columns or subset • Text: wildcard options

  20. Filter Rules Summary • Headers must be used and must match • In place hides, copy deletes • Strings do not use “ • Rows are OR • Columns are AND • Can repeat names to AND a single column • Can identify subset of columns to display • To copy to another worksheet, must START on the destination

  21. Text Wildcards

More Related