Copy

Newsletter by jkp-ads.com

View this email in your browser

jkp-ads.com Newsletter for June 2015

Welcome

Greatings!
Here in my part of the worlds summer has just started, which means it is time for my summer sale! Check out the opportunities below.

Summer sale

Now that summer has arrived I've planned a summer sale. From July 1st up to July 10th I offer a 25% discount on both products I sell:
RefTreeAnalyser
and
The Excel File Remediation Utility
just go through the purchasing process and enter this coupon code to redeem your discount:
JKPADS-Summer2015
 

Excel tips

Editing nested functions using the function wizard

Die-hard Excel developers mostly write their formulas from the top of their head by typing and clicking. But there are definitively merits on using the function wizard to do this (for instance, the function wizards inserts the brackets for you at all the right places). Lets have a look at this formula:

=IF(A2=10,VLOOKUP(A3,$B$1:$C$14,2,FALSE),VLOOKUP(A4,$B$1:$C$14,2,FALSE))

Editing this in the function wizard (click the Fx button left to the formula bar or hit Shift+F3) brings up the If function and its three arguments in three boxes:

But what about those second and third parts of this IF function? Those are functions too. Simply clicking in those boxes only enables you to edit their text manually. What is cunningly hidden from you is that you can bring up the function wizard to edit those parts as well. How?
Simply click in the formula bar within the function you want to edit:

If you are done editing one piece of your formula and wish to edit another piece, do not click the OK button. That will enter your formula into the grid. Instead click in the formula bar on the other function you want to edit. Only When you are completeley done editing click OK.
 

Events, courses

Excel VBA voor Financials 5th edition

This well received (Dutch) course will get a major overhaul and will be run again (5th time already!) on October 6th, 14th and 21st. Join us to learn all a financial needs to know to get started using VBA to automate tedious processes.

VBA course

I am repeating myself, I know, but we're still in the planning stages of an "Advanced Excel VBA" course. I have put up a survey to ask opinions on course content and whether or not you'd be interested in such a course.
 

Auditing of Formulas made easy

Check out our RefTreeAnalyser
the ultimate Excel formula auditing tool.
 

Mission-critical Excel Model Crashes

Do you have mission-critical Excel files that cause problems? Consider our Excel File Remediation Utility
.
 
Copyright © 2015 JKP Application Development Services, All rights reserved.


unsubscribe from this list    update subscription preferences 

Email Marketing Powered by Mailchimp