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.

@LearnitTraining

7 ай бұрын

Happy to help!

Can I upload /add images into the spread sheet like photos of contacts

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.

@LearnitTraining

3 ай бұрын

Excellent advice!

thank you for these videos I am glad I have found this channel

@LearnitTraining

6 ай бұрын

You are very welcome!

Can you add page break in number like excel so you can see where your printable space ends thanks so much - great class

@LearnitTraining

7 ай бұрын

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

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,

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

@LearnitTraining

4 ай бұрын

Thanks for the tip

Thank you so much!!!!

@LearnitTraining

10 ай бұрын

You're welcome!

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 see your excel course. that's awesome.

@LearnitTraining

Жыл бұрын

Glad you like it!

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

@LearnitTraining

8 ай бұрын

We are working on videos that will focus on finance and spreadsheets this coming year.

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.

@LearnitTraining

9 ай бұрын

This article may help: support.apple.com/guide/numbers/find-and-replace-text-tan71c6a7a38/mac

Hello, how can we change the size of a checkbox? Thanks

@LearnitTraining

Ай бұрын

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!

@samsan5445

Ай бұрын

@@LearnitTraining i try but it doesn’t work..

And the office supply table the same I can’t see it please

Interested in having an electronic spreadsheet to keep a balance, making credits, deductions…..totals

@LearnitTraining

6 ай бұрын

It really helps tracking financial data!

I understand Google Sheets is not secure. How secure is Numbers?

@LearnitTraining

2 ай бұрын

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!

Excellent video. Thanks a lot.

@LearnitTraining

11 ай бұрын

You are welcome!

can i relational table integrate two other tables. Necessary it works when filtered

@LearnitTraining

8 ай бұрын

This article may help: apple.stackexchange.com/questions/170053/linking-between-tables-in-numbers

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?

@LearnitTraining

7 ай бұрын

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.

thanks adam hill i from indonesian and i can learn with your explan

@LearnitTraining

Жыл бұрын

My pleasure!

We’re is the casting calls template? 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.

@LearnitTraining

10 ай бұрын

Hello Run ForrestRun! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com/

sir your exercise table is corrupted i guess, blanks are showing...

@LearnitTraining

10 ай бұрын

Hello Tanya! We just tested the files and they seem to be working right now.

@tanyapunyo2074

10 ай бұрын

@@LearnitTraining when i used 2-3 blanks where showing in pivot table...

how are you able to get this on computer man?

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!

@LearnitTraining

Жыл бұрын

Hello Murat! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com/

I signed up but still gettings ads

@LearnitTraining

10 ай бұрын

Hello Mary! You can find all the ad-free videos here: www.youtube.com/@LearnitTraining/membership

How to fix running log

I can't use filter for merged cells?

@LearnitTraining

11 ай бұрын

This article may help: support.apple.com/guide/numbers/filter-data-tan28bd63a8a/mac

how can I add progress bar?

@LearnitTraining

Жыл бұрын

Hello AboValdez! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com

The big problem with numbers is printing , you can not select like in excel the print area .😅

@LearnitTraining

Жыл бұрын

Excel is still the superior program but Numbers does most of the heavy lifting you need on a Mac

Can I actually do return inside cell to wrap text as I want to?

@LearnitTraining

Жыл бұрын

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

@LearnitTraining

11 ай бұрын

Hello Ranjeetsingh! You can get help from our instructors at Offsite, our online community - www.offsitebylearnit.com

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.

@LearnitTraining

22 күн бұрын

Noted!

@margaretq1089

22 күн бұрын

@@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

@LearnitTraining

7 ай бұрын

👍

I have a Mac ,

James or Adam?

@LearnitTraining

Жыл бұрын

Both!

@heyt54

Жыл бұрын

@@LearnitTraining interesting.

0.25 = 1/2 ? wtf

@LearnitTraining

3 ай бұрын

👍

just use excel lol

@LearnitTraining

Ай бұрын

We think Excel is the superior program too! Numbers however is free for Apple users.