Picture

Joseph @spreadsheetsme

Helping frustrated users understand Excel on a daily basis. spreadsheetsmadeeasy.com Joined May 2012
  • Tweets
    271
  • Followers
    784
  • Following
    802
  • Likes
    47
spreadsheetsme Profile Picture

Joseph @spreadsheetsme

8 years ago

I was building out a template workbook and I thought I'd share this useful way to use the CHOOSE function in #Excel. If you need to randomly select an item from a small set of data, you can use the CHOOSE function like so: =CHOOSE(RANDBETWEEN(1,4),"West","East","North","South")

Joseph retweeted
msexcel Profile Picture

Microsoft Excel @msexcel

8 years ago

To our community, thank you for an excel-lent year. We’ve come a long way since our Hall of Tortured Souls days… get pumped… we’ve got some exciting things in store for 2018. Happy New Year!

spreadsheetsme Profile Picture

Joseph @spreadsheetsme

8 years ago

Did you know that you can use the #Excel's SUM function like SUMIF / SUMIFS / COUNT / COUNTA / COUNTIF / COUNTIFS? youtu.be/8ePRYYAW8QI

Joseph retweeted
msexcel Profile Picture

Microsoft Excel @msexcel

8 years ago

Happy Holidays from Frosty the Cell Man. ☃️ ❄️

spreadsheetsme Profile Picture

Joseph @spreadsheetsme

8 years ago

Very handy #excel function, thanks @TomUrtis! Just for fun, here's a more complicated way to do the same thing 😀 just with less characters: =IF((B6---"08:30:00")*(--"17:00:00"-B6)>=0,"Yes","No")

TomUrtis Profile Picture

Tom Urtis @TomUrtis

8 years ago

Very handy #excel function, thanks @TomUrtis! Just for fun, here's a more complicated way to do the same thing 😀 just with less characters: =IF((B6---"08:30:00")*(--"17:00:00"-B6)>=0,"Yes","No")

spreadsheetsme Profile Picture

Joseph @spreadsheetsme

8 years ago

Understanding #Excel boolean logic can help you build complex array functions 👍 youtu.be/KW3IHYE3Z8s

spreadsheetsme Profile Picture

Joseph @spreadsheetsme

8 years ago

Always save your documents while working on them...because #Windows can (and will) crash on you. AutoRecover doesn't work on brand new spreadsheets :/

spreadsheetsme Profile Picture

Joseph @spreadsheetsme

8 years ago

What happens when multiple conditional formatting rules collide? youtube.com/watch?v=oUEOug…

spreadsheetsme Profile Picture

Joseph @spreadsheetsme

8 years ago

Can't wait for this. Looks like it's going to be awesome!

spreadsheetsme Profile Picture

Joseph @spreadsheetsme

8 years ago

Very handy formula 👍

TomUrtis Profile Picture

Tom Urtis @TomUrtis

8 years ago

Very handy formula 👍

spreadsheetsme Profile Picture

Joseph @spreadsheetsme

8 years ago

This is awesome!

greatbigstory Profile Picture

Great Big Story @greatbigstory

8 years ago

This is awesome!

spreadsheetsme Profile Picture

Joseph @spreadsheetsme

8 years ago

That moment when you realize you forgot to save your changes in your #Excel report before sending it to your boss 😂

spreadsheetsme Profile Picture

Joseph @spreadsheetsme

8 years ago

Always use "Option Explicit" in your #Excel #VBA modules. This helps save you from mistakes like misspelling a variable 👍

spreadsheetsme Profile Picture

Joseph @spreadsheetsme

8 years ago

Be more productive at your job with this FREE #Excel keyboard shortcuts PDF printout 👌 spreadsheetsmadeeasy.com/excel-shortcut…

Joseph retweeted
TomUrtis Profile Picture

Tom Urtis @TomUrtis

8 years ago

Conditionally formatting times for AM and PM #MSExcel #DataScience #businessintelligence #Analytics

spreadsheetsme Profile Picture

Joseph @spreadsheetsme

8 years ago

Here are my favorite #Excel keyboard shortcuts :) What are yours? youtube.com/watch?v=xF5-JI…

spreadsheetsme Profile Picture

Joseph @spreadsheetsme

8 years ago

Ever needed to set multiple named ranges in #excel? youtube.com/watch?v=_PUojv…

spreadsheetsme Profile Picture

Joseph @spreadsheetsme

8 years ago

Take a closer look at #excel #vba Sub Procedures spreadsheetsmadeeasy.com/excel-vba-intr…

spreadsheetsme Profile Picture

Joseph @spreadsheetsme

8 years ago

3 Ways to make your #excel spreadsheet spooky! Happy #halloween spreadsheetsmadeeasy.com/3-ways-to-make…

Joseph retweeted
TomUrtis Profile Picture

Tom Urtis @TomUrtis

8 years ago

Getting the cube root of a number #MSExcel #BigData #DataScience #businessintelligence #Analytics

Trends for United States

Karen
87 B posts
Rachel
77,6 B posts
Chiefs
203 B posts
AJ Lee
257 B posts
Herbert
58,1 B posts
FKJD FANDAY24 SG
111 B posts
Mahomes
68,7 B posts
GiveRep V1
1.100 posts
#SmackDown
202 B posts
Ken Dryden
4.499 posts
Big Brother
24,9 B posts
#MarvelTokonFightingSouls
Kelce
42 B posts
#OverstockIsBack
Bader
15,2 B posts
Worthy
55,9 B posts
Jarritos
1.213 posts
Tart
6.524 posts
Chris Jones
5.438 posts
Keenan Allen
5.604 posts

You might like

Excel website & blog by Debra Dalgleish @ddalgleish Excel MVP
Contextures
@contextures
5K Followers
We think of cool spreadsheet designs, with nothing but data on our minds.
Excel Effects
@ExcelEffects
6K Followers
Contextures Excel site; MS MVP Excel; Spreadsheet Day founder; https://t.co/t6c0WWVmqF https://t.co/vdAdfyLaDi https://t.co/NoYyeBrhgo
Debra Dalgleish
@ddalgleish
6K Followers
Excel, Access, and VBA consulting.
Sheet1 Consulting
@Sheet1
776 Followers
Handy add-ins for Microsoft Excel, Outlook, Word; nifty Office how-tos, tips, articles and tutorials
Ablebits
@Ablebits
687 Followers
Excel Prodigy - Advance level Excel Training center in Chennai, we conduct Microsoft Excel Training (corporate and individual).
Excel Prodigy
@excelprodigy
955 Followers
Social Media Manager & Head of Fan Engagement for Warren Zeiders. I lead digital campaigns and coordinate exclusive fan experiences.
Tom Harper
@Tom_Harper01
327 Followers