This is a mini guide to recap those 9 functions which were launched in year 2022. PDF file corresponding to this video – https://1drv.ms/b/s!Akd5y6ruJhvhvwCdltcqWqFlen0f?e=cAzGyg
Category: Articles
Article 51 – Recursive Lambdas
Lambda function was launched few months prior to Lambda helper functions. With Lambda came the ability to perform recursive looping and there was a lot of excitement around this. Yes, after Lambda helper functions came, people rarely talk about recursive Lambdas in Excel. Here are recursive Lambdas which I had created when Lambda function was…
Important – Content of this Website is 100% Copyright Free
I just want to convey that the content of this site is completely copyright free. You can use the content the way you want without seeking any permission. Whether you are using it commercially or non-commercially, personally or within your organization, it doesn't matter. There is no need to give any acknowledgement either that you…
Power Query Article 1 – NetworkDays using List.Accumulate
This article on Power Query contains one line m-code for calculating NETWORKDAYS.INTL using List.Accumulate. Hence, you can control weekends as well as list of holidays.
Article 50 – SEQUENCE Function
SEQUENCE is one of the functions introduced in 2020 for Office 365 subscribers as part of Dynamic Array functions. I have published this article @ Linked. Click below SEQUENCE FUNCTION
Article 49 – SWITCH Function
SWITCH is one of the underused functions in Excel and this article is an attempt to encourage folks to use SWITCH function which is like SWITCH function used in Java and CASE – SELECT of VBA. This article I have published on Linkedin. Below is the link for that. https://www.linkedin.com/pulse/excel-switch-function-excel-vba-power-bi/
Article 48 – Split A Workbook into Multiple Workbooks on the basis of a Column
Sometimes, we need to prepare multiple workbooks on the basis of entries in a column. It is all the more useful in organizations where you need to send files to stakeholders. For example, in below sheet, you want to split the files on the basis of entries in column C. You may also like to…
Article 47 – New Functions in Excel 2016
This is a guest post contributed by Hannah Sharron of http://spreadsheeto.com/ Microsoft has added six new built-in functions with the release of Excel 2016. These functions are also available in Office 365. In this article, we will take a quick look at three of those new functions. TEXTJOIN For a long time, the CONCATENATE has…
Article 46 – Creating Pivot Table with Dynamic Range
The file related to this article can be downloaded from Dynamic Pivot Tables We all make pivot tables and we also know that every time, the range of data which pivot uses goes beyond the current range, we need to change the data range. It becomes painful and also if you are creating dashboards, it…
Article 45 – How to know if a Cell contains Time
We talked about Article 19 – How to Check if a cell contains a date. Now, in this article, I will talk about checking the cell for time. The way Excel stores dates as numbers, in the same way it stores time as numbers only. Only change is in range. The numbers get stored between…