Computer Excel Formulas Discussion Presentation

Question Description

DISCUSS USING POWERPOINT

  • Share what you learned from this week, what was most interesting, or even what was the most challenging feature for you. Also share as to how you came up with your solutions in the assignments and the type of analysis you decided to use.
  • VLOOKUP is a function that is difficult to grasp. Please read this article of the VLOOKUP function and provide feedback on it: https://www.techonthenet.com/excel/formulas/vlookup.php

LESSON LEARNT THIS WEEK:

This week we will concentrate on the analysis of data and what features support this functionality. It is important to reinforce the following:

  • Spend some time reviewing the concept of formulas within the discussions.
  • The IF function is in particular challenging to students. Make sure to post examples and go over this during the discussions to reinforce this concept
  • Make sure to explain the differences of charts and how to select the right chart for the right data. Provide examples and ask students to identify the right chart for the data you may provide. IF Function: https://support.office.com/en-us/article/if-function-69aed7c9-4e8a-4755-a9bc-aa8bbff73be2 (Links to an external site.)
  • By the end of the week you should be able to understand and apply the following course outcome: Analyze spreadsheets by evaluating data, charts, and other information common in health professions and personal application