How to rank data in Excel tables

How to rank data in Excel tables

by | Apr 4, 2018

Sure, it’s easy to find the highest or smallest values in a data set. But what if you’re looking for the 3rd, 10th, 20th rank in a large table, or need to do this in ascending and descending order? Luckily, Excel features a formula that does just that....
How to calculate weighted average with SUMPRODUCT

How to calculate weighted average with SUMPRODUCT

by | Apr 2, 2018

A final exam is worth more in terms of graduation score and the term weighed average becomes relevant. In such cases, SUMPRODUCT formula can help calculate the weighed totals of a data set. In our example, test scores of 3 candidates are being compared. Although...
How to COUNT values between two dates

How to COUNT values between two dates

by | Apr 2, 2018

A quick and easy way to count between dates is by using the COUNTIFS formula. Create formula-based filters, find your sales figures, or organize your tables in no time. Syntax =COUNTIFS(date range, >=minimum date, date range, <=minimum range) Steps Type...

How to Use Logic Statements in Excel: IF – AND – OR – NOT

by | Mar 26, 2018

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...

Power Query 101 - Data Scrub and Analysis in Microsoft Excel

by | Jan 23, 2018

Power Query, a dynamic and robust add-in for Excel, is a game-changer for business users dealing with data. As we all know, data can come in various forms and from diverse sources, making it challenging to manage and analyze. Moreover, reporting tools often have...

Custom Application Tutorial

by | Feb 23, 2016

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...
Implementing Goal Seek with SpreadsheetWEB

Implementing Goal Seek with SpreadsheetWEB

by | Jan 20, 2016

What is Goal Seek? In numerical analysis, goal seek constitutes a question: under a given set of criteria, what degree of change is required to achieve a convergence between the actual and a theoretical result? It can be understood as a tool for determining the cause...

Decoupling Business Logic with Excel-based Microservices

by | Jan 12, 2016

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...