Excel Tips: 2 DIY functions that use LAMBDA

In this episode, Neale Blackwood shares Excel tips for how to create custom functions in Excel using the LAMBDA function. 0:00 Welcome 00:48 Structure for first custom function example 01:37 BYCOL function to add up columns in a spill range 02:35 Convert BYCOL function to BYROW function 03:51 LAMBDA function to test the custom function 04:31 Special layout for the Formula Bar for LAMBDA functions 04:44 Keyboard shortcut to insert a line break in a cell 05:06 The SWITCH function – like a lookup table with a formula 07:01 Extra set of brackets (parentheses) on the end required to test the LAMBDA 08:20 Convert the LAMBDA into a fnSUMDA custom function 11:51 fnFY custom function for financial year 13:16 A keyboard shortcut to change the height of the Formular Bar 13:36 Review the LAMBDA text function 13:53 The LET function and how it uses variables 15:05 Financial year variable calculations 16:44 SWITCH function for the three financial year options 17:38 Demonstration of the different financial year start months 18:15 Advantages of custom functions Visit the INTHEBLACK website for more Excel content: intheblack.cpaaustralia.com.au/ Want to learn more from Neale Blackwood? Visit A4 Accounting a4accounting.com.au #microsoft #microsoftexcel #excel #digitalskills #digitalliteracy #accounting #finance #business #jobready #INTHEBLACK #CPAAustralia