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
  • 1 Comments
  • california sales template, Excel Consultant, Excel Expert, heat map in excel, sales template,
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
01Jan2015

How to sort horizontally in Excel? (from left to right)

Sorting horizontally in Excel: Sorting horizontally in excel (from left to right) is required when we have a table/data as shown in the image below. In the below image, we want to sort horizontally based on employee name. This blog explains how to sort multiple columns horizontally from left to right. Let’s take a sample
  • 1 Jan, 2015
  • Excel for Commerce
  • 0 Comments
  • Excel Consultant, Excel Expert, Sort horizontally in Excel,
Read more
09Dec2014

How to use SUMPRODUCT function in Excel

SUMPRODUCT function in Excel returns the sum of the products of the corresponding ranges or arrays. Let’s check the syntax for this function. Formula Syntax: SUMPRODUCT (array 1, [array 2], [array 3], …) The arrays in the formula are the ranges of the cells that we wish to multiply.   SUMPRODUCT function in Excel: Let’s
  • 9 Dec, 2014
  • Excel for Commerce
  • 0 Comments
  • Excel Consultant, Excel Expert, SumProduct,
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
22Nov2014

Excel shortcuts: Tips and tricks to speed up in Excel

Learning Excel keyboard shortcuts will improve your speed and productivity in a big way. Most of the daily routines in the excel worksheets can be done using keyboard shortcuts. This blog contains nearly all the shortcuts which can be helpful while working with Excel. Excel shortcuts and tips:   How to know the Excel shortcut key
  • 22 Nov, 2014
  • Excel for Commerce
  • 0 Comments
  • Excel Consultant, Excel Expert, Excel Keyboard Shortcuts,
Read more
18Nov2014

INDIRECT function in Excel: How to dynamically refer multiple sheets?

INDIRECT function in Excel returns the reference specified by a text string. The syntax for this excel function is as follows. Formula Syntax: INDIRECT( ref_text, [a1] ) ref_text can be the range of cells or a named range. [a1] can be TRUE or FALSE. TRUE is used to indicate that ref_text is in R1C1 style
  • 18 Nov, 2014
  • Excel for Commerce
  • 0 Comments
  • Excel Consultant, Excel Expert, indirect function in excel,
Read more
13Nov2014

Introduction to Advanced Filter in Excel

Advanced filter in Excel depends on the user defined criteria that can applied to many columns of data. Advanced Filter is used to perform complex filtering which is not possible using the basic auto filter function. To access Advanced Filter, click on DATA tab in Excel ribbon and click on Advanced in sort and filter
  • 13 Nov, 2014
  • Excel for Commerce
  • 0 Comments
  • advanced filter, Excel Consultant, Excel Expert,
Read more
<< Newer Posts:::Older Posts >>