Using OFFSET Function in Microsoft Excel

Using OFFSET Function in Databases in Microsoft Excel

Now we are going to see how works the OFFSET function. With the OFFSET function you can returns a reference that is a number of rows and a number of columns from a cell or range of cells selected With this function you can get the specific value in a database, that allows you to search information in big lists of data Let’s see the video and learn how to use the OFFSET function, you can use it with the MATCH function explained in the last video and search specific values in a Database. You can learn more about Microsoft Excel functions and applications here: Excel Training Videos

Please wait...

Subscribe to ExcelMOOC posts

Want to be notified when our Excel article is published? Enter your email address and name below to know all new Excel features and cool tips