by Adam | Nov 3, 2017 | Blog
Excel’s array formulas are indeed a fascinating subject. Although they can be very useful by making it possible to solve some complex calculations, and replace hundreds of formulas in certain situations, most Excel users have probably never used these formulas before...
by Adam | Sep 7, 2017 | Blog
A good grasp on Excel functions can enhance your ability to perform day to day business tasks. Although there are hundreds of formulas in Microsoft Excel’s repertoire, most users only ever use a handful of them and you probably won’t ever need to use most of them. We...
by Adam | Aug 16, 2017 | Blog
Advanced Excel users often utilize external links or workbook connections to save data or referencing. External links can be hard to detect in a complicated spreadsheet, or a workbook you’re not familiar with. Finding these connections manually one by one can be a...
by Adam | Jul 20, 2017 | Blog
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...
by Adam | Jul 14, 2017 | Blog
Goal Seek is one of those tools that can stop you from scratching your head and give you the answers to problems like what interest rate can you afford for your loans, or how much should you sell a product for to make a profit. Essentially, any scenario where you have...
by Adam | Jul 7, 2017 | Blog
Pivot tables are tabular representations of data sets. They typically summarize data in an accessible way and also come with additional analysis features such as count, total, or average calculations. PivotTable (one word) is Microsoft’s trademarked feature and is...
by Adam | Jun 29, 2017 | Blog
You can create all sorts of mathematical models in Excel, but imagine a model with thousands of formulas, all of which need to be calculated every time you enter a value. This would make calculations very slow and the user experience, not a pleasant one. Thanks to its...
by Adam | Jun 20, 2017 | Blog
INDIRECT is a versatile function in Excel’s already huge repertoire of referencing tools. In this guide we’re going to take a look at its various use cases. This function can return the reference specified by a text string, foolproof your Excel models, or even...
by Adam | Jun 14, 2017 | Blog
Excel can be your database, it can be your calculator, and it can even be your time card. This handy software is also the first choice of many business professionals when it comes to data visualization. Dynamic charts in Excel allow for creating dashboards that...
