What Microsoft doesn’t want you to know about Microsoft Office

Рет қаралды 2,434,386

2 жыл бұрын

Stop paying for Microsoft Office every year! Microsoft has an option that allows you to buy office if you really want it and there are a bunch of options out there that you should be looking at instead!
SUBSCRIBED YET?
kzfaq.info...
Microsoft Office One Time Fee: www.microsoft.com/en-us/micro...
LibreOffice: www.libreoffice.org/
OpenOffice: www.openoffice.org/
WPS: www.wps.com/
I bought Windows 10 Pro for $3 - does that license key work? : • Do $3 Windows 10 and W...
Can you trust Google Drive and Microsoft OneDrive? • Storing your files in ...
BIG MISTAKE switching to Linux from Windows • Don't switch to Linux ...
#TheTechieGuy
Need to get faster wifi and faster internet? Is your gaming lagging and your zoom buffering? What is a Mesh WiFi and WiFi 6?
I show you all you need to know about faster and better connectivity with the best router settings, wifi optimization, wifi tips and internet bandwidth performance tricks and even boosting speed apps.
My name is Liron Segev, aka TheTechieGuy, and I make tech simple for everyone to understand - I answer your technology questions making so you are more productive more efficient, and getting more out of your phones, gadgets, and apps
Liron Segev aka TheTechieGuy
TheTechieGuy.com

Пікірлер: 1 700

@LironSegev 2 жыл бұрын

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.

@Nothuman76 2 жыл бұрын

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.

@unimatrix1 2 жыл бұрын

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.

@LironSegev 2 жыл бұрын

@@unimatrix1 dude KZfaq 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

@Tito23452 2 жыл бұрын

@@unimatrix1 He telling the truth. It happen to me too. It seemed like that, isn't him.

@stirech 2 жыл бұрын

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.

@audioaddict420 2 жыл бұрын

I remember a time when you brought a computer these things came already installed

@LironSegev 2 жыл бұрын

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.

@sherlock.homeless Жыл бұрын

I remember a time when people used to buy a computer rather than bring one.

@lisam8358 Жыл бұрын

Until Greed stepped in hey

@Dave-lx6ml Жыл бұрын

Never happened with office. It happened with works and maybe just word.

@benjaminmurray3504 Жыл бұрын

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 😖

@4richis Жыл бұрын

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 🙌🏻

@AlexParkYT 2 жыл бұрын

"You will own nothing and you will be happy." - Real life James Bond villain.

@fvrrljr 2 жыл бұрын

*Cue the Bond memes*

@NeverMetTheGuy 2 жыл бұрын

Eat the bugs.

@salserokorsou 2 жыл бұрын

Give up your job and everything you own. You don't need them anymore, right?

@ideastoragedb 2 жыл бұрын

Klaus Schwab ... Nice to see somebody awake in here ⏰ :) Bill's foundation is in his club.

@davidchristensen2970 2 жыл бұрын

Seriously scary quote.

@andrewsstuffy 2 жыл бұрын

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.

@LironSegev 2 жыл бұрын

boom!

@Ulven3829 2 жыл бұрын

And it’s been discontinued for years.

@milohoffman274 2 жыл бұрын

libreoffice is the modern updated version of openoffice.

@chronos401 2 жыл бұрын

@@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.

@nowthatsjustducky 2 жыл бұрын

I thought hardly anyone used OpenOffice any more after it was forked to LibreOffice when Oracle was going to close source OO.

@bobf2206 2 жыл бұрын

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.

@HMMELD 2 жыл бұрын

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.

@psa110 2 жыл бұрын

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.

@bungalowmo 5 ай бұрын

I’d never even heard of LibreOffice, but it sounds better than giving gates more $$

@CrashLoopBackOff-K8s 2 жыл бұрын

Just found your channel. I appreciate the information and the enthusiasm -- subscribed and leaving this comment for the algorithm. Keep up the good work.

@welshtony1 2 жыл бұрын

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 :)

@wharpblast264 2 жыл бұрын

Me too. I love the Office button. Only downside, no help available. Have to Google.

@Ostap1974 2 жыл бұрын

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.

@faguolvlv 2 жыл бұрын

libre office ;p

@chrix2381 2 жыл бұрын

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)

@85rx7se 2 жыл бұрын

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.

@Cyba_IT 2 жыл бұрын

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

@clary5739 Жыл бұрын

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!!!!

@Exceltrainingvideos 2 жыл бұрын

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."

@skyfreeman5461 2 жыл бұрын

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

@JG27Korny 2 жыл бұрын

Indeed, but since 2007 did Microsoft make any revolutionary upgrade to the Word?

