Spreadsheets

Spreadsheets are common data tables with may uses. This guide gives tips and instructions for using them, especially for data.

• Basic Skills - Basic actions and concepts such as cell reference and formulas
• Charts & Graphs - Instructions and tips for creating data visualizations
• Data Management & Cleaning - How to fix and organize data
  • OpenRefine - An open source software useful for data cleaning
• Summarizing Data - Using Pivot Tables to see summary statistics
• Data Analysis - Add-ins and other options for doing analysis
• Software - How to access Excel and other useful alternatives
• Get Help - Where can you get assistance with spreadsheets

Excel Skills for Data

• Formulas with Absolute and Relative Cell References
• Pivot Tables and Pivot Charts - Create Summary Statistics
• Conditional Formatting - Change colors based on cell values
• Power Query - More advanced data manipulation

Related InfoGuides