Exceljet (@exceljet) header
Exceljet (@exceljet) profile picture

Exceljet

@exceljet

Quick, clean, and to the point. Practical resources to help you work faster in Excel. 100% human.

 Salt Lake City
exceljet.net
Joined December 2012
  • Tweets713
  • Following114
  • Followers2.1K
301Media
Photo by Exceljet (@exceljet)Photo by Exceljet (@exceljet)Photo by Exceljet (@exceljet)Photo by Exceljet (@exceljet)Photo by Exceljet (@exceljet)Photo by Exceljet (@exceljet)Photo by Exceljet (@exceljet)Photo by Exceljet (@exceljet)Photo by Exceljet (@exceljet)Photo by Exceljet (@exceljet)
Check out @jschwabish's new book, Data Visualization in Excel! It will take you well beyond the defaults of #Excel charts and show you how to create better and more effectives data visualizations.| amzn.to/3IwuG8f
Data Visualization in Excel: A Guide for Beginners, Intermediates, and Wonks (AK Peters Visualiza...

Data Visualization in Excel: A Guide for Beginners, Intermediates, and Wonks (AK Peters Visualiza...

Data Visualization in Excel: A Guide for Beginners, Intermediates, and Wonks (AK Peters Visualization Series)

amazon.com
1
2
1,357
Great post from @exceljet on the pros and cons of VLOOKUP and XLOOKUP | exceljet.net/articles/xlooku…

XLOOKUP vs VLOOKUP

For many years, VLOOKUP has reigned supreme as the most widely used lookup function in Excel. But now that XLOOKUP is more widely available, VLOOKUP's reign will likely come to an end. XLOOKUP is a...

exceljet.net
1
4
1,837
Replying to @exceljet
@exceljet thanks for the best excel KungFu resource in the planet 👍
1
2
Replying to @exceljet
@exceljet is a godsend!
1
3
Exceljet.net Exceljet teaches you Excel with clear examples and bite-sized videos: Exceljet offers: • free videos • paid courses • 500+ formulas • 100+ functions • 200+ shortcuts
Image from Clint Murphy (@IAmClintMurphy)
1
22
1
213
Replying to @exceljet
@exceljet Just wanted to say thanks for your site and excel information. When I want to read/learn/remind about any Excel function, your site is my first stop. Well done.
1
4
Hey @exceljet, your newsletters are invaluable. THANK YOU!
1
3
Geeky good stuff from @exceljet. New behavior (to me anyway and with Office 365) with dynamic arrays. exceljet.net/what-is-an-arra…
Image from Josh Preston (@joshpresto)
1
2
How long has #Excel had a filter function? My discovery of the morning and a great blog post by @exceljet helped me out. What's your discovery and what blog helped you?#AlwaysLearning exceljet.net/excel-functions…
1
2
10
One of my favorite things on the internet. @exceljet Bookmark it and your life will be better. exceljet.net/
3
4
Just used xlookup and boolean arguments in anger for the first time in Excel. Truly I am living life. (This would not have been remotely possible without the awesome @exceljet, the BEST Excel resource ever, so thank you Dave)
1
3
Just saved myself 15 minutes of Excel hell by this neat formula from @exceljet exceljet.net/formula/strip-n… Thanks Dave! 😃😃😃😃

Strip non-numeric characters

To remove all non-numeric characters from a text string, you can use a formula based on the REGEXREPLACE function. In the example shown, the formula in D5 is: =REGEXREPLACE(B5,"[^0-9]","")+0 As the...

exceljet.net
1
2
7
I was not aware of the @msexcel functions translator addin. People in English-speaking countries can't imagine our hell with localized Ex-hell. support.office.com/en-us/art…
5
1
8
After creating wordless instructions for making charts in Excel, what about creating them for #Tableau? That's even funnier. New post. excelcharts.com/wordless-ins…

Wordless instructions for making charts: Tableau Edition

After creating wordless instructions for making charts in Excel, here is the Tableau version. This post discusses similarities and differences between both tools. Check out the e-books at the botto…

excelcharts.com
5
20
5
97
Very sorry to hear of the passing of #Excel MVP Chip Pearson recently. Chip's web pages on Visual Basic Extensibility were an amazing resource. ow.ly/eknI30jKMlN
12
17
7
36
#Excel Office 365 adds pivot table defaults (video) youtu.be/9NeXHc2MI0c?a
1
8
1
10
[NEW POST] Six Alternatives to the Clustered Bar Chart, aka the most overused chart in history annkemery.com/clustered-bar-… – at Washington, DC
Image from Ann K. Emery (@AnnKEmery)
2
46
44
In this case, I was looking for excel shortcuts for Mac and found them on Exceljet.com, by @dgbruns.
1
1
2
Why are Excel shortcuts so dang popular? The team at @ExcelTV and @exceljet lay it all out owl.li/FobXM #excel
1
Do you have Excel-itis? This site will help you tame the spreadsheet beast in no time! - exceljet.net/
1
1
Load more