Without macros it’s still limited dramatically in what it can do, and how it can work with major corporate users. Like it or not, macros are an absolute must for all but “mom and pop” companies / users. Excellent review btw…
I use excel very often for work and university. My big question was to see if it could function the way I needed to for my accounting classes and other classes and I am happy to see that it has every feature that I do need. Great video! Thank you!
@@chamberofrelics I brought the M2 MacBook air 13.6’. The battery is amazing. But since it’s my first MacBook it’s really uncomfortable for me. The LT itself is great but I think it’s the system that I don’t like that much. For example with windows is more intuitive opening and closing tabs. Microsoft office is way better as well. Even to split windows in 2 it was a nightmare to learn. Learning apple shortcuts is sooo annoying. Even copy and paste feels so uncomfortable. I’ve chosen the laptop because it’s way cheaper then the tablet + accessories. The tablet base model has only 64GB 🙁. If I had to choose now, I would buy the tablet + pencil for school and I could use my windows laptop at home. My windows i7 laptop is great the only issue is with the battery and the weight. I’m thinking about buying the tablet just because I love devices with pen for school. I used to have galaxy note for school and loved it so much. But I really don’t wanna be consumiste. 1 phone, 3 LT (1 personal windows, 1 MacBook, 1work) and 1 tablet?? Too much.
Hi Fernando, as what Mr. Barnes said, we don't mind seeing your face, but we'd love it if you could just make the iPad screen recording fullscreen and you can just put an overlay shape (maybe a circle) of the video of you talking in the topmost or bottom most right corner, wherever it is lesser intrusive and will not block any app features. Thank you for what you do, I hope MS keeps improving their iPadOS version of apps and hopefully GSuite follows.
iPad OS Excel is one of my favourite apps that I use on my M1 iPad Pro. A few days ago, my brother sent me two photos each with a table of financial data. Using the new iPad OS 15 "live text" feature, I was able to copy all numbers in each table in a single step and then paste them into Excel as a table data I could perform further analysis on. OK, I needed to perform a little bit of clean-up to ensure all numbers pasted were treated as numbers and not text, but for me this further illustrates how powerful the iPad Pro has become, and why I now rarely use my MacBook Pro.
Thank you for this 🙏🏻 I appreciate you even looking at my comments, never mind acting upon something I ask in them 🙂 I just want to be clear though for you, I didn’t mind seeing your face at all, so don’t think it was about that. I just wanted a larger iPad view that fills the screen more so I could see stuff easier! Thx 😃 Excel - it really isn’t ‘Pro’ at all on the iPad is it? I mean, can’t create pivot table, can’t change tab colours, can’t set up conditional formatting. That’s not good. I still have to use my 2013 MacBook Air just to do basic things. Anyway, great video Fernando 👊🏻 Yep I’m still watching so no need to hide away though brother! I have no issues seeing your face, I just want to see more of the iPad on these type videos 😉 Thanks 👍🏻
haha I know I was sort of playing around with you! I noticed you commented something similar in a few videos so wanted to poke fun. I always appreciate the positive critique and I appreciate you watching the channel! I will work on making the presentation better. Its just tough to go all out full screen because the aspect ration of iPad is 4:3 and I record in 16:9, so there will always be some unused space. But I will keep getting better
For the life of me I can’t select individual cells that aren’t adjacent. On a Mac I press control and click on any cells on the sheet. But with the iPad Pro and Magic kb neither command or control works.
Theres a specific feature on excel where you can lock in a specific cell in a formula by using F4 button on a regular laptop.. does that work on ipad too?
Great video, thx. Sadly you skipped the link function, could you do a video on that? My iPad Pro has the link button greyed out, so it’s there but I can’t find a video that shows how to enable them. All videos are how to activate options in the regular excel, not the iPad app version. If you could answer that question, that would be absolutely awesome! Tia
Hi Fernando, is there anyway to select multiple non adjacent cells on the excel for iPad app? Usually with Mac you select command and click on the cells needed but doesn't seem to work with iPad. I have the new iPad Pro with magic keyboard. Is this a feature that is not available?
Hi Fernando, how do I paste especial on Excel for iPad? I mean, if I copy a series of values that are produced by using a formula, I want to copy the values and not the formula in another cell. Thanks
thanks for the video! Not sure if I am doing something wrong, but in IPadOS I couldn't find how to "refresh data" on a file created on a desktop. That for me is a big issue.
The biggest problem is creating graph. I cannot select dat, or add in a new set of data to the graph, as there is not select data function in ipad. Also, I often need to use linear regression for data analysis, and there is no add in for that. It would be necessary for Microsoft to add these stuff to excel.
what about exporting some specific part of my sheet to pdf? on my laptop, all i have to do is select the part i want to export and hit “select print area” and just save as pdf..
Being restricted on iPad is a bummer. Everything should be the same. I pay for excel and still don’t get full editing with pivots and other things. It’s putting me off apple products massively, and I’ve everything Apple.
Hi at 2:10 for the multitasking feature, when you say you can open 2 different Excel sheets, do you mean you can open 2 different workbooks/Excel files at the same time? You didn’t actually demo that example, so would like to know. Thanks!
Have you Excel pro users attempted to open old live sharepoint files? I cant seem to connect and live edit from the Excel app. I can either work on the Safari web-browser (glitchy), or download a copy (that needs to be uploaded...if you have witting permissions on the sharepoint site).
Wanna know whether it is possible to save excel file as pdf in Ipad. Also with regard to macros I use attest one macro in my excel file..for instance to save a sheer as pdf I use macros. So is that possible?
Having issues filtering data on iPad Pro when I do A to Z for a city, the cities are alphabetically ordered but addresses don’t adjust accordingly to city like on my MacBook Pro. I have to manually filter each address to match city.
great video very interesting, help. how do i select different non-adjacent cells? on the mac I use cmd and ctrl on windows but here on ipad with magic keyboard the cmd key does not work. thanks if you can help me
I 'create' Excel 'apps' on my Win10 desktop -- BUT ALL during the development phase, I have to remind myself of the limitations of the application-in-use on my iPad Pro. Senseless waste of time...and money -- since I purchased the iPad Pro so that I could use MS Access and MS Excel in the field. I attempted to use a 2-in-1 Windows laptop early on after 2-in-1 models were released. The Dell machine was full of problems....some related to touch-screen; others, to the shoddy design and engineering of Dell.....the 'machine' was returned to Dell twice for repair....each time, for sereral weeks. Apple, Microsoft, Dell -- and sometimes HP -- all very successfully ignore the needs of the users. "We will build it; they will come!" so say the 'majors'.
Hola, Fernando. Podrías hacer vídeos con subtítulos en español o en español? Seguro que hay un gran colectivo hispano interesado como yo en tus vídeos de iPadOS Microsoft. Mil graciasssss
Dear Apple team pretty much dissapointed , in excel there are a lot problem ipad excel dosn't have Dropdown list ,Macro recording, and Link to other sheet not working ..what is the advantage to buy investing more then 1 lakh and rs 489 for excel ...very very dissapointed 👎🏻👎🏻👎🏻👎🏻👎🏻👎🏻👎🏻👎🏻👎🏻👎🏻👎🏻👎🏻👎🏻👎🏻👎🏻👎🏻
Get PaperLike: paperlike.com/nandoprince93
Icon Pack: nandoprince93.gumroad.com/l/uhUDr
Wallpaper link: gum.co/boVvia
Try Public Investing: public.qwjcdi.net/c/2687105/698556/10608
Wallpaper link brings up "page not found" 🥺
How about iPad Air 2022 ? The excel still compatible for iPad Air too ? What say you ?
Without macros it’s still limited dramatically in what it can do, and how it can work with major corporate users. Like it or not, macros are an absolute must for all but “mom and pop” companies / users.
Excellent review btw…
I use excel very often for work and university. My big question was to see if it could function the way I needed to for my accounting classes and other classes and I am happy to see that it has every feature that I do need. Great video! Thank you!
Same as me. I just enrolled my master’s im Accounting and Audit and I need to decide if either I buy an Ipad or MacBook air.
@@Ayshasilwhat didja buy
@@chamberofrelics I brought the M2 MacBook air 13.6’. The battery is amazing. But since it’s my first MacBook it’s really uncomfortable for me. The LT itself is great but I think it’s the system that I don’t like that much. For example with windows is more intuitive opening and closing tabs. Microsoft office is way better as well. Even to split windows in 2 it was a nightmare to learn. Learning apple shortcuts is sooo annoying. Even copy and paste feels so uncomfortable.
I’ve chosen the laptop because it’s way cheaper then the tablet + accessories. The tablet base model has only 64GB 🙁.
If I had to choose now, I would buy the tablet + pencil for school and I could use my windows laptop at home. My windows i7 laptop is great the only issue is with the battery and the weight.
I’m thinking about buying the tablet just because I love devices with pen for school. I used to have galaxy note for school and loved it so much. But I really don’t wanna be consumiste. 1 phone, 3 LT (1 personal windows, 1 MacBook, 1work) and 1 tablet?? Too much.
@@Ayshasilsame
Hi i am trying same but i am not able to drag formulas how you do that
Excel in iPad OS is one Pivot table from greatness.
İs it possible for excel to get updated and be able to access all these features?
Hi Fernando, as what Mr. Barnes said, we don't mind seeing your face, but we'd love it if you could just make the iPad screen recording fullscreen and you can just put an overlay shape (maybe a circle) of the video of you talking in the topmost or bottom most right corner, wherever it is lesser intrusive and will not block any app features. Thank you for what you do, I hope MS keeps improving their iPadOS version of apps and hopefully GSuite follows.
thanks for that kind words! but I agree. I will work to make sure the presentation of the app still gets better
iPad OS Excel is one of my favourite apps that I use on my M1 iPad Pro. A few days ago, my brother sent me two photos each with a table of financial data. Using the new iPad OS 15 "live text" feature, I was able to copy all numbers in each table in a single step and then paste them into Excel as a table data I could perform further analysis on. OK, I needed to perform a little bit of clean-up to ensure all numbers pasted were treated as numbers and not text, but for me this further illustrates how powerful the iPad Pro has become, and why I now rarely use my MacBook Pro.
can u make a formula source from other file?like when u open "a" file and you want to add from other file which is still open?
Thanks just woke up for my homework😊
would be REALLY useful to see a comparison in functionality and ease of use between the iPad APP VS. Web Version on Safari on iPad
Love that video idea!
One of the best app you can find on a mobile device! Thanks for this video!
I 100% agree! of course!
Thank you for this 🙏🏻 I appreciate you even looking at my comments, never mind acting upon something I ask in them 🙂
I just want to be clear though for you, I didn’t mind seeing your face at all, so don’t think it was about that. I just wanted a larger iPad view that fills the screen more so I could see stuff easier! Thx 😃
Excel - it really isn’t ‘Pro’ at all on the iPad is it? I mean, can’t create pivot table, can’t change tab colours, can’t set up conditional formatting. That’s not good. I still have to use my 2013 MacBook Air just to do basic things.
Anyway, great video Fernando 👊🏻 Yep I’m still watching so no need to hide away though brother! I have no issues seeing your face, I just want to see more of the iPad on these type videos 😉 Thanks 👍🏻
haha I know I was sort of playing around with you! I noticed you commented something similar in a few videos so wanted to poke fun. I always appreciate the positive critique and I appreciate you watching the channel! I will work on making the presentation better. Its just tough to go all out full screen because the aspect ration of iPad is 4:3 and I record in 16:9, so there will always be some unused space. But I will keep getting better
For the life of me I can’t select individual cells that aren’t adjacent. On a Mac I press control and click on any cells on the sheet. But with the iPad Pro and Magic kb neither command or control works.
Thanks for the great video
Hi. How do I edit a graph in Excel on my iPad? It’s driving me mad
Really has helped me. Great vid
Theres a specific feature on excel where you can lock in a specific cell in a formula by using F4 button on a regular laptop.. does that work on ipad too?
Thanks, Fernando! Love your videos. I always watch your videos before making any Apple purchase. Significance of the “Father” sweatshirt???
I am glad I can help! But there might be some significance haha
EXCELLENT VIDEO
What I would like to do is create Excel spreadsheets on my MacBook Air and then move or copy it on my Gen10 iPad.
Great video, thx. Sadly you skipped the link function, could you do a video on that? My iPad Pro has the link button greyed out, so it’s there but I can’t find a video that shows how to enable them. All videos are how to activate options in the regular excel, not the iPad app version. If you could answer that question, that would be absolutely awesome! Tia
Hi Fernando, is there anyway to select multiple non adjacent cells on the excel for iPad app? Usually with Mac you select command and click on the cells needed but doesn't seem to work with iPad. I have the new iPad Pro with magic keyboard. Is this a feature that is not available?
good review, thanks... perhaps less coffee pre take.
Can you please do a full review of Safari, try popular web apps and extensions
Great video, thanks. 👏
Glad you liked it! also your first name is my middle name haha
Hi Fernando, how do I paste especial on Excel for iPad? I mean, if I copy a series of values that are produced by using a formula, I want to copy the values and not the formula in another cell. Thanks
Your Excel UI looks different. What size of your iPad?
thanks for the video! Not sure if I am doing something wrong, but in IPadOS I couldn't find how to "refresh data" on a file created on a desktop. That for me is a big issue.
Selection of non-adjacent cells on Excel ipad PLEASE
On it! 👍🏻
Thanks for this it helps me a lot to choice iPad OS over anriod tablet for work. subscribe!
Glad I could help! and thanks for subbing!
The biggest problem is creating graph. I cannot select dat, or add in a new set of data to the graph, as there is not select data function in ipad.
Also, I often need to use linear regression for data analysis, and there is no add in for that.
It would be necessary for Microsoft to add these stuff to excel.
Nice video, is there a way to select all sheets on the iPad.
Thank you
Nice video, but I am using Excel v. 2.72 on iPad I do not have a cell border option in the Manu. You lost me there.
Thanks for the video! What mouse are you using to operate the Ipad in this video??
Can I get help from you about printing excel spreadsheet on ipad pro??
what about exporting some specific part of my sheet to pdf?
on my laptop, all i have to do is select the part i want to export and hit “select print area” and just save as pdf..
How do i keep the excel files open the way i can do on macbook. If i open another excel file, the first one goes off. How to fix this?
How do you extend data down a column? The directions I found online doesn’t actually give you the little arrows that should appear. 😔
Hello, why I can’t type any word in excel on iPad ? It doesn’t load keyboard for me too .
I can’t seem to find the ‘ Merge & Center ‘ button.
you need to collab with Leila Gharani!!
i had never heard of her until now! Thanks for showing me her channel! Maybe if there is enough comments it could happen
Can I connect MS Onedrive thru the iPad? I have been a Windows user but would like to experiment on iPad OS.
Being restricted on iPad is a bummer. Everything should be the same. I pay for excel and still don’t get full editing with pivots and other things. It’s putting me off apple products massively, and I’ve everything Apple.
Having a huge problem finding the header and footer editor on the app.
Any help would be great!
The table you showed towards the end appears to be just a table and not a pivot table.
Does anyone know if 16g ram or 8g ram on iPad Pro makes a lot difference?❓❓⁉️⁉️
love your vids mate, I just wondering can metamask be used on safari extension or chrome on ipad?
For your future video… has Microsoft OneNote adopted all the keyboard/mouse/trackpad capabilities as in Word?
Hi at 2:10 for the multitasking feature, when you say you can open 2 different Excel sheets, do you mean you can open 2 different workbooks/Excel files at the same time? You didn’t actually demo that example, so would like to know. Thanks!
When I last tried it ipen data entry was pretty useless. I wonder if it has improved?
my excel file for ipados keeps telling me I have circular cell references but doesn’t tell me how to find them…how dumb!!
Is there an alt+enter equivalent on the ipad excel where you can have a new line to type on?
,
Have you Excel pro users attempted to open old live sharepoint files? I cant seem to connect and live edit from the Excel app. I can either work on the Safari web-browser (glitchy), or download a copy (that needs to be uploaded...if you have witting permissions on the sharepoint site).
I cannot find borders on my excel app anymore. Did they move the tab?
is tablet good for data entry job?
Wanna know whether it is possible to save excel file as pdf in Ipad. Also with regard to macros I use attest one macro in my excel file..for instance to save a sheer as pdf I use macros. So is that possible?
How do I select different cells in the spreadsheet? in Windows we use the Ctrl key and select the desired cells.
Is there a print preview in excel on my iPad ? I need to get to page set up
Is there "move or copy sheet" excel function in IPad?
Having issues filtering data on iPad Pro when I do A to Z for a city, the cities are alphabetically ordered but addresses don’t adjust accordingly to city like on my MacBook Pro. I have to manually filter each address to match city.
Whats “F2” equivalent?
Is the user experience the same as window os?
great video very interesting, help. how do i select different non-adjacent cells? on the mac I use cmd and ctrl on windows but here on ipad with magic keyboard the cmd key does not work. thanks if you can help me
Forget pivot tables and macros, I can’t even edit a header…
Does it have pivot table and remove duplicates and conditional formatting ?
Is there a difference between the office app and the standalone excel version in the App Store?
I have a logitech keyboard and sadly I haven't found a way for the F2 key to work in Excel. That's what I use to select a cell and make it editable...
Try control+U
I 'create' Excel 'apps' on my Win10 desktop -- BUT ALL during the development phase, I have to remind myself of the limitations of the application-in-use on my iPad Pro. Senseless waste of time...and money -- since I purchased the iPad Pro so that I could use MS Access and MS Excel in the field. I attempted to use a 2-in-1 Windows laptop early on after 2-in-1 models were released. The Dell machine was full of problems....some related to touch-screen; others, to the shoddy design and engineering of Dell.....the 'machine' was returned to Dell twice for repair....each time, for sereral weeks. Apple, Microsoft, Dell -- and sometimes HP -- all very successfully ignore the needs of the users. "We will build it; they will come!" so say the 'majors'.
Is there any way to get our handwriting scribble using the Apple Pencil 2 to convert to text on the MS 365 app for iPad? Thanks
Yeah, but the wrap text function is not there it seems
I am looking to learn the formula for division. Simple. I want to divide the sum in one cell by 12. Why is it so hard to find this?
there might not be a formula for that but the "/" key is the division symbol. Try using that in a formula
may i ask if I need to pay for ms office apps ?
yes you do, theres a monthly subscription
That's enough for the light user like me. I am not professional yes
How to select more than 1 cells in ipad (magic keyboard)?
Did you ever find the answer to this?
@@connorhilley7081 unfortunately not. Do you know now?
Can I use descriptive statistics on the ipad version of excel?
what about vba Macros?
Hola, Fernando. Podrías hacer vídeos con subtítulos en español o en español? Seguro que hay un gran colectivo hispano interesado como yo en tus vídeos de iPadOS Microsoft. Mil graciasssss
Si tiene subtítulos en español, solo actívalos
Can anyone tell me how to make part of the text in Excel bold ?
Is it free ?
there's a one month free trial
Hi, love your video. Do you know how to insert a table from the web to the excel on iPadOS15?
Question, How can I change the text direction in a cell?
you have to click into a cell and change the orientation of the text to the right
@@fernandosilva and without a mouse?
@@fernandosilva Sorry, I don't understand! Where can I turn the text to the right?
Fernando silva can u give ipad
maybe for Xmas
7:28 this starts in the middle of the video. Not helpful!
😢
This is stupid it doesn’t have half the options a computer has. WASTE OF MY MONEY!!!!!
I get that you re a pro, but we re clearly not!!! Can you Sloooooow down!!! 😱
EVERYTHING WAS FINE UNTIL YOU ARRIVED TO PIVOT TABLES ALL AFTER THAT WAS GIBBERISH
Dear Apple team pretty much dissapointed , in excel there are a lot problem ipad excel dosn't have Dropdown list ,Macro recording, and Link to other sheet not working ..what is the advantage to buy investing more then 1 lakh and rs 489 for excel ...very very dissapointed 👎🏻👎🏻👎🏻👎🏻👎🏻👎🏻👎🏻👎🏻👎🏻👎🏻👎🏻👎🏻👎🏻👎🏻👎🏻👎🏻
Hey Fernando - what about the insert a link . It does not seem to work on ipad