Excel Blog http://www.tvmcalcs.com/blog/ A blog of Excel tips and tricks by Timothy R. Mayes, Ph.D. I am the author of "Financial Analysis with Microsoft Excel, 4th ed." and am a faculty member in the Finance Department at Metropolitan State College of Denver. en mayest2@comcast.net Copyright 2009 2009-01-20T07:38:51+00:00 39.668576-105.091913 Variance/Covariance Matrix Add-in for Excel 2003 and Earlier http://feedproxy.google.com/~r/ExcelBlog/~3/a0MUFyJQvyw/ http://www.tvmcalcs.com/blog/comments/VarianceCovariance_Matrix_Add-in_for_Excel_2003_and_Earlier/ Add-ins, Excel, Excel 2003, VBA
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]
]]> 2009-01-20T07:38:51+00:00 http://www.tvmcalcs.com/blog/comments/VarianceCovariance_Matrix_Add-in_for_Excel_2003_and_Earlier/ Variance/Covariance Matrix Add-in for Excel 2007 http://feedproxy.google.com/~r/ExcelBlog/~3/bRhrsp25iTY/ http://www.tvmcalcs.com/blog/comments/VarianceCovariance_Matrix_Add-in_for_Excel_2007/ Add-ins, Array Formulas, Excel, Excel 2007, VBA
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]
]]> 2009-01-08T00:01:29+00:00 http://www.tvmcalcs.com/blog/comments/VarianceCovariance_Matrix_Add-in_for_Excel_2007/ High Quality Screenshots for Print http://feedproxy.google.com/~r/ExcelBlog/~3/4pCksIY__t0/ http://www.tvmcalcs.com/blog/comments/high_quality_screenshots_for_print/ Excel
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]
]]> 2008-11-11T00:24:52+00:00 http://www.tvmcalcs.com/blog/comments/high_quality_screenshots_for_print/ Division, the Hard Way http://feedproxy.google.com/~r/ExcelBlog/~3/P8h8GCLauEs/ http://www.tvmcalcs.com/blog/comments/division_the_hard_way/ Other Spreadsheets, Spreadsheet for iPhone
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]
]]> 2008-10-06T07:08:53+00:00 http://www.tvmcalcs.com/blog/comments/division_the_hard_way/ Sneaking a Peek inside the Chart Advisor Add-in http://feedproxy.google.com/~r/ExcelBlog/~3/hUCQHdihsqY/ http://www.tvmcalcs.com/blog/comments/sneaking_a_peek_inside_the_chart_advisor_add_in/ Charts, Excel, Excel 2007, XML
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]
]]> 2008-08-29T20:04:22+00:00 http://www.tvmcalcs.com/blog/comments/sneaking_a_peek_inside_the_chart_advisor_add_in/ Office Labs Chart Advisor for Excel http://feedproxy.google.com/~r/ExcelBlog/~3/u7idchozZ-M/ http://www.tvmcalcs.com/blog/comments/office_labs_chart_advisor_for_excel/ Charts, Excel, Excel 2007
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]
]]> 2008-08-25T20:59:34+00:00 http://www.tvmcalcs.com/blog/comments/office_labs_chart_advisor_for_excel/ The UltimateSteal Is Back http://feedproxy.google.com/~r/ExcelBlog/~3/SFpUiVrnP6M/ http://www.tvmcalcs.com/blog/comments/the_ultimatesteal_is_back/ Excel, Excel 2007
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]
]]> 2008-08-23T06:50:36+00:00 http://www.tvmcalcs.com/blog/comments/the_ultimatesteal_is_back/ Duplicate Post Issue is Fixed http://feedproxy.google.com/~r/ExcelBlog/~3/8scsrO-ur-E/ http://www.tvmcalcs.com/blog/comments/duplicate_post_issue_is_fixed/ TVMCalcs New Content
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]
]]> 2008-08-19T02:17:10+00:00 http://www.tvmcalcs.com/blog/comments/duplicate_post_issue_is_fixed/ Creating Time Value of Money Tables in Excel http://feedproxy.google.com/~r/ExcelBlog/~3/bdfjX_X-VoA/ http://www.tvmcalcs.com/blog/comments/creating_time_value_of_money_tables_in_excel/ Data Validation, Excel, Excel 2007, Functions, And, Financial Functions, FV, PV, TVMCalcs New Content
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]
]]> 2008-07-26T22:56:38+00:00 http://www.tvmcalcs.com/blog/comments/creating_time_value_of_money_tables_in_excel/ Coin Tosses and Stock Price Charts http://feedproxy.google.com/~r/ExcelBlog/~3/tvvFBnh4dI0/ http://www.tvmcalcs.com/blog/comments/coin_tosses_and_stock_price_charts/ Charts, Excel, Excel 2003, Excel 2007, Functions, Rand, Round, Simulation, VBA
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]
]]> 2008-06-14T06:18:24+00:00 http://www.tvmcalcs.com/blog/comments/coin_tosses_and_stock_price_charts/ Modifying the Ribbon in Excel 2007 http://feedproxy.google.com/~r/ExcelBlog/~3/C9fiW2hvcsU/ http://www.tvmcalcs.com/blog/comments/modifying_the_ribbon_in_excel_2007/ Excel, Excel 2007, Ribbon
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]
]]> 2008-03-27T08:52:38+00:00 http://www.tvmcalcs.com/blog/comments/modifying_the_ribbon_in_excel_2007/ Analyze Google AdSense Data Using Pivot Tables http://feedproxy.google.com/~r/ExcelBlog/~3/XBN_uV7RJO0/ http://www.tvmcalcs.com/blog/comments/analyze_google_adsense_data_using_pivot_tables/ AdSense, Dates, Excel, Excel 2007, Functions, Date Functions, Day, Month, WeekDay, Year, RoundUp, VLookUp, PivotTables, Table
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]
]]> 2008-03-16T08:59:33+00:00 http://www.tvmcalcs.com/blog/comments/analyze_google_adsense_data_using_pivot_tables/ Testing a String for Proper Case http://feedproxy.google.com/~r/ExcelBlog/~3/8hPIlS1FBSc/ http://www.tvmcalcs.com/blog/comments/testing_a_string_for_proper_case/ Array Formulas, Functions, Offset, String Functions, Code, left, len, mid, Proper, VBA
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]
]]> 2008-03-09T01:28:13+00:00 http://www.tvmcalcs.com/blog/comments/testing_a_string_for_proper_case/ Charting Economic Time Series with Shaded Recessions http://feedproxy.google.com/~r/ExcelBlog/~3/CmLLO9ELpjc/ http://www.tvmcalcs.com/blog/comments/charting_economic_time_series_with_shaded_recessions/ Charts, Dates, Economic Data, Excel, Excel 2007, Functions, And, Index, Match
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]
]]> 2008-02-04T00:46:52+00:00 http://www.tvmcalcs.com/blog/comments/charting_economic_time_series_with_shaded_recessions/ Native Excel 2007 Viewer Now Available http://feedproxy.google.com/~r/ExcelBlog/~3/Tn2_w_UbjjQ/ http://www.tvmcalcs.com/blog/comments/native_excel_2007_viewer_now_available/ Excel, Excel 2007
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]
]]> 2008-01-16T20:04:26+00:00 http://www.tvmcalcs.com/blog/comments/native_excel_2007_viewer_now_available/ Disallow Special Characters Using Data Validation http://feedproxy.google.com/~r/ExcelBlog/~3/TriGjDFif1k/ http://www.tvmcalcs.com/blog/comments/disallow_special_characters_using_data_validation/ Data Validation, Functions, String Functions, Search, VBA
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]
]]> 2008-01-15T05:54:20+00:00 http://www.tvmcalcs.com/blog/comments/disallow_special_characters_using_data_validation/ Chart the Yield Curve Using Yahoo! Finance Data http://feedproxy.google.com/~r/ExcelBlog/~3/vk5_SUAZiYI/ http://www.tvmcalcs.com/blog/comments/chart_the_yield_curve_using_yahoo_finance_data/ Bonds, Charts, Functions, String Functions, Find, left, mid, Value, Web Query
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]
]]> 2008-01-04T21:50:06+00:00 http://www.tvmcalcs.com/blog/comments/chart_the_yield_curve_using_yahoo_finance_data/ Display Scenarios Using a Drop-Down List http://feedproxy.google.com/~r/ExcelBlog/~3/QNNUQ46uhDI/ http://www.tvmcalcs.com/blog/comments/display_scenarios_using_a_drop_down_list/ Controls, Combo Box, Functions, Financial Functions, NPV, Scenario Manager, VBA
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]
]]> 2007-09-24T01:06:53+00:00 http://www.tvmcalcs.com/blog/comments/display_scenarios_using_a_drop_down_list/ Adding an Average Line to a Chart Using Defined Names http://feedproxy.google.com/~r/ExcelBlog/~3/2XCtI6Y8KmA/ http://www.tvmcalcs.com/blog/comments/adding_an_average_line_to_a_chart_using_defined_names/ Charts, Defined Names, Functions, Count, Offset
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]
]]> 2007-09-04T07:54:29+00:00 http://www.tvmcalcs.com/blog/comments/adding_an_average_line_to_a_chart_using_defined_names/ Dealing With Unusual Date Formats http://feedproxy.google.com/~r/ExcelBlog/~3/yiRIrKuEZRU/ http://www.tvmcalcs.com/blog/comments/dealing_with_unusual_date_formats/ Dates, Economic Data, Excel, Functions, Date Functions, Date, EOMonth, String Functions, Find, left, len, mid, right, Search
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]
]]> 2007-08-28T08:57:03+00:00 http://www.tvmcalcs.com/blog/comments/dealing_with_unusual_date_formats/ Parallel Install of Office 2007 and Office 2003 http://feedproxy.google.com/~r/ExcelBlog/~3/u9haYCXc2-A/ http://www.tvmcalcs.com/blog/comments/parallel_install_of_office_2007_and_office_2003/ Excel, Excel 2003, Excel 2007
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]
]]> 2007-08-07T09:02:46+00:00 http://www.tvmcalcs.com/blog/comments/parallel_install_of_office_2007_and_office_2003/ Video: Using Controls to Change Chart Data http://feedproxy.google.com/~r/ExcelBlog/~3/x_lD0OECzYU/ http://www.tvmcalcs.com/blog/comments/video_using_controls_to_change_chart_data/ Charts, Controls, Combo Box, Video
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]
]]> 2007-07-30T09:13:22+00:00 http://www.tvmcalcs.com/blog/comments/video_using_controls_to_change_chart_data/ Google Spreadsheets and Google Finance http://feedproxy.google.com/~r/ExcelBlog/~3/b6veTiHWZS4/ http://www.tvmcalcs.com/blog/comments/google_spreadsheets_and_google_finance/ Other Spreadsheets, Google Spreadsheets
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]
]]> 2007-07-18T09:21:57+00:00 http://www.tvmcalcs.com/blog/comments/google_spreadsheets_and_google_finance/ Loan Amortization Tutorial Added http://feedproxy.google.com/~r/ExcelBlog/~3/ORXOz3FIK3s/ http://www.tvmcalcs.com/blog/comments/loan_amortization_tutorial_added/ TVMCalcs New Content
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]
]]> 2007-07-15T09:33:35+00:00 http://www.tvmcalcs.com/blog/comments/loan_amortization_tutorial_added/ The NPV Function Doesn’t Calculate Net Present Value http://feedproxy.google.com/~r/ExcelBlog/~3/t7HiHZkjNGM/ http://www.tvmcalcs.com/blog/comments/the_npv_function_doesnt_calculate_net_present_value/ Array Formulas, Functions, Financial Functions, NPV, PV
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]
]]> 2007-06-19T09:53:27+00:00 http://www.tvmcalcs.com/blog/comments/the_npv_function_doesnt_calculate_net_present_value/ Video: Creating Step Function Charts in Excel http://feedproxy.google.com/~r/ExcelBlog/~3/ouXcg1ZMzEI/ http://www.tvmcalcs.com/blog/comments/video_creating_step_function_charts_in_excel/ Charts, Video
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]
]]> 2007-06-17T10:25:12+00:00 http://www.tvmcalcs.com/blog/comments/video_creating_step_function_charts_in_excel/ On Arrays and Accumulated Depreciation http://feedproxy.google.com/~r/ExcelBlog/~3/OejmU1wJWtM/ http://www.tvmcalcs.com/blog/comments/on_arrays_and_accumulated_depreciation/ Array Formulas, Functions, Financial Functions, DDB, Indirect
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]
]]> 2007-06-11T10:14:36+00:00 http://www.tvmcalcs.com/blog/comments/on_arrays_and_accumulated_depreciation/