by Adam | Apr 26, 2018 | Blog
Excel is an amazing tool for financial tasks, and calculating loan payments is no exception. The PMT function (sounds a lot like payment, right?) is often essential to investment, valuation, and decision making processes. If you are dealing with capital loans like...
by Adam | Apr 18, 2018 | Blog
Excel is the perfect tool for financial modeling. Many organizations can efficiently create and publish their models using only this tool. It’s no surprise Excel offers a ton of formulas that can handle almost any financial operation. In this article, we’re going to...
by Adam | Apr 16, 2018 | Blog
What is a Gantt Chart? Gantt charts are widely used in managing resources, operations, production, and other fields. The start and end times of each item is portrayed using the X axis scale and the bar length. Thanks to the way this chart is structured, you can see...
by Adam | Apr 10, 2018 | Blog
The data we collect in Excel spreadsheets are often unorganized and need to be restructured before using in reports or other calculations. When capturing first and last names, product IDs, or other properties, data collection tools can have different inputs for all...
by Adam | Apr 4, 2018 | Blog
There’s various functions and combinations of functions that can be used to lookup data in Excel. In this article, we compare the three common formulas used for this job, LOOKUP, VLOOKUP, and HLOOKUP. VLOOKUP & HLOOKUP The famous VLOOKUP is widely...
by Adam | Apr 2, 2018 | Blog
If you used Excel in any shape or form, there is a pretty good chance that you’ve used the formatting and number formatting features. Formatting options like number, currency, percentage, date and time values are easily accessible to users. However, that’s not all...
by Adam | Mar 26, 2018 | Blog
The beauty of Excel lies in its flexibility to create pretty much any mathematical model with little effort. Logic gates can be established within a table, chart, or any other spreadsheet element to dissect data and results. This gives Excel users the ability to...
by Adam | Mar 22, 2018 | Blog
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...
by Adam | Mar 21, 2018 | Blog
It’s that time of the year! Of course there are all kinds of tools out there you can use to calculate and submit your taxes for the last year, but it’s always a good idea to double check everything and if you prefer to do everything by hand, you might find this guide...
