Excel vs Google Sheets

Поділитися
Вставка
  • Опубліковано 13 жов 2024
  • ✅GET FOUR FREE COURSES! ⏩
    www.simonsezit...
    Which is best? Excel or Google Sheets? Both are great spreadsheet tools. But which should you focus your time on? In this Excel vs Google Sheets video, we compare these two tools!
    Google Sheets and Microsoft Excel are both spreadsheet applications that do virtually the same thing. Whilst Excel has always been the go-to spreadsheet application for business, times are changing. Now, Excel is not necessarily the first choice for consumers.
    It’s the biggest rival in recent times is Google Sheets. As part of the free G-suite package, Sheets seamlessly integrates with other Google applications such as Google Drive, Google Docs, and Gmail.
    But does free equate to better? It’s time to stack them up against each other and find out.
    ✅GET FOUR FREE COURSES! ⏩
    www.simonsezit...
    🌍 Get unlimited training with Simon Sez IT’s 150+ courses ⏩ www.simonsezit...
    🚀 Level up your skills with a a free 30 day trial to our complete training library of 8,500+ video ⏩ www.simonsezit...
    🔥Check out our Google Workspace and Google Sheets for Beginners playlist here
    ⏩ • Using Google Workspace...
    🔥Check out our FREE 300+ hour training course playlist here
    ⏩ • Simon Sez IT Long Trai...
    💻Watch more popular tutorials from Simon Sez IT:
    ✅Microsoft Office 2021 and Office 365 Training Tutorials playlist
    👉 • Microsoft Office 2021 ...
    ✅Microsoft Office 2019 Training Tutorials for Beginners playlist
    👉 • Microsoft Office 2019 ...
    ✅Excel 2021 Tutorials for Beginners playlist
    👉www.youtube.co...
    💬Stay in touch!
    ✅SimonSezIT.com: 👉www.SimonSezIT...
    ✅StreamSkill.com: 👉StreamSkill.com/
    ✅UA-cam Channel: 👉 / simonsezittraining
    ✅LinkedIn: 👉 / simon-sez-it
    🔔Subscribe to our channel:
    www.youtube.co...
    If you enjoyed the video, please give a "thumbs up" and subscribe to the channel 👍🏽 ;-)

