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