Financial Crisis 101

by admin on October 21, 2008

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 [...]

{ 0 comments }

Dynamic Named Ranges in Excel

by admin on May 31, 2007

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 [...]

{ 0 comments }

Excel Phantom Links

January 18, 2007

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 the full article →

Using the F-Lock and restore function Keys on Microsoft keyboards

October 17, 2006

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 the full article →

Excel Links

September 6, 2006

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 the full article →

Loan Amortization Calculator

August 23, 2006

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 the full article →

Resolution Flowchart (Click image to enlarge)

August 18, 2006

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 the full article →

Stealth / Invisible Windows XP User Account

August 18, 2006

The following was copied from an article originally posted September 11, 2003 on the “old” Tech TV website (a former stomping ground of Leo Laporte. The article was originally presented and written by a Tech TV contributor, Sarah Lane, and reproduced here for your enjoyment!
User accounts normally appear on your Windows XP welcome screen. Today [...]

Read the full article →

Essbase Retrieve in Excel using VBA

August 18, 2006

Here is a snippet of code to place in a VBA script to retrieve data from Hyperion Essbase. If you use the code, I’d love to hear your comments on how it worked for you and how you’re incorporating Essbase data into your Excel analysis.
Sub Macro1()
Application.Goto Reference:=”retrieve”
Application.Run (“EssMenuRetrieve”)
Sheets(“parameters”).Select
Range(“a1″).Select
End Sub
Here is another presentation of the [...]

Read the full article →

Enable / Disable Function in VBA and Microsoft Access

August 18, 2006

Here is a function that first Disables, then Enables (or re-enables) all of the “pop-ups” in Access when running queries. If you use the code, I’d love to hear your comments on how it worked for you and how you’re incorporating it into your projects.
When running code, the last thing you want is something [...]

Read the full article →

Data Warehousing Intro

August 18, 2006

As more and more financial data is created in sophisticated transactional systems (the General Ledger or “GL”) and summarized in complex reporting systems (Oracle, Hyperion, Lawson, Great Plains), it seems that the reports that are actually “Delivered” to management continue to come from the more traditional sources such as Excel and Word. Until [...]

Read the full article →

That’s What you Should have Said (at Work)

January 1, 2003

I can see your point, but I still think you’re full of it….
I don’t know what your problem is, but I’ll bet it’s hard to pronounce.
How about never? Is never good for you?
I see you’ve set aside this special time to humiliate yourself in public.
I’m really easy to get along with once you people learn [...]

Read the full article →