КОМЕНТАРІ • 39

  • @toobalicious
    @toobalicious 3 роки тому +18

    Um…no. Ever hear of “work in offline mode”? I use it regularly and it works great.

    • @harshaghosh
      @harshaghosh Рік тому

      You can work on google sheets offline as well. You just have to open your browser to access it offline. there's many videos covering the topic online. Go ahead and check it out.

  • @retromograph3893
    @retromograph3893 10 місяців тому +1

    You forgot to mention community. That's very important. Which one has the best, most active forums? Tutorials? Online help?

  • @Ali3nh3art
    @Ali3nh3art 3 роки тому +9

    I use both. . I use the =split() function on google sheets lots

    • @SimonSezIT
      @SimonSezIT  3 роки тому +1

      It's a good one!

    • @jaiconruedas
      @jaiconruedas 2 роки тому

      =TEXTSPLIT is now available on Excel 365

  • @tonycstech
    @tonycstech 3 роки тому +16

    Many formulas you have in Excel will not work with Google Sheets.
    Macros will absolutely NOT work with Google Sheets. That makes you unable to do any advanced programming.
    With that said, DEVELOPER tab or feature is none existent.
    For corporations: Stay away from Google.

    • @cesarebachelli
      @cesarebachelli 2 роки тому +11

      Google Sheets have macros and app scripts (works like Javascript) on its "extension" menu

    • @nsx001
      @nsx001 Рік тому +2

      Boomers use Excel and defend it

  • @nsx001
    @nsx001 Рік тому +4

    Sheets is available offline aswell and is 100x intuitive

  • @user-ns5pr2md1q
    @user-ns5pr2md1q 3 роки тому +5

    Hello! You missed que query function that really add a plus to google sheets IMO. Good channel

  • @ronitdahiya7523
    @ronitdahiya7523 Рік тому +3

    Are google sheets and ms Excel formulas same?

    • @SimonSezIT
      @SimonSezIT  Рік тому +1

      Yes, they are basically the same when it comes to formulas and calculations.

  • @petermaye2249
    @petermaye2249 Рік тому

    I recently ran into a significant compatibility problem with excel using activex controls. These don't work on Macs and are only recognized in Windows. So trying to develop a more complex workbook for everyone to use I am not trying with google sheets.

    • @Celall
      @Celall Рік тому

      This is something that I really care about. Thank you for indicating that.

  • @SimonSezIT
    @SimonSezIT  Рік тому

    We have additional free Google Sheets training here 👉ua-cam.com/play/PLzj7TwUeMQ3j2l5vfMGeUyJ60154MW9-n.html
    & Excel playlist here👉ua-cam.com/video/PlPgYOFJROI/v-deo.html
    & PivotTable training here 👉 ua-cam.com/play/PLzj7TwUeMQ3iJ5hWG_iZuIvFvnuJJ-mtc.html
    Check out our FREE 300+ hour training course playlist here ➡
    🔥ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html

  • @dennistucker1153
    @dennistucker1153 Рік тому

    You really should have done your homework on this a little better. Google Sheets is available offline with a browser extension. On Large Worksheets, you should have done more homework on this too. Excel does have more cells available. However, most of these are NOT usable due to memory limitations and processing speed. I simple test proves this. The test I ran was putting 1 single character into all cells within a single worksheet then save it, close it and reopen it. This test fails because the amount of data within the sheet exceeds memory available.

  • @user-pd8ko4yl6v
    @user-pd8ko4yl6v 3 роки тому +7

    Size does matter 😉

  • @lukejamesquinn
    @lukejamesquinn 3 роки тому +19

    Excel wins not even a contest, only use sheets if you are doing basic stuff

    • @nsx001
      @nsx001 Рік тому +2

      Sheets > Excel

    • @jjwien8593
      @jjwien8593 Рік тому

      You have no idea what G Sheets is capable of, advance programming with scripting and automation is possible on Google sheet. You can even have data automatically updated. Why are people reviewing something they have no knowledge of?

    • @BabuMosahi
      @BabuMosahi Рік тому +2

      ​@@jjwien8593then you don't know what Excel is capable of.

  • @neilugaddan
    @neilugaddan Рік тому

    How about macros using VBA?

  • @lortesen007
    @lortesen007 Рік тому +1

    Well my desktop sheet app works fine offline. Thats little poor to make a video and don't even know that it has a desktop app. 😂

  • @ginnytilby7906
    @ginnytilby7906 2 роки тому +1

    OR. It's a classic symptom of the ADHD brain's struggle with executive functioning :)

  • @jasonluong3862
    @jasonluong3862 3 роки тому +36

    Google Sheets is not free. Remember, when you use a free product, you are the product.

    • @rdsa1
      @rdsa1 3 роки тому +14

      also its kinda win win situation isn't it?

    • @hqrlock
      @hqrlock 3 роки тому

      Spot on.

    • @areluc
      @areluc 3 роки тому +15

      This is true for the Google search engine, UA-cam or Gmail but not for Google Sheets. So if you use these services, it doesn't really make a difference if you use the latter or not. That's why you can actually call it free.

    • @adamcurtin3410
      @adamcurtin3410 Рік тому +1

      @@areluc well now they get you to pay monthly to store your documents once you get past a certain amount of storage 😢

    • @BabuMosahi
      @BabuMosahi Рік тому +1

      Microsoft Excel is not free 😂 and it's ironic when you said that you are the product for "Google" one of the most notorious tech giants who thrives on the users data and sheet is a jackpot for them.

  • @sujoyinnovates
    @sujoyinnovates 2 роки тому +2

    "Excel could take years to master" LOL

    • @SimonSezIT
      @SimonSezIT  2 роки тому +2

      We all learn differently. ;)

    • @sujoyinnovates
      @sujoyinnovates 2 роки тому

      Agreed :)

    • @BrilTek
      @BrilTek 2 роки тому

      @@SimonSezIT Exactly what I came here to type.

    • @gizmospazz
      @gizmospazz Рік тому +1

      To "master", yes.
      To use, no.

  • @smokeypillow
    @smokeypillow Рік тому +2

    Excel is astoundingly worse than Google Sheets

  • @biosdaddy
    @biosdaddy Рік тому

    What about automation of the web version of google sheets and excel?