# Author Archive | Rich Rinaldi

• Rich writes about Excel and the PMP for Magoosh. He's an Excel nerd who passed his PMP exam with 4 Proficients & 1 Moderately Proficient (curse that Initiation domain!). He earned his BSBA in Operations Management at Georgetown University and his MBA in Non-Profit Management at Chaminade University in Honolulu. He works as a business analyst & project manager at a nationwide non-profit headquartered in Villanova, PA. Rich and his fiancée Hadley enjoy traveling the world or playing with Bear, Cherokee, and Nalani (their cats).

## How to Create a Drop Down List in Excel (With Examples)

At some point, you’ll be asked how to create a drop down list in Excel. Whether you’re an Excel novice or a whiz, you might not know this skill. After all, it’s not something you need every day. But trust me, when someone wants a drop down menu, they won’t settle for anything else. To […]

## How to Create a Pivot Table in Excel

Want to learn how to create a Pivot Table in a few easy steps? Look no further than Magoosh. We’ll get you started, and you’ll be a #PivotTablePro soon!

## Using the Sum Formula in Excel

Have you ever seen someone put data into Excel, then manually calculate the solution, and then type it into Excel? Perhaps you’ve even been this person! The good news is that I’m here to help you make sure that never happens again. Folks (like you!) who are looking to learn more about the sum function […]

## How to Use VLOOKUP in Excel

If you want to go from novice user to highly-respected Excel office guru, VLOOKUP is the function you need to master. It’s hard to underestimate the importance of VLOOKUP, so I can say without exaggeration that VLOOKUP will change your (Excel) life. Knowing it is absolutely essential. You might be wondering why VLOOKUP matters so […]

## The Difference Between Relative and Absolute References in Excel

You’re not getting the most out of Excel if you aren’t using relative and absolute references correctly. Get learning with Magoosh!