Archive for February, 2013

Adding HyperLinks Functions To Better Navigate Your Excel Spreadsheets

Excel function tutorials

I’ve discussed in the past how you could use Excel to add links to many different files on your computer that you use on a daily basis in order to become more productive. I got a similar question that might be of help to you. Basically, let’s imagine this user has a frontpage with several informations that are all displayed on different tabs. The summary is a recap but all details would be found in the many other tabs of the excel file. Here is a summary of a simplified version:

The names refer to different tabs as you can see:

Basically, I could go on the cells and either do “Insert/Hyperlink” or click “Ctrl-K”, the shortcut:

Then, I would simply select on the left that I’m looking to link to a “place in this document” on the left menu, cell A1 (which could be changed):

Once that is done, the user can click on that cell and be automatically taken to the correct location to see a breakdown of what that number means

It’s easy to do and can turn out to be a time saver for both yourself and others that are using the excel spreadsheet! Makes sense?

How Would You Deal With an Unexpected Expense?

Personal finance

We all know that life can throw us a curve ball at times. In mid-2011, due to a freak accident my engine got messed up. Then as soon as I fixed this, someone rear ended me and drove off. So yes, I had a rough month there. I had to fork over tons of money that I wasn’t planning on spending. I had to miss out on a trip and I really had to cut back. Thankfully, I had the money in an savings/emergency account. I definitely wasn’t too pleasant about suddenly blowing all of this money.

We’ve all had to deal with a financial emergency at some point in life. It’s not pleasant, but life doesn’t care about that.

How would you deal with an unexpected expense? This question is always on my mind because you really never know what can happen. You can always at any point in time get hit with a shock expense. If you’re living paycheck to paycheck, this will catch you off guard and ruin things for you.

Let’s look at common options for dealing with sudden, yet unexpected expenses:

Your credit card.

Most of us will usually turn to a credit card to deal with a sudden expense. It’s quick and easy. Best of all, credit cards do NOT ask questions. Everyone else does. With your plastic, you don’t have to worry about approval as long as you’re within your limit.

There’s just one difference here. Some of us have the money in a savings account to pay off this balance. Others have to wait for their next paycheck to handle this. Which side do you fall under?

Your emergency fund.

Do you have money saved away just in case? While some of my friends don’t believe in just leaving money around in savings account, I do. I see the argument for why it makes sense to invest your money. I just don’t believe that you have to invest every single penny. You can keep some money in a savings account just to cover yourself in the event that something should happen.

When dealing with an emergency, you don’t want to stress about liquidation or selling off stocks. You just want instant access to your hard earned money.

Be screwed!

Unfortunately this is an option because we either can’t always be prepared or the expense is too large. In the former situation, the onus is on you to take the time to put some money away. In the event of the latter, there’s nothing that we can do. There’s only so much money that you can save for emergencies. Some emergency situations will simply be too large too handle. Hopefully this doesn’t happen to any of you guys.

What’s your plan? I’m curious to hear about how you guys would handle a surprise expense if something were to happen tomorrow  Do you have a plan? Do you just go with the flow?