Spreadsheet Nation
Spreadsheet Nation
  • Видео 350
  • Просмотров 1 328 146

Видео

3 Reasons You Get Errors in VLOOKUPs in Excel or Google Sheets
Просмотров 5946 месяцев назад
3 Reasons You Get Errors in VLOOKUPs in Excel or Google Sheets
Excel Chart Series Part 12: Scatter Charts and Bubble Charts
Просмотров 1676 месяцев назад
Excel Chart Series Part 12: Scatter Charts and Bubble Charts
Excel Chart Series Part 11: Waterfall Charts
Просмотров 746 месяцев назад
Excel Chart Series Part 11: Waterfall Charts
Excel Chart Series Part 10: Map Charts
Просмотров 796 месяцев назад
Excel Chart Series Part 10: Map Charts
Excel Chart Series Part 9: Combo Charts
Просмотров 896 месяцев назад
Excel Chart Series Part 9: Combo Charts
Get a list of dates in Excel
Просмотров 7186 месяцев назад
Get a list of dates in Excel
Excel Chart Series Part 8: Pie Charts
Просмотров 927 месяцев назад
Excel Chart Series Part 8: Pie Charts
Excel Chart Series Part 7: Line Charts
Просмотров 1187 месяцев назад
Excel Chart Series Part 7: Line Charts
Excel Chart Series Part 6: 100% Stacked Bar Chart
Просмотров 1,6 тыс.7 месяцев назад
Excel Chart Series Part 6: 100% Stacked Bar Chart
Excel Chart Series Part 5: Stacked Bar or Column Charts
Просмотров 597 месяцев назад
Excel Chart Series Part 5: Stacked Bar or Column Charts
Excel Chart Series Part 4: Bar or Column Charts
Просмотров 677 месяцев назад
Excel Chart Series Part 4: Bar or Column Charts
Excel Chart Series Part 3: Chart Format Ribbon
Просмотров 1477 месяцев назад
Excel Chart Series Part 3: Chart Format Ribbon
Excel Chart Series Part 2: Chart Design Ribbon
Просмотров 8087 месяцев назад
Excel Chart Series Part 2: Chart Design Ribbon
Excel Chart Series Part 1: Chart Basics
Просмотров 647 месяцев назад
Excel Chart Series Part 1: Chart Basics
Create custom dates in Excel or Google Sheets
Просмотров 4328 месяцев назад
Create custom dates in Excel or Google Sheets
Create a time sheet to calculate hours worked in Excel
Просмотров 42 тыс.8 месяцев назад
Create a time sheet to calculate hours worked in Excel
Color Cells based on Due Dates in Excel
Просмотров 42 тыс.8 месяцев назад
Color Cells based on Due Dates in Excel
Images in Cells in Excel
Просмотров 13510 месяцев назад
Images in Cells in Excel
Sort Colors in Excel
Просмотров 2422 года назад
Sort Colors in Excel
Excel Trick: Dynamic Drop-Down List
Просмотров 2853 года назад
Excel Trick: Dynamic Drop-Down List
Excel Explained: Named Ranges
Просмотров 1184 года назад
Excel Explained: Named Ranges
Excel Explained: Add, Subtract, Multiply, or Divide with Paste Special
Просмотров 2174 года назад
Excel Explained: Add, Subtract, Multiply, or Divide with Paste Special
Excel Explained: Split Data into Multiple Columns
Просмотров 1154 года назад
Excel Explained: Split Data into Multiple Columns
Excel Explained: Text Rotation
Просмотров 454 года назад
Excel Explained: Text Rotation
Excel Explained: Add Shortcuts to Quick Access Toolbar
Просмотров 614 года назад
Excel Explained: Add Shortcuts to Quick Access Toolbar
Excel Explained: Shortcuts to Copy/Move Data
Просмотров 454 года назад
Excel Explained: Shortcuts to Copy/Move Data
Excel Explained: Mail Merge in Word
Просмотров 3134 года назад
Excel Explained: Mail Merge in Word
Excel Explained: Worksheet Navigation
Просмотров 244 года назад
Excel Explained: Worksheet Navigation
Excel Explained: Custom Sort
Просмотров 504 года назад
Excel Explained: Custom Sort

