Analytics Vidhya: 10+ Simple Yet Powerful Excel Tricks for Data Analysis. “I’ve always admired the immense power of Excel. This software is not only capable of doing basic data computations, but you can also perform data analysis using it. It is widely used for many purposes including the likes of financial modeling and business planning. It can become a good stepping stone for people who are new to the world of business analytics.”
The Verge: You can now make sick beats in Microsoft Excel. “Late last year, electronic musician and YouTuber Dylan Tallchief made a functional drum machine in Microsoft Excel after a bunch of Excel DAW memes made their way around social media. Now, Tallchief is back with an even more ambitious project that fully realizes the original meme’s potential: an Excel DAW he calls xlStudio. (For those outside the audio world, DAW stands for ‘digital audio workstation’ and is a software suite like Ableton or FL Studio used for making music.)”
ZDNet: Want to analyse your tweets? How to import Twitter JSON data exports into Excel. “It used to be easy to analyze your Twitter data: you’d go to your settings and ask for a download, and there among all the files would be a CSV file full of your tweets and the associated metadata. You could then load the CSV into Excel, convert it into a table, and save the resulting workbook. Once it was all in hand you were able to apply filters, searches, and, well, whatever analytical techniques you liked. But things have changed at Twitter, and if you request a download of your data it comes as a set of JSON files.”
Lifehacker: These Viral Excel Shortcuts Are Actually Useful. “‘How fast can you work in Excel?’ asks a viral video that’s been bouncing around the internet for over a year. The animation demonstrates some quality Excel shortcuts.”
How-To Geek: How to Count Data Matching Set Criteria in Google Sheets. “The COUNTIF function in Google Sheets lets you analyze data in your spreadsheet and returns the number of times it appears in your document if it meets a set of specific criteria. Here’s how to use it.”
BetaNews: Millions of Microsoft Excel users vulnerable to remote DDE attack as new exploit is discovered. “Security researchers from Mimecast Threat Center have discovered an Excel exploit that could leave 120 million users vulnerable to attack. The security flaw means that it is possible to use Excel’s Power Query tool to dynamically launch a remote Dynamic Data Exchange (DDE) attack on a spreadsheet and actively control the payload.”
Online Journalism Blog: How to: uncover Excel data only revealed by a drop-down menu. “Sometimes an organisation will publish a spreadsheet where only a part of the full data is shown when you select from a drop-down menu. In order to get all the data, you’d have to manually select each option, and then copy the results into a new spreadsheet. It’s not great. In this post, I’ll explain some tricks for finding out exactly where the full data is hidden, and how to extract it without getting Repetitive Strain Injury.” Ooo. Spreadsheet forensics. I like.