Excel Formula Address from Vlookup magic

From a big list of address enter in single stroke. Excel magic and tricks

Explanation:

=VLOOKUP($A$6,'D:\[Address.xls]Address'!­$B$4:$G$100,2,FALSE)

1. Vlookup - Enter Formula
2. $A$6 - Address name of person
3. 'D:\[Address.xls]Address'! - file location name and Sheet name
4. $B$4:$G$100 - Address range from address excel file
5. 2 - Addresses column number

Microsoft Excel Formula: Small

You can find small number from a big list of Rows and columns. Just Follow video procedure.

Microsoft Office: Small Formula - Watch the top videos of the week here

You can give your suggestions for developing blog.

Excel Formula Roman

FUNCTION DISPLAYS Roman Numbers

Microsoft Excel Formula: Roman - Click here for more home videos

Excel Formula Sumproduct

Just watch how hard formula shows easy.

Microsoft Excel: Sumproduct - For more funny videos, click here

If any suggestion contact blogger967@gmail.com

You can subscribe for updated videos from this blog.

COUNT Function, Excel COUNT Formula

You can easily learn after seeing this video of COUNT Function. Even any confusion first open Excel and play video side by side and follow the video procedure.

Microsoft Office: COUNT Function, Excel COUNT Formula - The funniest videos clips are here

Email subscription widget for blogger

I have searched email subscription widget blogger like you on so many sites and forums also not available not given proper reply.

Even my blog is different to this topic I am publishing.

Do you want add Email Subscription widget to your blog. Normally any widgets you can search and simply copy code and paste into your blog . But email subscription widget for blog is some different you can’t find on any site. You have to create widget for you blog.

Just follow the procedure.

1. open www.feedburner.com . You can sign with your Gmail or blogger account. Feedburner owned by Google.
2. Type your Blog address (ex: http://microsoftexcel2010.blogspot.com) under Burn a feed right this instant. Then select Next button
3. After that you will see two options Atom and RSS. Select Atom and click Next button.
4. Enter Feed Title your choice (ex: Microsoft Excel Formulas Video Tutorial). Feed address will come automatically.
5. You will Find Congrats!. Click Next option
6. Again click Next button.
7. Now select Publicize Tab.
8. Left side you can see Email Subscriptions button. Just click Email Subscription.
9. Then click Activate button
10. Select your language and Copy HTML code and paste in your blog.

OR
Select dropdown arrow of use as a widget and select Blogger then select GO. It will be added to your blog.

Good. This is your blog email subscription widget.

If any clarification contact blogger967@gmail.com

All the Best.
Venkat

Find Formula

You can learn from this formula specified letter can be found from a big sentence.

All the Best.

Exact Formula

Exact formula will compare and determine two items of text.

enjoy.

Excel Formula Roundup

To useful for reducing decimal points.

Added new video enjoy....

Our video VLookup Formula- Highly viewed in Metacafe

You can easily understand after seeing this video of VLookup Formula. Even if you don't understand after seeing video.First open Excel and play video side by side and follow the video procedure. You can easily learn Vlookup Formula

More videos from metacafe link to our blog :
http://microsoftexcel2010.blogspot.com/

http://www.metacafe.com/channels/chinni321/

Microsoft Excel VLookup Formula - The best free videos are right here

Formula CountIF

Microsoft Excel Formula Countif:

Excellent Excel Formula - PROPER

Amazingexcel formula for making disorder letters (sentences) into correct sentences.
Formula Proper

By Chinni321/blogger967 --- Metacafe/Youtube

Microsoft Excel Tutorial for Beginners

A quick look at setting up a simple spreadsheet in Excel complete with a chart. More tutorials to follow that will go into more detail.............

Excellent video for Biginners whereas highest views in Youtube

By Motion Training

Excel Formula: Upper

It reaches the 1840 views in metacafe review panel upto Jan 07 2010. Do you want learn upper formula watch this video.
Small letters can be made Caps letter by using Upper formula. open Excel and video side by side follow video instructions. it is very easy to learn Microsoft Excel.

The video has been hit the metacafe review panel


Microsoft Excel: Upper Formula, MS Excel Upper Function - The best video clips are here

Round Formula

Round Formula reach the 2000 views in Metacafe Review panel:

Do you want watch:


Excel Formula: Round - For more amazing video clips, click here