Category: Advanced Excel

Excel has a wide variety of functions that you can utilize to accomplish a myriad of tasks. We have put a list of tutorials together on the functions that you absolutely have to know and what’s even ...

Excel provides the text worksheet functions, namely the Upper Function, the Lower Function and the Proper Function, which can change the case of a specified input text string. This text string could ...

It is often necessary to protect either the sensitive information in one’s actual worksheet or the workbook structure, from being edited. Excel provides different options for protecting and securing ...

Creating 3D referencing in Excel within a formula involves referring to the same cell or the same range of cells, on different worksheets. Each of the sheets, one is using, to create the 3D reference ...

Most of us are familiar with standard Excel chart types such as a pie chart, a column chart, and a line chart, as well as the types of data they are used to showcase visually. Excel, however, offers ...

The FORMULATEXT Function is a new Excel function, which was introduced in Excel 2013 and later versions of Excel. Using the FORMULATEXT Function will allow you to select any cell containing a formula ...