@Dominus_Potatus 2 жыл бұрын

@@JG27Korny Oh... at least for 2013, it had a big upgrade, appearance and some formatting improvement

@IwanTamimi 2 жыл бұрын

Remember you may need security update plus the office 365 iclides 1 TB Onedrive, I subscribe because of it

@Chepakishui 2 жыл бұрын

@@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.

@Cat-wl2ub 2 жыл бұрын

Been using WPS for a few years now. It does everything I need, for free. Never had any problems. Your videos rock!

@giovannigiordano366 2 жыл бұрын

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

@srikrishna2561 2 жыл бұрын

Privacy is important. That's why I stopped using WPS Office.

@antoniog9814 2 жыл бұрын

@@srikrishna2561 This is the 2nd time you say this. Can you explain?

@jublywubly 2 жыл бұрын

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.

@adamfuller3035 2 жыл бұрын

@@antoniog9814 i looked it up on wiki It's propriety (not open source) and it's from China (Kingsoft)

@johnmckown1267 2 жыл бұрын

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.

@lachlanbell8390 28 күн бұрын

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!

@johnmckown1267 28 күн бұрын

@@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.

@jasondugas8184 2 жыл бұрын

Appreciate you making these videos, great content and production. You had me at "remember when..." lol. Cheers.

@nv1493 2 жыл бұрын

If there's something that is truly helpful, its someone that knows computers and software that can clearly explain to a "surface user" like me. I used your MS tips on stopping misc apps, privacy etc. Great help, subscribed.

@bhangrafan4480 2 жыл бұрын

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.

@longrolstral 9 ай бұрын

Home subs and Student subs go beyond business use.

@cliftonmcnalley8469 7 ай бұрын

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.

@HeatherMajors 2 жыл бұрын

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.

@LironSegev 2 жыл бұрын

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!

@Sobbayi 2 жыл бұрын

@@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.

@LironSegev 2 жыл бұрын

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

@thesphyrth 2 жыл бұрын

@@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).

@HMMELD 2 жыл бұрын

HM < I need some of the features that only come with the paid version.> Which features..

@rahuldasgupta5996 2 жыл бұрын

One drive is in the Microsoft 365 which is actually important depending on the type of work, hence the subscription is important.

@revivedsoul1099 2 жыл бұрын

Bless you by guiding people for easy route in life. Subbed bro

@jjsmallpiece9234 2 жыл бұрын

I bough Office in 2010 on DVD back then. It still works fine. No intention of paying MS anymore money.

@gunfisher4661 2 жыл бұрын

Supposedly this month MS is going to stop security updates and so forth for 2010

@atticusherodes6648 2 жыл бұрын

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.

@PuR3OwNaGe45 2 жыл бұрын

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!

@deeinsearchof4278 2 жыл бұрын

TYSM for sharing. I am new to your channel and appreciate you being here with awesome info.

@andrasbradacs6016 2 жыл бұрын

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.

@poorboybmx2511 2 жыл бұрын

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

@LironSegev 2 жыл бұрын

Glad it helped!

@jjsmallpiece9234 2 жыл бұрын

Same her, still using Office 2010.

@Pipsterz Жыл бұрын

Excellent! I learned more in seconds with you in Libre than months fumbling on my own lol ⭐👍

@Pete856 2 жыл бұрын

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".

@svenlarsen8770 2 жыл бұрын

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

@kevinphilips7453 2 жыл бұрын

Thank you so much for the video! Is there any trustworthy website to get Office 2021 for cheap?

@olegj285 2 жыл бұрын

BNH Software is a great web. I love their customer support, Hope this information will help you.

@patrickhauser631 2 жыл бұрын

Great tips! Thank you for making and posting this video!

@leong1190 2 жыл бұрын

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.

@AbhishekBana 2 жыл бұрын

I didn't need to be convinced. But I'm share this with others. Saves me from explaining them. Great stuff.

@BradGryphonn 2 жыл бұрын

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.

@k9yeahk9yeah25 2 жыл бұрын

Thank you so much Liron for the advice, you're really helpful.

@superzero4250 2 жыл бұрын

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… …

@rikardogibola1312 2 жыл бұрын

I'm still using Windows 7 with Libre Office. I've been using it for years, never a problem - perfect.

@Redballoon99 2 жыл бұрын

Terrible and spectacularly insecure - I truly hope ur not using for a business -

@fogdragon23 2 жыл бұрын

@@Redballoon99 Can you provide source? I'm only seeing one vulnerability that happened this year.

@Redballoon99 2 жыл бұрын

@@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

@twin10broter 2 жыл бұрын

