Excel Tips: 2 DIY functions that use LAMBDA
398 بار بازدید -
ماه قبل
-
In this episode, Neale Blackwood
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
ماه قبل
در تاریخ 1403/05/17 منتشر شده
است.
398
بـار بازدید شده