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.
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.
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.
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 🙌🏻
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.
@@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 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.
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.
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'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".
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'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.
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?
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.
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).
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.
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.
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'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 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.
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
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
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.
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.
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.
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.
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 :)
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'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.
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 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.
FYI having cloud storage is not a security for your files. Because I have all of my documentation backed up off line as well as on line and I study the damages of ransom ware and other viruses so that I can remove or rescue clients computers, I have a computer linked to both drop box, one drive and google drive. I released a ransom virus on the computer and it not only encrypted all the files on the computer it wiped out all of the files on the cloud drives because they were connected. For me it was not a problem because I have several computers that I keep off line that have duplicate files, I also have every file duplicated in triplicate off line. Instead of paying a criminal $1000.00 after studying how the virus worked, I wiped the computer and the cloud drives, reloaded the clone and the computer was right back running. Cloud drives as long as they are connected to your computer the data is not secure.
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?
Idk mate, Microsoft 365 Family split six ways is like $18 a year lol. AND that gives you 1000gb of cloud storage + extra apps + copilot included. The payback period for a single-use license is multiple YEARS after which you would be buying the next version of office anyway. What's the point
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
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
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.
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
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.
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.
You totally skipped over the cost of buying MS Office and not subscribing. Many users, myself included, use many of the office apps. Subscription rates are about $100 a year for 5 computers. Not bad. Not to mention that buying the software you are limited to the number of updates you get with that version. Office has a update cycle of every few years, so why would it make any sense to pay $500 or more one time and only get a few years of updates? If I rebuy the program every year (and I use to do this before Office 365) I would spend $1000 over 5 year period. With the subscription, I get updates all the time and over the same 5 years only pay $500. And did I say I can install all the programs on up to 5 computers, and sometime the cost of a year subscription is sold at at significant discount? ($50 is the best price I have purchased office 365 for ) This comes down to $20 per person per year or less when installed on 5 computers for 5 people. If your going to push the free stuff, and there's nothing wrong with that. Then you owe it to your viewers to tell them the other side of the story as well. Other than that, your video was well made. Thank you.
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
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 simply started a free trial of Office E5. For some reason you don't need the credit card to do it. And I think you can use your phone number several times.
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.
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 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
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?
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.
I bought the one time suite and when I went to download they made it NEARLY impossible without signing up for 360. I don’t even remember how I did it now. It cost me two days of frustration 🙄🙄🙄
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.
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.
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 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 paid for office when I bought my macbook in 2015. I had it serviced and they deleted everything on my hard drive. No big deal! I'll just redownload office. it won't let me because of the subscription service. How can I legally get access to the version I paid for? 🤔 :( the apple store just tells me to log in on MS Office's website with my apple ID but that does nothing :( 💔
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
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!
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.
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.
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!)
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.
Office 2016 still works just fine, and I only paid $10 for it...legitimately, through my job. It's also how I have Windows 10 Pro--I just used the key from Windows 7 Pro, which also cost me about $10. While I do have OneDrive, I don't really use it--I always have backups, so why do I need them? With modern storage devices, I can carry an enormous amount of data on me, and not have to worry about connecting to the internet.
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 have had copies of Microsoft Office since it came out. I now have it on 3 desktop computers. Yesterday I wrote a DRAFT Memo. Went to access it today - got a message from Microsoft that I must copy it to OneDrive + now my Window version no longer lists that I have Excel, Word, etc. I have been retired for 20 years, now 70 years old, I do not need to have my files on OneDrive so I can access them from any location. I stay home. AND I was never asked if I wanted to switch to OneDrive - Microsoft switched me.
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.
The only downside is that Office 2021 one-time purchase doesn't give the benefits of OneDrive premium, as in 1,024 GB of OneDrive storage added onto the 5 GB, as well as things like OneDrive Vault and Microsoft Defender. It also has a 5 Windows-specific device limit. However, if you aren't heavy on files and only have one Windows PC, paying $150 for Word, Excel, and PowerPoint will save money in the long run.
I've used Open Office off and on for years. One time a former boss wanted to change to Libre Office and we found that work instructions in calc (excel substitute) did not translate between the two. They had photos with added arrows and text and the arrows and text showed up in the wrong places and pointing in all directions so I would not recommend using the free programs unless you are working alone or all of your team has the same program. Calc has formulas like Excel but the functions do not necessarily have the same names.
MS office itself is free. If you dont subscribe or authenticate it, it only shows the dialog box in the beginning or something which u can always ignore. Windows itself is free, the paid authentication only activates Windows defender antivirus. But we can use any third party antivirus for that.
Worked with OpenOffice for years, but then around 4 years ago when I moved over to Windows 10 it became very unstable and kept on crashing forcing you to have to save every few minutes, especially when I tried to insert graphics. Got Office 360 and never had any problems. You get what you pay for.
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.
You can also buy old Licenses, which were resold. Got a license for two machines for office 2021 for something around 30€ early this year. Legally and with full functionality
Most free versions of apps are very limited. For basic use, it's fine but if you're serious about making school or semi professional documents the free version of Office doesn't cut it. I actually using online office because I could get 1TB of storage for the price of office.
I still use the Office 2016 since I got it in 2017. As long as it keeps working I see no reason to switch. The moment it breaks I will switch to Libre Office though. The only real thing I would be missing is Outlook.
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 😖
"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'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.
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.
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.
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 🙌🏻
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
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'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 🤦♂
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 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.
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 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
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)
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".
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'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.
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
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.
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.
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.
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.
This is useful for home people but not most businesses. They are addicted to outlook, its invites , and also need teams for meetings.
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'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 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!
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
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
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?
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.
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.
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.
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 :)
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'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.
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 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.
I didn't need to be convinced. But I'm share this with others. Saves me from explaining them. Great stuff.
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 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.
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.
FYI having cloud storage is not a security for your files. Because I have all of my documentation backed up off line as well as on line and I study the damages of ransom ware and other viruses so that I can remove or rescue clients computers, I have a computer linked to both drop box, one drive and google drive. I released a ransom virus on the computer and it not only encrypted all the files on the computer it wiped out all of the files on the cloud drives because they were connected. For me it was not a problem because I have several computers that I keep off line that have duplicate files, I also have every file duplicated in triplicate off line. Instead of paying a criminal $1000.00 after studying how the virus worked, I wiped the computer and the cloud drives, reloaded the clone and the computer was right back running. Cloud drives as long as they are connected to your computer the data is not secure.
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
Idk mate, Microsoft 365 Family split six ways is like $18 a year lol. AND that gives you 1000gb of cloud storage + extra apps + copilot included. The payback period for a single-use license is multiple YEARS after which you would be buying the next version of office anyway. What's the point
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.
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.
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.
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
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!!!!
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.
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.
You totally skipped over the cost of buying MS Office and not subscribing. Many users, myself included, use many of the office apps. Subscription rates are about $100 a year for 5 computers. Not bad. Not to mention that buying the software you are limited to the number of updates you get with that version. Office has a update cycle of every few years, so why would it make any sense to pay $500 or more one time and only get a few years of updates? If I rebuy the program every year (and I use to do this before Office 365) I would spend $1000 over 5 year period. With the subscription, I get updates all the time and over the same 5 years only pay $500. And did I say I can install all the programs on up to 5 computers, and sometime the cost of a year subscription is sold at at significant discount? ($50 is the best price I have purchased office 365 for ) This comes down to $20 per person per year or less when installed on 5 computers for 5 people. If your going to push the free stuff, and there's nothing wrong with that. Then you owe it to your viewers to tell them the other side of the story as well. Other than that, your video was well made. Thank you.
Did you watch the video? 👀
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 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
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 simply started a free trial of Office E5. For some reason you don't need the credit card to do it. And I think you can use your phone number several times.
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.
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 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
I've been using OfficeSuite on Android and PC for 5 so years. No problems opening non-main stream files. I love it.
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?
You are the first Tuber in 2021 who mentioned more than one alternative to Microsoft Office Free&paid, thanks for sharing.
Happy to help!
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(?)
I bought the one time suite and when I went to download they made it NEARLY impossible without signing up for 360. I don’t even remember how I did it now. It cost me two days of frustration 🙄🙄🙄
That's why I'm here, I've had it with what they do; paying for inconvenience, frustration, etc., I'm done.
One drive is in the Microsoft 365 which is actually important depending on the type of work, hence the subscription is important.
I have been using Libre Office for years, never had a problem, updates properly and works like a charm, and NO ADS EVER.
Still using Office 2000 after all these years.
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.
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.
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 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 paid for office when I bought my macbook in 2015. I had it serviced and they deleted everything on my hard drive. No big deal! I'll just redownload office. it won't let me because of the subscription service. How can I legally get access to the version I paid for? 🤔 :( the apple store just tells me to log in on MS Office's website with my apple ID but that does nothing :( 💔
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
This is literally the most helpful channel on TH-cam.
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!
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.
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.
I've been using libre office for years. I give up on Widows and Microsoft expensive products.
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!)
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.
how about free pdf editor sir?
Office 2016 still works just fine, and I only paid $10 for it...legitimately, through my job. It's also how I have Windows 10 Pro--I just used the key from Windows 7 Pro, which also cost me about $10. While I do have OneDrive, I don't really use it--I always have backups, so why do I need them? With modern storage devices, I can carry an enormous amount of data on me, and not have to worry about connecting to the internet.
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 have had copies of Microsoft Office since it came out. I now have it on 3 desktop computers. Yesterday I wrote a DRAFT Memo. Went to access it today - got a message from Microsoft that I must copy it to OneDrive + now my Window version no longer lists that I have Excel, Word, etc.
I have been retired for 20 years, now 70 years old, I do not need to have my files on OneDrive so I can access them from any location. I stay home.
AND I was never asked if I wanted to switch to OneDrive - Microsoft switched me.
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.
The only downside is that Office 2021 one-time purchase doesn't give the benefits of OneDrive premium, as in 1,024 GB of OneDrive storage added onto the 5 GB, as well as things like OneDrive Vault and Microsoft Defender. It also has a 5 Windows-specific device limit.
However, if you aren't heavy on files and only have one Windows PC, paying $150 for Word, Excel, and PowerPoint will save money in the long run.
Libre is ok, but it looks like it's always 10 years behind the real Office.
Right 👍
Nobody talks about OnlyOffice. It has full compatibility with documents, plus it's free, multiplatform and does not feature ads
I've used Open Office off and on for years. One time a former boss wanted to change to Libre Office and we found that work instructions in calc (excel substitute) did not translate between the two. They had photos with added arrows and text and the arrows and text showed up in the wrong places and pointing in all directions so I would not recommend using the free programs unless you are working alone or all of your team has the same program. Calc has formulas like Excel but the functions do not necessarily have the same names.
MS office itself is free. If you dont subscribe or authenticate it, it only shows the dialog box in the beginning or something which u can always ignore. Windows itself is free, the paid authentication only activates Windows defender antivirus. But we can use any third party antivirus for that.
Worked with OpenOffice for years, but then around 4 years ago when I moved over to Windows 10 it became very unstable and kept on crashing forcing you to have to save every few minutes, especially when I tried to insert graphics. Got Office 360 and never had any problems. You get what you pay for.
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.
You can also buy old Licenses, which were resold. Got a license for two machines for office 2021 for something around 30€ early this year. Legally and with full functionality
Excellent! I learned more in seconds with you in Libre than months fumbling on my own lol ⭐👍
Most free versions of apps are very limited. For basic use, it's fine but if you're serious about making school or semi professional documents the free version of Office doesn't cut it. I actually using online office because I could get 1TB of storage for the price of office.
I still use the Office 2016 since I got it in 2017. As long as it keeps working I see no reason to switch. The moment it breaks I will switch to Libre Office though. The only real thing I would be missing is Outlook.