Record Data

• Excel contains spreadsheets where you can record data. There are columns and rows, so that you can easily enter and organize numbers or words. Each rectangular field corresponds to a row and cell number (such as A5 or D12) and is called a cell. You may want to use the first column and first row to appropriately label your information for easy recognition within the spreadsheet. The rows and columns expand so that you can input as much data as you'd like. Excel also offers templates for times when you need a specific format, such as accounting or budgeting sheets. You can open up a template and it will pre-populate several fields so that all you need to do is enter your own recorded information, such as prices, amounts or scores.
  
  

Organize Information

• Within Excel, you can easily organize your data. Use the sort function to sort through rows or columns of information to make them easier to handle. The sort function allows you to sort a small amount of data, such as a single row, at a time. Sort through large amounts of cells by selecting several rows or columns. Options within the sort function allow you to sort and filter your raw data in different ways, such as from highest to lowest or by a value that you choose.
  
  

Calculations and Formulas

• Add formulas to rows or columns in Excel to calculate data. Create your own calculations by beginning a cell with "=", then clicking on specific cells and adding functions, such as addition or subtraction. This function is useful for keeping running totals, such as for budgeting or accounting. You have the ability to complete simple calculations, such as adding all of the digits in a row or column, or more complex functions, like rates or formulas specific to your business.
  
  

Charting and Sharing

• Create charts in Excel by using the Chart function. A chart or graph consolidates your information into an image, so that you can share your information efficiently with others. Utilize charts and graphs to illustrate trends or topics within your data. Excel offers a wide variety of charts, such as bar graphs or pie charts. Print charts to share hard copies or share them electronically. If you need to share your raw data, save your work in a workbook and distribute the file electronically to allow other people to access the bulk of your recorded information.