https://macmost.com/e-3170 Learn some basic Numbers spreadsheet skills by building a document that tracks a stock portfolio. Learn to use functions, perform math operations, get column sums, format cells in various ways, use conditional highlighting, use multiple tables, build charts and more.
FOLLOW MACMOST FOR NEW TUTORIALS
▶︎ Subscribe here at YouTube — http://macmost.com/j-youtube (And hit the 🔔)
FREE EMAIL NEWSLETTER
▶︎ See what's new each week and more — https://macmost.com/newsletter 📬
▶︎ Per-Video Email Notifications — http://macmost.com/ytn 📆
SUPPORT MACMOST AT PATREON
▶︎ https://macmost.com/patreon ❤️
00:00 Intro
00:49 Starting From Scratch
01:16 Accessing Stock Information
02:40 Add Purchase Information
04:01 Formatting Cells
04:34 Getting the Current Stock Price
06:36 Calculating Gains and Losses
07:41 Add More Stock Information
08:04 Custom Formatting For Large Numbers
08:34 Adding More Stocks
09:34 Conditional Highlighting For Gains and Losses
10:48 Adding a Summary Table
12:54 Adding a Pie Chart
#macmost #mactutorial