INDEX & MATCH: A Better Way to Look Up Data

INDEX & MATCH: A Better Way to Look Up Data

VLOOKUP and HLOOKUP are the go-to functions for most Excel users to look up data in a table. However, there is an alternative to this function that can do the same job, with added benefits. It’s the INDEX and MATCH combo. Using these two formulas in conjunction can...
Crunch Data Even Faster with Excel SUMIFS Function

Crunch Data Even Faster with Excel SUMIFS Function

SUMIF function, as the name suggests, sums up the values in a range of cells, if a certain criteria is met. What if you want to compare multiple checks and add different columns? That’s where its older brother, SUMIFS, come into play. SUMIFS can do the exact same...
Reducing Formula Errors in Excel

Reducing Formula Errors in Excel

Following certain guidelines when working in Excel can save you the headache of dealing with errors. And if something does go wrong with a formula, there are things you can still do. Let’s take a look at some recommended methods for creating formulas, and how to...
Extract Data Quickly From Tables with Excel’s SUMIF Function

Extract Data Quickly From Tables with Excel’s SUMIF Function

SUMIF function is, in a way, a combination of SUM and IF statements. The formula SUMs up the values of a range of cells, IF certain criteria is met. In other words, data that pass the logic test gets to be added up (or another column of your choice, that corresponds...
Identifying and Analyzing Spreadsheets: Formula Auditing

Identifying and Analyzing Spreadsheets: Formula Auditing

Were you just handed a massive spreadsheet and you have no idea how it’s structured, or what it does? Are you tired of following the root cause of errors in your formulas? If you answered yes to any of these questions, or simply would like to audit the formulas in an...

Create Your Own Custom Time Cards in Excel

Punch cards were taken over by software a long time ago. There are all kinds of applications, proprietary software, and templates that help businesses track their employees and bill their clients. However, most professionals swear by the most reliable office tool...
What’s New in Version 5.2

What’s New in Version 5.2

This update exclusively focuses on Microsoft Excel’s conditional formatting feature. It’s a challenging implementation on web applications and we dedicated this entire development cycle to all its quirks. For those of you who are not too familiar with conditional...
Developing Mobile Enabled Spreadsheet Tools

Developing Mobile Enabled Spreadsheet Tools

While Excel has been a very powerful productivity software, a great majority of businesses have been relying on their employees building powerful tools using this platform. With added capabilities VBA/macros have to offer,…