Holy sheet: How to pull contact details from a website using only Google Sheets (The Next Web)

The Next Web: Holy sheet: How to pull contact details from a website using only Google Sheets. “Are you in a job where you regularly need to collect contact information from companies? And do you find it an annoying and unnecessarily time-consuming task to sort through ever-changing web designs, to find that one button or bit of information you’re actually looking for? Don’t look any further… help is on the way!” Brilliant use of IMPORTXML / XPath.

The nightmare is real: ‘Excel formulas are the world’s most widely used programming language,’ says Microsoft (The Register)

The Register: The nightmare is real: ‘Excel formulas are the world’s most widely used programming language,’ says Microsoft. “Microsoft will let users create custom functions in Excel using the number wrangler’s own formula language….Dubbed LAMBDA, the feature (currently rolling out to beta customers) will be a lifesaver for anyone charged with maintaining herds of increasingly complicated spreadsheets, who have doubtlessly been wondering how it could be that Excel was missing such a seemingly obvious ability for so many decades.”

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