Warning: Invalid argument supplied for foreach() in
/home3/heygasto/public_html/wp-content/plugins/amazonfeed/php/amazonfeed.class.php on line
354
Warning: Invalid argument supplied for foreach() in
/home3/heygasto/public_html/wp-content/plugins/amazonfeed/php/amazonfeed.class.php on line
354
Warning: Invalid argument supplied for foreach() in
/home3/heygasto/public_html/wp-content/plugins/amazonfeed/php/amazonfeed.class.php on line
354
Warning: Invalid argument supplied for foreach() in
/home3/heygasto/public_html/wp-content/plugins/amazonfeed/php/amazonfeed.class.php on line
354
Warning: Invalid argument supplied for foreach() in
/home3/heygasto/public_html/wp-content/plugins/amazonfeed/php/amazonfeed.class.php on line
354
RSS Feed for FAT Luci, my Finance and Accounting Blog at FatLuci.com
Financial Crisis 101
Countless journalists and bloggers have commented on the who/what/when/why of the financial crisis we find ourselves in these days. In trying to make sense of it all, I stumbled upon a compelling series of 3 videos that actually makes things easier to understand.
The videos may seem a bit long at six to ten minutes [...]
(read more)Dynamic Named Ranges in Excel
When using named ranges for pivot tables (among other things), I find myself constantly having to update the area of the spreadsheet referred to by the named range. This renaming occurs as a result of my adding new raw data to the table, or editing the table’s Column/Row layout. When researching possible [...]
(read more)Excel Phantom Links
Excel may be asking you to update links when you do not even know you have any. Below is a strategy to detect links you may not be aware of:
Unhide any hidden Worksheets first. Then right click on any sheet name tab and select “Select all sheets“. Now go [...]
(read more)Using the F-Lock and restore function Keys on Microsoft keyboards
My new keyboard from Microsoft, the Microsoft Natural Ergonomic Keyboard 4000, while very useful and easy to type with has one big flaw. The function keys (F1 – F12) displayed along the top of the device lose their base functionality by default. The old functionality is replaced with “new” functions as assigned by [...]
(read more)Excel Links
Here is a list of useful Excel websites and blogs. from my Del.icio.us account. They have been tremendously resourceful over the years. Once on Del.icio.us you can use the tags “Access”, “Visio”, “Word” and “Windows” for other useful sites related to those programs. Enjoy!
(read more)Loan Amortization Calculator
Below are two Excel spreadsheets which will calculate the amortization of a loan after manual entry of Purchase Price, Down Payment (nets with Purchase Price to obtain Loan amount), Interest Rate, Loan Period and Loan Start Date.
The resulting table details the amortization of the entire loan for each month of the loan’s life. Also provided, [...]
(read more)Resolution Flowchart (Click image to enlarge)
Here is a Flowchart that provides a “Visual” approach to tackling and resolving those annoying “ankle-biter” decisions we all have to make every day. Enjoy!!
(read more)
