XL4HF, which stands for Excel for Hedge Funds, is a leading video blog on trading IT. XL4HF helps you leverage your technology assets--including Microsoft Excel--in order to trade, analyze, and operate with greater insight. Read more about xl4hf, and if you like what you see, sign up for free access to our videos.

differences between Grouping or Hiding/Unhiding

in
What are the differences between Grouping or Hiding/Unhiding of rows or columns?
Click to read the answer

graphing linear functions in Excel

in
How do I graph a linear function in Excel, if I have a series of X and Y values in cells--instead of getting two seperate lines?
Click to read the answer

VBA search: the power select

in

Use Excel's object model to write fast VBA code...

»

What's most important for you in a custom software solution?

in
»

multiplication bug in Excel 2007

in
Take a look at the following thread for more information on a serious bug in Excel 2007
»

Loading data with custom formats

in
Often when migrating data between databases, data is held in various formats. You can use Excel's custom formatting to quickly format cells so that they are simple to understand for the target system.
»

Inconsistent R^2 values

in

I have a feeling that R^2 values in Excel are a bit off. I seem to be getting different values. For the same data set, the R-squared value that chart tool calculates is different from the value that the LINEST() worksheet function generates. What gives? The R-squared values were never right when I checked the Set Intercept = 0 box.

Click to read the answer
« first‹ previous123456next ›last »
Add to Technorati Favorites Syndicate content