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.
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.
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.
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.
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?
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?
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
Is that mean that I can’t use excel in iPad as old version & do more analysis on it?? I need to work on queries, connection and dashboard parts is that possible on the iPad???
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
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!
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.
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.
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..
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
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).
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.
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?
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'.
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.
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?
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?
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!
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.
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
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?
One of the best app you can find on a mobile device! Thanks for this video!
I 100% agree! of course!
Thanks just woke up for my homework😊
I can’t seem to find the ‘ Merge & Center ‘ button.
Hi. How do I edit a graph in Excel on my iPad? It’s driving me mad
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?
Thanks for the great video
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
Your Excel UI looks different. What size of your iPad?
Is that mean that I can’t use excel in iPad as old version & do more analysis on it??
I need to work on queries, connection and dashboard parts is that possible on the iPad???
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
What I would like to do is create Excel spreadsheets on my MacBook Air and then move or copy it on my Gen10 iPad.
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!
Does anyone know if 16g ram or 8g ram on iPad Pro makes a lot difference?❓❓⁉️⁉️
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.
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.
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
How do you extend data down a column? The directions I found online doesn’t actually give you the little arrows that should appear. 😔
Nice video, is there a way to select all sheets on the iPad.
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.
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..
Hello, why I can’t type any word in excel on iPad ? It doesn’t load keyboard for me too .
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?
Can I get help from you about printing excel spreadsheet on ipad pro??
Can you please do a full review of Safari, try popular web apps and extensions
On it! 👍🏻
Selection of non-adjacent cells on Excel ipad PLEASE
Can I connect MS Onedrive thru the iPad? I have been a Windows user but would like to experiment on iPad OS.
How do I select different cells in the spreadsheet? in Windows we use the Ctrl key and select the desired cells.
Having a huge problem finding the header and footer editor on the app.
Any help would be great!
When I last tried it ipen data entry was pretty useless. I wonder if it has improved?
Thanks for the video! What mouse are you using to operate the Ipad in this video??
I cannot find borders on my excel app anymore. Did they move the tab?
Hey Fernando - what about the insert a link . It does not seem to work on ipad
Is there a print preview in excel on my iPad ? I need to get to page set up
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
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).
Great video, thanks. 👏
Glad you liked it! also your first name is my middle name haha
Whats “F2” equivalent?
Thank you
is tablet good for data entry job?
Does it have pivot table and remove duplicates and conditional formatting ?
good review, thanks... perhaps less coffee pre take.
For your future video… has Microsoft OneNote adopted all the keyboard/mouse/trackpad capabilities as in Word?
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.
Is there a difference between the office app and the standalone excel version in the App Store?
Is there an alt+enter equivalent on the ipad excel where you can have a new line to type on?
,
The table you showed towards the end appears to be just a table and not a pivot table.
Yeah, but the wrap text function is not there it seems
Is the user experience the same as window os?
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?
Can I use descriptive statistics on the ipad version of excel?
love your vids mate, I just wondering can metamask be used on safari extension or chrome on ipad?
my excel file for ipados keeps telling me I have circular cell references but doesn’t tell me how to find them…how dumb!!
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
what about vba Macros?
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
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
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
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!
7:28 this starts in the middle of the video. Not helpful!
😢
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 anyone tell me how to make part of the text in Excel bold ?
may i ask if I need to pay for ms office apps ?
yes you do, theres a monthly subscription
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?
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'.
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.
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
Hi, love your video. Do you know how to insert a table from the web to the excel on iPadOS15?
Forget pivot tables and macros, I can’t even edit a header…
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
That's enough for the light user like me. I am not professional yes
Is it free ?
there's a one month free trial
Fernando silva can u give ipad
maybe for Xmas
I get that you re a pro, but we re clearly not!!! Can you Sloooooow down!!! 😱
This is stupid it doesn’t have half the options a computer has. WASTE OF MY MONEY!!!!!
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 👎🏻👎🏻👎🏻👎🏻👎🏻👎🏻👎🏻👎🏻👎🏻👎🏻👎🏻👎🏻👎🏻👎🏻👎🏻👎🏻
Is there "move or copy sheet" excel function in IPad?