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
29Jan2015

Get combobox selected value in Excel VBA

There are three methods to read the selected values from a combobox in VBA. Please go through the following blog to know how you can do it. Method 1: Consider, we have a dropdown list having days mentioned in it. The value selected in the dropdown is ‘Sunday’. Now, we will try to read the selected
  • 29 Jan, 2015
  • Excel for Commerce
  • 0 Comments
  • Combobox Selected value, Dropdown value,
Read more
06Jan2015

Microsoft Access – How to run a macro when database opens?

Microsoft Access allows the users perform a set of actions every time a database loads or opens by creating a macro called ‘AutoExec’. You can run a macro when database opens by naming it as ‘AutoExec’ or calling the ‘AutoExec’ macro. As the name suggests, an ‘AutoExec’ macro is a macro that automatically executes the actions we
  • 6 Jan, 2015
  • Excel for Commerce
  • 0 Comments
  • Access, AutoExec,
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
<< Newer Posts