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