How to check if a cell is empty / blank in Excel
In this post, you will learn how to check for an empty cell. To check if a cell is empty or blank, we use the isBlank() function isBlank() function takes a cell address as input and returns true or false. In the example shown in the screenshot above, In...
How to create a schedule in Microsoft Project
The easiest way to create a schedule in Microsoft Project is to use the Gantt Chart view. In this post, I will be demonstrate how to create a create the schedule, add/modify/delete tasks, and how add and remove dependencies. Gantt Chart View Start Microsoft Project and choose a blank...
How to change Project Start Date
This post shows how to change the project start date in Microsoft Project. To change the Project Start dates, go to Project > Project Information and change the Start Date. Following is a step-by-step explanation: Click on Project and then Project Information Update the Start Date and click ok...
How to count cells with Excel formula
This post shows how to count cells with Excel formulas. Excel provides 4 different functions to count cells: count(), counta(), countblank(), countif() Let’s look at each in a bit more detail =count(A1:A10) Counts cells in the range which hold a value. Empty cells and cells containing formulas are not...
How to convert XML to JSON using PHP code
This post show how to convert XML to JSON using PHP code. json_encode() function converts valid XML to JSON Following is example: In this example, we have an empty data.json file and a data.xml with the following content data.xml <staff> <employee> <name id="1">Alice</name> <dob>January 1, 2000</dob> </employee> <employee> <name...
How to create CSV output from PHP code
This post shows how to generate CSV output from PHP code. In PHP, the fputcsv() function generates a csv file when it is provided a valid two dimensional array. Following is an example with explanation // create a two dimensional array of data $myarrays = array( array ('Canada', 'China'),...
Cleaning text with trim() and proper()
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 how to use trim() and proper() functions to clean text in Excel. I have the following text that needs...
Excel: How to visualize formula dependencies
Suppose you want to know what the impact of changing the value of a cell would be. Excel provides an easy way to visualize all the cell that will be impacted by change the value of a cell. To visualize cell dependencies in Excel, go the Formulas ribbon 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 use the shortcut ctrl + ~ Following are detailed instructions: I have an income statement with many formulas that...
Exploring WordPress Block Manager
WordPress ships a large number of blocks. Many plugins add even more blocks to your WordPress. Therefore, WordPress offers a Block Manager feature that allows you to manage your blocks. To access the Block Manager, click on + New > Post: The click on the “vertical 3-dot icon” and then...
How to change the language of your WordPress site
This post show how to change the language of your WordPress website. To change the site language, go to Dashboard > Settings and select the language of your choice for Site Language. The click on Save Changes. Following are step-by-step instructions: Step 1: Go to the Dashboard Step 2:...
What is the difference between =, ==, and === in JavaScript
The following example illustrates the difference between =, ==, and === var x = 10 // intvar y = “10” // stringx == y // returns truex === y // returns false x==y casts y to an integer and then compares the two values, returning truex === y tests...