by Adam | Mar 4, 2019 | Blog
A scatter chart is a graphic representation of data by placing a collection of points on Cartesian Coordinates. The position of each point is determined by the value of two variables, one for the x-axis and the other for the y-axis.Scatter charts are useful for...
by Adam | Mar 1, 2019 | Blog
In this update, we’ve introduced many new thrilling features that will allow you to do more with your designer applications that are even more flexible than ever. One of the biggest changes in this version is that you can now include the designer charts and maps in...
by Adam | Feb 22, 2019 | Blog
Dropdown style inputs are very useful in the sense that their use can expedite the data entry process in most applications. Imagine you want to use this feature to create sequential questions that affect each other, like disabling some options based on the previous...
by Adam | Feb 21, 2019 | Blog
To ensure their vendors have necessary measures in place, businesses often request security audit forms that capture details about vendor practices. These forms typically consist of questions regarding physical and digital security systems, common procedures, and...
by Adam | Feb 19, 2019 | Blog
Excel’s Pivot Tables are very powerful in the sense that you can perform most data organization and analysis tasks on the fly. Although Pivot Tables have several advantages over using formulas for the same effect, working with Pivot Tables can be tricky in certain...
by Adam | Feb 12, 2019 | Blog
An area chart is a graphic representation of data by highlighting the areas between the axes and the plot lines. Being a variation of the line chart, the area chart places more emphasis on the “gap” between the data and the axis, and is commonly used to compare two or...
by Ugur | Feb 6, 2019 | Blog
Configure, Price, Quote (CPQ) is a term that is used to describe software solutions that aid companies in effectively and accurately quoting costs for complex products. For example, a computer server has numerous components that contribute to the pricing model, such...
by Ugur | Jan 30, 2019 | Blog
Wikipedia defines financial modeling as “the task of building an abstract representation (a model) of a real world financial situation.” Many of these financial models are built in Excel. In this article, I will outline the basic principles of financial modeling in...
by Ugur | Jan 25, 2019 | Blog
Microsoft Excel is an invaluable tool in the hands of entrepreneurs. They can model and program an entire business process in Excel. Those proprietary models can extend from financial applications, like business valuation tools, to engineering calculators. Many...