The Verge: Scientists rename human genes to stop Microsoft Excel from misreading them as dates

The Verge: Scientists rename human genes to stop Microsoft Excel from misreading them as dates. “There are tens of thousands of genes in the human genome: minuscule twists of DNA and RNA that combine to express all of the traits and characteristics that make each of us unique. Each gene is given a name and alphanumeric code, known as a symbol, which scientists use to coordinate research. But over the past year or so, some 27 human genes have been renamed, all because Microsoft Excel kept misreading their symbols as dates.”

Analytics Vidhya: 10+ Simple Yet Powerful Excel Tricks for Data Analysis

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

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

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.”

BetaNews: Millions of Microsoft Excel users vulnerable to remote DDE attack as new exploit is discovered

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.”

How to: uncover Excel data only revealed by a drop-down menu (Online Journalism Blog)

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.

Search Engine Journal: 11 Places You Can Learn Microsoft Excel for Free

Search Engine Journal: 11 Places You Can Learn Microsoft Excel for Free . “You don’t have to attend formal classes at a university to get a grip on Excel. There are numerous free resources available that let you learn the program from the comfort of your home. So, put on your favorite ‘Netflix and chill’ outfit, grab a snack or a tasty beverage, and prepare to understand Excel like you never have before thanks to these 11 places where you can learn Microsoft Excel for free.”

Digital Trends: Learn How To Convert A PDF Into An Excel Document, With These Easy Options

Digital Trends: Learn How To Convert A PDF Into An Excel Document, With These Easy Options. “Just because your co-worker sent you a PDF file instead of the Excel document you wanted, doesn’t mean you have to stick with it. In this guide, we’ll teach you how to convert a PDF into an Excel document in a few quick and easy steps. We’ll even teach you a few different ways to do it.”