03Feb2016

How to use ‘What-If Analysis’ tools in Excel

Microsoft Excel is equipped with “What-If Analysis” tools like scenario manager, Goal-seek and Data table. These tools allow you to use different data sets in one or more formulas to come up with different sets of results. For example, scenario manager can be used to compare two different budgets at the same time using its “Summary”
  • 3 Feb, 2016
  • Excel for Commerce
  • 0 Comments
  • Data table, Goal Seek, Scenario Manager, What-if analysis in excel,
Read more
21Jan2016

How to use Solver in Excel

In our day to day lives, at an individual level or at a business level, we come across questions like: “How much should my personal expenses on a particular item be cut down so that my total expenses don’t reach the threshold?” “To what extent should the company increase its advertising spend so that revenue
  • 21 Jan, 2016
  • Excel for Commerce
  • 0 Comments
  • ExcelSolver, Solveraddin,
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
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
25Feb2015

Difference between Activex and Form controls

There are two types of controls in Excel – ActiveX and Form controls. These controls can be accessed from Developer tab in Controls Section as shown in the image below. 1) Form controls are simple to use and are more integrated into Excel while ActiveX controls are loaded in excel by separate dlls (dynamic link library). 2)
  • 25 Feb, 2015
  • Excel for Commerce
  • 0 Comments
  • difference between activex and form controls, Excel Consultant, Excel Expert,
Read more
03Feb2015

Dynamic Charts in Excel

Dynamic charts in excel are useful when we add new data to our existing data tables. For example, lets take 1st quarter sales data for Laptops, Mobiles and Tablets as shown in the image below. A chart for such a data table is generally static i.e. the chart does not reflect new data which gets added to the
  • 3 Feb, 2015
  • Excel for Commerce
  • 0 Comments
  • Dynamic Charts in Excel, Excel Consultant, Excel Expert,
Read more
02Dec2014

How to create dynamic dropdown list in Excel?

Dynamic dropdown list in Excel: Dynamic dropdown list in excel falls under Data Validation. This can be accessible in Data Tools section in Data tab in excel ribbon as shown in the image below. Data Validation picks from a list of rules to limit the type of data that can be entered in a cell.
  • 2 Dec, 2014
  • Excel for Commerce
  • 0 Comments
  • Dependent dropdown, Dynamic dropdown, Excel Consultant, Excel Expert,
Read more
Older Posts >>