by Ilker | Jul 5, 2023 | Blog
Microsoft Excel, a staple in the toolkit of professionals across a myriad of industries, is often perceived as a simple spreadsheet program, ideal for organizing data and performing basic calculations. However, Excel is far more versatile than it appears at first...
by Ilker | May 11, 2023 | Blog, Tutorial
Excel provides a wide range of user interface features that allow users to interact with the application. However, these features can be time-consuming to use, especially when performing repetitive tasks. Macros can be used to automate these tasks and streamline the...
by Ilker | May 4, 2023 | Blog, Tutorial
Incorporating VBA-based UDFs (User-Defined Functions) in Excel empowers users to extend the functionality of their spreadsheets beyond the standard set of available functions. By leveraging VBA (Visual Basic for Applications), a versatile programming language native...
by Ugur | Mar 2, 2018 | Blog
Recursive simulations of spreadsheet models constitute one of the more advanced uses of Excel across various industries, although perhaps most commonly in the financial services industry. Often, third-party add-ins are utilized to run Monte-Carlo simulations in Excel....
by Ugur | Feb 22, 2018 | Blog
One of our primary undertakings for the SpreadsheetWEB 6.0 release was a major dedicated effort to improve the performance of our core spreadsheet calculation engine. The calculation engine was written in C++ and is optimized for server-side processing, focusing...
by Ugur | Apr 14, 2017 | Blog
Many Excel projects start with a small assignment to solve a simple problem. The individual tasked to solve the problem puts together an Excel workbook. As its usage expands, it is distributed to more and more individuals in the company. As more individuals utilize...
by Ilker | Feb 23, 2016 | Tutorial
What is a Custom Application? Custom application feature allows user to create unique user interfaces (UI) by using the flexibility of HTML and CSS combined with power of JavaScript programming language. How to create Custom UI applications Custom applications...
by Ilker | Feb 10, 2016 | Tutorial
What is a User Defined Function (UDF)? A user-defined function (UDF) is a function provided by the user of a program or environment, in a context where the usual assumption is that functions are built into the program or environment. Although Microsoft Office Excel...
by Sasha | Jan 12, 2016 | Blog
Most applications, albeit web-based or otherwise, incorporate some resemblance of business logic – “the part of the program that encodes the real-world business rules that determine how data can be created, displayed, stored, and changed.”[1] Not only do these rules...