1 / 12

Spreadsheet Basics

Spreadsheet Basics. Why Use Spreadsheets?. Options. Microsoft Excel. Google Documents. Uses. Budgeting. Address Book. Scheduling. Event Planning. Math . Financial Planning. Track Book or Movie Collections. Templates. Math Functions.

zubin
Download Presentation

Spreadsheet Basics

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. Spreadsheet Basics

  2. Why Use Spreadsheets?

  3. Options Microsoft Excel Google Documents

  4. Uses • Budgeting • Address Book • Scheduling • Event Planning • Math • Financial Planning • Track Book or Movie Collections

  5. Templates

  6. Math Functions • Start with an equal sign to indicate a mathematical equation or function • Can use numbers or cells = + - * /

  7. Copy and Pasting • Paste Special! • Paste Values • Paste Formulas • Paste Format

  8. Basic Commands Addition  =SUM(A1,A2,A5) Average  =AVERAGE(A1:A:5) Join  =A1&A5

  9. Other Useful Commands • If Statement • Count If

  10. Conditional Formatting Use the “Highlight Cells” rules to make color indicators for your data

  11. Let’s See it in Action!

More Related