Sets

A set is the basic concept of batched data. Excel is ab […]

Join

The JOIN is one of the most important SQL operations. I […]

Grouping

Formulas and their copying We mentioned in the precedin […]

Structure

Formula copying Records are represented by the rows in […]

Background

Excel In effect, Excel, instead of many of the BI tools […]

esCalc Download

esCalc provides several editions and the license filesa […]

Monthly Top 5 Salesmen

Target Find the salesmen whose sales are in top 5 each […]

Wages Computing through Table Joins

Target Compute the net wages after joining the performa […]

Report of Sales of Various Car Models on Link Relative Ratio and Year-on-year Basis

Target: Make a grouped report on link relative ratio an […]

Share Price Rise on Five Consecutive Days

Target Find shares whose prices have been rising on at […]