Exceljet

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

[Exceljet @exceljet]

@CyrusShepard @ZebraBI We've been reporting ZebraBI's AI content as spam for a while now with no results so far. It's not in Google's interest to promote, since the user experience is poor. What is the right channel to report?

[Exceljet @exceljet]

Hey, we're famous for getting ripped off :)
https://t.co/Mh1P5htvpw

[Exceljet @exceljet]

@bresslertweets @ZebraBI @msexcel @MrExcel @LeilaGharani @googlesearchc Appreciated. Just trying to keep people honest around here :) We are just one of many #Excel sites that have worked hard to publish quality info

[Exceljet @exceljet]

Hey @ZebraBI - the @msexcel team will be surprised to learn that Excel has a STRIKETHROUGH() function! 😀 Currently #1 in Google for "Excel strikethrough". cc @MrExcel ,@LeilaGharani, @googlesearchc

https://t.co/tXJQGg5tX1

[Exceljet @exceljet]

On Bing, the same article is on page #3, FWIW.

[Exceljet @exceljet]

See your instructions here:

[Exceljet @exceljet]

@bresslertweets @ZebraBI @msexcel @MrExcel @LeilaGharani @googlesearchc Exactly. (1) Why is it out there at all? (2) Why is it ranking? What is 2000 words about strikethrough worth if it's not accurate?

[Exceljet @exceljet]

@MSExcelPro This is lifted directly from @wmfexcel's post here. You should give credit where credit is due. https://t.co/e9yxpqlca2

[MF Wong @wmfexcel]

Paginated report (kind of) in #Excel
https://t.co/zV2olmaPJ1

[Exceljet @exceljet]

@wmfexcel @MSExcelPro Very annoying. The right way to share another's content is to re-tweet. Can you share an example or two? Some basic info here - https://t.co/XkEveHkySY

[Exceljet @exceljet]

@MikeBlazerX As the 10-year-old site "featured" in Jake's case study (but not credited) - we think it's bad for all of us if good content is out-ranked by a flood of AI-gen spam. The Excel articles on Causal's site are garbage. Example - https://t.co/KiaA5UzLA2

[Exceljet @exceljet]

Look carefully at these steps to "change your row labels" in #Excel. It's not that these steps are wrong in some small way. It's that they actually describe a feature that does not exist in Excel. And yet it ranks as a "featured snippet" in Google's search results.

[Exceljet @exceljet]

The cool thing in the example is the *negative* instance number in TEXTAFTER. This tells TEXTAFTER to get all text after the *last* space. Excellent feature, useful in many situations.

[Exceljet @exceljet]

The new functions in #Excel are useful. The "old" formula to get the last name:

=MID(B5,FIND("*",SUBSTITUTE(B5," ","*",LEN(B5)-LEN(SUBSTITUTE(B5," ",""))))+1,100)

The "new" formula: =TEXTAFTER(B5," ",-1)

We like the second option :)

[Exceljet @exceljet]

@CyrusShepard ZebraBI is running a very similar project, spraying out thousands of crappy AI-gen Excel articles with overlapping titles, many now ranking #1 as featured snippets. Is it possible to count these articles?

[Exceljet @exceljet]

Bottom line: at over 2000 words, this article is mostly just AI-generated fluff. Yet, for some reason, Google is ranking it #1. Please do better Google! There are many great Excel sites out there. More words <> more quality. cc @JohnMu

[Exceljet @exceljet]

What about advanced techniques?! They have it covered. Check out this word salad:

[Exceljet @exceljet]

Not helpful? Here are two more articles on the same topic:

[Exceljet @exceljet]

Plus, you can also use macros to automate the process! Yes. But do be careful if you go this route, because "macros can be risky". Actually, there is no code or instructions, so most people probably won't try macros?

[Exceljet @exceljet]

Followed by some nonsense about creating a weighted average with multiple criteria. Seriously, give these 4 steps a try, and let us know how it goes!

[Exceljet @exceljet]

Maybe the most interesting thing about this article is that there is not a single working formula or screenshot. The closest we get is this how-to:

[Exceljet @exceljet]

Another fluffy AI-generated article from @ZebraBI, currently ranking #1 as the "featured snippet" for "Excel weighted average" on @Google. (The screenshot comes from Exceljet, but that's for another day)