Here are the training videos, You can download all videos by clicking following link, These videos are available on youtube for better viewing (Please suggest me better wordpress plugin to embed videos here)
Link to download all videos (YouTube links below)
***** Coming SOOOON*****
Tutorial Theory (for excel)
- Let’s say we have following words
- Excel doesn’t know space
- So when using concatenate feature of wordpress you have tell excel to use space after words. Which can be done by typing ” “.
- So, for the above problem, ABCDEFGHI.. we can use A,” “,B,” “,C,” “.
- Now we can also write the above sentence as, “Business” (make sure you have quotation mark wrapped around the word) , (comma to seprate the “business” from ” ” (space))
- Once again in excel you have Business name, address, phone number, city, website..
- We want all together joined in one column
- So that it looks like, Business, address, phone number (Business, space, address, space, phone number, space, website)
- excel doesn know space, or where to use space.
- So in excel file under temp (this is the new column we made, please see video) we’ll write, “Business”, A2,” “,”Postal Code”,” “,B3,” “, … so on…
- For more info on concatenate feature you can visit http://office.microsoft.com/en-ca/excel-help/concatenate-HP005209020.aspx
- Watch following videos, and if you don’t understand contact me or add me on skype vshrivas420 when addding me on skype please use your paypal id as message you used to pay for the product