Category - Advanced Excel Tutorials

Learn the process for splitting names in Excel spreadsheets. When importing information into Excel, name data usually ends up all in one column, making it …

Follow our guide to learn how to remove initial in name in Excel. Initials and middle names in Excel documents can hinder other formulas that …

In Excel, you have the ability to add drop down menus to any cell, row, or column. With these menus, you are able to access multiple data …

Using a password in Excel to protect your documents is good for any sensitive information you are recording. Password protection in Excel is done differently for …

In Excel, Macros allow a user to automate tasks. In this tutorial, you will see how to combine values from two columns into a new …

Excel’s VLOOKUP function allows a user to search through the first column in a certain cell range and return the data from a cell in the …

In Excel, users are able to facilitate conditional formatting to highlight certain cells based on their contents.  This can be achieved with multiple “if statements”, …

The array formulas for Excel work to perform more complicated calculations than basic formulas. The primary purpose of array formulas is to calculate numbers that …