Track Your Expenses in Mac Numbers

macmostvideo December 20, 2023
Video Thumbnail
macmostvideo Logo

macmostvideo

@macmost

About

Subscribe to MacMost to watch daily video tutorials about how to get the most from your Mac, iPad and iPhone! This show focuses on the "how to." You'll learn how to use macOS and the apps that come with your Mac. MacMost also features news, commentary reviews geared toward the casual personal and business Apple user. Every day is a new topic covering the range from absolute beginners and switchers, to intermediate and advanced tutorials as well. Each tutorial is written and presented by Gary Rosenzweig, a computer scientist, tech expert and Mac enthusiast who has been writing books and educating user for more than 25 years. Gary will walk you step-by-step through how-to tutorials and concepts.

Video Description

https://macmost.com/e-3070 You can use a simple spreadsheet in Numbers to track your home or personal expenses. No formulas or calculations are required. Just record your expenses and then use a simple Pivot Table to see a summary of your expenses by category over months or years. Follow this step-by-step tutorial. FOLLOW MACMOST FOR NEW TUTORIALS EVERY DAY ▶︎ YouTube — http://macmost.com/j-youtube (And hit the 🔔) ▶︎ YouTube Email Notifications — http://macmost.com/ytn ⭐️ ▶︎ MacMost Weekly Email Newsletter — https://macmost.com/newsletter ✉️ SUPPORT MACMOST AT PATREON ▶︎ https://macmost.com/patreon ❤️ 00:00 Intro 00:36 Create a New Document 00:59 Create an Expenses Journal Table 03:49 Formatting the Cells 05:37 Sorting Your Expenses Table 06:15 Viewing Totals For Months and Categories 09:22 Filter Results By Date Range 09:54 Create Multiple Summary Views 10:28 View Only Some Categories #macmost #mactutorial #numbers

You May Also Like

Master Mac Finance Tools

AI-recommended products based on this video

Loading...
Macally Small Wired Keyboard for Mac and Windows - 78 Scissor Switch Keys Compatible Apple Keyboard - USB Mini Keyboard That Saves Space and Looks Great - Plug and Play Wired Mac Keyboard - Aluminum

Macally Small Wired Keyboard for Mac and Windows - 78 Scissor Switch Keys Compatible Apple Keyboard - USB Mini Keyboard That Saves Space and Looks Great - Plug and Play Wired Mac Keyboard - Aluminum

(4,883)
27.99
PrimeFREE delivery Saturday, June 14 on orders shipped by Amazon over $35
200+ bought in past month
Loading...
Wireless Gaming Headset for PS5, PS4, PC, Mac, Switch, 2.4GHz Gaming Headsets with Bluetooth 5.4, Hidden ENC Noise Canceling Mic, 35H Battery, 3D Spatial Sound, 3.5mm Wired - Black

Wireless Gaming Headset for PS5, PS4, PC, Mac, Switch, 2.4GHz Gaming Headsets with Bluetooth 5.4, Hidden ENC Noise Canceling Mic, 35H Battery, 3D Spatial Sound, 3.5mm Wired - Black

(132)
$14.99
FREE delivery Jul 2 - 6 on $35 of items shipped by Amazon
2K+ bought in past month
Loading...
UGREEN USB C to USB Hub with 4 USB 3.0, Powered USB C Splitter for Laptop, MacBook Pro, Mac mini M4, iMac, iPad Pro, Chromebook, Dell XPS, Galaxy S23, and More, 0.5FT

UGREEN USB C to USB Hub with 4 USB 3.0, Powered USB C Splitter for Laptop, MacBook Pro, Mac mini M4, iMac, iPad Pro, Chromebook, Dell XPS, Galaxy S23, and More, 0.5FT

(12,070)
9.99
PrimeFREE delivery Saturday, June 14 on orders shipped by Amazon over $35
400+ bought in past month
Loading...
Wireless Bluetooth Mouse for Apple iPad iPhone MacBook Android Samsung Tablet Phone Dual-Mode Rechargeable 2.4G Portable Computer Mice for Windows Laptop Notebook PC Mac Desktop USB Receiver (Black)

Wireless Bluetooth Mouse for Apple iPad iPhone MacBook Android Samsung Tablet Phone Dual-Mode Rechargeable 2.4G Portable Computer Mice for Windows Laptop Notebook PC Mac Desktop USB Receiver (Black)

(1,960)
9.99
PrimeFREE delivery Saturday, June 14 on orders shipped by Amazon over $35
500+ bought in past month
Loading...
Wireless Bluetooth Mouse for Apple iPad iPhone MacBook Android Samsung Tablet Phone Dual-Mode Rechargeable 2.4G Portable Computer Mice for Windows Laptop Notebook PC Mac Desktop USB Receiver (Black)

Wireless Bluetooth Mouse for Apple iPad iPhone MacBook Android Samsung Tablet Phone Dual-Mode Rechargeable 2.4G Portable Computer Mice for Windows Laptop Notebook PC Mac Desktop USB Receiver (Black)

