Microsoft Excel is a spreadsheet application designed for everyday business tasks such as setting up a balance, managing a client list and calculating reports.
In order to do these tasks, numerous formulas can be used to create higher efficiency and more accurate results.
This lesson plan will teach and explain 5 basic formulas while applying them in a real world way.
AutoSum, Running Balance, Average, and the Smallest/Largest Value of a Range
In order to do these tasks, numerous formulas can be used to create higher efficiency and more accurate results.
This lesson plan will teach and explain 5 basic formulas while applying them in a real world way.
AutoSum, Running Balance, Average, and the Smallest/Largest Value of a Range
We'll begin by doing a short survey while watching a video to establish a baseline for what you already know.
By the end of this lesson, you should be able to use and explain 5 basic Excel formula in real world office situations.
By the end of this lesson, you should be able to use and explain 5 basic Excel formula in real world office situations.
Please use this live chat, during or after the video to discuss any observations or questions you may have
|
|
Once you are done the survey, video and any live collaborations, please write a brief reflection in the message board below in the thread "Excel: an Introduction" about what you saw in the video and discussed as a group.
Were you surprised about some functions?
Was it easier, or, harder to use than what you imagined?
Were you surprised about some functions?
Was it easier, or, harder to use than what you imagined?