@@Redballoon99 can you really blame them when newer versions of windows come with a lot of bloatware

@romainsavioz5466 Жыл бұрын

@@Redballoon99 🤦‍♂

@Kannon_BR 2 жыл бұрын

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.

@AndrewHellyer 2 жыл бұрын

only come may 2022, you won't be able to use this with an exchange online mailbox.

@flod5486 2 жыл бұрын

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)

@willemtaurus Жыл бұрын

try using XLOOKUP in Off 2016-excel

@AlexKarasev Жыл бұрын

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.

@Kannon_BR Жыл бұрын

@@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.

@navalcomand1981 Жыл бұрын

Thank you so much Liron, it's really helpful information, much appreciated.

@Pengochan 2 жыл бұрын

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.

@iangerahty3422 2 жыл бұрын

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.

@LironSegev 2 жыл бұрын

Thanks for sharing and hanging out here!

@driedbrainfreeze2149 2 жыл бұрын

I prefer libre, been using for many years. I think it far superior to Office

@JJ_TheGreat 2 жыл бұрын

@@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.

@driedbrainfreeze2149 2 жыл бұрын

@@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.

@JJ_TheGreat 2 жыл бұрын

@@driedbrainfreeze2149 Gotcha. That makes sense!

@brentthompson4153 2 жыл бұрын

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.

@johnrichardson544 2 жыл бұрын

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?

@brennanceltic Жыл бұрын

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.

@Sunshine-uv4we 4 ай бұрын

Thank you for the informative video. It clears up my confusion and I learned something new here!

@michaeloneillire 2 жыл бұрын

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.

@streamdungeon5166 2 жыл бұрын

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.

@dannybuoyuk 2 жыл бұрын

Yup, I use the family sub for 6 1TB OneDrive accounts… and just get Office as a bonus.

@Gocho2000 2 жыл бұрын

Exactly my thoughts

@hondaland_ 2 жыл бұрын

or just use google drive?

@ArnoM86 2 жыл бұрын

@@hondaland_ for 1To and perfect integration?

@CathrineMacNiel 2 жыл бұрын

@@hondaland_ why would you entrust Google with your documents?

@madmo5420 Жыл бұрын

Love u man!! Keep em coming!!

@LironSegev Жыл бұрын

More to come! thanks for being here!

@chorbo1942 2 жыл бұрын

I've been looking for this information a long time ago! Thanks 🙌🏻

@LironSegev 2 жыл бұрын

Glad you are here 🔥

@bloqk16 2 жыл бұрын

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.

@CelticVictory Жыл бұрын

All I learned from my search is that there is no alternative to Word.

@linuxretrogamer 2 жыл бұрын

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 2 жыл бұрын

Libre Office is far better than any other office suites available in the market.

@linuxretrogamer 2 жыл бұрын

@@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.

@kaarinaMoongo Жыл бұрын

Wow, this was so helpful. I'm so grateful for the info

@Think1stMedia Жыл бұрын

Another great 👍 video man. I keep paying for office 365 and was aware of Open Office and Libre Office but figured they did not have all the features of MS Office. Also I am a OneNote Guy too. This has given me something to consider.

@natevelar Жыл бұрын

Keep in mind that this permanent option is usually $99 (not $149) during black friday and Christmas at many retailers.

@andrescarrasco1248 2 жыл бұрын

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 2 жыл бұрын

libre office is ok too ;-) I have no idea why there are still people out there (and businesses) that buy microsoft's word :-(

@BlackHawkTejas 2 жыл бұрын

@@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!

@andrescarrasco1248 2 жыл бұрын

@@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 2 жыл бұрын

@@andrescarrasco1248 Thanks man for the quick reply & the answer!

@vasopel 2 жыл бұрын

@@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)

@user-ou9ft6if4h 11 ай бұрын

WOW 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!!!!!!!!!!!!!!!!

@walterpinkus5534 2 жыл бұрын

The Open Office, etc., work-alikes for Excel are all missing a command that Excel has, that I use a lot. This is Past as Values. This lets you do a bunch of things, with results ending in a column or array, then copy and past the resulting values (*not* the formulas in that final column or array) somewhere else. I use this a lot for building inventory control tracking: input=what I had; middle=what I sold, etc.; output=what's left. Time for a new reporting period? Copy output values to the input field, zero out the middle, save-as new name, (maybe do a physical inventory & correct input field, save again), ready to go.

@BoraHorzaGobuchul 2 жыл бұрын

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.

@wahidpawana424 Жыл бұрын

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.

@krs5267 2 жыл бұрын

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.

@Wyl7 2 жыл бұрын