Комментарии

  • @ryanb3665
    @ryanb3665 8 часов назад

    What does it do with the same number, I wonder? If I have multiple 70’s for example, does it share the same rank number?

    • @SpreadsheetNation
      @SpreadsheetNation 8 часов назад

      @@ryanb3665 Yes, it gives is the 70s the same rank. So if in my simple data, the 50 was turned into a 70, then the 100 would have a rank of 1. The two 70s would have a rank of 2. And the 60 would have a rank of 4. If you use the RANK.AVG function, the rank is averaged. So the 70s would get a rank of 2.5

  • @heard3879
    @heard3879 23 часа назад

    Oh wow. This is amazing

  • @EddyGurge
    @EddyGurge День назад

    No, I did not know that!

  • @pretty707
    @pretty707 2 дня назад

    Thank You Jesus I needed this so badly! It finally worked lol

  • @markjone6600
    @markjone6600 2 дня назад

    Thanks man you are a life saver

  • @w33r4
    @w33r4 2 дня назад

    I want to test this and windows choose to windows update now ! Nooooo

  • @w33r4
    @w33r4 2 дня назад

    I want MORE! 😊

  • @heard3879
    @heard3879 3 дня назад

    "Soothing spreadsheets" Lolol

  • @heard3879
    @heard3879 3 дня назад

    I didn't understand this. What did that picture from a National Park have to do with that data?

  • @heard3879
    @heard3879 3 дня назад

    Thank you for not adding any music

  • @zahaidrahman2052
    @zahaidrahman2052 3 дня назад

    Why would it be in 4 columns in the first place? All you are doing is creating more work for urself!

    • @jonathanc2536
      @jonathanc2536 2 дня назад

      you can't be serious

    • @zahaidrahman2052
      @zahaidrahman2052 2 дня назад

      @jonathanc2536 very serious, if you put them in one column while entering the data this task is not necessary. Saving time!

    • @thudthud5423
      @thudthud5423 9 часов назад

      If you have several columns sorted for different reasons, putting them in a single column would disallow that organization. For example: column B: Red Boxes R1-R500, column C: Blue Boxes B4-B750, column A: All Red and Blue Boxes.

    • @zahaidrahman2052
      @zahaidrahman2052 8 часов назад

      @@thudthud5423 fair enough

  • @kingscrown8803
    @kingscrown8803 5 дней назад

    How to I minus one hour

  • @nvsportscards7199
    @nvsportscards7199 6 дней назад

    An actual good use of Xlookup. The other videos out there use xlookup in the same way as vlookup

  • @IronReel
    @IronReel 14 дней назад

    The whole "F4" thing is what was throwing me off. Thanks for this!

  • @shotomobile9272
    @shotomobile9272 14 дней назад

    Thank you so much 🎉🎉🎉🎉🎉🎉🎉🎉🎉🎉🎉🎉🎉🎉🎉🎉🎉🎉🎉

  • @nokam113
    @nokam113 14 дней назад

    Sir whenever I use weekday function ,it considers From Monday to Friday , how to customize it from From Monday to Saturday ....please make a video too

  • @EddyGurge
    @EddyGurge 16 дней назад

    =TODAY() I learned a couple things :)

  • @EddyGurge
    @EddyGurge 18 дней назад

    Did not know that one. Now I need to remember it!

  • @Prasannarao-e8c
    @Prasannarao-e8c 18 дней назад

    Advise on how to calculate time in lieu please

  • @arturocaissut1071
    @arturocaissut1071 21 день назад

    Holy crap

  • @BarackObamaJedi
    @BarackObamaJedi 21 день назад

    oh i thought it would convert any image into a spreadsheet lmao, like that guy who converted a mr krabs png into a series of chess games

  • @DrshahG
    @DrshahG 21 день назад

    Or just scan using your phone. Or ask chat gpt. Or just ask god

  • @waistcoat5066
    @waistcoat5066 21 день назад

    In reality this barely ever works - you need to manually correct all the information anyway…

  • @Kim-tf5cx
    @Kim-tf5cx 21 день назад

    GOSH YHANK YOU SO MUCH YOU SAVED MY LIFEEEEEEEEE😭😭 MY WORK FILE DIDNT SAVE YESTERDAY AND TODAY I HAVE WORK PRESENTATION THANK YOUUUUU

  • @Mahadev_ka_dewana857
    @Mahadev_ka_dewana857 22 дня назад

    Thanks brother ❤

  • @ShipOnTheSea
    @ShipOnTheSea 25 дней назад

    Yes!!!!!!!

  • @EddyGurge
    @EddyGurge 25 дней назад

    I never knew that. Would have (now will) saved me a lot of time!

  • @omojiraabdulai2761
    @omojiraabdulai2761 26 дней назад

    Show a time sheet having both breakfast and lunch break and a person worked for over 12 hours duty in a Day

  • @florinpandele5205
    @florinpandele5205 Месяц назад

    I doubt it's always working that well.

  • @lenesmith2090
    @lenesmith2090 Месяц назад

    Mines keeps giving me a calendar date not a number count

  • @je5979
    @je5979 Месяц назад

    Bruh I've been trying to figure out how to do this for like a month.

  • @nabilshaikh2525
    @nabilshaikh2525 Месяц назад

    Saved my life... thanks

  • @rodrigok1220
    @rodrigok1220 Месяц назад

    If you hit the function, it gives you a pop up that explains the inputs. Maybe easier for someone whose new learning or using various other formulas

  • @Alexander24871
    @Alexander24871 Месяц назад

    Nice terrorist and grapist flag on top left

  • @A_itsar
    @A_itsar Месяц назад

    What if some have middle names tho?

    • @SpreadsheetNation
      @SpreadsheetNation Месяц назад

      Unfortunately, it doesn’t do really great if only some cells have middle names.

  • @mathijs9365
    @mathijs9365 Месяц назад

    Use Textsplit

  • @Goodman._
    @Goodman._ Месяц назад

    Good to know the shortcut

  • @ZenZangetsu
    @ZenZangetsu Месяц назад

    Is there a Google sheets nation?

  • @mattihp
    @mattihp Месяц назад

    Funny names, I see what you did there!

  • @TheBlackLibraryOriginal
    @TheBlackLibraryOriginal Месяц назад

    Demons!

  • @TheBlackLibraryOriginal
    @TheBlackLibraryOriginal Месяц назад

    Sweet Christmas!!!

  • @bluzfiddler1
    @bluzfiddler1 Месяц назад

    Holy smokes. It gets even faster than Split Text?

  • @BurnaBwoi
    @BurnaBwoi Месяц назад

    Nice!

  • @atlashammercock9582
    @atlashammercock9582 Месяц назад

    GIVE ME ALL THE SHEET HACKS

  • @ThatsSoRaechel
    @ThatsSoRaechel Месяц назад

    This is really helpful, but who is Dwight Wilson?

  • @badgebhai99
    @badgebhai99 Месяц назад

    Thanks

  • @Sattaar5El
    @Sattaar5El Месяц назад

    Super quick and easy! 💯Thank you!

  • @yuliana1628
    @yuliana1628 Месяц назад

    Pretty useful

  • @akayneee
    @akayneee Месяц назад

    Oh that's why, it's only on 365

  • @ritikjha3212
    @ritikjha3212 Месяц назад

    Thanks