If you have tried to serialize an object in Python into JSON you may have come across an oblique error that mentions you're unable to serialize it, but what does this mean? I recently had an example whereby I needed to transfer a dict object … [Read more...] about JSON.dumps Not Able To Serialize Object
Blog
Not Null In Google Sheets
How can you check if a cell or value is not null in Google Sheets? There are several ways to check if a cell is not null in Google Sheets with formulas like ISBLANK() or simple operator checks like "<>" with formulas like AVERAGEIF and … [Read more...] about Not Null In Google Sheets
How To Use Google Sheets QUERY SELECT & WHERE With Examples
Are you looking to learn how to use the Google Sheets QUERY function to select and filter data based on specific conditions? In this blog post, you'll explore the ins and outs of the powerful QUERY function, particularly focusing on SELECT and … [Read more...] about How To Use Google Sheets QUERY SELECT & WHERE With Examples
What Are Sheets in Excel? A Clear Explanation for Beginners
As someone who has been using Excel for several years, I know how important it is to understand the basics of the program. One of the most fundamental elements of Excel is the sheet, which is essentially a grid of cells that can be filled with … [Read more...] about What Are Sheets in Excel? A Clear Explanation for Beginners
How to Sort Data In Excel: Single Column & Multi-Column
Sorting data in Excel is a fundamental skill that can help you better analyse and understand your data. Whether you are working with a small or large dataset, sorting can help you quickly identify patterns, trends, and outliers. Excel provides … [Read more...] about How to Sort Data In Excel: Single Column & Multi-Column
What Are Cells in Excel: A Simple Explanation
What is a cell in Excel? Once you dive into learning Excel it doesn't take long before you discover a whole new world with its own language! And cells are a frequent term used, so what is it? Simply put, cells are the individual unit of an … [Read more...] about What Are Cells in Excel: A Simple Explanation