👩🏼🏫 Apple Numbers Tutorial — Sum, Average, Autofill, Formulas / Functions, Conditional Formatting
It's a common problem amoungst office workers. The job description required expertise with spreadsheets, but that qualification was lacking. After months… perhaps years …of avoiding tasks related to Microsoft Excel, suddenly that grid of cells needs to be filled!
Well, hopefully with this Photics.TV educational video, you won't have to fake your knowledge of spreadsheets. The app shown in the video is Apple's Numbers, part of the iWork suite of productivity apps. However, the concepts are general and should be quite applicable to other spreadsheet applications.
This video is also a follow-up to a previous Photics.TV video. It shows how the Crossy Road Coin Collection Averages spreadsheet was created. Since Apple Numbers is available via iCloud, you too could create your own scientific analysis. Perhaps there's more to collecting coins than previously imagined.
Using Math To Get More Crossy Road Coins
• Using Math To Get More Crossy Road Coins
Additionally this video shows Apple Numbers from both the Mac Desktop (macOS) perspective, and the iPhone / iPad mobile perspective.
CHAPTERS
00:00 Introduction
00:31 Adding & Averaging
02:41 Autofill
05:06 Formulas & Functions
07:42 Text Formatting
08:34 Conditional Formatting
*CREDITS
Apple iWork Numbers @Apple — https://www.apple.com/numbers/
Crossy Road @HipsterWhaleOfficial — https://www.crossyroad.com
Widgets & WordNet
Word definitions were displayed with the Widgets app… https://photics.com/tools/widgets/ …which uses Princeton University's WordNet (https://wordnet.princeton.edu) as source data.
TAGS
#apple #numbers #iwork #spreadsheet #spreadsheets #excel #computers #iphone #ipad #mac #macos #tutorial #tutorials #lesson #lessons #photics