A spreadsheet helps users to be able to perform calculations without doing this process manually by hand. As you come to use spreadsheets more often you’ll be impressed at the …
If a cell contains words it can be easy to split these into individual cells using the Text to columns feature in Excel. Simply select the cells you want to …
When you start entering text into a cell and the first character of that cell is a plus symbol (+) you will get an error #NAME? and you would have …
When using large numbers in Excel or any other spreadsheet application, such as Google Sheets, some cells may display a number in scientific notation like 9.991E+35. How do you get …
How do you increase a variable by one in Python? In other popular programming languages to increment a variable by one you can use the simple increment syntax of ++, …
When using a spreadsheet it can be as easy as using the TRANSPOSE function on a range to transform the rows and columns into columns and rows, but how do …
You can construct a list in a certain number of ways as detailed in the Python documentation. The most popular I use the most is by defining my list variables …
To remove an individual item from a list in Python you can use either a list method or the del statement, both approaches mutate the original list – meaning the …
The VLOOKUP formula is a popular function for getting the value from a tabular data set and has 3 required parameters and an optional fourth, and looks something like this: …
To sort a list of strings according to their length, use a lambda function on the key parameter with the lambda function using the len function on each element. This …
The QUERY formula is a great way of being able to perform basic SQL-like commands on a data range. The signature of the QUERY formula is as follows: The first …
Merged cells are a great way to span content over multiple cells, and you can easily remove a single merged cell with one click by clicking on the merge cell …
There will come a time when using Google Sheets where you will be checking the value of a cell against multiple criteria, which one is the best to use? There …
Recently I had a column of names in a spreadsheet with the following structure: Last Name, First Name and they needed to change to the structure: First Name Last Name. …
I recently had an exercise where I needed to extract all the text from an OmniGraffle document. The task at hand was to check a beautifully designed organisation chart against …
To convert a string to an integer you use the handy int() function. For example, if you have a string such as “79” and you insert this like so into …
One of the first formulas I started with when exploring more about the functionality of spreadsheets is the IF formula. The IF formula is easy to understand and contains only …
How do you check if a cell is empty or blank in Google Sheets? There is a handy function called ISBLANK which enables you to check if a cell is …
Recently, I had an issue where I needed to calculate the age of a person at specific dates throughout the year. Using a Google Sheet, I thought I could simply …
Recently, I had an exercise where I needed to flatten a two-dimensional list down to just one dimension, something where I needed the result to be like this: There were …
In Python there is a handy function to determine the data type of any variable, and it is aptly called type(). This function can help to assess whether a variable …
