Ultimate Trade Tracking tools for traders! - - Official TJS... News & Update blog.
Trading Journal Spreadsheet
TJS Trading Log
Record It, Track It, Analyze It!
Expertly crafted, simple to use trading spreadsheets for traders.
Products for all: Stock, Options, Futures, Forex, SpreadBetting, CFD markets.
Expertly crafted, simple to use trading spreadsheets for traders.
Products for all: Stock, Options, Futures, Forex, SpreadBetting, CFD markets.
Showing posts with label Excel status bar. Show all posts
Showing posts with label Excel status bar. Show all posts
Tuesday, May 17, 2011
Quick 'Summary' Using Excel's Status Bar
For those that don't know... Excel displays a very helpful summary in the (lower status bar) window.
Just scroll & highlight any numeric data column and you'll see some interesting calculations come to life:
* Sum
* Average
* Minimum
* Maximum
* Count (# of items)
Unlike a formula entered into a cell, you cannot permanently keep these results in your trading spreadsheet, but when you want a quick answer to a question on your input area, it can't be beat for its quick and instant display.
To change your choice of what the status bar displays, just right-click in the status bar to see your choices (towards the bottom-half), then check or uncheck the ones you want displayed.
Click the image to see an example using the new TJS Elite.
Subscribe to:
Posts (Atom)
