Advertisement

Member Login


Or call us
US +1 (617) 500-8224
EU +44 (113) 815 2220
Or Skype us

Who's Online

We have 16 guests and 3 members online


Enter Amount:


Total Downloads

156788
Home arrow The XLC add-in for Excel arrow XLC Help & Tutorials

Help and Tutorials

 Quick Start - On your marks, get set and go - each picture is linked to a screencam video tutorial to get you off to a flying start with XLC.

1) Name and show equations. Display above and below a division line. Greek characters. 2) Algebraic and numeric equation displays. Equation cloning. Behaviour of EQS() functions. 3) Equation automatic updates. Verification of cell formula. Equation numbering. 4) Save as a Native Excel Format with no XLC functions. 5) Seeing and correcting errors in cell formulas. 6) Deleting equations. Changing XLC default settings. XLC Release code for XLC Pro subscribers. 7) Units button. Copy OVD()/UND() button. Delete Equation pictures button. Equation Redraw button. 8) ExcelCalcs search utility. Using a search bias. Finding Repository items. 9) Email ExcelCalcs Repository calculations.

How to Turn Off XLC Automatic Equation Redraw? – Automatic equation redraw gives a tremendous productivity gain but if you decide to stop working with equations to work on a large spreadsheet full of data it might slow you down. It is easy to switch off - click on the ‘about XLC and settings’ which you find on the XLC toolbar and uncheck the 'automatic equation redraw' checkbox.

Button by Button Help - Please note that your browser needs a flash player to view these tutorials.

New Buttons Added in XLC V10_09
 
 
 
Automatic equation redraw gives a tremendous productivity gain but you to switch it off to work on a large spreadsheet because it will slow you down. It is now easy to switch XLC's automatic functions on and off and the to check its current setting.
 
 
 
 
 
 
 
 
It is easy to toggle between algebraic equation display and numeric equation display with XLC's new 'Number\Algebra' button.
 
 
 
 
 
 
 
 
You can now name tabular data with XLC and display them in equations. Have you ever been sent a complicated table of full of formulas and wondered what the hell is going on? Now it is now easy to decipher the calculation method by displaying the tabular formulae in XLC equations!
 
 
 
 
Other Excel Tips 
Excel's REPT() Function and In-Cell Charts