Instructional Video

Excel 2016: Functions

Curated and Reviewed by Lesson Planet

When working with numerical data in a Microsoft Excel spreadsheet, which is better: formulas or functions? Pupils discover the answer through a short, instructional video.  First, scholars learn about the parts of a function and discover how they differ from formulas. Next, they see how to use AutoSum and the Insert Function command.

3 Views 1 Download
CCSS: Adaptable
Instructional Ideas
  • Have learners create their own tutorials about how to use functions in Excel 
Classroom Considerations
  • Each student requires a computer and headphones if watching individually
  • Discusses some advanced mathematical and technical concepts; may need to play several times
  • 15th of 27 videos from the Microsoft Excel 2016 set
  • This video is hosted on YouTube
Pros
  • Provides a text lesson resource
  • Narrator speaks clearly and slowly for maximum comprehension 
Cons
  • None
Common Core