Modern Formulas Course

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

Section Content
0% Complete 0/1 Steps
Not Enrolled
This course is currently closed

Course Includes

  • 6 Sections
  • 44 Lessons
  • Course Certificate

Responses

  1. 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?

      1. 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! 🙂

    1. 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! 🙂