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 rotate video
This post shows how to rotate a video using VLC player. VLC player is a free software that be downloaded from https://www.videolan.org/. To rotate video: Download and Install VLC Player: Go…
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 generate public/private keys
This post shows how to generate public / private key pair. To generate public/private key pair, simply run the following command:$ ssh-keygen -t rsa Following are step-by-step instructions: 1. Open your…
Linux: How to delete files recursively
The rm command deletes files. To delete a directory that is not empty and its subdirectories, use$ rm -rf directory However, sometimes you need to remove a specific subdirectory rather…
What is the difference between on-premise and cloud
This post discuss the technical pros and cons of on-premise infrastructure and cloud infrastructure. What is cloud computing? Cloud computing is on-demand delivery of IT resources and applications via the…
How to create a table in WordPress
This post shows how to create a table in WordPress. To create a table in WordPress: Following are detailed instructions. In your post page, Click on the + icon to…
How to install a WordPress Theme
This post shows how to install a WordPress theme with a few clicks. To install a theme: Following are detailed instuctions: Go to your WordPress dashboard: Then click on Appearance…