Sakai's Snacks exercise - example videos
Here I am showing you some of the features of Microsoft Excel while solving a specific problem for Sakai's Snacks business. Sakai owns a business and wants to know how much the overall function should cost when he prepares a bill for his customers. He starts with a simple spreadsheet template, but needs a better business solution to be able to answer customer queries quickly and in real time. Microsoft Excel contains features that can help him to make these calculations quickly and without error.
|
|
|
|
| ||||||||||
| sakai_snacks_problem_guide.pdf |
Key Excel Knowledge
These video clips are best viewed on a computer using the HD option. When clicked, the video gets launched in Vimeo directly.
Another option if you are viewing on a device without YouTube being blocked by a firewall is to access the playlist shown at the bottom of the screen. This will play through all of the clips in turn and is highly recommended for aiding your Excel understanding.
Another option if you are viewing on a device without YouTube being blocked by a firewall is to access the playlist shown at the bottom of the screen. This will play through all of the clips in turn and is highly recommended for aiding your Excel understanding.
|
Basic formulas (+ - / * %)
|
Key Excel functions (SUM, COUNT...)
|
Complex functions
|
|
Conditional statements (IF)
|
Lookups (VLOOKUP)
|
Inserting notes or comments
|
|
Creating a graph or chart
|
Relative and absolute cell references
|
Naming cell ranges
|
|
Data validation (electronic)
|
Validation messages
|
Cell protection
|
|
Worksheet referencing
|
|
|
|
Conditional Formatting and Sheet Protection
|
|
