Have you ever wanted to pull up specific term or phrase within your document and a value that might be associated with it? This would be difficult to perform from multiple tabs and…
Advanced Excel Instruction
How to Use the COUNTIF Function in Excel
Counting the number of times a specific item appears in an Excel spreadsheet can be tedious, especially when you have to look through multiple pages or tabs to get an accurate account of…
How to Use the Concatenate Function in Excel
Have you ever wanted to change the look and appeal of your Excel spreadsheet? Maybe you want to write extensive messages, but find extending the columns in one row just makes the portions…
Split Full Names in Excel
Learn how to split full names in Excel spreadsheets. When you have a worksheet with a column of full names, or have imported a document that puts full names in just one column,…
Remove Middle Initial in Excel
Learn how to remove middle initial in Excel spreadsheets. If you have a list of names in your Excel sheet but want to break it down to just the first name and last…
Excel Dropdown Lists Tutorial
In Excel, a user has the ability to customize columns and rows of cells through unique dropdown menus. In dropdown lists, you can access many data choices for output within a cell. The…