d formula

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

TrustPilot

starstarstarstarstar Excellent

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

Forum home » Delegate support and help forum » Microsoft Excel Training and help » 3D Formula

3D Formula

resolvedResolved · Low Priority · Version 2003

Natalie has attended:
Excel Intermediate course

3D Formula

Interesting in receiving more information on VLookups and similar formula rather than manual input.

RE: 3D Formula

Hello Natalie

Thank you for your question and welcome to the forum.

Forum access is provided so if you have questions relating to the the content of the courses you have taken with us, we can provide advice and support relating to your questions.

Vlookups (and other formulas that reduce manual input) are covered as part of our Excel Advanced course, therefore you may be interested in taking Advanced level training with us.

Alternatively, I have provided a link below to a page which gives a good explanation of the VLOOKUP function:
http://www.contextures.com/xlFunctions02.html

Amanda


 

Excel tip:

Using Excel's MODE function

Use Excel's MODE function to display the most common value present in a particular range of cells.

The Mode function looks like this:

=MODE(cell range)

As an example, if 35 is the most commonly recurring number in a particular cell range, then the function will display 35.

View all Excel hints and tips


Server loaded in 0.08 secs.