7shami

7shami added to a playlist 2 days ago

8:51 Add to

Excel Magic Trick #126: Macro: Advanced Filter Extract Text

See how to create a macro that will do an Advanced Filter Movie Title Extract for a Movie Database. See how to create the TRUE FALSE formula for ad...

44,466 views

Excel 8 videos

• 
• 
• 
• 
• 

• 8:27 Add to

  How to make a calendar in Excel 2010

  How to make a calendar in Excel adding color using conditional formatting.

  Download the calendar Excel 2007 and 2010 template here:

  http://cid-6b2...

  64,209 views
• 6:07 Add to

  CONSOLIDATION

  6,891 views
• 8:18 Add to

  Combining MATCH and INDEX - Excel for Business - Lesson 2

  November 2010 Update: Visit: http://www.ExcelinaMinute.com/ for my new Excel video tutorials. "One minute videos for bite-sized learning!"

  Excel t...

  21,846 views
• 5:19 Add to

  Excel Name Trick #7: INDIRECT function, Names and LOOKUP

  THE most amazing Name Trick: See how to use Data Validation, the INDIRECT function, the space operator and Names to look things up!

  Two 2 Way Look...

  65,898 views
• 7:34 Add to

  Using AND, OR, IF Funtions in Excel

  http://www.TeachExcel.com

  How to use the AND() OR() IF() functions in excel. Includes nesting the AND() and OR() functions and formulas within and...

  15,956 views
• 5:47 Add to

  Using the Nested IF Statement in Excel 2007

  Watch the full course at http://SimonSezIT.com.

  In this video, we show you how to use the Nested IF Statement in Microsoft Excel 2007.

  Website: ...

  44,099 views
• 4:04 Add to

  Excel Drop Down Lists for Country and City

  http://www.contextures.com/...

  With Excel data validation you can create drop down lists on a worksheet. In this example, use depende...

  843 views

+ 7 more videosshow less