You will certainly need to work with many workbooks. Here we will demonstrate 3 methods to switch between multiple Excel workbooks. If you need to deal with many Excel workbooks at the same time, you will certainly switch between those...
Read more »Sometimes you need to find merged cells in Excel. And here we have found 2 methods to find merged cells in Excel worksheet. Merged cells will interrupt you if you need to use references in formulas or other places. In the image below, you can...
Read more »In using Excel functions, you will certainly need to use the different average functions. In this article, we will explore the usages of all the average functions. There are 4 variants of average functions: AVERAGE, AVERAGEA, AVERAGEIF and...
Read more »Sometimes you need to present data in a pie chart. And in this article, we will show you how to present your data in a half pie chart. Suppose now you need to present the sales volume in a half pie chart. There are 12 months with the...
Read more »In this article, we will introduce a method to quickly insert rows or columns into every two adjacent rows/columns quickly. In the image below, now you are going to input rows into to every two adjacent rows in this range. Instead of add rows...
Read more »Sometimes you need to save Excel files as PDF files. And in this article, we will introduce two methods to save worksheets as separate PDF files. PDF is a widely spread file format among users due to its character. Therefore, sometimes you need...
Read more »You can use add-ins in Excel to fulfill some complex task. And in this article, we will introduce how to add and disable add-ins in Excel. If you need to use add-ins in Excel, you need to add and activate it into Excel. On the other hand, if you...
Read more »In Excel, you can use the icon sets to mark cells with different values. And in this article, we will talk about how to use this feature in Excel. Icon sets is a very useful feature in Excel. It is also a small feature of the conditional...
Read more »If you want to create a chart in an Excel chart sheet, you can use the 2 methods in this article. You will certainly create a chart for a range in Excel. Sometimes instead of putting the chart in the same worksheet, you need to input the chart...
Read more »Count functions are the most frequently used functions in Excel. In this article, we will discuss about the different 5 count functions in detail. There are 5 variants of count functions: COUNT, COUNTA, COUNTBLANK, COUNTIF and COUNTIFS. Below we...
Read more »