For all those saying Office has OneDrive cloud storage: That is NOT the point of the video. It's about showing alternative productivity suits as NOT everyone has a need for cloud storage, but everyone HAS a need to create docs. It's like saying the reason to buy one cell phone over another is that the one gives you a free case. That may be exciting for some, but for most people they just want to know which phone is better and not which one comes with whatever add-ons. That is very secondary.
oops yeah i didn't read before writing my comment, yeah, the cloud storage is the main reason for my subscription Hehe... your right, if you're not using Office as a power user then the free options are very fine to use.
Still, this doesn't give you the right to delete people's comments (like you deleted mine)! If you don't agree with someone's opinion, comment on it, but don't just delete it because their views are different.
@@unimatrix1 dude TH-cam has a comment bug. I certainly don't delete people's comment that I don't agree with who are civil. You can see my Twitter where I have a screen recording showing this bug
Whilst I agree with your main point 1) your example is pretty poor since what possible need would someone have for a phone case without the phone. 2) I believe you should of at least briefly mentioned and addressed Onedrive in the video. I confident that a high % of people (non-business) pay the MS Office tax for this very reason, I know I do. The Office suite is a side benefit to the main benefit - 1TB storage.
I been using OpenOffice too with no problems at all. Same experience - no bugging me for up-dates or up-grades. Still in the exact same format and screen all this time. Spell-check is weak so I go elsewhere for that. Been thru multiple computers thanks to Micro-POS crashing them or otherwise rendering them useless. I just pull OO off the net and there it is - exactly the same as before.
One thing worth remembering is that OpenOffice is built on the source code from Star Office which started development in 1985. Microsoft Office began development in 1988. So in terms of lineage OpenOffice is older than MS office.
@@FlyboyHelosim OpenOffice had/has a nasty bug. When encountered, it wipes out all of one's work. After experiencing that a few times and seeing it wasn't addressed in years, I switched over to LibreOffice permanently. The vast majority of people use a small percent of features in productivity software. Programmers typically create what they themselves think is neat to code. So, more useless added features aren't needed but bug fix releases are important.
Im still using Office 2007 that I bought direct from Microsoft many years ago for around £20. Still works perfectly fine. Only downside is I now have to go hunting for it if I should loose my copy and need to redownload it. But it still does everything I need it to do :)
Same here, using 2010 with family license. Would purchase 2021, but it allows installation to one computer only, which might have been OK in 1997, but nowadays it is common to have more than one computer for a family. Libre/OO is no option because of a need for scripting compatibility.
About the same here! Still using Office 2003! I never could be used to the switch to change the appearance with Office 2007 :-) If I will switch, I would give Libre Office a change (not sure Excel Macro's will run on it)
On my old XP computer it is still Office XP Pro .. works fine for Word and Excel .. Only downside to an older version is if you use Outlook for your emails ... They change the types of security needed from time to time and sometimes, the older version of Outlook will not work for all email providers.
Regarding Microsoft Office One Time Fee: Every time there is an upgrade, you'll have to pay - that's what is mentioned on the website. "Office 2021 is a one-time purchase that comes with classic apps like Word, Excel, and PowerPoint for PC or Mac, and does not include any of the services that come with a Microsoft 365 subscription. One-time purchases don’t have an upgrade option, which means if you plan to upgrade to the next major release, you'll have to buy it at full price."
you will not use what upgrade give you, the mjority of office users, use only 20 % of office power . so you can run with office 2013 even now, without any probleme
@@IwanTamimi updates and upgrades are 2 different things. For example, even if your Windows 10 computer can not UPGRADE to Windows 11 because of compatibility issues, does not mean you can't continue to get Windows 10 UPDATES.
@@fogdragon23 any and every free license is not secure. should never be used for business - the only way to protect a business environment is with security tools that COST so if your getting Office free then your not paying for security. Windows 7 is also no longer support by microsoft uless you BUY the 2020 Extended Security Update, for 50 euro, and the 2021 for 100 euro and the 2022 for 200 euro. you can't just get the latest you have to buy all three and every yr it will double in price. WHY - because you shouldn't be using windows 7 in the first place
I can only say bravo! I was a little tired of finding irrelevant content regarding ways to operate with Excell on Mac, and this video was so enlightening! Short, straight to the point, while also sharing a lot of actually practical information. Thank you very much for this. Have a nice day 🙌🏻
Hey wise cat! Do you know how to type math formulas in an easy way with wps? Like i would like fractions and powers to be automatic, and the ability to write greek letters with the backslash i.e. \gamma should be the greek letter gamma
Me too. I have it on my Android tablet. Admittedly, the Android version is a bit tricky, compared to to MS Office, but that may just be the nature of Android programs. I haven't tried the Windows version, yet, because I'm still using Office 2010.
I still use the office 2007 line and never had an issue. (The only thing is that i almost never use it so for someone that have very little need for it just get an old one and it will works perfectly)
Office 2016 has old bugs and security holes that you ought to update to Office 365's up-to-date bugs and security holes. Also the old software tends to lack the siphoning of your data back to the manufacturer.
@@AlexKarasev Nah, I'll be fine... I doubt Microsoft or anyone would be interested in whatever I type there, not even close of being an industrial secret of sorts.
I have always bought office outright, being a single domestic user. It updates too. I had no idea there was any secret about it. I always assumed that the renting option was to give businesses flexibility over how many copies they needed from year to year, or if they wanted to switch to different software or systems. I expect it is a lot more expensive to buy office outright for hundreds of employees than to 'rent' it.
The actual point of "the cloud" is so MSN (and others) can have unobstructed access to our lives via our electronics. Telling us it's "safer storage" is hogwash.
The compatibility issues are really just for opening MS docs in the free software because MS uses proprietary extensions (that obviously can't be added to free software). There should be absolutely no issues with compatibility unless you're using some super advanced features of MS office suite, which 99% of users don't even know about so don't use.
So, here's what I'm doing in-spite of what this video is all about. I have a 2010 version MS Office that I am still using. It works great, no issues and I will never change unless of course my system blows up. I am also still running Windows 7 Ultimate edition and it hasn't failed me yet (knock on wood).
I'm still using Office 2000, my mother bought it back in the day and it came on 2 CDs....one contains everything, except publisher, which is on the 2nd. For 22 year old software it still works great for all I want to do, I only really use Word and Excel, and they do everything I need. On Excel, I can format the cells and write quite complicated formulas, maybe by today's standards they're basic but it's enough for me. Example, one I often use is to keep a running tally and it might go something like this; =IF(C166>0,D165-C166,"0") this one is taking away from the line above to give the tally, while formatted cells below display "0".
I miss when i was allowed to own things instead of renting, And i don't need a new version of everything every year. I been using WPS to write my books, even if it is owned by china but i almost never need a cloud. or collaborative sharing.
Been using my (officially paid for) full pro MS office suite 2003 with a 2007 update and am more than happy with that. It's 100% mine, never had any issues uploading it onto XP, Vista, Win7, Win10.
In my experience, unless you need bibliography automatic tools that Microsoft word has, open office is just enough, it has 99% of the official program tools and functions, so yeah I'm happy with open office
@@vasopel Is it cross compatible? I mean if I did my work in Libre or Open office & send it to a person using MS Office? Will there be an issue there? Primarily work is done in Excel! Thanks in Advance!
@@BlackHawkTejas is totally compatible, same kind of files, there might be a warning message, the same way when you open with office a Google doc file or vice versa, but by definition they all must be compatible
@@BlackHawkTejas Andres already answered ;-) personally I never had a problem with using these 2 different suites (for example in my old job half of their PCs had MS office and the other half had libre office,nobody complained)
I’ve been using the free alternatives on Windows/Linux/Mac since the earliest versions of Star Office which has since morphed and forked into Libre and Open Office. Generally I have found the free apps much better and few compatibility problems. Thanks for the tip on the fonts.
@@driedbrainfreeze2149 In what ways? I am so used to everything in the Microsoft apps - I know where everything is; I am used to the ribbon, etc. There are some powerful functions like the Dynamic Array functions (which are awesome), which I haven’t seen in the free alternatives. BTW, I also refuse to pay for the subscription service. But I am currently using the Online versions. They are a bit stripped down, but can still do 90% of what the desktop app can do (mainly doesn’t have Power Query and Power Pivot) - and even has some features which the desktop versions do not have.
@@JJ_TheGreat have used Linux for many years so when faced with returning to Windows Libre followed. I use several different file conversions and Libre makes it a one click issue. And I'm just used to it.
Yes, I started using Open Office on Linux, but I've moved back onto Windows and the Open Office is EXACTLY THE SAME as it was on Linux. Don't pay for software when you don't need to.
Been a Star/Open/Libre Office user since the turn of the millennium. Never had a problem with it. Formatting errors from MS docs are very rare and have got rarer with each edition.
@@aravindsarkar1255 I wouldn't say it's far better than MS Office but with 99% of the features and 100% price discount it is hard to fathom MS's continued dominance.
I've used LibreOffice an Linux and Windows for years. I can transfer files back and forth between work & home (but nothing with company confidential information) with, as you said, only some minor formatting problems. After a while, I figured out what causes this and can generally avoid it. Advanced Excel formulas are a bit more difficult at times, especially if they get data from SQL server because I can't access that data at home.
What did you identify as the typical causes of the formatting problems? I've tried using both LibreOffice and OpenOffice in the past, but eventually stopped using both as anything I did with them was practically unusable with MS Office - the formatting was so broken I basically had to start from scratch. If it was just for my own purposes it wouldn't matter, but almost everything I need office suite for is either for academic or employment purposes, so any document that's broken when opened in MS Office is a non-starter. If there's a way to avoid this, or at very least make it quick/easy to resolve, I would dearly love to know about it!
@@lachlanbell8390 I don't entirely remember. As best as I recall, I didn't use any advanced formatting. And I didn't save as .doc or .docx, but IIIRC one of the xml formats. I mainly used it for 3 or 4 page "how to" type things.
@@MJ-uk6lu Hum, I kind of understand. In such a case, I would likely use something based on TeX, like LaTeX or MiKTeX or TeXstudio (and are free on Windows, MacOS, and Linux). I avoid M$ software because M$ can, and has, changed things in the past which messes up things.
This is nice that you point out the options for people so they can make an informed decision. The reason I choose to use the paid version is that the online ones are lite (stripped down as you say) and I need some of the features that only come with the paid version.
perfect - that makes complete sense. We each need to make a decision that works for us as there is no global right or wrong. Appreciate you hanging out here!
@@LironSegev You arguments in the video are incomplete and grossly underestimated in favor of the free versions. At points in my working life (going back to the 90s) I've rotated between OpenOffice, Libreoffice, and WPS and reverted to Ms Office due to document compatibility issues and breaking of formated layouts etc. As a person who has clients in corporate companies It can get quick embarrassing if not frustrating.
Actually, I don't have an argument in favor of the free version - I am showing that you have options. The free suits had serious compatibility issues back in the day, but this has become less of an issue with the newer versions. Many of us use these free suits and communicate with clients and companies who use Office without any issues in 95% of the time. If you are in the graphic design industry or mockups or require absolute precision in images and formatting, then just use Office. Good luck
@@Sobbayi I share in the embarrassment/frustration. But I look at it in a way that "I hope people would switch to the free suites already." Open Document Format (odt, ods, odp, etc) hopefully becomes the standard, not Microsoft's proprietary formats (docx, xlxs, etc).
I went with SoftMaker Office which is available on Windows, Mac, IOS, and Linux. Full Compatibility with MS Office across all platforms. There is a free version, a one time pay version and a subscription option to always have the latest. Pricing is reasonable, if you choosse a paid version. They also partner with other Windows software vendors to offer lower pricing on other applications. Been using this for number of years and have never had a problem.. (I am just a customer and not in any way affiliated with SoftMaker). I just like their product.
I personally use WPS Office and I can guarantee that whatever you mentioned is 100% true! The best part was you busting the myths... Myth Busting Liron!
May i ask you if you know how to type math formulas in an easy way with wps? It does not automatically write fractions or powers. Also i'm not able to write greek letters with just the backslash like \gamma would not translate into the actual greek letter gamma
@@cenevspeed_CARS All of them, in particular power point. I need to build reports for my labs but it's taking ages cause open office is not compatible with Ms office when using formulas, and wps has no kind of automation or shortcut (as far as i know at least). Any help is really appreciated and would save me days of work. Thank you for your answer btw
I've tried and used all of the above free versions and while they're good, I do like and use most of the utilities office provides, however, I flat out REFUSE to pay a subscription! In the end, I bought a licensed copy of office pro 2013, it wasn't overly expensive and offered ALL the options I wanted and use, so I'm happy :)
I've bought office this year for the first time in 20 years of owning it (I've always used older versions that I "acquired"). But I need the more advanced data sources functionality. Updates for the year, 1TB One drive storage and some free minutes monthly for calling phones on Skype for about €50 a year (about €4.16 a month). There comes a time when you have to say is the €50 saved by using free software worth the extra effort. If you're a basic user then it probably is. If you use some of the more complex features or macros then (for me) it's not.
The answer is simple: Stay on old versions to avoid a forced upgrade cycle. I can do 95% of what I need with version 4.3 on Windows 3.1. The other 5% can be handled on Office 97 for the rare times I need more than 16k rows in Excel or use merged cells. Furthermore, the 2007 compatibility pack can be installed over Office 97 for the extremely rare times I need to open the newer formats. YMMV.
Exactly what I do. I'm still using Office 2000 with the free compatibility pack. Only limitation: Outlook isn't usable as an e-mail client anymore, because it's lacking security standards, that most mail providers enforce. So I replaced that with free Thunderbird and switched to Lotus Organizer 97 for the calendar part. Overall I'm very productive with these applications and I never missed anything.
Great topic dude, I use Office 2010 which I purchased back then, it does everything I need but now I get the odd compatibility issue, your link will be useful. Looking forward to you next video
I pay for the annual subscription. Some of my considerations included: 1) Features - I need some of the paid-only features 2) OneDrive - Being able to access documents from my various devices (laptop, desktop, and phone) is immensely beneficial 3) Compatability - I can't open Microsoft Office files with freeware alternatives 4) Continual updates - I'm not stuck with the same version 5) Value - I feel the value I get is worth the price paid
The most important part of 365 for me is the cloud anyway. I get to share files or folders, even publicly in some cases, I can cooperate on content in an environment I prefer to Google office apps and sometimes I just use Office as Office. Oh and also my entire family gets the cloud AND the office for one price.
As much as I loved libre office when I was in my early 20s, now that I work in an office environment and collaborate with others- everyone uses Google Docs or Office 365. Nobody wants to email files back and forward and version control is a key feature. Cloud hosting and file sharing is the most important aspect of office productivity where we can track changes is an essential aspect for any job. It’s worth the cost.
The Microsoft office alternatives work very well with the exception of Microsoft Excel alternatives. Something as simple as a pivot table sadly doesn't work using the free software
I work with many companies that licensed office 16 and have not upgraded. Excel has added powerful stiff they lack. * filter * sort * unique * textjoin * let * lambda Some don't even have power pívot and their power query is literally years behind. If you are a power user, excel has no real competition. If you don't even know how to use Vlookup, subtotal and if, any free suite will be enough.
You are great at providing useful insights. I, as do most people, worry about years of saving documents in MS apps (years ago I used Word Perfect) that will not be compatible or require extensive cleaning up and, so, skipped moving over to another office suite of docs. You have cleared up my fear about doing that. Thanks.
I switched to Open source for pretty much all my productivity software, I am a home user not a big business. I am not going to pay hundreds of dollars for software I don't rely on... honestly even if I did, I would still stay with open source. Half of what your paying for is the name corporation that makes the software, and the only benefit really is it is a bit more user friendly.
You see, the most important point of buying the yearly office (family edition) is that each user gets 1TB of cloud storage on OneDrive! With more and more photos being taken on phones etc, you can set them to upload to the OneDrive, no need to worry about backups etc. So the cloud storage you get is less than you'd pay with other 3rd party offerings alone! I have also never paid the full price for Office, in the UK, is £79.99 for the 6 users family version, I have always paid £50 or less when on offer (multiple times per year), so when an offer is available, you can stack them, I got 4 years remaining. If you are not bothered about cloud storage, you can also just buy the licence for as little as £20-30 online (legit) for the full version of the latest MS Office, including Outlook.
The simple fact is the family suite comes with 1TB of free cloud storage per user, and Dropbox isn't part of Microsoft so no idea why you're mentioning them!? What reputable provider offers 1TB of storage for the equivalent of $15 per year?
@@bennyceca a company that makes an absolute buttfuckload of money offering this service to enterprise, and giving a cut down service to consumers for dirt cheap.
Been using open office for 15 years. On a side note, when Adobe went the same subscription way, I left them and while I still have cs2 on a machine, I started using Gimp. These companies and their overpriced software are not needed anymore.
I was using Office for decades and was a pretty competent user. Then I started using Sheets and Docs because that was what my company was using. When I left I wanted to go back to Office and bought a “subscription.” I can’t believe how much it had been changed. The easiest functions became a nightmare. For example I’m working on a 100 page document. I can’t figure out how to jump to a page, let’s say 89 without scrolling to get there. Help is useless and a Google search has come up empty. Many other which used to be simple are a struggle . Even the main headings have been changed. Why would Microsoft do this?
For students, small associations, your first resume or occasional use cases, LibreOffice is actually great. But for pros, there's no beating about the bush: MS Office remains the gold standard. As much as I hate Microsoft, I gotta admit that I renew my 365 sub every year, cause I can't afford any incompatibility with my documents. Business and clients first!
2 issues: 1.)if you use office online you cant use it when your offline 2.) MS office has some cool features like powerquery which is a feature since office 2016 which is not availble in libre office etc
I've been using OpenOffice for I dunno how many years now, probably almost two decades, I started with 1.x. I create several documents every day with oodles of formatting. I have found no shortcomings when compared to MS Office and f-r-e-e fits right in my budget.
Actually, the family subscription is great - you get all of the stuff for 5*6 installs, and always have the latest versions. Of course, if you use excel for making shopping lists, you may not need the latest versions with their new cool functions. Using alternative office apps works until you need to work with Ms office files which are somewhat complex.
Have been using OpenOffice and LibreOffice for past years until recently when more people in my household need to cloud storage and a have lots of email to manage. The family pack is way more convenient and cost effective when there are more people willing to share the fee. If it weren't for this purchase, i wouldn't ever have known how useful Microsoft Access is to manage stuff.
For Mac users, Pages, Numbers, and Keynote which formally were bundled as iWorks, and prior to that AppleWorks all function well enough, and are on all iPhones, iPads, and Macs. I haven’t used Microsoft Office for well over a decade. Open Office is something I download on all my computers too… …
Thanks for showing the options. Suggestions to others is try the free version before spending their money. I lost the use of my older version of Office when I went to a new computer. Been using the online version, but it feels a little clunky compared to the computer based version. Will try Libre Office before I subscribe or purchase the new Microsoft version. - Thanks again.
I have managed to install Office 2000 on Windows 10. It did throw up some errors, but I was able to bypass them, and word and excel did at least seem to load ok, so not sure what the errors would affect?
I was forced to find a free alternative to Microsoft Word when I was busy doomsday prepping my trusty laptop. I picked LibreOffice 7.2 as I have heard it was the best one out there. I have now been using LibreOffice for the past four months and I really love it. I write a lot and this software has never failed me yet. It prints perfectly and the design is very similar (but not exactly identical) to Windows XP Word. I definitely would recommend this one for you readers to try.
Microsoft's business model is going to force customers to make some serious choices soon. Given current circumstances many will make the choice that the price of staying loyal is just not worth it.
Started using Linux full time decades ago. Haven't bought an OS or office application since the 90's. It hasn't been perfect but for the most part is has met my needs. I'm not a gamer and I do not do sophisticated macros in my documents so Linux/Libreoffice is satisfactory. Your mileage may vary.
Those software publishers that came up with the annual fee business model actually did me a favor, as it got me to search out one-time paid apps that were superior, at least for my needs, than what Adobe Acrobat and Microsoft Publisher offered with their fee-based apps.
I pay $35/month for full-blown Office 365 (all the apps). It gives me 5 completely legit separate installs. This is a far better way for me to have Office than any other option (including past options where you paid $300-$500 each depending on the number of apps you get. And since I work from home for my company, and use my own computer to do it, that cost is tax deductible. This subscription also gives me full upgrades at no additional costs every time they are released.
The installs are still only virtual running of the programs. If you think not, disconnect from the Internet, restart your computer and try running the programs again.
You totally forgot to say something about formulas and VBA capabilities of Excel. I worked in small companies up to enterprises since the birth of Excel and VB, and I have to say that in the last 15 years I did not see any serious Excel worksheet without moderate to heavy use of formulas and frequently also VB custom functions or macros. How do behave all the free office tools?
I was shocked when I discovered the LibreOffice stuff. I had to adjust to not using VBA, but I've converted so many people to it who are angry paying the MS subscription fee.
I just stopped using my MS Office 2007 I bought in 2008 :) Got my money out of that purchase... now retired, I don't produce work documents anymore but bust a lot of numbers using google sheets and all my excel files have opened and worked fine... People, there are OPTIONSs and as the creator noted, if you're not share files - it's probably not an issue any differences that may exist... Thanks for the video sir :)
Btw compatibility issues are represented in the different MS Office versions as well. I’m working at a book company as an IT guy. We have a lot of problems because of colleges using different types of MS Office. The only thing that makes harder to change that people have habits and they really not like if they have to learn new things especially if they developed their workflow in a few years.
I used Office 2007 for years. I found a full registered copy at a consignment shop for $1.00, and it got me though college and University. I got my Master's degree with Microsoft office 2007, and never need to renew subscriptions. These are free when you are in school but I much prefer the 2007 one.
Great content Liron! I always set the Libre files to save as the corresponding MS extensions by default but didn't think to change the default font to calibre. Great tip! Cheers
I know it's not terribly relevant for lots of people is that a family license allows installation on up to 5 computers. This - and OneDrive is the only reason I'm still subscribing for it. Also I use it for work and it can be confidential documents I'm not allowed to use on a cloud solution. But for most people this is great advice.
I partially agree with you, but there's a point almost no one explains... With Microsoft 365 you can install Office (with all the apps e.g. Publisher, Outlook, etc.) on 5 PCs, tablets, and phones. I mean this is a real advantange you'd consider before buying a single installation for the full price (without having the possibility to get all the future upgrades).
Indeed. I also pay for office 365 up front for 12 months with Amazon. far cheaper than microsoft! Also as you say I utilise the 5 PCs - onedrive is useful, and Outlook is far superior to free versions plus I can use it for work! Libreoffice is ok but it is far from great!
I've used OpenOffice for years on both a PC and a Mac with no compatibility issues. I can open MS files in the OpenOffice environment and can save my work as a MS file extension if I so choose. There are no ads and it functions much the same as MS Office. One thing I can't do is on the spreadsheet function, I cannot change the color of a cell based on what value that cell holds (e.g., when the sell is 100% based on a calculation the cell changes to green and when it's 0% it changes to red). Those sorts of advanced functions are not available on the free opensource programs. But, hey! It's free with subscription charges or even a one-time up-front fee. It works for me.
I think it all depends on the environment these solutions are to be used in. Libre Office is ideal for private use, i.e. the occasional word processing when there might be the necessity of writing an application or whatever and doing your household bookkeeping on the spreadsheet. No point in spending money on the MS versions. Even small independent businesses or sales representatives can cover documentation, invoicing etc. with them. However, if you enter a corporate/industrial environment, where full compatibility on one "industry standard" is required and certain incompatibilities could possibly start to become a hindrance, then of course, one might not be able to skirt MS anymore, but only then.
@@nawantabahpangestu1973 I mean that nowadays MS is the standard in the field of office throughout companies and corporations, though I currently do also see Google solutions being implemented more and more.
thing is though, if you're doing work through msoffice for your job you likely already have a company email with a subscription to msoffice suite paid for by them, so there's still no point in paying for your own subscription unless whatever personal work you're doing at home requires you to utilize niche functionalities in msoffice apps there's really no need for it
We heavily use VBA and excel macros and as long as the libreoffice doesn't fully support them, we can't just use libreoffice or any open source alternative.
I've been using Open Office on Windows for literally decades. I used Office for years at work but over the years Open Office goes on any computer I get. I can edit .docx files, but can't save to them. I can save to an earlier .doc Microsoft version, but quite frankly, it's never been an issue.
Libre Office is great and really worth using. A little bit of an issue especially with excel macros (LibreO uses a different programming language) and no equivalent to the Power BI apps.
Just switch to google…. sheets, keep, etc. for free. And have it work with ANYTHING you use. I’ve stopped using office products 5+ years ago because I don’t want to pay for basic things.
I have been using open source software for years now and never run into serious issues on my own computer. I did have an issue once after installing libreoffice on a computer at work because of the way Office handled regional settings. Basically, it all came down to Office using a period while Libreoffice used a comma (one using local regional settings while the others used the regional settings associated with the system language). It caused a problem with proprietary third-party online software that the company used all the time, so I was forced to switch back to Office (all because of a period!)
When MS tried to charge me for a very old MS office install decades ago I uninstalled it and went to Open Office. I've never looked back. It's true that MS office is a little different, but for all intents and purposes Open Office does everything I could ever want and more, and of course I've been running it on windows ever since windows xp.
The reasons I still choose to pay annually for office 365: I have multiple devices, 2 desktop, 2 laptop and some mobile devices. I don't have to worry about my files sync between those devices as 1TB OneDrive does it for me. Plus I have 5 family members and all of them using same office 365 subscription as well. Economically, the subscription model is quite cheap for me. And don't forget I live in a country where USD 100 considered to be expensive (based on income) compared to one who live in USA or Europe.
I have Office 2019. A few days ago the UI changed fairly noticeably and unexpectedly in Excel. They removed the distinctive forest green color from the title bar and now everything is very pale shades of gray. The UI elements changed their look too with a lot of rounded corners. Harder to tell which tab is selected on the ribbon menu. Supposedly it's easier to use, but I don't see it.
You can change the title bar colour back. Go to File | Account | Office Theme, and select "Colourful" from the drop-down menu. You will still be stuck with the rounded corners though.
I've been on Apache OpenOffice for years. It does everything MS Office does and its totally free. Runs on my Windoze machines as well as my Linux boxes. Fully compatible. I love it.
Google's suite is great for basic use, but MS word is absolutely loaded with functionality and tools that are extremely helpful and productive if you're in a situation that demands them.
GREAT VIDEO! I USE LIBRE OFFICE AN OPEN OFFICE AND I SPECIFY, THAT I HATE MICROSOFT SOFTWARE! IT IS ALWAYS CHAOTIC, CONFUSING AND DIFFICULT TO USE, PLUS IT HAS LOTS OF BUGS! THESE FREE OPTIONS DO A FAR BETTER JOB, UPDATE REGULARLY AND DO A GREAT JOB, PLUS THEY ARE A LOT EASIER TO USE! AND NOT OVERCLUTTERED WITH USELESS SETTINGS AND FLUFF!
My experience with buying office was that it didn't just limit to one pc at a time, but also you could only activate it like 3x. Ran into that issue really fast when I was getting indecisive about running it on my desktop or surface device and poof, no office any more, you have exceeded maximum number of activations for this software. Wonder if that issue is ongoing and relevant to your examples
@@kosbebot6360 I have downloaded ms office 2007 like 12 times on mostly 4 computers, but its possible they just dont monitor the key as of like 2012-4?
I am just a retired bloke who writes about 5 letters per year and creates the occasional spreadsheet. I have been using Libre Office for several years now, after using the MS suite for many years at work and at home. I can categorically tell you that I never have any problems whatsoever with Libre Office. (BTW Liron, the "e" on the end of Libre is silent. It's French, don't you know😘) If I need to, I can also open a word document in Libre Office, if I need to. Stop paying Microsoft money you don't have to folks.
If ur a business u can’t use free versions - also BUYING FOR A ONE OFF FEE COST 400 Home and student also can’t be used in business environment Office web apps also not useful to business - so remember to make people aware ur referring to home use Office at 10.50 a month for a business user along with mail teams and share point / one drive is great offer
The real problem is the compatibility, and that only if you're working on the same documents together with others who use MS-office, or with powerpoints, if you have to do the presentation using MS-office. Another issue is to find an alternative for outlook in an environment with an exchange server. But most of these issues are (for most people) workplace issues. It's the employers decision to use the MS office environment (often because he/his employees have to work with others in an MS-office environment), so he should provide you with the tools.
As soon as people begin using this, Microsoft will change their format (extension) and nothing will be compatible. This is great and I will give this a try from home. Thank You! ! !
Latex is the way to go for professional looking documents. The learning curve is steep though but once you get the hang of it, it is a breeze and the the documents are of superior quality, especially math formulas.
I've been using WPS Office from 2016. It has the best compatibility with MS Office 2007-2021 files in my opinion. Just some PowerPoint 2013-2021 files won't show the right animations, because of some proprietary "heavy" animations, that only MS Office has.
I started paying for it when Google discontinued the unlimited photo storage in Drive. I pay more or less the same amount Google charges for storage for 1 TB of OneDrive storage, it's fully compatible with all my devices unlike Google which really lacks apps on Windows, so it's really the best option for me to keep everything backed-up and the Office apps/programs are pretty much bonus at this point.
Excel formulas differ in higher functions.. H-lookup validate in microsoft has an operator of ‘ true or false ‘, in open office the operator is 0 or 1. Small differences in higher functions.. basically still works.
I'll stick with my old ancient machine-resident Word and Excel. Being old and retired, my needs are minimal. I'll keep my data on my machine and saved on my own media, thanks.
This a great video for those looking to switch off subscriptions, but if you’re really looking to get office suite products, then please look into just buying full versions of older MS products and then looking up videos that show you how to activate and install them. Those products keys are much cheaper than doing it this way. Either way, helpful video to help people turn in the right direction!
That is why companies have switched over to this subscription type of software "leasing". Not because it's cheaper for the customer, but to generate a steady cashflow, and in the end make more money from the same product
For all those saying Office has OneDrive cloud storage: That is NOT the point of the video. It's about showing alternative productivity suits as NOT everyone has a need for cloud storage, but everyone HAS a need to create docs.
It's like saying the reason to buy one cell phone over another is that the one gives you a free case. That may be exciting for some, but for most people they just want to know which phone is better and not which one comes with whatever add-ons. That is very secondary.
oops yeah i didn't read before writing my comment, yeah, the cloud storage is the main reason for my subscription Hehe... your right, if you're not using Office as a power user then the free options are very fine to use.
Still, this doesn't give you the right to delete people's comments (like you deleted mine)! If you don't agree with someone's opinion, comment on it, but don't just delete it because their views are different.
@@unimatrix1 dude TH-cam has a comment bug. I certainly don't delete people's comment that I don't agree with who are civil. You can see my Twitter where I have a screen recording showing this bug
@@unimatrix1 He telling the truth. It happen to me too. It seemed like that, isn't him.
Whilst I agree with your main point 1) your example is pretty poor since what possible need would someone have for a phone case without the phone. 2) I believe you should of at least briefly mentioned and addressed Onedrive in the video. I confident that a high % of people (non-business) pay the MS Office tax for this very reason, I know I do. The Office suite is a side benefit to the main benefit - 1TB storage.
I remember a time when you brought a computer these things came already installed
haha yeah. You still paid for them and the OEM version meant that it lived and died with your computer ie not transferable to a new computer.
I remember a time when people used to buy a computer rather than bring one.
Until Greed stepped in hey
Never happened with office. It happened with works and maybe just word.
I hear you,
I just bought a new HP laptop for over $1000 and I'm still unable to send a word document as an email. I'm so frustrated 😖
I've been using OpenOffice on PC for 15 so years. No problems opening non-main stream files, no adds, no bugging to upgrade to pay version. I love it.
I been using OpenOffice too with no problems at all. Same experience - no bugging me for up-dates or up-grades. Still in the exact same format and screen all this time. Spell-check is weak so I go elsewhere for that. Been thru multiple computers thanks to Micro-POS crashing them or otherwise rendering them useless. I just pull OO off the net and there it is - exactly the same as before.
One thing worth remembering is that OpenOffice is built on the source code from Star Office which started development in 1985. Microsoft Office began development in 1988. So in terms of lineage OpenOffice is older than MS office.
boom!
And it’s been discontinued for years.
libreoffice is the modern updated version of openoffice.
@@FlyboyHelosim OpenOffice had/has a nasty bug. When encountered, it wipes out all of one's work. After experiencing that a few times and seeing it wasn't addressed in years, I switched over to LibreOffice permanently. The vast majority of people use a small percent of features in productivity software. Programmers typically create what they themselves think is neat to code. So, more useless added features aren't needed but bug fix releases are important.
I thought hardly anyone used OpenOffice any more after it was forked to LibreOffice when Oracle was going to close source OO.
Im still using Office 2007 that I bought direct from Microsoft many years ago for around £20. Still works perfectly fine. Only downside is I now have to go hunting for it if I should loose my copy and need to redownload it.
But it still does everything I need it to do :)
Me too. I love the Office button. Only downside, no help available. Have to Google.
Same here, using 2010 with family license. Would purchase 2021, but it allows installation to one computer only, which might have been OK in 1997, but nowadays it is common to have more than one computer for a family. Libre/OO is no option because of a need for scripting compatibility.
libre office ;p
About the same here! Still using Office 2003! I never could be used to the switch to change the appearance with Office 2007 :-) If I will switch, I would give Libre Office a change (not sure Excel Macro's will run on it)
On my old XP computer it is still Office XP Pro .. works fine for Word and Excel .. Only downside to an older version is if you use Outlook for your emails ... They change the types of security needed from time to time and sometimes, the older version of Outlook will not work for all email providers.
Regarding Microsoft Office One Time Fee: Every time there is an upgrade, you'll have to pay - that's what is mentioned on the website. "Office 2021 is a one-time purchase that comes with classic apps like Word, Excel, and PowerPoint for PC or Mac, and does not include any of the services that come with a Microsoft 365 subscription. One-time purchases don’t have an upgrade option, which means if you plan to upgrade to the next major release, you'll have to buy it at full price."
you will not use what upgrade give you, the mjority of office users, use only 20 % of office power . so you can run with office 2013 even now, without any probleme
Indeed, but since 2007 did Microsoft make any revolutionary upgrade to the Word?
@@JG27Korny Oh... at least for 2013, it had a big upgrade, appearance and some formatting improvement
Remember you may need security update plus the office 365 iclides 1 TB Onedrive, I subscribe because of it
@@IwanTamimi updates and upgrades are 2 different things.
For example, even if your Windows 10 computer can not UPGRADE to Windows 11 because of compatibility issues, does not mean you can't continue to get Windows 10 UPDATES.
I bough Office in 2010 on DVD back then. It still works fine. No intention of paying MS anymore money.
Supposedly this month MS is going to stop security updates and so forth for 2010
"You will own nothing and you will be happy." - Real life James Bond villain.
*Cue the Bond memes*
Eat the bugs.
Give up your job and everything you own. You don't need them anymore, right?
Klaus Schwab ... Nice to see somebody awake in here ⏰ :) Bill's foundation is in his club.
Seriously scary quote.
I'm still using Windows 7 with Libre Office. I've been using it for years, never a problem - perfect.
Terrible and spectacularly insecure - I truly hope ur not using for a business -
@@Redballoon_Cartoons Can you provide source? I'm only seeing one vulnerability that happened this year.
@@fogdragon23 any and every free license is not secure. should never be used for business - the only way to protect a business environment is with security tools that COST so if your getting Office free then your not paying for security. Windows 7 is also no longer support by microsoft uless you BUY the 2020 Extended Security Update, for 50 euro, and the 2021 for 100 euro and the 2022 for 200 euro. you can't just get the latest you have to buy all three and every yr it will double in price. WHY - because you shouldn't be using windows 7 in the first place
@@Redballoon_Cartoons can you really blame them when newer versions of windows come with a lot of bloatware
@@Redballoon_Cartoons 🤦♂
I can only say bravo! I was a little tired of finding irrelevant content regarding ways to operate with Excell on Mac, and this video was so enlightening! Short, straight to the point, while also sharing a lot of actually practical information. Thank you very much for this. Have a nice day 🙌🏻
Been using WPS for a few years now. It does everything I need, for free. Never had any problems. Your videos rock!
Hey wise cat! Do you know how to type math formulas in an easy way with wps? Like i would like fractions and powers to be automatic, and the ability to write greek letters with the backslash i.e. \gamma should be the greek letter gamma
Privacy is important.
That's why I stopped using WPS Office.
@@srikrishna2561 This is the 2nd time you say this. Can you explain?
Me too. I have it on my Android tablet. Admittedly, the Android version is a bit tricky, compared to to MS Office, but that may just be the nature of Android programs. I haven't tried the Windows version, yet, because I'm still using Office 2010.
@@antoniog9814 i looked it up on wiki
It's propriety (not open source) and it's from China (Kingsoft)
I still use a retail version of office 2016 and I see no differences in usability whatsoever from the 365 version. Pretty happy with my old one.
only come may 2022, you won't be able to use this with an exchange online mailbox.
I still use the office 2007 line and never had an issue.
(The only thing is that i almost never use it so for someone that have very little need for it just get an old one and it will works perfectly)
try using XLOOKUP in Off 2016-excel
Office 2016 has old bugs and security holes that you ought to update to Office 365's up-to-date bugs and security holes. Also the old software tends to lack the siphoning of your data back to the manufacturer.
@@AlexKarasev Nah, I'll be fine... I doubt Microsoft or anyone would be interested in whatever I type there, not even close of being an industrial secret of sorts.
I have always bought office outright, being a single domestic user. It updates too. I had no idea there was any secret about it. I always assumed that the renting option was to give businesses flexibility over how many copies they needed from year to year, or if they wanted to switch to different software or systems. I expect it is a lot more expensive to buy office outright for hundreds of employees than to 'rent' it.
Home subs and Student subs go beyond business use.
The actual point of "the cloud" is so MSN (and others) can have unobstructed access to our lives via our electronics. Telling us it's "safer storage" is hogwash.
The compatibility issues are really just for opening MS docs in the free software because MS uses proprietary extensions (that obviously can't be added to free software). There should be absolutely no issues with compatibility unless you're using some super advanced features of MS office suite, which 99% of users don't even know about so don't use.
Microsoft switched to OpenXML formats 15 years ago. Many 3rd party apps handle them.
Even Microsoft Office is not compatible with previous versions, to the point that Microsoft created something called "compatibility mode".
I deleted WPS , now I can't edit the files on MW even though it's activated
So, here's what I'm doing in-spite of what this video is all about. I have a 2010 version MS Office that I am still using. It works great, no issues and I will never change unless of course my system blows up. I am also still running Windows 7 Ultimate edition and it hasn't failed me yet (knock on wood).
OK. You do you
Just store the Office key somewhere and grab a 2010 installer before they completely disappear, even if your PC fails, you can reinstall.
I'm still using Office 2000, my mother bought it back in the day and it came on 2 CDs....one contains everything, except publisher, which is on the 2nd. For 22 year old software it still works great for all I want to do, I only really use Word and Excel, and they do everything I need. On Excel, I can format the cells and write quite complicated formulas, maybe by today's standards they're basic but it's enough for me. Example, one I often use is to keep a running tally and it might go something like this; =IF(C166>0,D165-C166,"0") this one is taking away from the line above to give the tally, while formatted cells below display "0".
I miss when i was allowed to own things instead of renting, And i don't need a new version of everything every year. I been using WPS to write my books, even if it is owned by china but i almost never need a cloud. or collaborative sharing.
Been using my (officially paid for) full pro MS office suite 2003 with a 2007 update and am more than happy with that. It's 100% mine, never had any issues uploading it onto XP, Vista, Win7, Win10.
In my experience, unless you need bibliography automatic tools that Microsoft word has, open office is just enough, it has 99% of the official program tools and functions, so yeah I'm happy with open office
libre office is ok too ;-) I have no idea why there are still people out there (and businesses) that buy microsoft's word :-(
@@vasopel Is it cross compatible? I mean if I did my work in Libre or Open office & send it to a person using MS Office? Will there be an issue there? Primarily work is done in Excel! Thanks in Advance!
@@BlackHawkTejas is totally compatible, same kind of files, there might be a warning message, the same way when you open with office a Google doc file or vice versa, but by definition they all must be compatible
@@andrescarrasco1248 Thanks man for the quick reply & the answer!
@@BlackHawkTejas Andres already answered ;-) personally I never had a problem with using these 2 different suites (for example in my old job half of their PCs had MS office and the other half had libre office,nobody complained)
Keep in mind that this permanent option is usually $99 (not $149) during black friday and Christmas at many retailers.
I'll keep an eye out for that time frame. thanks!
I’ve been using the free alternatives on Windows/Linux/Mac since the earliest versions of Star Office which has since morphed and forked into Libre and Open Office. Generally I have found the free apps much better and few compatibility problems. Thanks for the tip on the fonts.
Thanks for sharing and hanging out here!
I prefer libre, been using for many years. I think it far superior to Office
@@driedbrainfreeze2149 In what ways? I am so used to everything in the Microsoft apps - I know where everything is; I am used to the ribbon, etc.
There are some powerful functions like the Dynamic Array functions (which are awesome), which I haven’t seen in the free alternatives.
BTW, I also refuse to pay for the subscription service. But I am currently using the Online versions. They are a bit stripped down, but can still do 90% of what the desktop app can do (mainly doesn’t have Power Query and Power Pivot) - and even has some features which the desktop versions do not have.
@@JJ_TheGreat have used Linux for many years so when faced with returning to Windows Libre followed. I use several different file conversions and Libre makes it a one click issue. And I'm just used to it.
@@driedbrainfreeze2149 Gotcha. That makes sense!
Yes, I started using Open Office on Linux, but I've moved back onto Windows and the Open Office is EXACTLY THE SAME as it was on Linux. Don't pay for software when you don't need to.
I love the fact that its exactly the same no matter what.
Been a Star/Open/Libre Office user since the turn of the millennium. Never had a problem with it. Formatting errors from MS docs are very rare and have got rarer with each edition.
Libre Office is far better than any other office suites available in the market.
@@aravindsarkar1255 I wouldn't say it's far better than MS Office but with 99% of the features and 100% price discount it is hard to fathom MS's continued dominance.
I've used LibreOffice an Linux and Windows for years. I can transfer files back and forth between work & home (but nothing with company confidential information) with, as you said, only some minor formatting problems. After a while, I figured out what causes this and can generally avoid it. Advanced Excel formulas are a bit more difficult at times, especially if they get data from SQL server because I can't access that data at home.
What did you identify as the typical causes of the formatting problems? I've tried using both LibreOffice and OpenOffice in the past, but eventually stopped using both as anything I did with them was practically unusable with MS Office - the formatting was so broken I basically had to start from scratch. If it was just for my own purposes it wouldn't matter, but almost everything I need office suite for is either for academic or employment purposes, so any document that's broken when opened in MS Office is a non-starter. If there's a way to avoid this, or at very least make it quick/easy to resolve, I would dearly love to know about it!
@@lachlanbell8390 I don't entirely remember. As best as I recall, I didn't use any advanced formatting. And I didn't save as .doc or .docx, but IIIRC one of the xml formats. I mainly used it for 3 or 4 page "how to" type things.
It's basically unusable where accurate formatting is crucial.
@@MJ-uk6lu Hum, I kind of understand. In such a case, I would likely use something based on TeX, like LaTeX or MiKTeX or TeXstudio (and are free on Windows, MacOS, and Linux). I avoid M$ software because M$ can, and has, changed things in the past which messes up things.
This is nice that you point out the options for people so they can make an informed decision. The reason I choose to use the paid version is that the online ones are lite (stripped down as you say) and I need some of the features that only come with the paid version.
perfect - that makes complete sense. We each need to make a decision that works for us as there is no global right or wrong.
Appreciate you hanging out here!
@@LironSegev You arguments in the video are incomplete and grossly underestimated in favor of the free versions. At points in my working life (going back to the 90s) I've rotated between OpenOffice, Libreoffice, and WPS and reverted to Ms Office due to document compatibility issues and breaking of formated layouts etc. As a person who has clients in corporate companies It can get quick embarrassing if not frustrating.
Actually, I don't have an argument in favor of the free version - I am showing that you have options. The free suits had serious compatibility issues back in the day, but this has become less of an issue with the newer versions.
Many of us use these free suits and communicate with clients and companies who use Office without any issues in 95% of the time.
If you are in the graphic design industry or mockups or require absolute precision in images and formatting, then just use Office.
Good luck
@@Sobbayi
I share in the embarrassment/frustration. But I look at it in a way that "I hope people would switch to the free suites already."
Open Document Format (odt, ods, odp, etc) hopefully becomes the standard, not Microsoft's proprietary formats (docx, xlxs, etc).
HM < I need some of the features that only come with the paid version.> Which features..
I went with SoftMaker Office which is available on Windows, Mac, IOS, and Linux. Full Compatibility with MS Office across all platforms. There is a free version, a one time pay version and a subscription option to always have the latest. Pricing is reasonable, if you choosse a paid version. They also partner with other Windows software vendors to offer lower pricing on other applications. Been using this for number of years and have never had a problem.. (I am just a customer and not in any way affiliated with SoftMaker). I just like their product.
I personally use WPS Office and I can guarantee that whatever you mentioned is 100% true! The best part was you busting the myths... Myth Busting Liron!
😂 Gotta do what you gotta do
May i ask you if you know how to type math formulas in an easy way with wps? It does not automatically write fractions or powers. Also i'm not able to write greek letters with just the backslash like \gamma would not translate into the actual greek letter gamma
Note: i'm running Ubuntu 20.04 and i also have libreoffice, however math formulas are not compatibles with ms office in general
@@giovannigiordano366 Are you asking this for Excel, PowerPoint or Word?
@@cenevspeed_CARS All of them, in particular power point. I need to build reports for my labs but it's taking ages cause open office is not compatible with Ms office when using formulas, and wps has no kind of automation or shortcut (as far as i know at least). Any help is really appreciated and would save me days of work. Thank you for your answer btw
I've tried and used all of the above free versions and while they're good, I do like and use most of the utilities office provides, however, I flat out REFUSE to pay a subscription!
In the end, I bought a licensed copy of office pro 2013, it wasn't overly expensive and offered ALL the options I wanted and use, so I'm happy :)
I've been m enjoying 'Only Office' lately. Seems to work fine so far
same mate. same. the only one thing that i wish they put it in there is the word counter. tho its not like i use that often anyway..
But it doesn't have all the features though.
Only office has much better file compatibility than Libre and OpenOffice.
Where do you backup your photos/files from your phone/computer?
I've bought office this year for the first time in 20 years of owning it (I've always used older versions that I "acquired"). But I need the more advanced data sources functionality.
Updates for the year, 1TB One drive storage and some free minutes monthly for calling phones on Skype for about €50 a year (about €4.16 a month).
There comes a time when you have to say is the €50 saved by using free software worth the extra effort.
If you're a basic user then it probably is.
If you use some of the more complex features or macros then (for me) it's not.
I've had Open Office installed for years. I rarely need to produce documents or spreadsheets nowadays so it is the perfect solution for me.
The answer is simple: Stay on old versions to avoid a forced upgrade cycle. I can do 95% of what I need with version 4.3 on Windows 3.1. The other 5% can be handled on Office 97 for the rare times I need more than 16k rows in Excel or use merged cells. Furthermore, the 2007 compatibility pack can be installed over Office 97 for the extremely rare times I need to open the newer formats. YMMV.
Exactly what I do. I'm still using Office 2000 with the free compatibility pack. Only limitation: Outlook isn't usable as an e-mail client anymore, because it's lacking security standards, that most mail providers enforce. So I replaced that with free Thunderbird and switched to Lotus Organizer 97 for the calendar part. Overall I'm very productive with these applications and I never missed anything.
Great topic dude, I use Office 2010 which I purchased back then, it does everything I need but now I get the odd compatibility issue, your link will be useful.
Looking forward to you next video
Glad it helped!
Same her, still using Office 2010.
I pay for the annual subscription. Some of my considerations included:
1) Features - I need some of the paid-only features
2) OneDrive - Being able to access documents from my various devices (laptop, desktop, and phone) is immensely beneficial
3) Compatability - I can't open Microsoft Office files with freeware alternatives
4) Continual updates - I'm not stuck with the same version
5) Value - I feel the value I get is worth the price paid
The most important part of 365 for me is the cloud anyway. I get to share files or folders, even publicly in some cases, I can cooperate on content in an environment I prefer to Google office apps and sometimes I just use Office as Office. Oh and also my entire family gets the cloud AND the office for one price.
Yup, I use the family sub for 6 1TB OneDrive accounts… and just get Office as a bonus.
Exactly my thoughts
or just use google drive?
@@hondaland_ for 1To and perfect integration?
@@hondaland_ why would you entrust Google with your documents?
Thank you so much for the video!
Is there any trustworthy website to get Office 2021 for cheap?
BNH Software is a great web.
I love their customer support, Hope this information will help you.
I use softmaker office. reasonably priced, no need to update yearly ore ever if you don't want to. Opens and saves Microsoft files no problem.
Softmaker Office is just great.
As much as I loved libre office when I was in my early 20s, now that I work in an office environment and collaborate with others- everyone uses Google Docs or Office 365. Nobody wants to email files back and forward and version control is a key feature. Cloud hosting and file sharing is the most important aspect of office productivity where we can track changes is an essential aspect for any job. It’s worth the cost.
The Microsoft office alternatives work very well with the exception of Microsoft Excel alternatives. Something as simple as a pivot table sadly doesn't work using the free software
I work with many companies that licensed office 16 and have not upgraded. Excel has added powerful stiff they lack.
* filter
* sort
* unique
* textjoin
* let
* lambda
Some don't even have power pívot and their power query is literally years behind.
If you are a power user, excel has no real competition.
If you don't even know how to use Vlookup, subtotal and if, any free suite will be enough.
You are great at providing useful insights. I, as do most people, worry about years of saving documents in MS apps (years ago I used Word Perfect) that will not be compatible or require extensive cleaning up and, so, skipped moving over to another office suite of docs. You have cleared up my fear about doing that. Thanks.
I’d never even heard of LibreOffice, but it sounds better than giving gates more $$
I switched to Open source for pretty much all my productivity software, I am a home user not a big business. I am not going to pay hundreds of dollars for software I don't rely on... honestly even if I did, I would still stay with open source. Half of what your paying for is the name corporation that makes the software, and the only benefit really is it is a bit more user friendly.
You see, the most important point of buying the yearly office (family edition) is that each user gets 1TB of cloud storage on OneDrive! With more and more photos being taken on phones etc, you can set them to upload to the OneDrive, no need to worry about backups etc. So the cloud storage you get is less than you'd pay with other 3rd party offerings alone! I have also never paid the full price for Office, in the UK, is £79.99 for the 6 users family version, I have always paid £50 or less when on offer (multiple times per year), so when an offer is available, you can stack them, I got 4 years remaining.
If you are not bothered about cloud storage, you can also just buy the licence for as little as £20-30 online (legit) for the full version of the latest MS Office, including Outlook.
"he" didn't. The focus is on the suite not the storage. He also didn't mention Dropbox 🤦♂️
You certainly are. My hero
The simple fact is the family suite comes with 1TB of free cloud storage per user, and Dropbox isn't part of Microsoft so no idea why you're mentioning them!? What reputable provider offers 1TB of storage for the equivalent of $15 per year?
😂 He deleted this comment.
@@bennyceca a company that makes an absolute buttfuckload of money offering this service to enterprise, and giving a cut down service to consumers for dirt cheap.
Been using open office for 15 years. On a side note, when Adobe went the same subscription way, I left them and while I still have cs2 on a machine, I started using Gimp. These companies and their overpriced software are not needed anymore.
True. Way overpriced and even worse now when we are force to pay monthly for usage.
I was using Office for decades and was a pretty competent user. Then I started using Sheets and Docs because that was what my company was using. When I left I wanted to go back to Office and bought a “subscription.” I can’t believe how much it had been changed. The easiest functions became a nightmare. For example I’m working on a 100 page document. I can’t figure out how to jump to a page, let’s say 89 without scrolling to get there. Help is useless and a Google search has come up empty. Many other which used to be simple are a struggle . Even the main headings have been changed. Why would Microsoft do this?
in MS Words press Ctrl + G
in PPT in Slide Show mode type slide number you want to go
WOW This is all I need to create simple documents and write my book, and I love the templates more than office. Thanks Liron, you are great!!!!
For students, small associations, your first resume or occasional use cases, LibreOffice is actually great. But for pros, there's no beating about the bush: MS Office remains the gold standard. As much as I hate Microsoft, I gotta admit that I renew my 365 sub every year, cause I can't afford any incompatibility with my documents. Business and clients first!
2 issues: 1.)if you use office online you cant use it when your offline
2.) MS office has some cool features like powerquery which is a feature since office 2016 which is not availble in libre office etc
What is powerquery
@@HMMELD Power Query is for data analysis and automation. Its an addon since Office 2016. Check out some videos on the same.
I've been using OpenOffice for I dunno how many years now, probably almost two decades, I started with 1.x. I create several documents every day with oodles of formatting. I have found no shortcomings when compared to MS Office and f-r-e-e fits right in my budget.
Same here - OO at least 10 years. No problems.
I have been using Libre Office for years, never had a problem, updates properly and works like a charm, and NO ADS EVER.
Actually, the family subscription is great - you get all of the stuff for 5*6 installs, and always have the latest versions. Of course, if you use excel for making shopping lists, you may not need the latest versions with their new cool functions.
Using alternative office apps works until you need to work with Ms office files which are somewhat complex.
Have been using OpenOffice and LibreOffice for past years until recently when more people in my household need to cloud storage and a have lots of email to manage.
The family pack is way more convenient and cost effective when there are more people willing to share the fee.
If it weren't for this purchase, i wouldn't ever have known how useful Microsoft Access is to manage stuff.
For Mac users, Pages, Numbers, and Keynote which formally were bundled as iWorks, and prior to that AppleWorks all function well enough, and are on all iPhones, iPads, and Macs. I haven’t used Microsoft Office for well over a decade. Open Office is something I download on all my computers too…
…
I didn't need to be convinced. But I'm share this with others. Saves me from explaining them. Great stuff.
This is useful for home people but not most businesses. They are addicted to outlook, its invites , and also need teams for meetings.
Thanks for showing the options. Suggestions to others is try the free version before spending their money. I lost the use of my older version of Office when I went to a new computer. Been using the online version, but it feels a little clunky compared to the computer based version. Will try Libre Office before I subscribe or purchase the new Microsoft version. - Thanks again.
I have managed to install Office 2000 on Windows 10. It did throw up some errors, but I was able to bypass them, and word and excel did at least seem to load ok, so not sure what the errors would affect?
I was forced to find a free alternative to Microsoft Word when I was busy doomsday prepping my trusty laptop. I picked LibreOffice 7.2 as I have heard it was the best one out there.
I have now been using LibreOffice for the past four months and I really love it. I write a lot and this software has never failed me yet. It prints perfectly and the design is very similar (but not exactly identical) to Windows XP Word. I definitely would recommend this one for you readers to try.
Microsoft's business model is going to force customers to make some serious choices soon. Given current circumstances many will make the choice that the price of staying loyal is just not worth it.
@C.: Assumedly one part of that is that people may need to cut back on subscriptions, especially now given the rise in the cost of living(?)
Started using Linux full time decades ago. Haven't bought an OS or office application since the 90's. It hasn't been perfect but for the most part is has met my needs. I'm not a gamer and I do not do sophisticated macros in my documents so Linux/Libreoffice is satisfactory.
Your mileage may vary.
Those software publishers that came up with the annual fee business model actually did me a favor, as it got me to search out one-time paid apps that were superior, at least for my needs, than what Adobe Acrobat and Microsoft Publisher offered with their fee-based apps.
All I learned from my search is that there is no alternative to Word.
I pay $35/month for full-blown Office 365 (all the apps). It gives me 5 completely legit separate installs. This is a far better way for me to have Office than any other option (including past options where you paid $300-$500 each depending on the number of apps you get. And since I work from home for my company, and use my own computer to do it, that cost is tax deductible. This subscription also gives me full upgrades at no additional costs every time they are released.
The installs are still only virtual running of the programs. If you think not, disconnect from the Internet, restart your computer and try running the programs again.
How do you get that price?
You totally forgot to say something about formulas and VBA capabilities of Excel. I worked in small companies up to enterprises since the birth of Excel and VB, and I have to say that in the last 15 years I did not see any serious Excel worksheet without moderate to heavy use of formulas and frequently also VB custom functions or macros. How do behave all the free office tools?
The amount of work some. People. Put in Excell, just hire a programmer
If i'm not wrong, there's a VBA support library for WPS office. I haven't test it out though
They run fine in libre, I run macros and vba functions on my excel files in libre office.
@@cubbucca And what about formulas? is there 100% compatibility?
Only Office use python for its macro language of choice... Far superior to VBA imho
I was shocked when I discovered the LibreOffice stuff. I had to adjust to not using VBA, but I've converted so many people to it who are angry paying the MS subscription fee.
Basically, there are more than enough free options out there, but people are just over-paying Microsoft just to use the Designer.
or worse - overpay just to use Word and Excel....
I just stopped using my MS Office 2007
I bought in 2008 :) Got my money out of that purchase... now retired, I don't produce work documents anymore but bust a lot of numbers using google sheets and all my excel files have opened and worked fine... People, there are OPTIONSs and as the creator noted, if you're not share files - it's probably not an issue any differences that may exist... Thanks for the video sir :)
Btw compatibility issues are represented in the different MS Office versions as well. I’m working at a book company as an IT guy. We have a lot of problems because of colleges using different types of MS Office. The only thing that makes harder to change that people have habits and they really not like if they have to learn new things especially if they developed their workflow in a few years.
I used Office 2007 for years. I found a full registered copy at a consignment shop for $1.00, and it got me though college and University. I got my Master's degree with Microsoft office 2007, and never need to renew subscriptions. These are free when you are in school but I much prefer the 2007 one.
Great content Liron! I always set the Libre files to save as the corresponding MS extensions by default but didn't think to change the default font to calibre. Great tip! Cheers
I know it's not terribly relevant for lots of people is that a family license allows installation on up to 5 computers. This - and OneDrive is the only reason I'm still subscribing for it. Also I use it for work and it can be confidential documents I'm not allowed to use on a cloud solution. But for most people this is great advice.
I partially agree with you, but there's a point almost no one explains...
With Microsoft 365 you can install Office (with all the apps e.g. Publisher, Outlook, etc.) on 5 PCs, tablets, and phones. I mean this is a real advantange you'd consider before buying a single installation for the full price (without having the possibility to get all the future upgrades).
Indeed. I also pay for office 365 up front for 12 months with Amazon. far cheaper than microsoft! Also as you say I utilise the 5 PCs - onedrive is useful, and Outlook is far superior to free versions plus I can use it for work! Libreoffice is ok but it is far from great!
I've been using OfficeSuite on Android and PC for 5 so years. No problems opening non-main stream files. I love it.
Still using Office 2000 after all these years.
I've used OpenOffice for years on both a PC and a Mac with no compatibility issues. I can open MS files in the OpenOffice environment and can save my work as a MS file extension if I so choose. There are no ads and it functions much the same as MS Office. One thing I can't do is on the spreadsheet function, I cannot change the color of a cell based on what value that cell holds (e.g., when the sell is 100% based on a calculation the cell changes to green and when it's 0% it changes to red). Those sorts of advanced functions are not available on the free opensource programs. But, hey! It's free with subscription charges or even a one-time up-front fee. It works for me.
I think it all depends on the environment these solutions are to be used in. Libre Office is ideal for private use, i.e. the occasional word processing when there might be the necessity of writing an application or whatever and doing your household bookkeeping on the spreadsheet. No point in spending money on the MS versions.
Even small independent businesses or sales representatives can cover documentation, invoicing etc. with them.
However, if you enter a corporate/industrial environment, where full compatibility on one "industry standard" is required and certain incompatibilities could possibly start to become a hindrance, then of course, one might not be able to skirt MS anymore, but only then.
I tried using Libre Calc solver to complete linear programming OSCM models. It didn’t work at all. I reverted back to excel.
What do you mean by "industry standard"?
@@nawantabahpangestu1973 I mean that nowadays MS is the standard in the field of office throughout companies and corporations, though I currently do also see Google solutions being implemented more and more.
Libre is only ideal if you are a techie person. It's far from ideal when you aren't.
thing is though, if you're doing work through msoffice for your job you likely already have a company email with a subscription to msoffice suite paid for by them, so there's still no point in paying for your own subscription
unless whatever personal work you're doing at home requires you to utilize niche functionalities in msoffice apps there's really no need for it
We heavily use VBA and excel macros and as long as the libreoffice doesn't fully support them, we can't just use libreoffice or any open source alternative.
One drive is in the Microsoft 365 which is actually important depending on the type of work, hence the subscription is important.
I've been using Open Office on Windows for literally decades. I used Office for years at work but over the years Open Office goes on any computer I get. I can edit .docx files, but can't save to them. I can save to an earlier .doc Microsoft version, but quite frankly, it's never been an issue.
Libre Office is great and really worth using. A little bit of an issue especially with excel macros (LibreO uses a different programming language) and no equivalent to the Power BI apps.
Libre is awful.
Just switch to google…. sheets, keep, etc. for free. And have it work with ANYTHING you use. I’ve stopped using office products 5+ years ago because I don’t want to pay for basic things.
I have been using open source software for years now and never run into serious issues on my own computer. I did have an issue once after installing libreoffice on a computer at work because of the way Office handled regional settings. Basically, it all came down to Office using a period while Libreoffice used a comma (one using local regional settings while the others used the regional settings associated with the system language). It caused a problem with proprietary third-party online software that the company used all the time, so I was forced to switch back to Office (all because of a period!)
When MS tried to charge me for a very old MS office install decades ago I uninstalled it and went to Open Office. I've never looked back. It's true that MS office is a little different, but for all intents and purposes Open Office does everything I could ever want and more, and of course I've been running it on windows ever since windows xp.
Libre is ok, but it looks like it's always 10 years behind the real Office.
Right 👍
The reasons I still choose to pay annually for office 365: I have multiple devices, 2 desktop, 2 laptop and some mobile devices. I don't have to worry about my files sync between those devices as 1TB OneDrive does it for me. Plus I have 5 family members and all of them using same office 365 subscription as well. Economically, the subscription model is quite cheap for me. And don't forget I live in a country where USD 100 considered to be expensive (based on income) compared to one who live in USA or Europe.
I have Office 2019. A few days ago the UI changed fairly noticeably and unexpectedly in Excel. They removed the distinctive forest green color from the title bar and now everything is very pale shades of gray. The UI elements changed their look too with a lot of rounded corners. Harder to tell which tab is selected on the ribbon menu. Supposedly it's easier to use, but I don't see it.
You can change the title bar colour back. Go to File | Account | Office Theme, and select "Colourful" from the drop-down menu.
You will still be stuck with the rounded corners though.
I've been on Apache OpenOffice for years. It does everything MS Office does and its totally free. Runs on my Windoze machines as well as my Linux boxes. Fully compatible. I love it.
I’ve never paid Microsoft for anything. I use google’s stuff for free
Google's suite is great for basic use, but MS word is absolutely loaded with functionality and tools that are extremely helpful and productive if you're in a situation that demands them.
GREAT VIDEO! I USE LIBRE OFFICE AN OPEN OFFICE AND I SPECIFY, THAT I HATE MICROSOFT SOFTWARE! IT IS ALWAYS CHAOTIC, CONFUSING AND DIFFICULT TO USE, PLUS IT HAS LOTS OF BUGS! THESE FREE OPTIONS DO A FAR BETTER JOB, UPDATE REGULARLY AND DO A GREAT JOB, PLUS THEY ARE A LOT EASIER TO USE! AND NOT OVERCLUTTERED WITH USELESS SETTINGS AND FLUFF!
My experience with buying office was that it didn't just limit to one pc at a time, but also you could only activate it like 3x. Ran into that issue really fast when I was getting indecisive about running it on my desktop or surface device and poof, no office any more, you have exceeded maximum number of activations for this software. Wonder if that issue is ongoing and relevant to your examples
Even the old disc copies sold at stores had 3 activations max
@@kosbebot6360 I have downloaded ms office 2007 like 12 times on mostly 4 computers, but its possible they just dont monitor the key as of like 2012-4?
I am just a retired bloke who writes about 5 letters per year and creates the occasional spreadsheet. I have been using Libre Office for several years now, after using the MS suite for many years at work and at home. I can categorically tell you that I never have any problems whatsoever with Libre Office. (BTW Liron, the "e" on the end of Libre is silent. It's French, don't you know😘) If I need to, I can also open a word document in Libre Office, if I need to. Stop paying Microsoft money you don't have to folks.
how about free pdf editor sir?
If ur a business u can’t use free versions - also BUYING FOR A ONE OFF FEE COST 400
Home and student also can’t be used in business environment
Office web apps also not useful to business - so remember to make people aware ur referring to home use
Office at 10.50 a month for a business user along with mail teams and share point / one drive is great offer
The real problem is the compatibility, and that only if you're working on the same documents together with others who use MS-office, or with powerpoints, if you have to do the presentation using MS-office. Another issue is to find an alternative for outlook in an environment with an exchange server.
But most of these issues are (for most people) workplace issues. It's the employers decision to use the MS office environment (often because he/his employees have to work with others in an MS-office environment), so he should provide you with the tools.
As soon as people begin using this, Microsoft will change their format (extension) and nothing will be compatible.
This is great and I will give this a try from home.
Thank You! ! !
lets hope not!!!
Latex is the way to go for professional looking documents. The learning curve is steep though but once you get the hang of it, it is a breeze and the the documents are of superior quality, especially math formulas.
I've been using WPS Office from 2016. It has the best compatibility with MS Office 2007-2021 files in my opinion. Just some PowerPoint 2013-2021 files won't show the right animations, because of some proprietary "heavy" animations, that only MS Office has.
Learn how to use Corel WP office suite, might take some time for retraining but worth it and cheaper.
I still use office 97 that I paid for yrs ago.
Great video I always thought that the latest office was a ripoff making you pay every year
and you still use windows vista huh?
@@carbonarrow7 no windows 10 , did prefer windows 7 though
I started paying for it when Google discontinued the unlimited photo storage in Drive. I pay more or less the same amount Google charges for storage for 1 TB of OneDrive storage, it's fully compatible with all my devices unlike Google which really lacks apps on Windows, so it's really the best option for me to keep everything backed-up and the Office apps/programs are pretty much bonus at this point.
Excel formulas differ in higher functions.. H-lookup validate in microsoft has an operator of ‘ true or false ‘, in open office the operator is 0 or 1. Small differences in higher functions.. basically still works.
I'll stick with my old ancient machine-resident Word and Excel. Being old and retired, my needs are minimal. I'll keep my data on my machine and saved on my own media, thanks.
This a great video for those looking to switch off subscriptions, but if you’re really looking to get office suite products, then please look into just buying full versions of older MS products and then looking up videos that show you how to activate and install them. Those products keys are much cheaper than doing it this way. Either way, helpful video to help people turn in the right direction!
That is why companies have switched over to this subscription type of software "leasing". Not because it's cheaper for the customer, but to generate a steady cashflow, and in the end make more money from the same product