Excel Solutions

How to Use the OFFSET Function in Your Excel Worksheet

Functions in Excel can help you solve many complex problems. And today we will introduce the usage of the OFFSET function in Excel worksheet. Among all the functions in Excel, the OFFSET function is a very useful one. This function also has a wide range of use in Excel. In this article, we will show you how to use this function in different conditions. The Usage of OFFSET Function The OFFSET function will return the cells reference according to a certain condition. Here we will use this...

Read more »

How to Group or Ungroup Data in a Pivot Table in Your Excel Worksheet

Pivot table can help us manage large data and information. In this article, we will introduce how to group or ungroup data in a pivot table. There are many useful features in pivot table. And those features make the pivot table a very useful tool for data analysis. The image below shows the pivot table in a worksheet. The first column is the date of the range. By default, they will all be listed in the column A. But if you need to know the sales volume in a certain period, such as in a...

Read more »

2 Useful Methods to Convert Numbers to Dates in Your Excel Worksheet

The numbers in cells will not turn into dates automatically in a certain condition. Therefore, in this article, we will provide two methods to help you solve this problem. You will certainly need to input dates into excel worksheet. And there are many different types of date format. On the other hand, you will also copy some dates into Excel cells. However, if there is no symbol for dates, i.e. the hyphen symbol (-) or the slash symbol (/), those numbers will not change into dates...

Read more »