27Mar2015

Split Function in VBA

How to use SPLIT function in VBA Split function in VBA is used to split a text string based on a delimiter. This delimiter can be a special character like “,”, ” -“, “&”  or even text delimiters like “and”, “or”, “the”, “sample” etc. For example, lets takes a data set with Employee name, Designation
  • 27 Mar, 2015
  • Excel for Commerce
  • 0 Comments
  • Excel Consultant, Excel Expert, split function,
Read more
19Mar2015

Bollinger Bands using Excel

Bollinger Band was developed by a technical trader John Bollinger in 1980. A band plotted two standard deviations away from a simple moving average is Bollinger Band. The price of the stock is banded by an upper and lower band along with a 21-day simple moving average. Bollinger Bands are a volatility indicator for the
  • 19 Mar, 2015
  • Excel for Commerce
  • 0 Comments
  • bollinger bands, bollinger bands template, investment tool, stock investment tool,
Read more
10Mar2015

Mail Merge in Excel

Mail merge is used to print letters or to send Email Messages to multiple addresses. For Example, If you have a letter that is to be sent to many clients then Mail merge can be very helpful. It is used to create multiple copies from a single template using a data source. This letter can be
  • 10 Mar, 2015
  • Excel for Commerce
  • 0 Comments
  • Excel Consultant, Excel Expert, mail merge,
Read more
02Mar2015

California Sales Template with Heat Map in Excel

Does your company have sales spread all over the counties in a State like California? Are you bored of having your sales data represented using regular in-built excel charts? Are you looking for  a more intuitive way  to represent your data? Then this California Sales Template is for you. This template will help you in visualizing your sales
  • 2 Mar, 2015
  • Excel for Commerce
  • 0 Comments
  • california sales template, Excel Consultant, Excel Expert, heat map in excel, sales template,
Read more