Http://wiki.ubc.ca/LFS:Workshops/Excel Basics

From UBC Wiki

== DRAFT in progress ==

About spreadsheet applications

• Excel is a Spreadsheet

• About Excel: Wikipedia

• Top 10 Excel Essentials: 10 Excel Essentials

http://www.csub.edu/~emiranda3/Using%20Excel.pdf


Setting up spreadsheets

• columns

• Rows


Setting up workbooks and sheets operations

• [http://]


Functions and Formulas

• [1]



Charts

File:Put in a picture of a chart

• [https://en.wikipedia.org/wiki/Chart



Key Skills

  • How to enter basic formulas and calculations in Excel
  • Add up a column or row of cells in Excel
  • Absolute and relative references in Excel
  • Rounding numbers in Excel
  • Scale your spreadsheet to fit on one page when printing from Excel
  • Print an Excel 2010 spreadsheet with page numbers
  • Freeze or lock rows and columns in an Excel worksheet
  • How to use the IF function in Excel to calculate values based on different criteria
  • How to use Autofilter in Excel
  • How to create a Pivot Table in Excel


Excel resources

Example Data Sources



http://www.techrepublic.com/blog/10-things/the-10-most-important-things-to-teach-your-excel-users/ http://www.csub.edu/~emiranda3/Using%20Excel.pdf http://www.pcmag.com/slideshow/story/327311/20-excel-tips-for-becoming-a-spreadsheet-pro/10 http://www.techrepublic.com/blog/five-apps/five-tips-for-working-efficiently-with-excels-fill-handle/

File:Excel Basics Materials.zip

Retrieved from "https://wiki.ubc.ca/index.php?title=Http://wiki.ubc.ca/LFS:Workshops/Excel_Basics&oldid=399570"