Upload
102

ExcelDom22

  • Microsoft Excel - Named Ranges - Duration: 2 minutes, 33 seconds.

    • 2 years ago
    • 197 views
    This video shows you how to define a named range in Microsoft Excel.

    The formula to lookup sales for the month of June is as follows...

    =INDEX(Sales,MATCH(D2,Month,0))

    Visit http://www.xl-centra...
  • Excel 2007 / 2010 - Picture Lookup - Duration: 2 minutes, 29 seconds.

    • 2 years ago
    • 51,061 views
    This video shows you how to lookup a picture in an Excel worksheet using Microsoft Excel 2007 and 2010.

    The forumula for the defined named is as follows...

    =INDEX($B$2:$B$4,MATCH($D$2,$A$2:$A$4,0...
  • Microsoft Excel - Creating a Dynamic Named Range - Duration: 2 minutes, 48 seconds.

    • 2 years ago
    • 1,240 views
    This video shows you how to create a dynamic named range in Microsoft Excel using the OFFSET function.

    The formula for the dynamic named range is as follows...

    =OFFSET($B$2,0,0,COUNTA($B:$B)-1,1)...
  • Excel 2007 / 2010 - PivotTables: Accessing the Option for Multiple Consolidation Ranges - Duration: 2 minutes, 32 seconds.

    • 3 years ago
    • 3,883 views
    This video shows you a couple of ways of accessing the option for "Multiple Consolidation Ranges" when creating a PivotTable in Microsoft Excel 2007 and 2010.

    Visit http://www.xl-central.com
to add this to Watch Later

Add to

Loading playlists...