Key Performance Indicator using REPT()

Hi,

I recently wanted to display some information in a table using conditional formatting for ease of reading.
I eventually ended up using the function rept().

It looked just like that:

Free: Monte Carlo simulator in Excel

Now it’s time for hands-on…

First you need to download a small library that you can find here: download
The author did a great job here and will save you lots of time… (I take no credit for the writing of this fantastic piece of script)
Install it by 2x clicking on the file and follow the instructions.

If the install is properly done you’ll see a new toolbar showing up in Excel with barbaric names like “Insert Input“, “Insert Output“, “Insert Correlation“….

Are you “Office 2007 ready” ?

Hi,

You received insider information from a top Hedge Fund manager. Information is gathered in a word document, data analysis in an Excel spreadsheet. Hastily you download the files, 2x click. You just can’t wait, in a couple of days, thanks to this information you’ll finally be a High Net Worth customer, private bankers will invite you for wine tasting sessions and golf contests! But… nothing happens. Is the file encrypted??

Yes and no. You friend may just have overlooked that he’s using Office 2007 and 99% of Office users are still using earlier versions of the same software. Mesmerized by the all the new opportunities offered by Word or Excel 2007 (you no longer are limited to 256 columns for 65535 rows wohoooooooooo!!) that person will have saved the file in the “new” native format.

This happened to me before I get a trial version of the latest Office Pack. I didnt really know what to do with the file that Excel didn’t even recognize.

FREE: Currencies and World Indices historical data…

Hi,

I just wanted to share a tip with you today on how to get historical financial data FREE from the internet in a matter of minutes.

Back in the days I was working in a bank I had my own Bloomberg and Reuters terminals. Access to financial information was not a problem. In case I couldn’t find the information I needed: a support tech from either Bloomberg or Reuters would get back to me within the minute and assist me either on the phone or online and deal with the problem in a snap.

Now these days are gone… I now am my own information provider and support tech!
I am well aware of the cost of financial information. The thing is: I am not willing to pay… Still I need this information to run some correlation tests and volatility analysis.
So if you need information and don’t want to pay (like me…) read what follows!

Dynamic dashboards in Excel

Not exactly a function. More a feature here…
We are going to learn how to do this:

So: What’s so impressive about this?