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.”
Alphr: Understanding If /Then Statements In Google Sheets. “If/Then statements are often considered complex. But in reality, they’re not at all difficult to pull off. Plus, they can be more useful than you realize when working with specific data sets or expressions in a spreadsheet.”
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.”
How-To Geek: How to Count Blank or Empty Cells in Google Sheets. “When you’re analyzing data in a spreadsheet, counting empty or blank cells could help you focus on specific areas. This is why functions like COUNTBLANK, COUNTIF, COUNTIFS, and SUMPRODUCT are so important in Google Sheets.”
How-To Geek: How to Use the AND and OR Functions in Google Sheets. “If you’ve ever wanted to check whether data from your Google Sheets spreadsheet meets certain criteria, you can use AND and OR. These logical functions give you TRUE and FALSE responses, which you can use to sort through your data.” Decent overview for beginners, not too deep.
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.”