How to transpose data in Excel
The following steps show how to transpose data in Excel. Transposition refers to switching between rows and columns. See the three step process below: 1 – copy a dataset 2…
Counting cells in Excel
Excel provides 4 different functions to count cells: count(), counta(), countblank(), countif() Counts cells in the range which hold a value. Empty cells and cells containing formulas are not counted.…
How to write nested if statements in Excel
This post shows how to write nested if statements in Excel To write a nested if statement, write other if statements in place of true or false statements. For example:=if(A3=A4,if(B3=B4,”True”,”False”),”False”)…
How to merge and unmerge cells in Excel
In this post, you will learn how to merge and unmerge cells in Excel. Select cells and then click on Home tab in the menu followed by Merge and Center…
How to add line breaks in WordPress
This post shows how to add line breaks in WordPress. There are two ways add line breaks. Shift+Enter in visual mode or by adding <br /> in HTML mode. When…
How to concatenate cells in Excel
This post shows how to concatenate cells in Excel. concatenate() function concatenates cells=concatenate(A1,A2) Suppose we have the following data: The & operator can be used to concatenate cells. The following…
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 remove author and date from WordPress posts
This post will show you how to remove author and date from your WordPress posts using additional CSS. To remove author and date, add additional CSS that sets .entry-meta to…
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…