17Jul2015

Grouping Checkboxes in Excel

Grouping checkboxes will help to keep the checkbox values discrete. We may also need to group the checkboxes in order to move or resize them as per requirement. Grouping helps to take control on all checkboxes at a time.   Grouping checkboxes in Excel: After inserting checkboxes onto the worksheet. Select all check boxes as
  • 17 Jul, 2015
  • Excel for Commerce
  • 0 Comments
  • Excel Consultant, Excel Expert, grouping checkboxes in excel,
Read more
25Jun2015

Text to Columns in Excel

Text to Columns in Excel are used to split a single column of text into multiple columns. This feature is helpful when we import data from word, PDF or any other source. As the imported data may not be usable right away. We can split the text based on fixed width or split it at
  • 25 Jun, 2015
  • Excel for Commerce
  • 0 Comments
  • Excel Consultant, Excel Expert, Text to Columns,
Read more
16Jun2015

How to Browse and Select File and Folder in VBA

Browse and select file in VBA : Sometimes, we may need to work with external files in Microsoft Excel. We might need a button in excel to open windows file dialog box so as to select the desired file. To achieve this we need to write the following code in VBA editor.   VBA Code Snippet:
  • 16 Jun, 2015
  • Excel for Commerce
  • 1 Comments
  • Browse and Select File and Folder in VBA, Excel Consultant, Excel Expert,
Read more
21May2015

INSTRING function in VBA

Instring function in VBA returns the position of the first occurrence of a substring. This function can be used to find whether the search string (Sub string) is present in a string. Syntax:  InStr( [start], string, substring, [compare] ) Start: It is the starting position for the search. If this parameter is omitted, then default
  • 21 May, 2015
  • Excel for Commerce
  • 0 Comments
  • Excel Consultant, Excel Expert, instring function,
Read more
07May2015

How to Analyze Large Data Sets in Excel

Ever wanted to use Excel to examine big data sets? This tutorial will show you how to analyze over 300,000 items at one time. And what better topic than baby names? Want to see how popular your name was in 1910? You can do that. Want to find the perfect name for your baby? Here’s
  • 7 May, 2015
  • Excel for Commerce
  • 0 Comments
  • analyze large data sets, Excel Consultant, Excel Expert,
Read more
23Apr2015

Monte Carlo Simulation in Excel

What is Monte Carlo Simulation? The name Monte Carlo simulation comes from the computer simulations performed during the 1930’s to know the probability that the chain reaction needed for an atom bomb to detonate successfully. The physicists who involved in this work were big fans of gambling hence the name Monte Carlo.   How to
  • 23 Apr, 2015
  • Excel for Commerce
  • 0 Comments
  • Excel Consultant, Excel Expert, monte carlo simulation,
Read more
17Apr2015

How to create a waterfall chart in Excel

A waterfall chart is also called as a cascade chart or a bridge chart. This type of chart is not a built-in chart option in excel. However, we can create one by using a modified stacked bar chart by carefully arranging the data. Let’s take an example of net cash flow. Here, we are interested
  • 17 Apr, 2015
  • Excel for Commerce
  • 0 Comments
  • Excel Consultant, Excel Expert, waterfall chart,
Read more
14Apr2015

Using Array Formulas in Excel

An Array formula works with an array. You may see array formulas referred to as “CSE formulas,” because you press CTRL+SHIFT+ENTER to enter them into your workbooks. The following is a list of functions in Excel that use arrays: LINEST() MDETERM() MINVERSE() MMULT() SUM(IF()) SUMPRODUCT() TRANSPOSE() TREND() In general, array is a collection of items
  • 14 Apr, 2015
  • Excel for Commerce
  • 0 Comments
  • array formulas, Excel Consultant, Excel Expert,
Read more
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
  • 1 Comments
  • bollinger bands, bollinger bands template, investment tool, stock investment tool,
Read more
Older Posts >>