Excel Tips and Tricks Five awesome formulas in Excel January 9, 2023January 9, 2023 PKComments Off on Five awesome formulas in Excel
Excel Tips and Tricks TEXTSPLIT function with three use cases in Excel December 26, 2022December 26, 2022 PKComments Off on TEXTSPLIT function with three use cases in Excel
Excel Tips and Tricks LAMBDA Function in Excel with Example December 19, 2022December 19, 2022 PKComments Off on LAMBDA Function in Excel with Example
Excel Tips and Tricks Power Pivot Data Transformation to create Comma Separated List automatically December 12, 2022December 12, 2022 PKComments Off on Data Transformation to create Comma Separated List automatically
Charts and Visualization Quick Male-Female and Waffle Chart in Excel October 20, 2022October 20, 2022 PKComments Off on Quick Male-Female and Waffle Chart in Excel
Excel Tips and Tricks Searchable and Dependent Drop-down list in Microsoft Excel September 18, 2022September 18, 2022 PKComments Off on Searchable and Dependent Drop-down list in Microsoft Excel
Charts and Visualization Excel Tips and Tricks Find Top Employee with FILTER and RANK Function June 7, 2022September 9, 2022 PKComments Off on Find Top Employee with FILTER and RANK Function
Excel Tips and Tricks 6 Powerful Dynamic Array Function in Excel July 26, 2020July 26, 2020 PKComments Off on 6 Powerful Dynamic Array Function in Excel