Should You Use Microsoft Office or Apple Apps on Your Mac?
ฝัง
- เผยแพร่เมื่อ 7 ก.ค. 2024
- macmost.com/e-2867 Do you need to purchase and use Microsoft Office? Free Apple apps like Pages and Numbers are good alternatives to Word and Excel. But some people may still be better off buying Microsoft Office and having both sets of apps available.
FOLLOW MACMOST FOR NEW TUTORIALS EVERY DAY
▶︎ TH-cam - macmost.com/j-youtube (And hit the 🔔)
▶︎ TH-cam Email Notifications - macmost.com/ytn ⭐️
▶︎ MacMost Weekly Email Newsletter - macmost.com/newsletter ✉️
SUPPORT MACMOST AT PATREON
▶︎ macmost.com/patreon ❤️
00:00 Intro
00:52 Where To Get Microsoft Office
01:25 Stick With Microsoft Because You Know It Well
01:57 Use Microsoft Office Because They Are More Powerful
02:32 Use Microsoft Office For Compatibility With Others
02:57 Use Microsoft Office To Work With Existing Documents
03:25 Use Apple Apps Because They Are Free
03:52 Use Apple Apps Because They Are Easier To Learn/Use
05:06 Use Apple Apps For Mac Ecosystem Compatibility
06:05 Apple Apps Can Still Open Microsoft Documents
06:50 You Can Use Both
07:26 No Right Or Wrong Answer
#macmost #office - วิทยาศาสตร์และเทคโนโลยี
I am retired and don’t need the complexity of the Microsoft products any more. I am planning to use the Apple apps completely in future. My main reason is they are free!
And they are easy to use❤
Exactly. The Microsoft products are far more capable, especially Excel but Numbers is more than sufficient for most personal use. I moved to Apple when I retired.
I’m on a Condo board but just export to Microsoft when needed.
@@explorer7176 Well, that’s a pretty broad statement. But if you find your directors “power tripping” you can always run for the board yourself.
I just retired in January and feel the same way. Why pay for what I’m not using.
@@danharvey61 Enjoy your retirement, I certainly am!
I was a long time Microsoft user mainly because work was Windows based and Word, Excel and PowerPoint were what we all used. Now I’ve retired, I find I’m using Pages and, to a lesser extent, Numbers. Happily, the Macmost courses are exactly what I need to show me how to use the Apple apps.
I haven't used Microsoft Office for 15 years, and I don't miss it one bit.
Thanks for the video Gary. I finally pulled the plug on MS OneDrive and Office apps this months after years of using MS. Once I switched to all Apple a few years ago I use Pages and Numbers exclusively. I’m not a power user of office apps for personal use and the Apple office apps are more than powerful enough for what I need.
I find the Microsoft 365 Personal plan, at $70/year to be a good deal, because you get 1 TB of cloud storage as well as access to all of the Office products. I still use Excel instead of Numbers, since that’s the product we always used in the business world. I have, however, gone over to Pages instead of Word, which I always found to be way too complicated.
I agree.... $70/year was a deal changer for me since I came from the Windows world.
I use LibreOffice on all my machines, Linux, macOS, and Windows.
I used MS Office (mainly Word) when I was working because I had a copy supplied by my employer. I continued to use it (along with Apple's apps) after I retired until changes in OS/X meant I had to get a new version. I didn't want to pay the stupid subscription so I switched over entirely to Pages and Numbers. I find that they are more than adequate for my needs and, as you say, much easier to use (especially Numbers). I also have LibreOffice for those rare occasions when I need some bit of functionality that Pages or Numbers doesn't have.
Thanks Gary for this really helpful video. I’ve been a Mac user for 10 years+ and always used MS apps. I’m now going to give Pages and Numbers a go. Your insights are always encouraging.
What I tend to find as someone well within the walled garden who also works in a small business, Apple apps for personal use, Microsoft for professional. Numbers is perfect for my home finances, pages for CV/resume writing, and since work pays for the Microsoft apps I use them strictly for work-related business.
There are several differences between Microsoft Office for Mac and the Windows version people. Don't expect to do everything exactly the same way. I often lost a lot of time on the web looking for a way to do so to finally discover that the feature I needed didn't exist on Mac.
Thank you, this is one of the most useful piece of information for someone considering jumping from Windows to iOS
You're welcome.
How often do features not exist? Are the Win versions way” better than the Mac versions? Thx
Mac Excel is a disaster if you want to use VBA to the point of being unusable. Also be careful before you jump if you want PowerPivot.
I do like Office better on Mac than on Windows, tbh lol
As usual, Gary, you are one of the most objective and clearest explainers on TH-cam. I am trying to transition to Pages after years of using Word and am doing so with the "crutch" of LibreOffice. My eventual goal is to do everything in Pages and save files in different formats in the end. I am now getting through your great Playlist of Pages Tutorials.
Gary does have a gift!
I’ve learned more from Gary then I ever thought possible, so I agree.
For the last two decades I was a MS user. Now I have transitioned to Pages and Number , and I find them much better because they lack the frills, and are absolutely user friendly.
Good summary Gary. Some things from my experience:
1. I was a big Dragon dictation user (with PC Word) for many years, and initially there was nothing that came close to this on a Mac so ended up using a Windows VM in Parallels which worked fine. Over recent years, though, Apple native dictation into Pages has become almost as good - certainly good enough for me and I am a hard core writer. I also find that PDFs generated by pages somehow look nicer than those from Word.
2. I still use a Parallels Win VM for Excel though. This is to support a range of 10-15 year old VB macros that run very slowly in native Excel on the Mac if the there is a lot of number crunching involved. For day-to-day spreadsheet stuff though, I actually find Numbers more pleasant to use. Apple has done a good job replicating most of the Win Excel keyboard shortcuts. As a tip, I find mapping the modifiers to behave like a native Mac if you have to use Parallels (which is pretty easy to do)
3. We do a lot of charting of data for reporting purposes and Keynote is massively better for that, both in terms of chart creation and the quality for the final output (I would never embed a chart from PowerPoint into a published document, but Keynote graphics are fine).
4. I get sent a lot of PowerPoint presentations by other people (outside the company), but I find PowerPoint itself horribly cluttered, messy and intrusive nowadays, so I generally just open files once and save them as PDFs for general access. If I need to edit the content for my own purposes, then I generally convert it to Keynote and tidy it up.
Lastly, as a general comment, when we (mostly) ditched MS Office, we were concerned about exchanging documents with clients for review. We found, however, that providing clients with drafts in PDF format works really well. Everyone can mark up a PDF and best of all, clients can’t tamper with (and screw up) your content - they can only comment :)
Summing up (based on my and my teams’ experience): MS Office does more, but once you switch to a simpler environment, it seems unnecessarily complex and clunky when you go back, and the output doesn’t look as good.
That's MS in my experience: "Unnecessarily complex and clunky".
Unfortunately, I do not agree with the complexity idea... I prefer having options and not needing them rather than needing and not finding them
@@abdelhakhadji9992 depend how are the options.
@@abdelhakhadji9992I agree
I just love the way you explain things Mr. Gary. I have seen this clip number of times. Thanks.
I have used Microsoft Office for over 20 years on Windows. I was doubly surprised when I installed my Office 2019 pack on my very first Mac in 2021 (a 24-inch iMac).
1) my one-time Office 2019 license for Windows is perfectly compatible, I was able to download my purchase from my Microsoft account and import my license without having to buy a new license and 2) unlike Office on Windows, Office updates frequently in the background on my Mac. However, I prefer to use the mail app rather than Outlook because I find Outlook less well integrated on Mac and more complex to set up. The mail app is so much easier to use!
When I transitioned to mac from windows world, I had issues getting Microsoft office to function correctly. I do not subscribe to Office 365. But, having said that, I did install LibreOffice, the old open office. I found out it was easy to transition from Microsoft Office to LibreOffice. Plus, LibreOffice maintained the format of my files and document.
Hi. I found Numbers to be the most different to office suite, namely Excel, than the other ones. For small documents, I like the fact that in numbers you can easily arrange different tables and graphs. This is less aesthetic in Excel with the spreadsheet that covers the whole page.
That is true, but only for sheets with little data. And the whole point of excel is to analyze big tables with filtering, pivot and powerquery.
I've had MS Office 2019 on both my MacBook and iMac for over 3 years after obtaining a volume license that cost me something like $50 (no subscription). I needed it to support old legacy version of data/files I had prior to my Macs when I ran Windows and found it easier to use over the Mac native versions (Pages, Numbers, etc.). I'll probably never upgrade them, nor will ever need to, as they do everything I need.
I would, however, give my right leg for a cheap full version of Visio! I miss it so much and was an expert at doing so for my job (network & data center engineering documents).
I like Google Sheets and Pages.
Your videos are really making my transition from windows to Mac bearable. Keep coming back for the stuff I'm forgetting. Thanks dude.
A good summary. For the last 10 years of working life ( MS based) I used both systems when needed but one you didn’t mention is Keynote. I used it exclusively ( mainly because you were presenting with it rather than sharing.) I found it far superior to PowerPoint.
he actually did !!!
I work in a corporate setting that is MS centric and I use Apple (numbers, pages, keynotes) exclusively and import in and export out to the MS format seamlessly. I was. a MS user for years but like the usability and some of the features within the Apple suite better.
I have a sub to office 365 but I've been trying to learn the Mac versions. Numbers in particular I like for smaller tables and graphs since the tables can be resized. Makes for a good print.
Another great video Gary! I work in Microsoft environment but all my personal is in Apple. I do find that there is power in the simplicity of the Apple apps in the form of efficiency. When I have to cross over and run an excel file from work it does have some capability issues with font viewing size and formula conversion.
A very comprehensive overview. I handle the accounts reporting for our residents assn using Excel because I know it so well from using it daily at work. I tried hard to do the same with Numbers (for free of charge) but it didn’t have all that I needed. It did however create charts more easily but overall I stay with Office which incidentally is also compatible with iPhone and iPad, and couldn’t be happier.
That has more to do with your own skills developed through experience.
As always, Gary, great video. In the past, Apple products didn't seem to be nearly as good as MSOffice products. But recently, they seem to have improved a great deal. I use Apple products for my own stuff because I just enjoy them more. They do everything I need. I only use Word and Excel for compatibility with others who use them.
Thanks bunches. When I first got my Mac, I installed Office 360. But you talked me into learning Apple apps. I have found once the learning curve has passed, I so much more enjoy Apple apps. The subscription of 360 automatically renewed a couple of months ago. Next year, I will not renew.
Loved the video and I would definitely class myself a pro-pages person. I really enjoy pages and find it much more compatible with the way my brain works. I wrote my masters and doctorate portfolios in it and then converted to a word document with no hassle. It also became the main programme for word processing and desktop publishing at my last work place because of its ease of use and handling of objects such as tables.
I've since learned how to use LaTex and now try to use this, however that's more of a personal challenge and hobby.
Our family is all Mac/Apple. When my kids went to university I subscribed to Office365 Family for the Office Apps and the cloud storage. Nowadays its Apple One Premier. The reason I still subscribe to Microsoft365 Family is for the enhanced email. We all have Outlook email addresses and I like the enterprise grade security.
Good summary. Thank you. After a lifetime of Windows at work we subscribe to Office. However I have found Keynote to be better and more creative than Powerpoint. Some of that may be because most people are overloaded with Powerpoint presentations and Keynote’s look is fresher for them.
Happy New Year Gary!
Actually I think Microsoft Office (now Microsoft 365) increased Mac’s use in the businesses community. It happened to me. I really enjoy my Mac computers but also make intensive use o Microsoft 365 including Outlook because it is very easy to have a logo signature in it. Microsoft 365 for Mac and optimized for Apple Silicon is really great.
It is a beautiful and powerful combination! Cheers!
Thanks for this subject you have touched upon. One of the reasons for me to be tied to Mojave has been this: I am used to Microsoft Word. Tried to shift to Pages but found but was dissuaded from adopting it because I learned that the file sizes are more with Pages than Word documents. Regards.
I second the notion of using LibreOffice!
As a professional I used MS Office from inception until 2010 (retirement.). There is no need to give MS your personal data if you don't have to use MS Office due to employment related reasons. I am perfectly happy wiht Apple's apps. Some features I missed at first, and felt awkward trying to learn a new system, but, overall Apple does everything I need.
I couldn't agree more. I only use Windows because I have to for work. I'll be buying another Mac soon after not using one for over two decades. Word for Mac is better than Word for PC, but Pages is better than Word altogether. Microsoft is downright creepy with all the personal info they want just to use their inferior products. Not worth it.
I am a VBA programmer. It s not really available in Excel for Mac.
I've found that Pages scales a lot better on my 13 inch M1 Macbook Pro when I tile it to the right while doing research with Safari tiled on the left. I also find it a lot more aesthetically pleasing and less cluttered than Word.
I also love using a MacBook along side an iPad.
Excellent video tutorial today and very useful! Thank you, Gary! 👏🏻❤️
I bought office in 2013, spending 150€ and soon it was the old version. And other people i knew were still working with the even older doc format. So I had to export using doc instead of docx. Using Apple Numbers and Pages just made my life so much easier, if necessary for work I export to xlsx and docx, mostly I provide pdf. Privately I like making spreadsheets now and have a much better understanding of my finances.
I just started this week to migrate from Excel to Numbers. The current Office license I have comes to an end. I think that for my purposes Numbers is a good alternative for Excel.
But one could also use LibreOffice, and I'd like to see a comparison here. Many thanks for the concise explanation!
Open office too!
@@Erin-Thor Although OpenOffice is technically still available, the project has been on "life support" for several years and is likely to be shut down. LibreOffice is a fork of OpenOffice and also its replacement.
@@bcarr1122 - Good to know! I’ll try it, Thanks!
Best option. Will open office docs. LibreOffice #1 Microsoft bad stay away!
This video was very helpful. Answered my long time questions and more. Very wise, practical and thorough coverage of this topic. Thanks Gary.
Thanks Gary for the topic and the great explanation!
Very nice and concise comparison, so useful!
Great video Gary. One comment regarding that Apple Apps are free. If you need cloud storage, with Office 365 family, you get 6x1TB for $99 per year, which is way cheaper than iCloud + free Apps.
Thank you for this video, much appreciated!
Used to have Microsoft Office but somewhere in a Mac OS upgrade, lost or it wouldn't recognize my license. Wasn't going to do a subscirptiion. Went to Pages and Numbers, the more I used Numbers the better I liked it and FREE with any upgrades !!!
Really excellent, Gary. I"m stuck with one foot in each camp (Mac & Windows)
Another home run, Gary. Very well explained, and you showed no partiality (even though we all know you are an Apple guy 🙂, but I digress). Like you and most people, I use office mainly because it is given to me by my employer. For me, iWork apps are much easier to use and understand. Microsoft tends to take something good and change it for no reason and complicate things as they've done with Word (ribbon) and Onenote (2016 vs. windows 10). I think that getting into the business world via software and partnerships was a brilliant move on the part of MS as, at this point, there are so many options out there that do the same thing (albeit without all of the bells and whistles) that had it not been for these partnerships I wonder how much of the market share they would have. Also, to your point, they have been around for so long that many people see no reason to switch to another platform and stick with what they know.
Thank you Gary 🙏
For me it's Pages and Keynote for documents and presentations due to their ease and friendliness of use. Excel for spreadsheets because it's just more powerful than Numbers.
Excellent content! Thank you
When I was a university student, I relied on Pages for note taking bc of how simple it is and its uncluttered look. It’s easy to hide the formatting panel. I noticed a lot of students were using Pages as well. I’ve never liked Numbers so I use Excel bc I’m more familiar with it. I have a hard time with Numbers for some reason.
I like that you you state that MS Word and MS Excel are the most powerful. I am using MS office on my Mac Mini, iPad and iPhone. I do use Apple Numbers for converting my contacts to CSV for transfer to the Apple Contacts. I cannot get Excel to convert the contacts to CSV properly. contacts will not recognize the CSV files from Excel. (i.e. I have both Numbers and Excel). Overall a very non partisan view of MS office vs the Apple Apps.
Very helpful video...now to actually get them installed and use them. I have not used any document program in about 10 years!
I agree! I used to do a lot of work in Word and Excel. I still have them on my Mac, but now that I'm retired, I prefer to use Apple apps.
Yes, Excel is more powerful, but there is one very important thing I can do in Numbers that I can't do in Excel. They both have tabs, which I make extensive use of, but in pages, I can have multiple tables in the same tab. In Numbers, each table has its own column and row bars. I can change widths and heights in one table, and it doesn't mess up the layout of a table next to it. In Excel, you're stuck with one set of width and height bars for the entire tab. Maybe there's a way to do this in Excel, but I've never seen an example of it.
Thats a fair summary Gary, thanks for sharing.
Very useful and practical advice. Thanks Gary!
Thank you for this video, I have a pages doc and did not know I could export it as a word doc to send to others who do not have a MAC.
First computer: Osbourne. First GUI OS: Windows 2.0. However, this loooong time user of Microsoft is now totally fed up with them. I have switched to Mac. I will ONLY use Mac software and no longer be held hostage by Microshit. Love your tutorials, dude.
Very nice video! Thank you!
I use Numbers and Pages for my private documents because it's much easier to use it for me and for all the other reasons (Handoff, Collaboration with others etc.) At work because we use Windows Machines I'm stuck there with the MS Office Apps.
The Problem between MS Office on Windows and on the Mac is, they are 2 different Programms. So lot of functionality that you have on windows doesn't mean you have them also on the Mac version.
Thanks gary. I am new to mac and was really worried about not being able to open pages and keynote files in windows. I don't want to purchase Office365 and you saved my subscription.
Excellent video. Very precise explanation. I am really thankful for this.
I use libre office, it's free, compatible with Microsoft Office files and can do everything both options do.
I also use it bro it's almost same as Microsoft office
Great information....thanks so much...
New Subscriber! You are very helpful to me with my new Mac. Thank you
I use Pages in Mac (no 3rd party apps in it) and I have a PC laptop with MS Office if ever I want to use it.
Thanks great video
Having recently retired, I don't have to worry about sharing files with colleagues, so Apple's apps work great for me - they've got more than enough features for my needs, are simpler to use and easier on the eye. I keep LibreOffice as a standby in case I get sent any problematic MS Office attachments/forms, but so far I've not needed it.
When sharing files pdf is easy to use and not that much of a big deal.
I use both apple iPad and windows laptop, as most companies use windows it easy for me to do my work, windows easy of files
Great video as usual!
One thing I use in Numbers is the "Checkbox" column. Excel does not have an equivalency when converting a Numbers file to Excel.
Stll have to use MS Word within the company I work for, but have hated it ever since they introduced the ribbon (can never remember where things I use occasionally are).
Main problem I have is when I want to open a MS Word document on my Mac to send to my printer. The documents usually have images and different page layouts that Apple’s Pages can’t seem to handle properly.
Still, I won’t pay for MS Word on my Mac because if there is anything I hate more than MS Word’s ribbon it is subscriptions on software and the one-off payment is far too high.
Informative and nicely reasoned video, as always👍
Very balanced and reasonable opinion. Thanks
You are a lifesaver! Thnx!
Thank you 🎉
Thanks a lot.
After MS basically abandoning Publisher, I switched to pages. Word is brutal when it comes to inserting and editing images precisely in documents. There is definitely a learning curve but it’s well worth it.
Very helpful
ty
Thank you, I have the Microsoft office because I have a company and I do my bookkeeping with it. I recently have written it in numbers, and with the help off you I managed for 90% the whole bookkeeping with the formules in it. So thanks a lot for it. The reason was that I couldn’t look at my IPad because I had to pay for it extra but I didn’t like that.
And now I can look everything I want too. And my checkbox always is up to date. Funny thing is that watching your video’s and learning a lot from it I get smarter. Normally I asked my husband for something about the computer and now it’s the other way 😀😀😀👌👌. Hope to still learn from you about pages, keynote and numbers. O, and by the way, I had a problem with all my devices, got stuck, had to do always restart every device but yesterday I looked a video of you about changing the e-mailadres on th Apple ID. Tried it, did it and all worked well again so thanks for that! Keep them coming!
I moved to mac a couple years ago, however could not get used to pages & numbers, so I kept word and excel.
Thank you. I’ve been driving myself crazy trying to figure out if I needed to buy windows.
When I was a windows user my office program was Libre Office. And that I still use on my Mac Mini and MacBook. Works great. So I can work on the same documents with other people, for instance in DropBox and I don’t have to have two files (pages and docx) of the same document. As converting all the time is not ideal. That’s why I still haven’t managed to learn to work with pages and numbers and keynote. Problem is that I haven’t found a good app for my iPad. Advise is welcome.
Like I recommend in the video, you can use both. So maybe when you need to write on your iPad, use Pages.
The only thing I wish numbers had that excel does is the ability to highlight columns and use the tab to move around in just those highlighted areas
Microsoft Office is the primary tool for business. Without it being fully functional on an iPad, it's not much use.
Thanks for your overview on Microsoft office which is the legacy workplace standard. I was stunned to learn that you were forced to use MS by your publisher. That really sucks. I’m writing a book and I think that I have a new publisher red line.
Great Content!
Very helpful. New Sub. 😁
Nice information
Well, i love to use keynote, it has everything i need, and you can use your iphone as a remote at presentation which is so cool. With pages its fine, but for some more complex docs like creating more robust resume i was seeing some glitches, so small need for ms word and for notes i just use native apple notes app which is awesome. But for spreadsheets there is nothing like excel. It is powerhouse with build scripting, now also with python, and there are python packages to operate on excel files, everything you need for professional usage. Buuuut if you are someone like my mom who only do basic stuff on her laptop all of the apps from apple are great and most important free.
You're right Gary, I admit it is a habit and sadly I live surrounded by Windows Eco system here in Peru. So it's office for me...
Gary, love you, been watching for over a decade! Have you ever covered alternatives for MS Access on a Mac??
nice one
There is one glaring issue with the MS suite for Mac: not all functions of the Windows version of the suite are available on the Mac versions. Would running Windows on the Mac solve this issue? It’s an added cost, but you do not have to have a Mac/Windows setup.
The only MS product I need to use is Word and I have to subscribe to Office for one program I don’t need the storage or the other programs. I find Numbers and Keynote far easier than the MS equivalent. But for now I still need word.
I had to use MS Office at work and I would rather not deal with them now that I'm retired.
Yes, the iWork apps, Pages, Numbers, and Keynote do just about all I would ever need, but they're not entirely compatible with the ubiquitous Office documents.
For full Office document compatibility, I've found that the free LibreOffice suits all of my needs on the Mac without having to spend any money I don't have to.
I’ve been very happy using Numbers and Pages for years. They do more than I could ever require, and they’re free. I don’t like the Microsoft model of having to subscribe. Plus years ago I chose the guys from Orem Utah as that was the predominant software for government etc at the time. My biggest problem is that old documents that were saved in Wordperfect can’t be read by Pages. I have to convert them to Word documents then resave them in Pages if I want to use them.
I was a MSWord expert since the 80s, until Windows 11 They now have an issue with their onedrive, it disappears and then you cannot save! Besides that, it is taking too much Ram and too much CPU power. I even switched to Mac with 16 GB Ram , and installed Office, just to be able to work with Word, and then I got a spinning wheel on almost every click. It was draining all my brain processing power. I am now using Pages and I'm finding more functions than MSWord, for 10% of the processing power. Anybody can do a test by looking at the Activity monitor with both Pages and Word open. I am finally saying goodbye to Word . I'm finding Your videos very useful for the transition. Thank you Gary!
WPS office works on both Mac and Windows, and it is free.
Long time follower of Gary. Switched away from MS everything and PCs in 2010 when I retired. Now exclusively on MBAir, Studio monitor etc. I use Apples office quite happily after a long career on MS Office and cut my teeth on WordPerfect and Lotus! I’m that old!
Yes, you should have Office for Mac if you intend to engage with the big, wide world. Otherwise, I think Pages is a lot easier to use than Word and just as good if not better in some ways. It's improved exponentially through the years, and it will only get better. Keynote blows PowerPoint out of the water. As a company Apple does a far better job of respecting user privacy than Microsoft.
That would only matter if you and another person both wanted to work from the same document which to be honest is not that often for moat people. It is more simple to just produce your master document in word or pages and the pen convert to a pdf or some other format if you need to circulate it.