Use custom functions in Excel . Now that you know the basics about Excel custom functions, letâ s create one. In the example below, I will create an Excel function to calculate all odd numbers ...

You’ll use LAMBDA() functions the same way you use Excel functions. To demonstrate, enter the function and reference the values shown in Figure B , =SUBTRACTL(B3,C3) . (The period is grammatical ...

Method three: How to run a VBA sub procedure using a keyboard shortcut in Excel Keyboard shortcuts offer shortcuts to routine tasks, and most of us have a few favorites. Mine is Ctrl + Z, or Undo.