Excel Tips and Tricks
How to unhide sheets in Excel and restore the worksheets tab
If you lost a worksheet or cannot find the worksheet tabs section in your workbook, fear not! In this guide, we're going to show you how to unhide sheets and various methods to restore disappeared worksheet tabs. Unhide Sheets in ExcelExcel allows hiding...
Excel UNIQUE Function: Spill Range Operator
The unique function in Excel is a powerful tool for handling dynamic arrays and spill concepts. This functionality enables users to efficiently manage and manipulate data within Excel, enhancing the flexibility and effectiveness of spreadsheet operations. With the...
All you need to know about Excel's new Spill feature
The term spill in Excel's literature is defined as populating multiple cells with a single formula. With the announcement of the dynamic arrays in September 2018, Excel formulas can now return (spill) an array of values into neighboring cells by starting...
How to delete blank rows and columns at the end of worksheets using VBA
Excel doesn't always update the range of cells you've used in worksheets when you modify them. This can result in a larger file size and have performance impacts, even after you clear cell contents. The easiest way to fix this is by deleting the blank rows and columns...
Area Chart in Excel
An area chart is a graphic representation of data by highlighting the areas between the axes and the plot lines. Being a variation of the line chart, the area chart places more emphasis on the “gap” between the data and the axis, and is commonly used to compare two or...
How to use IFS and SWITCH formulas instead of nested IF statements
Nested IF statements are useful for creating more complicated scenarios in Excel. However, IFS and SWITCH formulas can work more efficiently when dealing with more than one condition. These formulas work a bit differently than the legacy IF function. Let's...
How to apply conditional formatting to Pivot Tables
Conditional Formatting is commonly used to highlight data fields to easily identify outliers, or narrow down the results. However, this feature works a bit differently when dealing with a Pivot Table. Pivot Tables are also dynamic elements, and conditional...
How to make a line graph in Excel
Widely used in various fields, a line chart is one of the staples of data visualization. Line graphs (charts) are a graphic representation of data shown on lines across the chart area. In a line chart, lines typically represent categories, and are drawn between data...
How to compare two columns in Excel
Comparing the data in two different columns is a frequently used method in data analysis. In Excel, you can compare using formulas or highlighting. In this guide, we’re going to show you how to compare two columns in Excel using these two methods.Compare...