How to swap x and y axis in Excel graph
Swapping the x and y axis in Excel can be a useful tool when presenting your data in a chart or graph. It allows you to switch the placement of the data series on the chart, making it easier to interpret and compare the data. In this blog post,...
How to Hide Pivot Fields in Excel Charts
When creating pivot charts in Excel, it is often necessary to hide specific fields from the chart to improve its readability or to focus on specific data points. In this blog post, we will go through the steps required to hide pivot fields in Excel charts. Step 1: Select...
How to pull in data from Federal Reserve Economic Data (FRED) to Excel
United States Federal Reserve collects massive quantities of economic data. The organization distributes some of its data for free online. This post shows how to import FRED’s data into Excel. Step 1: Install FREDs Add-In. Go to https://fred.stlouisfed.org/fred-addin/. Click on the checkbox next to I agree to terms of...
How to add and remove Excel Add-Ins
Add-Ins are used to add functionality Excel such as pulling stock prices from a website, getting live weather, or connect with Jira. In short, Add-Ins are to Excel what apps are to an iPhone. To add an Excel Add-In, click on Insert > Get Add-Ins. The choose the Add-In...
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 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...
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...
How to transpose data in Excel
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 is B, the transposition will be A in row1 column1 and B will be in row2 column2....
Counting cells in Excel
Excel provides 4 different functions to count cells: count(), counta(), countblank(), countif() =count(A1:A10) Counts cells in the range which hold a value. Empty cells and cells containing formulas are not counted. =counta(A1:A10) Counts non-empty cells in the range. Cells containing formulas are counted. =countblank(A1,A10) Counts empty cells in the...
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”) Following is a more detailed explanation: Excel if statements have the following syntax: if (condition, TRUE, FALSE) Condition defines...