Skip to content

Excel Posts

Cover Image - Create Dropdown Lists in Excel

Create Dropdown List in Excel

Learn how to create dropdown lists in Excel easily in this tutorial to help manage data entry in your workbooks.

Personal Macro Workbooks in Excel Cover Image

Setting up a Personal Macro Workbook in Excel (and some sample macros!)

When you develop a macro in Excel, it’s only available in the workbook you create it in – unless you add it to your Personal Macro Workbook. The workbook is a hidden workbook that runs in the background whenever you open Excel, allowing you to access any of the macros you’ve stored within it.

Vlookup in Excel Formula Cover Image

How to Use VLOOKUP in Excel

Learn everything you need to know about the magical and mystical VLOOKUP function in Excel!