This course is also part of our Elevate Excel Training Program.
Elevate Excel is our comprehensive, beginner-to-advanced Excel training program that will help you drastically improve your skills and become the Excel Hero of the office.
Click the button below to learn more and enroll in the course.
Course Content
Start Here
1 Lesson
Expand
Section Content
0% Complete
0/10 Steps
Section Content
0% Complete
0/21 Steps
LET Functions
4 Lessons
Expand
Section Content
0% Complete
0/4 Steps
LAMBDA
8 Lessons
Expand
Preview this Course

Not Enrolled
This course is currently closed
Course Includes
- 6 Sections
- 44 Lessons
- Course Certificate
Login
Accessing this course requires a login. Please enter your credentials below!
Responses
You must be logged in to post a comment.
In my excel software, to get dollar sign in front of selected rows, function f2 or fn+f2 is not working. How can I fix it. in the morning, it is working but later on it stopped working. How to fix it?
Solved. it is fn + f4. my mistake
Hi Devnshu,
Thank you for your comment and update! 👍 The standard process to access the dollar signs would be the F4 key without the Fn key. If that is not working, it could be a setting in your operating system or your keyboard that needs to be reset. See the options listed on the Microsoft webpage linked below for more information.
https://answers.microsoft.com/en-us/windows/forum/all/top-row-of-keys-dont-work-only-work-when-holding/73637f1c-9d74-478a-85d0-71a14f50c1df
Let us know if you have any follow-up questions, Devnshu. Have a great day! 🙂
Can we use Let & LAMBDA using a Mac with 2021 Excel?
Hi Chris,
Great question! 🙂 According to the links below, it’s a yes for LET and a no for LAMBDA.
LET on Excel 2021 for Mac
https://support.microsoft.com/en-us/office/let-function-34842dd8-b92b-4d3f-b325-b8b8f9908999
LAMBDA on Excel 2024 for Mac
https://support.microsoft.com/en-us/office/lambda-function-bd212d27-1cd1-4321-a34a-ccbf254b8b67
Did you check out any of the virtualization options referenced in our response to your previous post? Those may help you in enabling more features. The response is linked below for convenience.
https://learn.excelcampus.com/topic/l2-basic-transformations/#comment-27877
Keep the questions coming, Chris! 👍 Have a great weekend! 🙂
A very warm welcome to LET and LAMBDA !!! 🙂
Agreed, Danny! 👍
When will we see LAMBDA !
Great question, Daniel! 🙂 If you would like to try to expedite the process of seeing LAMBDA, feel free to make an entry at our Suggestion Box linked below.
https://learn.excelcampus.com/suggestion-box/
Have a great day! 🙂
I was wondering if you’ll be adding lessons for the LAMDA() and LET() formulas
I second that. LAMBDA LAMDBA!!!!
Hi Daniel,
Thank you for your excitement about modern formulas! 🙂 I have added the suggestion of training on LAMBDA to the Excel Campus list for potential future enhancements.
In the meantime, take a look at the Excel Campus page linked below.
https://www.excelcampus.com/functions/lambda-explained/
Thank you for your suggestion, and have a great day! 🙂