1 / 18

Excel 2010 Math Basics

This module provides basic instruction on creating calculations in Excel using formulas and functions. Download materials, practice exercises, and access additional resources to enhance your learning experience.

llee
Download Presentation

Excel 2010 Math 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. Excel 2010 Math Basics Welcome to Excel Math Basics! Click to advance manually through the presentation

  2. Overview Objective: This module provides basic instruction to get you started with creating calculations in Excel, using both formulas and functions Checklist: Please download the checklist for this course. Instructions: click the Resources link to access the Dropbox folder which contains materials for this module; you can download the whole folder by clicking the Download button, or choose to download files individually

  3. Survey To provide the organization with information from you, prior to studying this course, please complete the survey. It is a short one. Your time is appreciated!

  4. Questions Journal or notepad … • Describe situations where you have needed to use Excel for math, at work or at home, and have become stuck. Note: You will be asked to refer to these points after you have finished this module, to see how effective the module has been in addressing your questions. Jot down any specific questions you have about Excel math.

  5. Choices • Let’s get started: This module covers an introduction to both formulas and functions in Excel Note: If you are comfortable with formulas, you may skip directly to functions.

  6. Formulas Formulas Here is an example of an invoice that requires formulas… Watch the video on the next slide to find out how to create formulas!

  7. Formulas Play video

  8. Formulas You try it! Switch to Excel and practice creating simple formulas. Be sure to try adding, subtracting, multiplying and dividing. Some examples:

  9. Formulas More examples:

  10. Formulas Try this exercise! • Exercise: download Excel Formulas 1 from Resources Journal or notepad … • Jot down some examples of formulas you will use. Ready for Functions basics? Go to the next slide.

  11. Functions Functions • We can use functionsin a variety of ways, including: • Displaying today’s date • Adding up a list of numbers • Finding the average value of a range of values

  12. Functions Play video

  13. Functions You try it! • Switch to Excel and practice creating simple functions. Be sure to try adding, subtracting, multiplying and dividing. • Exercise: download Excel Functions 1 from Resources • Exercise: Create a budget. Using the graphic as a guide, fill in some numbers, then use a function to find totals.

  14. Challenges Challenges Try these: Find and contribute to a blog which discusses Excel functions at a basic level.Example: blog - How to Use Excel Tips Go to LinkedIn.com and search for an Excel group that you could join.Example: MS Excel Tips and Tricks

  15. Build Your Resources Resources • *** Check these out! *** • Glossary of terms • Excel Tips with Dennis Taylor • Excel Central – 850 Free Excel Video Training Tutorials • Blog – My Excel Online • Excel Wiki – lots of great articles!

  16. Summarize Please summarize your learnings for this module. Formulas: Functions: How about your questions? Did they get answered? (See Questions slide.)

  17. Feedback Please fill out this feedback form and tell us about your experience with this module.

  18. Wrap Up Thank you for attending this module!

More Related