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

Поделиться
HTML-код
  • Опубликовано: 12 ноя 2021
  • 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?
    ruclips.net/user/LironSege...
    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,6 тыс.

  • @LironSegev
    @LironSegev  2 года назад +503

    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
      @Nothuman76 2 года назад +24

      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
      @unimatrix1 2 года назад +11

      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
      @LironSegev  2 года назад +52

      @@unimatrix1 dude RUclips 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
      @Tito23452 2 года назад +17

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

    • @stirech
      @stirech 2 года назад +12

      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
    @audioaddict420 2 года назад +691

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

    • @LironSegev
      @LironSegev  2 года назад +63

      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
      @sherlock.homeless Год назад +31

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

    • @lisam8358
      @lisam8358 Год назад +16

      Until Greed stepped in hey

    • @Dave-lx6ml
      @Dave-lx6ml Год назад +6

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

    • @benjaminmurray3504
      @benjaminmurray3504 Год назад +8

      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 😖

  • @AlexParkYT
    @AlexParkYT 2 года назад +488

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

    • @fvrrljr
      @fvrrljr 2 года назад +4

      *Cue the Bond memes*

    • @NeverMetTheGuy
      @NeverMetTheGuy 2 года назад +24

      Eat the bugs.

    • @salserokorsou
      @salserokorsou 2 года назад +13

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

    • @ideastoragedb
      @ideastoragedb 2 года назад +42

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

    • @davidchristensen2970
      @davidchristensen2970 2 года назад +14

      Seriously scary quote.

  • @andrewsstuffy
    @andrewsstuffy 2 года назад +425

    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
      @LironSegev  2 года назад +37

      boom!

    • @Ulven3829
      @Ulven3829 2 года назад +25

      And it’s been discontinued for years.

    • @milohoffman274
      @milohoffman274 2 года назад +67

      libreoffice is the modern updated version of openoffice.

    • @chronos401
      @chronos401 2 года назад +22

      @@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
      @nowthatsjustducky 2 года назад +9

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

  • @4richis
    @4richis Год назад +62

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

  • @welshtony1
    @welshtony1 2 года назад +298

    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
      @wharpblast264 2 года назад +10

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

    • @Ostap1974
      @Ostap1974 2 года назад +20

      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
      @faguolvlv 2 года назад +8

      libre office ;p

    • @chrix2381
      @chrix2381 2 года назад +7

      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
      @85rx7se 2 года назад +9

      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.

  • @kevinphilips7453
    @kevinphilips7453 Год назад +281

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

    • @olegj285
      @olegj285 Год назад

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

  • @bobf2206
    @bobf2206 2 года назад +12

    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
      @HMMELD Год назад +1

      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.

  • @johnmckown1267
    @johnmckown1267 2 года назад +24

    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.

  • @jjsmallpiece9234
    @jjsmallpiece9234 2 года назад +22

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

    • @gunfisher4661
      @gunfisher4661 2 года назад

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

  • @rikardogibola1312
    @rikardogibola1312 2 года назад +23

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

    • @Redballoon99
      @Redballoon99 2 года назад +2

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

    • @fogdragon23
      @fogdragon23 2 года назад

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

    • @Redballoon99
      @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
      @twin10broter 2 года назад +1

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

    • @romainsavioz5466
      @romainsavioz5466 Год назад +1

      @@Redballoon99 🤦‍♂

  • @psa110
    @psa110 2 года назад +20

    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
      @bungalowmo 3 месяца назад

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

  • @Cyba_IT
    @Cyba_IT 2 года назад +14

    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

  • @Cat-wl2ub
    @Cat-wl2ub 2 года назад +28

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

    • @giovannigiordano366
      @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
      @srikrishna2561 2 года назад +1

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

    • @antoniog9814
      @antoniog9814 2 года назад +2

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

    • @jublywubly
      @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
      @adamfuller3035 2 года назад +1

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

  • @clary5739
    @clary5739 10 месяцев назад +1

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

  • @Kannon_BR
    @Kannon_BR 2 года назад +95

    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
      @AndrewHellyer 2 года назад

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

    • @flod5486
      @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
      @willemtaurus Год назад +1

      try using XLOOKUP in Off 2016-excel

    • @AlexKarasev
      @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
      @Kannon_BR Год назад +2

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

  • @atticusherodes6648
    @atticusherodes6648 2 года назад +17

    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.

  • @Exceltrainingvideos
    @Exceltrainingvideos 2 года назад +93

    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
      @skyfreeman5461 2 года назад +60

      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
      @JG27Korny 2 года назад +15

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

    • @Dominus_Potatus
      @Dominus_Potatus 2 года назад +5

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

    • @IwanTamimi
      @IwanTamimi 2 года назад +1

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

    • @Chepakishui
      @Chepakishui 2 года назад +4

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

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

  • @CrashLoopBackOff-K8s
    @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.

  • @dondamon443
    @dondamon443 2 года назад +8

    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
      @LironSegev  2 года назад +2

      OK. You do you

    • @affieuk
      @affieuk 2 года назад +3

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

  • @cenevspeed
    @cenevspeed 2 года назад +61

    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
      @LironSegev  2 года назад +3

      😂 Gotta do what you gotta do

    • @giovannigiordano366
      @giovannigiordano366 2 года назад +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
      @giovannigiordano366 2 года назад +1

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

    • @cenevspeed
      @cenevspeed 2 года назад +1

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

    • @giovannigiordano366
      @giovannigiordano366 2 года назад +1

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

  • @brennanceltic
    @brennanceltic Год назад +1

    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.

  • @Pete856
    @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".

  • @bhangrafan4480
    @bhangrafan4480 2 года назад +21

    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
      @longrolstral 7 месяцев назад +1

      Home subs and Student subs go beyond business use.

    • @cliftonmcnalley8469
      @cliftonmcnalley8469 5 месяцев назад

      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
    @HeatherMajors 2 года назад +75

    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
      @LironSegev  2 года назад +30

      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
      @Sobbayi 2 года назад +10

      @@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
      @LironSegev  2 года назад +27

      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
      @thesphyrth 2 года назад +8

      @@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
      @HMMELD Год назад +1

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

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

  • @PippaPipster
    @PippaPipster 10 месяцев назад

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

  • @linuxretrogamer
    @linuxretrogamer 2 года назад +26

    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
      @aravindsarkar1255 2 года назад +4

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

    • @linuxretrogamer
      @linuxretrogamer 2 года назад +3

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

  • @poorboybmx2511
    @poorboybmx2511 2 года назад +7

    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

  • @jasondugas8184
    @jasondugas8184 Год назад

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

  • @BradGryphonn
    @BradGryphonn 2 года назад +3

    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.

  • @rahuldasgupta5996
    @rahuldasgupta5996 2 года назад +6

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

  • @andrescarrasco1248
    @andrescarrasco1248 2 года назад +105

    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
      @vasopel 2 года назад +11

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

    • @BlackHawkTejas
      @BlackHawkTejas 2 года назад +4

      @@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
      @andrescarrasco1248 2 года назад +5

      @@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
      @BlackHawkTejas 2 года назад +6

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

    • @vasopel
      @vasopel 2 года назад +3

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

  • @bathsheba.b8656
    @bathsheba.b8656 2 года назад

    Thanks for that info, I am still using Office Pro 2000 that I pirated off my mother when she bought it as a new standalone product for her new Millenium present, it still does everything I want it to do. I also have a 21 year old Fujitsu Siemens tower computer that I fire up every so often for old times sake!!!

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

  • @iangerahty3422
    @iangerahty3422 2 года назад +109

    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
      @LironSegev  2 года назад +10

      Thanks for sharing and hanging out here!

    • @driedbrainfreeze2149
      @driedbrainfreeze2149 2 года назад +13

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

    • @JJ_TheGreat
      @JJ_TheGreat 2 года назад +9

      @@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
      @driedbrainfreeze2149 2 года назад +8

      @@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
      @JJ_TheGreat 2 года назад +2

      @@driedbrainfreeze2149 Gotcha. That makes sense!

  • @AbhishekBana
    @AbhishekBana 2 года назад +12

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

  • @musaka00
    @musaka00 10 месяцев назад

    I've been using OfficeSuite on Android and PC for 5 so years. No problems opening non-main stream files. I love it.

  • @revivedsoul1099
    @revivedsoul1099 2 года назад

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

  • @natevelar
    @natevelar Год назад +7

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

  • @michaeloneillire
    @michaeloneillire 2 года назад +4

    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.

  • @user-ou9ft6if4h
    @user-ou9ft6if4h 8 месяцев назад

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

  • @navalcomand1981
    @navalcomand1981 Год назад

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

  • @andrasbradacs6016
    @andrasbradacs6016 Год назад +6

    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.

  • @svenlarsen8770
    @svenlarsen8770 2 года назад +6

    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

  • @patrickhauser631
    @patrickhauser631 2 года назад

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

  • @k9yeahk9yeah25
    @k9yeahk9yeah25 Год назад

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

  • @mchenrynick
    @mchenrynick 2 года назад +6

    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
      @HMMELD Год назад

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

  • @krs5267
    @krs5267 2 года назад +38

    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
      @Wyl7 2 года назад +7

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

    • @nawantabahpangestu1973
      @nawantabahpangestu1973 Год назад +2

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

    • @alikhidzam3749
      @alikhidzam3749 Год назад +1

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

  • @DrewAndrews
    @DrewAndrews Год назад

    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.

  • @superzero4250
    @superzero4250 2 года назад +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…

  • @StevenMarksChannel
    @StevenMarksChannel 2 года назад +28

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

    • @dokidoki5850
      @dokidoki5850 2 года назад +3

      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
      @srikrishna2561 2 года назад +1

      But it doesn't have all the features though.

    • @mrfrenzy.
      @mrfrenzy. 2 года назад +2

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

    • @danmansonman1874
      @danmansonman1874 2 года назад

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

  • @brentthompson4153
    @brentthompson4153 2 года назад +7

    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
      @johnrichardson544 2 года назад +1

      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?

  • @deeinsearchof4278
    @deeinsearchof4278 2 года назад

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

  • @utahprepper8925
    @utahprepper8925 2 года назад

    I've been on Apache OpenOffice for years. It does everything MS Office does and its totally free. Runs on my Windoze machines as well as my Linux boxes. Fully compatible. I love it.

  • @DavidWonn
    @DavidWonn 2 года назад +6

    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
      @oschiri66 2 года назад +1

      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.

  • @loriwyuk
    @loriwyuk 2 года назад +5

    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
      @ratatatuff 2 года назад

      Softmaker Office is just great.

  • @Pengochan
    @Pengochan Год назад +1

    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.

  • @StinkySobaccos
    @StinkySobaccos Год назад +1

    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.

  • @streamdungeon5166
    @streamdungeon5166 2 года назад +105

    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
      @dannybuoyuk 2 года назад +16

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

    • @Gocho2000
      @Gocho2000 2 года назад +1

      Exactly my thoughts

    • @hondaland_
      @hondaland_ 2 года назад +9

      or just use google drive?

    • @ArnoM86
      @ArnoM86 2 года назад +1

      @@hondaland_ for 1To and perfect integration?

    • @CathrineMacNiel
      @CathrineMacNiel 2 года назад +10

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

  • @paolosardi67
    @paolosardi67 2 года назад +45

    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
      @richterman3962 2 года назад +9

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

    • @robertomedlo652
      @robertomedlo652 2 года назад +2

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

    • @cubbucca
      @cubbucca 2 года назад +8

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

    • @paolosardi67
      @paolosardi67 2 года назад

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

    • @elie9372
      @elie9372 2 года назад +5

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

  • @macmac1934
    @macmac1934 2 года назад

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

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

  • @bloqk16
    @bloqk16 Год назад +3

    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
      @CelticVictory 11 месяцев назад +1

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

  • @AllynHin
    @AllynHin 2 года назад +4

    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
      @HMMELD Год назад +1

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

  • @repvoid7680
    @repvoid7680 2 года назад

    This is literally the most helpful channel on RUclips.

  • @achong007
    @achong007 Год назад +1

    Outlook is very useful and makes organizing emails easier.

  • @Grigsy
    @Grigsy Год назад +11

    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.

  • @domxem5551
    @domxem5551 2 года назад +3

    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.

  • @Sunshine-uv4we
    @Sunshine-uv4we 2 месяца назад

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

  • @GaisaSanktejo
    @GaisaSanktejo 2 года назад +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 :)

  • @BoraHorzaGobuchul
    @BoraHorzaGobuchul 2 года назад +24

    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
      @wahidpawana424 Год назад +2

      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.

  • @dragonshadow1902
    @dragonshadow1902 2 года назад +7

    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.

    • @vister6757
      @vister6757 Год назад

      True. Way overpriced and even worse now when we are force to pay monthly for usage.

  • @saigueu
    @saigueu Год назад

    Just thank you. I overnighted searching it until I discovered your video.

  • @kaarinaMoongo
    @kaarinaMoongo Год назад

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

  • @delhatton
    @delhatton 2 года назад +5

    Still using Office 2000 after all these years.

  • @davuvnik
    @davuvnik 2 года назад +47

    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
      @Jimalcoatl 2 года назад +1

      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
      @originalkk882 2 года назад +1

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

    • @davuvnik
      @davuvnik 2 года назад +1

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

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

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

  • @RussellSlam
    @RussellSlam Год назад +3

    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
      @copetppd2136 Год назад

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

  • @malikrimzan5765
    @malikrimzan5765 2 года назад +7

    Basically, there are more than enough free options out there, but people are just over-paying Microsoft just to use the Designer.

    • @LironSegev
      @LironSegev  2 года назад +1

      or worse - overpay just to use Word and Excel....

  • @nemo4evr
    @nemo4evr Год назад

    I have been using Libre Office for years, never had a problem, updates properly and works like a charm, and NO ADS EVER.

  • @leong1190
    @leong1190 2 года назад +1

    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.

  • @sa3270
    @sa3270 2 года назад +4

    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
      @katrinabryce 2 года назад +6

      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.

  • @jacobopstad5483
    @jacobopstad5483 2 года назад +5

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

  • @Innuband
    @Innuband Год назад

    You are AWSOME, thank you for sharing!

  • @chorbo1942
    @chorbo1942 2 года назад

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

  • @johnnorth9355
    @johnnorth9355 2 года назад +8

    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.

    • @fetchstixRHD
      @fetchstixRHD Год назад

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

  • @bennyceca
    @bennyceca 2 года назад +10

    You see, the most important point of buying the yearly office (family edition) is that each user gets 1TB of cloud storage on OneDrive! With more and more photos being taken on phones etc, you can set them to upload to the OneDrive, no need to worry about backups etc. So the cloud storage you get is less than you'd pay with other 3rd party offerings alone! I have also never paid the full price for Office, in the UK, is £79.99 for the 6 users family version, I have always paid £50 or less when on offer (multiple times per year), so when an offer is available, you can stack them, I got 4 years remaining.
    If you are not bothered about cloud storage, you can also just buy the licence for as little as £20-30 online (legit) for the full version of the latest MS Office, including Outlook.

    • @LironSegev
      @LironSegev  2 года назад

      "he" didn't. The focus is on the suite not the storage. He also didn't mention Dropbox 🤦‍♂️

    • @LironSegev
      @LironSegev  2 года назад

      You certainly are. My hero

    • @bennyceca
      @bennyceca 2 года назад

      The simple fact is the family suite comes with 1TB of free cloud storage per user, and Dropbox isn't part of Microsoft so no idea why you're mentioning them!? What reputable provider offers 1TB of storage for the equivalent of $15 per year?

    • @LironSegev
      @LironSegev  2 года назад

      😂 He deleted this comment.

    • @moist_ointment
      @moist_ointment 2 года назад

      @@bennyceca a company that makes an absolute buttfuckload of money offering this service to enterprise, and giving a cut down service to consumers for dirt cheap.

  • @korolimorris6805
    @korolimorris6805 Год назад

    Thank you for videos. Helpful.

  • @gallixymike1530
    @gallixymike1530 Год назад

    Thanks Liron, I downloaded Libre Office and works GREAT, APPRECIATE it

  • @esrAsnataS
    @esrAsnataS 2 года назад +3

    You can get Office 2021 for less than a tenner, even at single install it's worth it. You can get one bound to your MS account for about 16quid.

    • @affieuk
      @affieuk 2 года назад

      I assume you mean the licenses on ebay, I've always wondered how these don't get blocked. Some of them are obviously not to resold, like educational licenses.

    • @esrAsnataS
      @esrAsnataS 2 года назад

      Not off eBay, I've installed different versions on several laptops and PCs over the years with no issues. I've used different retailers, all bought using PayPal.

    • @carbonarrow7
      @carbonarrow7 2 года назад

      the fact that office subscription is running on your computer in VIRTUAL MODE. It means that office is not physically running and installed on your computer, So any 3rd party apps cannot physically access those office programs to run and function because Office is not physically loaded on your computer. That is the HOOK with MS Program subscriptions.

  • @fredkeating8244
    @fredkeating8244 2 года назад +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
      @emberslave 2 года назад

      OneNote for Windows 10

  • @ecopennylife
    @ecopennylife Год назад

    Great video, I use Libre Office (Windows version), made a donation to them as I love it so much, especially the Draw programme which is easy to use like my venerable ClarisWorks which is too old to run on modern computers 👍

  • @TNKHART
    @TNKHART 2 года назад

    This is some great information. THANK YOU!!

  • @NyctalopeDiurne
    @NyctalopeDiurne 2 года назад +8

    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!

  • @jirikocman
    @jirikocman 2 года назад +3

    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

  • @Block-yc6bh
    @Block-yc6bh 2 года назад

    just discovered your videos! Gold mine!

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