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!
How to Use Excel Conditional Formatting
Conditional formatting is a wonderful and easy way to immediately format data in an excel spreadsheet. Click to know about Excel Conditional Formatting!
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 […]
What Is the Sumproduct Formula in Excel (and When Should You Use It?)
SUMPRODUCT is a function in Excel that multiplies range of cells or arrays and returns the sum of products. Click to know more about SUMPRODUCT Excel!
How to Use the If Function in Excel
Most beginner Excel users know how to build simple formulas. Want cells A1 and B1 multiplied together? Just enter “=A1*B1” in a new cell. But what do you do when you want a certain result only when a specific condition is met? This is where the IF function can help. For example, take a look […]
16 Excel Shortcuts to Make Your Work Easier
If you’re looking for some handy Excel shortcuts, you’ve arrived at the right place! Click to know some amazing Excel shortcuts to make your work easier!
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!
Understanding the Sumif Function in Excel
SUMIF is a function in Excel which adds all the numbers in a range of cells based on one criteria. Click to know more about SUMIF Excel!
An Introduction to Excel VBA
VBA (Visual Basics for Applications) is a basic but powerful programming language. It is built into many Microsoft products. Click to know about Excel VBA!