Microsoft switched to OpenXML formats 15 years ago. Many 3rd party apps handle them.

@nawantabahpangestu1973 Жыл бұрын

Even Microsoft Office is not compatible with previous versions, to the point that Microsoft created something called "compatibility mode".

@alikhidzam3749 Жыл бұрын

I deleted WPS , now I can't edit the files on MW even though it's activated

@Innuband Жыл бұрын

You are AWSOME, thank you for sharing!

@ShadowScoutSwede 2 жыл бұрын

Great video much appreciated and thanks for the update.

@domxem5551 2 жыл бұрын

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.

@CelticVictory Жыл бұрын

Libre is awful.

@cenevspeed 2 жыл бұрын

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!

@LironSegev 2 жыл бұрын

😂 Gotta do what you gotta do

@giovannigiordano366 2 жыл бұрын

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

@giovannigiordano366 2 жыл бұрын

Note: i'm running Ubuntu 20.04 and i also have libreoffice, however math formulas are not compatibles with ms office in general

@cenevspeed 2 жыл бұрын

@@giovannigiordano366 Are you asking this for Excel, PowerPoint or Word?

@giovannigiordano366 2 жыл бұрын

@@cenevspeed 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

@atoz4399 2 жыл бұрын

Thanks. I tried both OpenOffice and Libre so far I like the OpenOffice better as it appears bigger for some reason. Great tips. Thanks.

@OvGraphics 2 жыл бұрын

Super monster thanks for your video. I have been doing MS 2007 for years. It's still the best compatibility for publishing Amazon Books, so they say. But, some day in the future when the inevitable happens and it's time to install on a new computer IF it fails I'll have your alternatives. Got the Libre url stashed in Pocket. I had no idea about how compatible these programs were. Out of sight out of mind. Thank you for bringing it to the front brain LS. UPVOTED and SUBSCRIBED!

@dondamon443 2 жыл бұрын

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).

@LironSegev 2 жыл бұрын

OK. You do you

@affieuk 2 жыл бұрын

Just store the Office key somewhere and grab a 2010 installer before they completely disappear, even if your PC fails, you can reinstall.

@Grigsy Жыл бұрын

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.

@keithdmaust1854 Жыл бұрын

THANKS - subscribed because you helped solve a big problem for me!

@LironSegev Жыл бұрын

Glad I could help

@repvoid7680 2 жыл бұрын

This is literally the most helpful channel on KZfaq.

@loriwyuk 2 жыл бұрын

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.

@ratatatuff 2 жыл бұрын

Softmaker Office is just great.

@jacobopstad5483 2 жыл бұрын

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!)

@Julian_Edits Жыл бұрын

Thanks! I was always bitter that Word was even part of a subscription and would use Libre, but knowing that the Office website lets me use them for free is a game changer! Also updated my setting on Libre just in case

@microsoftsarker 2 жыл бұрын

Excellent explanation. Thank you!

@davuvnik 2 жыл бұрын

I mostly pay for the cloud storage and integration as it does wonders for my job and for keeping my personal data stored somewhere easily without me fiddling nor having to think about it. The suite itself is just a plus at this point, as there are many free options.

@Jimalcoatl 2 жыл бұрын

The cloud storage is so nice. I also use publisher a lot for my job (teacher) to make worksheets and handouts for my students, as well as cards and nametags and such. My school also has a ton of official ppt files that tend to open in ways that make them unusable in other Office alternatives. I did use Open Office for a year or so in University, but then my school got student subscriptions to office, so I could use Office for free while I was a student.

@originalkk882 2 жыл бұрын

"keeping my personal data stored somewhere". "Somewhere" = on MS servers where they can do what they choose with your personal data.

@davuvnik 2 жыл бұрын

@@originalkk882 I know. Someone Will eventually anyway, so... Don't really care.

@AllynHin 2 жыл бұрын

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.

@HMMELD 2 жыл бұрын

Same here - OO at least 10 years. No problems.

@GaisaSanktejo 2 жыл бұрын

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 :)

@achong007 Жыл бұрын

Outlook is very useful and makes organizing emails easier.

@sa3270 2 жыл бұрын

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.

@katrinabryce 2 жыл бұрын

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.

@delhatton 2 жыл бұрын

Still using Office 2000 after all these years.

@jasonuren3479 Жыл бұрын

Great info. Cheers! 👏

@TNKHART 2 жыл бұрын

This is some great information. THANK YOU!!

@StevenMarksChannel 2 жыл бұрын

I've been m enjoying 'Only Office' lately. Seems to work fine so far

@dokidoki5850 2 жыл бұрын

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..

@srikrishna2561 2 жыл бұрын

But it doesn't have all the features though.

