Experiglot - experiglot.com - Experiments in Finance
General Information:
Latest News:
Online Excel Training In The Making 21 Aug 2013 | 01:00 pm
Good morning to all of you! As may of you know, I’ve been looking into ways to improve the way I can help everyone improve their excel skills. More than ever, in a tough economy, being able to disting...
Building Pivot Tables… The Basics 14 Aug 2013 | 01:00 pm
Over the past few weeks, I’ve been getting an increased number of questions regarding the use of pivot tables. Believe me, I understand. As much as I know how useful and powerful pivot tables can be, ...
Example Of Nested If Conditions In Excel To Calculate Sales Commissions 7 Aug 2013 | 01:00 pm
I’ve done a couple of similar examples but here is one question I got a few days ago: I am trying to write a formula to pay a percentage up to a certain amount and then increase the percentage once a ...
Excel Improve Your Productivity By Pinning Specific Documents 31 Jul 2013 | 01:00 pm
Last week, I pubished a post about customizing your toolbar in Excel in order to increase efficiency. Today is another very quick and easy tip. I know that many of you use dozens of different excel sp...
Excel 2013 – Improve Your Productivity By Customizing The Excel Quick Toolbar 24 Jul 2013 | 01:00 pm
Today I wanted to discuss a very simple tip that is very helpful if you’re trying to be very productive can give you a hand. It’s a way to add buttons that are easy to access no matter where you are. ...
Using Freeze Panes Function In Excel To Improve Your Navigation 17 Jul 2013 | 01:00 pm
For many of you, working with large sets of data presents many challenges and today I thought I’d give you one way to make life much easier. Here is an example that probably occurs on a regular basis....
Using API’s In Excel; Why?, How?, etc? 10 Jul 2013 | 01:00 pm
It is very possible that you have heard about an API at some point in the past. Others might be asking what in the world I’m talking about. An API is an IT term that is basically a protocol that makes...
Nested If Condition – New Example 3 Jul 2013 | 01:00 pm
Working with excel functions is not easy to learn and usually requires a decent amount of practice. Every once in a while, I try to publish some examples sent by some of you and here is the latest one...
Using MSN Finance To Get Stock Prices In Excel 26 Jun 2013 | 03:04 pm
A few days ago I received an email telling me that the spreadsheet that got prices from the Yahoo finance website no longer worked. One clear downside of using web queries is that they sometimes requi...
Calculating The Value Of An Annuity In Excel 19 Jun 2013 | 01:00 pm
I’ve been discussing annuities quite a bit in recent days so i thought it would be interesting to give a shot at calculating the value of an annuity in excel. This is obviously not a perfect method an...
