Macros in Excel let users automate tasks for them. In the example tutorial, you will learn how to combine values from two different columns to create a third column. The data is represented…
Advanced Excel Instruction
How to Use VLOOKUP in Excel
Excel’s VLOOKUP function lets a user search the first column in a particular cell range and return data from a cell in the same row of that unique range. This example is for you…
How to Highlight Values in Excel
To highlight cells with certain values in Excel, you use conditional formatting. This creates highlighted cells for certain content. In the example, you’ll learn how to highlight values in Excel easily. Download the example…
Creating Arrays in Excel
In Excel, an array formula performs more intricate and powerful calculations than Excel’s basic formulas. Creating arrays in Excel will allow you to calculate numbers based on your set of conditions, along with…
How to Put a Password on your Excel Document
How to add Password Protection to your Excel documents For business or sensitive information, it’s important to password product your individual Excel document. Here you can learn how to put a password on…