esProc Desktop's Blog
Tag

Beginner Developers

#beginners

More content

Read more stories on Hashnode

Articles with this tag

#89 — Calculate Proportion Using the Aggregation Values of the Data from the Same Group

Nov 5, 20241 min read

Problem description & analysis: Here below is an annual and quarterly sales data table: Task: Calculate the proportion of each quarterly sales to the...

#89 — Calculate Proportion Using the Aggregation Values of the Data from the Same Group

#84 — Accumulation for Continuous Occurrence of A Certain Condition

Oct 29, 20241 min read

Problem description & analysis: There is a statistical table for daily sales: Task: We want to add a column to the right to calculate the cumulative...

#84 — Accumulation for Continuous Occurrence of A Certain Condition

#72 — Filter by Grouped Aggregation Values

Oct 12, 20241 min read

Problem description & analysis: We have an Excel table for the daily sales of products: Task: We want to find out the date when the total daily sales...

#72 — Filter by Grouped Aggregation Values

#69 — Filter by Multiple Conditions

Oct 9, 20241 min read

Problem description & analysis: There is an employee information table: Task: Now we want to find out the employees who are Female and were born...

#69 — Filter by Multiple Conditions

#68 — Search for Rows That Satisfy The Condition

Oct 8, 20241 min read

Problem description & analysis: We have a statistical table for daily sales of January 2022: Task: Find out the data with daily sales greater than...

#68 — Search for Rows That Satisfy The Condition

#64 — Search for Top N Values And Last N Values

Sep 25, 20241 min read

Problem description & analysis: Here below is a sales statistical table: Task: Now we want to find out the products ranked in the top 10 by sales and...

#64 — Search for Top N Values And Last N Values