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!
Conditional formatting is a wonderful and easy way to immediately format data in an excel spreadsheet. Click to know about Excel Conditional Formatting!
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 […]
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 […]
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!
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 […]
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!
You’re not getting the most out of Excel if you aren’t using relative and absolute references correctly. Get learning with Magoosh!
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!
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!