Category - Advanced Excel Tutorials

Splitting Names in Excel

Splitting Names in Excel

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 …

Read More

Remove Initial in Name in Excel

Remove Initial in Name in Excel

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 …

Read More

Drop Down Menus in Excel

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 …

Read More

Using a Password in Excel

Excel password protection

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 …

Read More

Excel Macros

Excel Macros

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 …

Read More

Using VLOOKUP in Excel

Using VLOOKUP in Excel

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 …

Read More

Highlighting Cells with Certain Values

Highlighting Cells with Certain Values

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”, …

Read More

How to Create Arrays in Excel

How to Create Arrays in Excel

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 …

Read More