There’s a brand new keyboard shortcut in Excel. You can now launch the Power Query Editor by pressing Alt + F12 instead of going to Data > Get Data > Launch Power Query Editor. A small but welcome addition.
For over 15 years, the bedrock of an Excel worksheet has been its 1,048,576 row by 16,384 column grid to house our data, formulas, tables, and charts. It wasn’t always this way. Prior to Excel 2007, only 65,536 rows and…
Since Elon Musk’s $44 billion acquisition of Twitter, things have gotten off to a rather tumultuous start. Like a bull in a china shop, he arrived and instantly asserted his authority, purging almost two-thirds of the workforce to take the headcount from 7,500 to…
Let’s talk about reactions. Facebook started the trend in 2016, when they unveiled five alternatives to the ‘Like’ we were all accustomed to: ‘Love’, ‘Haha’, ‘Wow’, ‘Sad’, and ‘Anger’. This was a response to the long-standing demand for a ‘Dislike’…
TEXTSPLIT and BYROW were both released earlier this year. The former allows you to split a text value by a delimiter, whilst the latter applies a LAMBDA to each row and returns an array of the results. Take a look…
Want an alternative to those boring 2D images strewn across your worksheet? Consider 3D models, which are graphics that can be rotated 360° or tilted up and down. Excel has an extensive range of static and animated 3D stock models….
End of content
End of content
