Use of Sequence function to create a dynamic calendar template
Download Excel Template from
https://bi-analytics.org/files/file/313-dynamic-calendar-excel-template/
Download file
https://bi-analytics.org/files/file/312-rank-function-in-excel/
The Excel RANK.AVG function returns the rank of a number against a list of other other numeric values. When values contain duplicates, the RANK.AVG function will assign an average rank to each set of duplicates.
The Excel RANK.EQ function returns the rank of a number against a list of other other numeric values. When values contain duplicates, RANK.EQ will assign the higher rank to each set of du
MAP – REDUCE – SCAN MAKEARRAY –BYROW – BYCOL ISOMITTED These are recently announced functions by Microsoft .where we can pass lambdas as arguments
Download template files
Overview of table in Excel
Download Practice file
https://bi-analytics.org/files/file/30-tutorial-18-tables-in-excel/
Make sure
you sign in on the site and joined the club