Tag Archives: Data Analysis Tools

Text from pictures in Excel

Excel recently added the ability to extract text from an image, either on the clipboard or from a selected file. To try this out I used a screenshot of a table with vertically aligned text, from a pdf copy of … Continue reading

Posted in Charts, Excel | Tagged , , , | Leave a comment

Using Linest for non-linear curve fitting, examples, hints and warnings

Since I wrote Using LINEST for non-linear curve fitting in 2011 it has been by far the most popular post on this blog.  This post (in response to a recent question) provides some more detailed guidance on how to apply the function … Continue reading

Posted in Curve fitting, Excel | Tagged , , , , , , | 3 Comments