Categories
- AdSense
- Array Formulas
- Bonds
- Charts
- Controls
- Data Validation
- Dates
- Defined Names
- Economic Data
- Excel
- Analyze Google AdSense Data Using Pivot Tables
- Charting Economic Time Series with Shaded Recessions
- Coin Tosses and Stock Price Charts
- Dealing With Unusual Date Formats
- Modifying the Ribbon in Excel 2007
- Native Excel 2007 Viewer Now Available
- Parallel Install of Office 2007 and Office 2003
- Excel 2003
- Excel 2007
- Functions
- Adding an Average Line to a Chart Using Defined Names
- Analyze Google AdSense Data Using Pivot Tables
- Chart the Yield Curve Using Yahoo! Finance Data
- Charting Economic Time Series with Shaded Recessions
- Coin Tosses and Stock Price Charts
- Dealing With Unusual Date Formats
- Disallow Special Characters Using Data Validation
- Display Scenarios Using a Drop-Down List
- On Arrays and Accumulated Depreciation
- Testing a String for Proper Case
- The NPV Function Doesn't Calculate Net Present Value
- And
- Count
- Date Functions
- Date
- Day
- EOMonth
- Month
- Now
- Today
- WeekDay
- Year
- Financial Functions
- Index
- Indirect
- Match
- Offset
- Rand
- Round
- RoundDown
- RoundUp
- String Functions
- Chart the Yield Curve Using Yahoo! Finance Data
- Dealing With Unusual Date Formats
- Disallow Special Characters Using Data Validation
- Testing a String for Proper Case
- Code
- Find
- left
- len
- mid
- Proper
- right
- Search
- Value
- VLookUp
- Google Spreadsheets
- PivotTables
- Ribbon
- Video
- Scenario Manager
- Simulation
- Table
- Security
- TVMCalcs New Content
- VBA
- Web Query

