Deep Learning ,

Modern Formulas Course

View Course details

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.

Learn More about The Elevate Excel Training Program

Course Content

Start Here 1 Lesson
Expand
Section Content
0% Complete 0/1 Steps
Preview this Course
Modern Formulas Course
Not Enrolled
This course is currently closed

Course Includes

  • 6 Sections
  • 44 Lessons
  • Course Certificate

Responses

  1. Devnshu Garg March 28, 2025

    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. Justin @ExcelCampus Moderator April 3, 2025

        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. Justin @ExcelCampus Moderator December 6, 2024

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

Report

Harassment or bullying behavior
Contains mature or sensitive content
Contains misleading or false information
Contains abusive or derogatory content
Contains spam, fake content or potential malware

Block Member?

Please confirm you want to block this member.

You will no longer be able to:

  • See blocked member's posts
  • Mention this member in posts
  • Invite this member to groups
  • Message this member
  • Add this member as a connection

Please note: This action will also remove this member from your connections and send a report to the site admin. Please allow a few minutes for this process to complete.

Report

You have already reported this .