Cleaning text with trim() and proper() in Excel
We often import data, including text, from different sources into Excel. Sometimes this text requires some cleaning such as removing spaces and adding consistency to the text. This post demonstrates…
Mean, Median, and Mode in Excel
In Microsoft Excel, you can easily calculate the mean, median, and mode for a set of data using built-in functions. Let’s break down how you can do each: Mean: To…
How to count cells in Excel
This tutorial shows how to count cells in Excel using various formulas effectively. Excel offers four distinct functions for cell counting, each catering to specific scenarios: COUNT(), COUNTA(), COUNTBLANK(), and…
How to see all formulas on a Worksheet
This post shows you how to visualize all formulas on an Excel sheet at once. To see all formulas on a worksheet, go to Formulas > Show Formulas or simply…
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. You should see the following:
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…