@mrfrenzy. 2 жыл бұрын

Only office has much better file compatibility than Libre and OpenOffice.

@danmansonman1874 2 жыл бұрын

Where do you backup your photos/files from your phone/computer?

@jirikocman 2 жыл бұрын

paid subscription to office gives you huge clouf storage which is really cheap copared to others. if you want cloud storage then office suite is included for free

@Jules_Pew 2 жыл бұрын

I use the 'Office Lite' that comes free but if I need something like filters, I open it in libre calc, put the filter in, save and continue in Excel. Yes, you get a warning, but it still works. I am slowly moving over 100% to Libre, but it's having the time to find where all the functions I use regularly are.

@andrewmcallister7781 Жыл бұрын

Everything you say makes sense and is correct. All I would say is that having a cloud backup solution for files is important, some people use external hard drives but from my experience (as a tech repair company) most dont complete backups regularly and dont manage them so it isnt a viable solution for most. With most cloud service providers you get a small amount of space free but most will exceed this with a normal amount of photos and files. So my point here is that if you just pay for Dropbox the cheapest plan costs than double the Office Personal which includes 1TB of storage. For £60 a year I get 1TB of cloud backup and all of the desktop apps, that doesnt seem that bad to protect my data

@mchenrynick 2 жыл бұрын

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.

@HMMELD 2 жыл бұрын

I love the fact that its exactly the same no matter what.

@ytucharliesierra 2 жыл бұрын

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.

@thekingofthisworld2154 Жыл бұрын

I tried using Libre Calc solver to complete linear programming OSCM models. It didn’t work at all. I reverted back to excel.

@nawantabahpangestu1973 Жыл бұрын

What do you mean by "industry standard"?

@ytucharliesierra Жыл бұрын

@@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.

@CelticVictory Жыл бұрын

Libre is only ideal if you are a techie person. It's far from ideal when you aren't.

@AlbanianThrash 7 ай бұрын

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

@TomMarvan 2 жыл бұрын

Great video. New sub! I got the Student version about 10 years ago and the code is saved in my Microsoft account. Each time I replace my computer, I log into my MS account on the new computer and download and use the code to set up the student edition (you may have to uninstall 365 on the new computer). The student version cannot be used in more than one computer I believe, so I usually delete it off of there, or just wipe the drive altogether.

@StinkySobaccos Жыл бұрын

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.

@fredkeating8244 2 жыл бұрын

What about free version of OneNote than can be installed and doesn't need cloud storage? Even if it's part of and Office package that would be okay. Would like to be able to use a stylus to write notes.

@emberslave 2 жыл бұрын

OneNote for Windows 10

@yepitsodex 2 жыл бұрын

its likely that the non sub models will not be 'compatible' with win 11. A meter between you and everything you need is the goal.

@sebastian19745 2 жыл бұрын

The last Office version that I have as original disk and license key is Office 2007 (I got the Enterprise version from my work place when they upgraded). Through the years I downloaded many add-ons, updates, patches and burned on a DVD. That way, I only have to use 2 disks (or a 8G USB drive) to fully install and update the program that I happily use even today. No need for another version since this is doing its job just fine and runs from XP up to Windows 10.

@teivavendetti5886 Жыл бұрын

very helpful tips. greetings from Tahiti

@RussellSlam Жыл бұрын

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?

@copetppd2136 Жыл бұрын

in MS Words press Ctrl + G in PPT in Slide Show mode type slide number you want to go

@paolosardi67 2 жыл бұрын

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?

@richterman3962 2 жыл бұрын

The amount of work some. People. Put in Excell, just hire a programmer

@robertomedlo652 2 жыл бұрын

If i'm not wrong, there's a VBA support library for WPS office. I haven't test it out though

@cubbucca 2 жыл бұрын

They run fine in libre, I run macros and vba functions on my excel files in libre office.

@paolosardi67 2 жыл бұрын

@@cubbucca And what about formulas? is there 100% compatibility?

@elie9372 2 жыл бұрын

Only Office use python for its macro language of choice... Far superior to VBA imho

@macmac1934 2 жыл бұрын

You are the first Tuber in 2021 who mentioned more than one alternative to Microsoft Office Free&paid, thanks for sharing.

@LironSegev 2 жыл бұрын

Happy to help!

@III_BLASTER_III 4 ай бұрын

To the point and very clear, you the man!!!

@LironSegev 4 ай бұрын

Appreciate you being here

@Lestibournes 2 жыл бұрын

My license ran out but the product still works 🤷‍♂️

@DavidWonn 2 жыл бұрын

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.

@oschiri66 2 жыл бұрын

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.