(1,960)
9.99
PrimeFREE delivery Saturday, June 14 on orders shipped by Amazon over $35
500+ bought in past month
Loading...
ESR Pencil (1st Generation) for iPad 2018-2025, Tilt Sensitivity, Palm Rejection, Compatible with iPad 11th(A16)/10th Generation,Air 11"/13", Pro 11"/12.9"/13",Mini 6/5, White

ESR Pencil (1st Generation) for iPad 2018-2025, Tilt Sensitivity, Palm Rejection, Compatible with iPad 11th(A16)/10th Generation,Air 11"/13", Pro 11"/12.9"/13",Mini 6/5, White

(1,961)
16.99
PrimeFREE delivery Saturday, June 14 on orders shipped by Amazon over $35
500+ bought in past month
Loading...
Stylus Pen for iPad 2018-2025, Fast Charging Magnetic Pencil (1st Generation) with Tilt Sensitivity & Palm Rejection for iPad Air 3/4/5/M2/M3, iPad mini 5/6, iPad 6/7/8/9/10/11, iPad Pro 11"/12.9"/M4

Stylus Pen for iPad 2018-2025, Fast Charging Magnetic Pencil (1st Generation) with Tilt Sensitivity & Palm Rejection for iPad Air 3/4/5/M2/M3, iPad mini 5/6, iPad 6/7/8/9/10/11, iPad Pro 11"/12.9"/M4

(6,242)
19.99
PrimeFREE delivery Saturday, June 14 on orders shipped by Amazon over $35
8K+ bought in past month
Loading...
UGREEN USB C to USB Hub with 4 USB 3.0, Powered USB C Splitter for Laptop, MacBook Pro, Mac mini M4, iMac, iPad Pro, Chromebook, Dell XPS, Galaxy S23, and More, 0.5FT

UGREEN USB C to USB Hub with 4 USB 3.0, Powered USB C Splitter for Laptop, MacBook Pro, Mac mini M4, iMac, iPad Pro, Chromebook, Dell XPS, Galaxy S23, and More, 0.5FT

(12,070)
9.99
PrimeFREE delivery Saturday, June 14 on orders shipped by Amazon over $35
400+ bought in past month
Loading...
UGREEN Uno 6 in 1 USB-C Hub with 10Gbps USB-C & USB-A Data Ports 4K@60Hz HDMI for MacBook Pro/Air, iPad Pro, Surface, XPS, Thinkpad and More.

UGREEN Uno 6 in 1 USB-C Hub with 10Gbps USB-C & USB-A Data Ports 4K@60Hz HDMI for MacBook Pro/Air, iPad Pro, Surface, XPS, Thinkpad and More.

(1,196)
22.49
PrimeFREE delivery Saturday, June 14 on orders shipped by Amazon over $35
100+ bought in past month
Loading...
Anker Power Bank(PowerCore 10K),Compact Travel-Ready 10,000mAh Battery Pack with PowerIQ Charging Technology,5V/3A High-Speed Charging for iPhone,iPad,and More (USB-C Input and Output(Black),1pack) ClimatePartner certified

Anker Power Bank(PowerCore 10K),Compact Travel-Ready 10,000mAh Battery Pack with PowerIQ Charging Technology,5V/3A High-Speed Charging for iPhone,iPad,and More (USB-C Input and Output(Black),1pack) ClimatePartner certified

(109,961)
$17.99$17.81
FREE delivery Fri, Aug 8 on $35 of items shipped by Amazon
10K+ bought in past month
Loading...
ZealSound Gaming Microphone Kit,Podcast Condenser USB Mic with Boom Arm,Supercardioid Microphone with Mute Button,Echo Volume Gain Knob,Adjust Monitor for Phone PC Computer (Black)

ZealSound Gaming Microphone Kit,Podcast Condenser USB Mic with Boom Arm,Supercardioid Microphone with Mute Button,Echo Volume Gain Knob,Adjust Monitor for Phone PC Computer (Black)

(770)
41.99
PrimeFREE delivery Saturday, June 14
200+ bought in past month
Loading...
FIFINE Gaming USB Microphone for PC PS5, Condenser Mic with Quick Mute, RGB Indicator, Tripod Stand, Pop Filter, Shock Mount, Gain Control for Streaming Discord Twitch Podcasts Videos- AmpliGame Global Recycled Standard
Best Seller

FIFINE Gaming USB Microphone for PC PS5, Condenser Mic with Quick Mute, RGB Indicator, Tripod Stand, Pop Filter, Shock Mount, Gain Control for Streaming Discord Twitch Podcasts Videos- AmpliGame Global Recycled Standard

(12,876)
$27.90$26.48
FREE delivery Thu, Sep 4 on $35 of items shipped by Amazon
4K+ bought in past month
Loading...
Funny Cute Mouse Pad with Wrist Rest, Dumpster on Fire Ergonomic Mouse Pads Wrist Support for Desk, Mousepad for Wireless Mouse Gaming Laptop Work Home Desk Accessories Office Supplies Decor

Funny Cute Mouse Pad with Wrist Rest, Dumpster on Fire Ergonomic Mouse Pads Wrist Support for Desk, Mousepad for Wireless Mouse Gaming Laptop Work Home Desk Accessories Office Supplies Decor

