Making name lists is a very common task done using Excel. It can be the list of employees, customers, friends, or family members. Sometimes, we may need to extract the last names only to include them in a report. In this section, we will discuss the ways of extracting last names from excel. There are … Read more
In Excel (Excel 365 or newer version), users often face a problem called “SPILL Error”. It is a new error code that can be found in Excel along with the usual error codes. Although the word “SPILL” sounds new to the users, the characteristics of “spilling” can be found in older versions of Excel too. … Read more
Box and Whisker Chart in Excel Box plots are usually called box and whisker charts. These are used not only to visually summarize a dataset but also to understand the distribution of the data better. On this page, we will discuss what a box and whisker chart is, how to interpret a chart, and how … Read more
