How to strikethrough text in Excel
This post shows how to strikethrough text in Excel. Select cells and press ctrl+shift+F simultaneously. You will see the format cells window. Click to check Strikethrough and click on OK.…
How to create a new team
This post shows how to create a new team in Microsoft Teams. To create a new team in Microsoft Teams, go to Teams > Join or create teams > Create…
How to join a team
This post will show you how to find and join an existing Microsoft Teams team. To join a team, simply click on the Teams icon and then on the “Join…
Python code to work with Excel files
Note: The instructions are for python3.x on Ubuntu There are several different libraries you can use to easily work with Excel. I will be covering openpyxl. Other options include xlsxwriter,…
Filling Excel worksheet cells automatically
When dealing with large datasets you would often need to fill in values. Excel provides several easy ways to fill cells. There are two primary methods for filling cells. 1.…
Excel: how to transpose data
The following steps show how to transpose data in excel. Transposition refers to switching between rows and columns. For example, if row 1, column1 is A, row 2, column 2…
Nested if statement in Excel
Excel allows you to write a nested if statements. Following is a typical if statement: To write another condition inside the one returns true:
Removing characters from Excel cells
Sometimes Excel cells contain unwanted data. Removing this data can be a very tedious job. For example, I recently received a data file where the first column cells contained some…