- Видео 350
- Просмотров 1 328 146
Spreadsheet Nation
США
Добавлен 5 авг 2017
I teach people Excel so they can further their career. Visit my website for more extended tutorials.
Excel change cell color based on value with conditional formatting #exceltips #workhacks
Excel change cell color based on value with conditional formatting #exceltips #workhacks
Просмотров: 1 815
Видео
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
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
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: 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
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?
@@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
Oh wow. This is amazing
No, I did not know that!
Thank You Jesus I needed this so badly! It finally worked lol
Thanks man you are a life saver
I want to test this and windows choose to windows update now ! Nooooo
I want MORE! 😊
"Soothing spreadsheets" Lolol
I didn't understand this. What did that picture from a National Park have to do with that data?
Thank you for not adding any music
Why would it be in 4 columns in the first place? All you are doing is creating more work for urself!
you can't be serious
@jonathanc2536 very serious, if you put them in one column while entering the data this task is not necessary. Saving time!
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.
@@thudthud5423 fair enough
How to I minus one hour
An actual good use of Xlookup. The other videos out there use xlookup in the same way as vlookup
The whole "F4" thing is what was throwing me off. Thanks for this!
Thank you so much 🎉🎉🎉🎉🎉🎉🎉🎉🎉🎉🎉🎉🎉🎉🎉🎉🎉🎉🎉
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
=TODAY() I learned a couple things :)
Did not know that one. Now I need to remember it!
Advise on how to calculate time in lieu please
Holy crap
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
Or just scan using your phone. Or ask chat gpt. Or just ask god
In reality this barely ever works - you need to manually correct all the information anyway…
GOSH YHANK YOU SO MUCH YOU SAVED MY LIFEEEEEEEEE😭😭 MY WORK FILE DIDNT SAVE YESTERDAY AND TODAY I HAVE WORK PRESENTATION THANK YOUUUUU
Thanks brother ❤
Yes!!!!!!!
I never knew that. Would have (now will) saved me a lot of time!
Show a time sheet having both breakfast and lunch break and a person worked for over 12 hours duty in a Day
I doubt it's always working that well.
Mines keeps giving me a calendar date not a number count
Bruh I've been trying to figure out how to do this for like a month.
Saved my life... thanks
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
Nice terrorist and grapist flag on top left
What if some have middle names tho?
Unfortunately, it doesn’t do really great if only some cells have middle names.
Use Textsplit
Good to know the shortcut
ruclips.net/user/shortsp91BUQQ4fFY?si=ahOsCz4QabscbYSV
Is there a Google sheets nation?
Funny names, I see what you did there!
Demons!
Sweet Christmas!!!
Holy smokes. It gets even faster than Split Text?
Nice!
GIVE ME ALL THE SHEET HACKS
This is really helpful, but who is Dwight Wilson?
Thanks
Super quick and easy! 💯Thank you!
Pretty useful
Oh that's why, it's only on 365
Thanks