Select Page

## Function: INT

The Excel INT function is a Math formula that rounds a given number down to the nearest integer. Although, it is similar to the TRUNC function, they work differently when working with negative numbers. In this guide, we’re going to show you how to use the INT function...

## Function: TRUNC

The Excel TRUNC function is a Math formula that truncates a given number by removing a number of digits. Although, it is similar to the INT function, the TRUNC function works differently when truncating negative numbers. In this guide, we’re going to show you how to...

## Function: COUNTBLANK

The Excel COUNTBLANK function is a Statistical formula that counts the empty cells in a given range. It can be especially useful in data analysis and organization tasks, where you need to find out any errors or fields that require attention. In this guide, we’re going...

## Function: REPT

REPT is a Text function that repeats a string a given number of times. It is useful for filling a cell or fixed length of strings, as well as creating simple histograms. In this guide, we’re going to show you how to use REPT function and also go over some tips and...

## How to get top values from a list or a table in Excel

Sorting data can substantially help organizing data and generating reports. In Excel, you can sort data with a single click using the Sort icons under the DATA tab. However, this is a permanent solution, meaning that the sorted data will remain that way, and you will...

## How to Generate a General Ledger (GL) List using SEQUENCE

Ledgers are crucial for keeping track of expenses, and managing the budget of any entity, be it a small house to an international company. Preparing a general ledger (GL) table can be a daunting task, especially when dealing with lots of category codes. If your table...

## Function: MEDIAN

The MEDIAN Excel function is a Math formula that calculates and returns the median of the selected values. The median in statistics represents the middle value in a dataset. In this guide, we’re going to show you how to use the Excel MEDIAN function and also go over...

## Function: TRANSPOSE

The TRANSPOSE Excel function is a Lookup & Reference formula that rotates a given range or array. Since the output of this formula is an array, you need to press the Ctrl + Shift + Enter (CSE) key instead of just pressing the Enter key when entering this function....

## Function: CONCATENATE

The CONCATENATE Excel function is a Text formula that joins multiple strings together. You can enter static strings and individual cell references. In this guide, we’re going to show you how to use the CONCATENATE Excel function and also throw in some tips and error...