(1,045)
7.99
PrimeFREE delivery Saturday, June 14 on orders shipped by Amazon over $35
500+ bought in past month
Loading...
Ozeino Gaming Headset for PC, Ps4, Ps5, Xbox Headset with 7.1 Surround Sound Gaming Headphones with Noise Canceling Mic, LED Light Over Ear Headphones for Switch, Xbox Series X/S, Laptop, Mobile White

Ozeino Gaming Headset for PC, Ps4, Ps5, Xbox Headset with 7.1 Surround Sound Gaming Headphones with Noise Canceling Mic, LED Light Over Ear Headphones for Switch, Xbox Series X/S, Laptop, Mobile White

(26,227)
$16.14
FREE delivery Sat, Nov 29 on $35 of items shipped by Amazon
7K+ bought in past month
Loading...
OneOdio Wired Over Ear Headphones Hi-Res Studio Monitor & Mixing DJ Stereo Headsets with 50mm Drivers and 1/4 to 3.5mm Jack for AMP Computer Recording Podcast Keyboard Guitar Laptop - Black
Best Seller

OneOdio Wired Over Ear Headphones Hi-Res Studio Monitor & Mixing DJ Stereo Headsets with 50mm Drivers and 1/4 to 3.5mm Jack for AMP Computer Recording Podcast Keyboard Guitar Laptop - Black

(70,956)
$31.99$19.99
FREE delivery Thu, Sep 4 on $35 of items shipped by Amazon
10K+ bought in past month
Loading...
Lenovo ThinkPad E14 Gen 5 Business Laptop (14" FHD+ Anti-glare, Intel 10-Core i7-1355U, 40GB RAM, 1TB SSD) Backlit, Fingerprint, Fast Charge, 1080p RGB Webcam, Wi-Fi 6, Win 11 Pro w/ Copilot

Lenovo ThinkPad E14 Gen 5 Business Laptop (14" FHD+ Anti-glare, Intel 10-Core i7-1355U, 40GB RAM, 1TB SSD) Backlit, Fingerprint, Fast Charge, 1080p RGB Webcam, Wi-Fi 6, Win 11 Pro w/ Copilot

(12)
$899.99
FREE delivery Wed, Jun 18
Loading...
PYS 4-Way Privacy Screen for MacBook Pro 13 Inch (2016-2022, M1, M2) & MacBook Air 13 Inch (2018-2021, M1) - 360° Anti-Spy Filter, Matte Anti-Glare Protector, Scratch-Resistant Film, Laptop Privacy Filter Shield

PYS 4-Way Privacy Screen for MacBook Pro 13 Inch (2016-2022, M1, M2) & MacBook Air 13 Inch (2018-2021, M1) - 360° Anti-Spy Filter, Matte Anti-Glare Protector, Scratch-Resistant Film, Laptop Privacy Filter Shield

(373)
15.99
PrimeFREE delivery Saturday, June 14 on orders shipped by Amazon over $35
300+ bought in past month
Loading...
UGREEN USB C to USB Hub with 4 USB 3.0, Powered USB C Splitter for Laptop, MacBook Pro, Mac mini M4, iMac, iPad Pro, Chromebook, Dell XPS, Galaxy S23, and More, 0.5FT

UGREEN USB C to USB Hub with 4 USB 3.0, Powered USB C Splitter for Laptop, MacBook Pro, Mac mini M4, iMac, iPad Pro, Chromebook, Dell XPS, Galaxy S23, and More, 0.5FT

(12,070)
9.99
PrimeFREE delivery Saturday, June 14 on orders shipped by Amazon over $35
400+ bought in past month
Loading...
UGREEN USB C Hub 10Gbps, 4 Ports USB 3.2 HUB with 2 USB-C 3.2 and 2 USB-A 3.2, USB Port Extender for MacBook Pro, MacBook Air, Acer Aspire, HP Laptops, iPad Pro, iPhone 15/15 Pro Max and More

UGREEN USB C Hub 10Gbps, 4 Ports USB 3.2 HUB with 2 USB-C 3.2 and 2 USB-A 3.2, USB Port Extender for MacBook Pro, MacBook Air, Acer Aspire, HP Laptops, iPad Pro, iPhone 15/15 Pro Max and More

(1,021)
19.99
PrimeFREE delivery Saturday, June 14 on orders shipped by Amazon over $35
50+ bought in past month
Loading...
ANKER 737 Power Bank, 24,000mAh 3-Port Laptop Portable Charger with 140W Fast Charging, Smart Display, for Outdoor Work, Compatible with iPhone 16/15/14 Series, Vision Pro, Samsung, MacBook, and More

ANKER 737 Power Bank, 24,000mAh 3-Port Laptop Portable Charger with 140W Fast Charging, Smart Display, for Outdoor Work, Compatible with iPhone 16/15/14 Series, Vision Pro, Samsung, MacBook, and More

(13,939)
109.99
FREE delivery Saturday, June 14
9K+ bought in past month