Learn How To Use Numbers In 5 Minutes
Video Overview & Insights
https://macmost.com/e-3475 If you are looking for a quick way to get up to speed with Mac Numbers, this tutorial takes you through the basics in just 5 minutes. Learn how to use sheets and tables to store data, sort and filter. Learn how to use formulas for calculations.
Hi, is there any tutorial and example on use "OFFSET" function? Thanks.
FOLLOW MACMOST FOR NEW TUTORIALS
▶️ Subscribe — https://macmost.com/j-youtube (And hit the 🔔)
Thank you.
🦋 Follow on Bluesky, Mastodon and more: https://macmost.com/social
FREE EMAIL NEWSLETTER
explained too fast
📬 See what's new each week and more — https://macmost.com/newsletter
📆 Per-Video Email Notifications — https://macmost.com/ytn
A very well paced and concise instruction on Apple Sheets.
SUPPORT MACMOST AT PATREON
❤️ https://macmost.com/patreon
For years I was frustrated by Numbers database functions. I manage an organisation that records expenses data monthly in a single table but I need to regularly produce different reports in various formats at different times of the year using sub sets of the data. Until recently I wasted hours, copying, pasting and re-typing formulas until I discovered snapshots - a built in capability that is poorly documented. Now I just filter the main table to get the data I want, then create a snapshot and paste the snapshot into a new table where it can be saved, formatted, reported on to my hearts content. I'm sure Gary will say there are better ways but if you need various 'views' of you data, give snapshots a try. Maybe Gary will do a video about them (if he hasn't already).
00:00 Intro
00:22 Sheets, Tables, Cells, Rows and Columns
I used to be able to drag a corner of the cell. to sum, but now I have to enter a formula =summ(@k2:k12) to get the totals, I checked apple site and perhaps they are changing something? do you know if that's the case or am I doing something wrong, thanks
01:10 Entering Data Into Cells
01:36 Tables Are Small Databases
Thanks for the tips. Usually I need to watch them a few times before I get it...
02:03 Style and Formatting Tools
02:58 Sorting and Filtering Data
Anything that helps me get away from Microslop is a Godsend to me.
03:23 Using Formulas To Perform Calculations
04:34 Using Multiple Tables For Calculations
I got into computers specifically macs, back in 1991 when I discovered excel spreadsheets! I consider myself pretty good at spreadsheets. Eventually I moved on to Libre Office, as Excel would do things I did not like. Now, in the last 2 or 3 years, I use Google Sheets and find them great. I also really like all things Apple, but one product that drives me absolutely crazy, which I just really despise is Numbers!! Yet, I have a friend who is a luddite when it comes to computers, and he uses Numbers in ways that blow my mind! I guess it appeals to some and not others.
05:07 Graphs and Charts
#macmost #mactutorial
As always blazingly fast crystal clear. Never knew return gave me a new row, always used ALT, but that is omitted in totals. Huh?
More User Perspectives
Great tune up video Thanks
@robertrobinson9904👍👍👍
@bsschrenkThanks, Gary.
As you referred to Numbers as a mini-database:
My favorite aspect of a database is that I can have one view with all my records, and all the fields for each of those records. When I look at it as a table, each row is a record, and each field is a column.
...But if I have a different view, I can have only a select handful of those fields displayed, fewer columns, but the View references the same data.
Can Numbers work this way? Can I have a "master table" with all the data and a clone of that table with fewer columns displayed?
Really, the only reason to download Office 365 is for Excel. Numbers is not in the same league. But Word, Outlook, PowerPoint are all certainly replaceable
@DavidJCarrellGood video, Garr!
@YogiUndeAfter dragging the Downloads folder from Finder to the Dock, it doesn’t open with a single or double click. Instead, I have to right-click and select “Open” every time. Is there a way to make it open with a double click like normal folders or like it works in Windows? It’s quite annoying.
@stargalaxy7Good info, thanks Gary. For excel users, tabs = tables. Just think of it like multiple tabs on the same page or tab. Gary, I keep using excel for its “watch me” macro creation abilities. I work with a lot of Report data files, LONG and in plain text format, as we get software updates or new equipment the formats change meaning the macros either need to be regenerated or modified. I’m at a loss how to do the macros in numbers to accomplish the same thing, have you ever covered the subject of macros in Numbers?
@Erin-ThorA very through starters guide in a short amount of time! Well done!
@lesbartThank you! Very concise and helpful information.
@ChrisSoCalRN1Excellent video. As always. One MINOR nit.
You can have 0, 1, or more tables. This is important for some odd use cases like sharing a Numbers file and using it as a shared white board. In some ways better than the other tools designed for that!
But as I said, pretty minor nit... for MOST people you are not going to have zero tables!
This is sooo useful, thank you! ❤
@KikiContrerasNyuFirst comment
@WorldAffairsExpert