Numbers is fine as long as you don’t plan to share the files with others, especially when there are formulas. Opening Numbers files in other spreadsheet programs like Excel and Google Sheets will eventually cause problems. The danger is the problem may not be apparent until later. When you share spreadsheets with important data like financial information, stick with one program and make it consistent.
Fyi...break this down into specific tutorials. Easier for searching an issue....this video is pretty much overload. Nice voice and easy to listen to but IN THE WEEDS
To insert a page break in Apple Numbers, you can either: Choose a row or column to insert a page break, and use the formatting tool to insert the page break. Place vertical and horizontal 'guide lines' in the document showing where the break will happen. In the View menu, choose Show Rulers. 0 on the rulers is the top left corner of the printed area of Page
Totally enjoyed your presentation! My need is I'm leaving Filemaker behind, too costly. I need to make a spread sheet from an imported CSV file from my Bank and one for my Credit Card co to keep track of my finances. I've managed to do this but wonder if there's a more efficient way of doing it. A future tutorial would be great. Don't know why but having trouble coloring every other row. My transactions are so many it's difficult to follow all the categories across in the header column Thanks
Hi Adam, I created a calendar using the calendar template from Numbers. The format looked like it was horizontal but it seems you can change it to any dimensions. So I made a horizontal dimension with a lot of space in the cells so I created a more horizontal format but when I tried to export to a PDF it broke the calendar into 3 parts so that each page of the PDF only had 1/3 of the calendar. Is there anyway to fix this calendar so it will print all in one page?
I just lost 5 days work in Excel. I am here to learn Numbers --it seems safer. One question. Can I save a Numbers file so my accountant can open it in Excel?
To save a Numbers file as an Excel file, you need to: Open the Numbers document you want to export. Click on the "More" button or the "Numbers" heading in the top-left corner of the Mac menu bar. Select "Export To". Click "Excel". Enter a name for your file.
To adjust the size of a checkbox in Apple Numbers, follow these steps: Cell Formatted Checkbox: If you’re using a cell formatted as a checkbox, the size is fixed. You can’t directly change it. However, you can resize the checkbox by adjusting the font size of the cell. To do this: Select the cell with the checkbox. Go to Format > Font > Bigger (or use the shortcut ⌘+). Note that this will also affect the font size of other content in the cell. Character Viewer Checkbox: If you inserted a checkbox character from the Character Viewer (display-only), you can resize it: Insert the checkbox character into a cell. Open the Text Inspector (⌘+T). Change the point size to resize the checkbox. Remember, if you want the checkboxes to be active (i.e., toggleable), use the checkbox data format. The ballot box characters are for display purposes only1. Hope this helps!
Apple Numbers provides some security features to protect your spreadsheets and data. Here are some aspects of its security: Password Protection: You can assign a password to a Numbers spreadsheet on your Mac. This ensures that only those who know the password can open the spreadsheet. Passwords can consist of almost any combination of numbers, uppercase or lowercase letters, and special keyboard characters. If you forget your password, there’s no way to recover it, so be sure to choose a password you won’t forget or write it down in a safe place. Touch ID Integration: If your Mac has Touch ID (fingerprint detection), you can use it to open your password-protected spreadsheets with your fingerprint alone. Version-Specific Passwords: If you add a password to a spreadsheet or change an existing password, it applies only to that version of the spreadsheet and subsequent versions. To prevent others from restoring an unprotected version of the spreadsheet or an older password version, stop sharing the spreadsheet, add a unique password, and then share it again. Integration with Apple Devices: One of the biggest advantages of using Apple Numbers as an Apple-exclusive user is its integration with other Apple devices. Whether you’re moving between iPad, Mac, iPhone, or the web, your documents are accessible and secure as long as you save them to iCloud. Additionally, it’s worth noting that Apple takes security seriously across its ecosystem. For example, when it comes to Apple Pay, the Device Account Number (used for transactions) is never stored on Apple’s servers, isn’t backed up to iCloud, and is isolated from the actual operating system of your device. Apple also doesn’t store or have access to the original card numbers when they’re added to Apple Pay. Remember to keep your passwords secure and choose strong ones to protect your data!
Why do some functions work on desktop Mac version but not loading numbers from iCloud? I notice things I can’t do on the iCloud version. In fact I hate working through iCloud version of numbers. Can’t save actual numbers file to where I want, so best to load and run from inbuilt app on the mac.
Hi. How can I some online information such as sport results to Numbers? Let's say soccer results. And I want to Numbers update the results every weekend. Excel does that but don't have it, don't want to use it.TIA!
Am finding this very confusing, as he jumps all over instead of focusing an in-depth tutorial of each template, but one at a time. And he goes fast, so I have to pause multiple times to take notes and study what he did. He keeps mentioning topics I want to learn, but then says that he'll 'go over it later.' I do NOT like it when instructors do that, b/c they almost never actually return to the topic!!! Anyway, I am slogging through it but it's confusing and frustrating, imho.
Thank you so much brother, I'm a Google Sheet user, but Apple Numbers is so easy and minimalist. Again, thanks for the helpful tutorial.
Happy to help!
Numbers is fine as long as you don’t plan to share the files with others, especially when there are formulas. Opening Numbers files in other spreadsheet programs like Excel and Google Sheets will eventually cause problems. The danger is the problem may not be apparent until later. When you share spreadsheets with important data like financial information, stick with one program and make it consistent.
Excellent advice!
Fyi...break this down into specific tutorials. Easier for searching an issue....this video is pretty much overload. Nice voice and easy to listen to but IN THE WEEDS
Thanks for the tip
thank you for these videos
I am glad I have found this channel
You are very welcome!
I see your excel course. that's awesome.
Glad you like it!
Can you add page break in number like excel so you can see where your printable space ends
thanks so much - great class
To insert a page break in Apple Numbers, you can either:
Choose a row or column to insert a page break, and use the formatting tool to insert the page break.
Place vertical and horizontal 'guide lines' in the document showing where the break will happen. In the View menu, choose Show Rulers. 0 on the rulers is the top left corner of the printed area of Page
Totally enjoyed your presentation! My need is I'm leaving Filemaker behind, too costly. I need to make a spread sheet from an imported CSV file from my Bank and one for my Credit Card co to keep track of my finances. I've managed to do this but wonder if there's a more efficient way of doing it. A future tutorial would be great. Don't know why but having trouble coloring every other row. My transactions are so many it's difficult to follow all the categories across in the header column Thanks
We are working on videos that will focus on finance and spreadsheets this coming year.
Can I upload /add images into the spread sheet like photos of contacts
Thank you so much!!!!
You're welcome!
thanks adam hill i from indonesian and i can learn with your explan
My pleasure!
Hi Adam, is there a Solver function in Numbers? Set one cell to a target value and change another related cell value to get the target value. Thanks,
Interested in having an electronic spreadsheet to keep a balance, making credits, deductions…..totals
It really helps tracking financial data!
Hi Adam,
I created a calendar using the calendar template from Numbers.
The format looked like it was horizontal but it seems you can change it to any dimensions. So I made a horizontal dimension with a lot of space in the cells so I created a more horizontal format but when I tried to export to a PDF it broke the calendar into 3 parts so that each page of the PDF only had 1/3 of the calendar.
Is there anyway to fix this calendar so it will print all in one page?
Excellent video. Thanks a lot.
You are welcome!
I just lost 5 days work in Excel. I am here to learn Numbers --it seems safer. One question. Can I save a Numbers file so my accountant can open it in Excel?
To save a Numbers file as an Excel file, you need to:
Open the Numbers document you want to export.
Click on the "More" button or the "Numbers" heading in the top-left corner of the Mac menu bar.
Select "Export To".
Click "Excel".
Enter a name for your file.
Hello, how can we change the size of a checkbox?
Thanks
To adjust the size of a checkbox in Apple Numbers, follow these steps:
Cell Formatted Checkbox:
If you’re using a cell formatted as a checkbox, the size is fixed. You can’t directly change it. However, you can resize the checkbox by adjusting the font size of the cell. To do this:
Select the cell with the checkbox.
Go to Format > Font > Bigger (or use the shortcut ⌘+).
Note that this will also affect the font size of other content in the cell.
Character Viewer Checkbox:
If you inserted a checkbox character from the Character Viewer (display-only), you can resize it:
Insert the checkbox character into a cell.
Open the Text Inspector (⌘+T).
Change the point size to resize the checkbox.
Remember, if you want the checkboxes to be active (i.e., toggleable), use the checkbox data format. The ballot box characters are for display purposes only1. Hope this helps!
@@LearnitTraining i try but it doesn’t work..
The big problem with numbers is printing , you can not select like in excel the print area .😅
Excel is still the superior program but Numbers does most of the heavy lifting you need on a Mac
I understand Google Sheets is not secure. How secure is Numbers?
Apple Numbers provides some security features to protect your spreadsheets and data. Here are some aspects of its security:
Password Protection:
You can assign a password to a Numbers spreadsheet on your Mac. This ensures that only those who know the password can open the spreadsheet.
Passwords can consist of almost any combination of numbers, uppercase or lowercase letters, and special keyboard characters.
If you forget your password, there’s no way to recover it, so be sure to choose a password you won’t forget or write it down in a safe place.
Touch ID Integration:
If your Mac has Touch ID (fingerprint detection), you can use it to open your password-protected spreadsheets with your fingerprint alone.
Version-Specific Passwords:
If you add a password to a spreadsheet or change an existing password, it applies only to that version of the spreadsheet and subsequent versions.
To prevent others from restoring an unprotected version of the spreadsheet or an older password version, stop sharing the spreadsheet, add a unique password, and then share it again.
Integration with Apple Devices:
One of the biggest advantages of using Apple Numbers as an Apple-exclusive user is its integration with other Apple devices.
Whether you’re moving between iPad, Mac, iPhone, or the web, your documents are accessible and secure as long as you save them to iCloud.
Additionally, it’s worth noting that Apple takes security seriously across its ecosystem. For example, when it comes to Apple Pay, the Device Account Number (used for transactions) is never stored on Apple’s servers, isn’t backed up to iCloud, and is isolated from the actual operating system of your device. Apple also doesn’t store or have access to the original card numbers when they’re added to Apple Pay.
Remember to keep your passwords secure and choose strong ones to protect your data!
can i relational table integrate two other tables. Necessary it works when filtered
This article may help: apple.stackexchange.com/questions/170053/linking-between-tables-in-numbers
Hello Adam. I am on a Mac using Numbers. Just need to find out why the "Find and Replace" search does not work. Could you please help? Thank you.
This article may help: support.apple.com/guide/numbers/find-and-replace-text-tan71c6a7a38/mac
And the office supply table the same I can’t see it please
Why do some functions work on desktop Mac version but not loading numbers from iCloud? I notice things I can’t do on the iCloud version. In fact I hate working through iCloud version of numbers. Can’t save actual numbers file to where I want, so best to load and run from inbuilt app on the mac.
Hello Run ForrestRun! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com/
I signed up but still gettings ads
Hello Mary! You can find all the ad-free videos here: www.youtube.com/@LearnitTraining/membership
how are you able to get this on computer man?
Can I actually do return inside cell to wrap text as I want to?
Hello Андріана Чижик! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com/
how to change numbers to words eg: 100 to hundred
Hello Ranjeetsingh! You can get help from our instructors at Offsite, our online community - www.offsitebylearnit.com
We’re is the casting calls template? Please
I can't use filter for merged cells?
This article may help: support.apple.com/guide/numbers/filter-data-tan28bd63a8a/mac
sir your exercise table is corrupted i guess, blanks are showing...
Hello Tanya! We just tested the files and they seem to be working right now.
@@LearnitTraining when i used 2-3 blanks where showing in pivot table...
how can I add progress bar?
Hello AboValdez! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com
Hi. How can I some online information such as sport results to Numbers? Let's say soccer results. And I want to Numbers update the results every weekend. Excel does that but don't have it, don't want to use it.TIA!
Hello Murat! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com/
How to fix running log
Am finding this very confusing, as he jumps all over instead of focusing an in-depth tutorial of each template, but one at a time. And he goes fast, so I have to pause multiple times to take notes and study what he did. He keeps mentioning topics I want to learn, but then says that he'll 'go over it later.' I do NOT like it when instructors do that, b/c they almost never actually return to the topic!!! Anyway, I am slogging through it but it's confusing and frustrating, imho.
Noted!
@@LearnitTraining My motto is: You cannot dumb it down enough for me. I need things dumbed waaaay down. Thank you for your understanding.
iphone numbers recents how to use serial number new Indian
👍
0.25 = 1/2 ? wtf
👍
I have a Mac ,
James or Adam?
Both!
@@LearnitTraining interesting.
just use excel lol
We think Excel is the superior program too! Numbers however is free for Apple users.