Personal Updates

Motel rooms for the wedding…

Hey everyone!  I’ve heard that rooms are going quickly in the area surrounding our wedding because it’s Memorial day weekend.  But, don’t let that stop you from attending the wedding!  We’d love to have you there, and we’ll find shelter for you somewhere if you need it!!

Tech Tips

My Favorite Firefox Extensions

I’ve been using Mozilla Firefox since version 0.8. I love it. It’s perhaps the best thing to happen to the Internet since Netscape 3.  One of the things I love about Firefox is that it is extensible. You can download hundreds of custom modifications to make Firefox tick just as you want.  Below is a list of the extensions I automatically install on every computer I plan on using for any length of time:

  • Web Developer Toolbar — An indespensible list to allow you to inspect any and every aspect of a webpage and its contents.  It’s the best thing I’ve ever seen for debugging CSS and DHTML code.
  • Tab X — Adds a close button to the corner of each open tab. Some people don’t like this, but I think it makes cleaning up a bunch of open web pages very easy.
  • Colorful Tabs — Makes sorting through tabs very easy, thanks to the soothing colors it assigns each tab.
  • Live HTTP Headers — Shows you exactly what’s being sent to the server. A web designers delight! I used it to debug a Smoothwall box just the other day!

If you don’t already have Firefox, get it now! You’ll be surfing faster and safer!

Personal Updates

Wedding Website

I can’t believe it, but I actually forgot to post a link to the wedding website.  So, here it is.  I am honestly very excited about marrying my favorite person in the whole world. With Becca, everything is brighter and more fun. What else can I say…

Personal Updates

It’s getting closer!!!

Hey everybody!  Thanks for visiting jerrytravis.com/wedding!  Feel free to e-mail me or Travis, or call the numbers listed above if you have any questions or concerns!  While you’re welcome to send in the paper RSVP card you received with your invitation, RSVPing online is simple and will save a stamp!!  The decision, though, is completely up to you, we just look forward to seeing you there!  The wedding is now less than 1 1/2 months away!  While I’m a little nervous and stress about getting everything done, I can’t wait to the big day!

Personal Updates

Far away from home…and busy!

Hey everybody, Travis is in Louisville for the next 2 days with Breathitt County ATC FBLA for state competition.  Which, in short translation, means that I have only spoken to him for a total of like, 2 minutes tonight.  For those of you have heard Trav gripe, you know that I love talking to him…a lot.  So, this has been a very stressful day for me, and it won’t end until Thursday.  And then it’s "My Name is Earl and The Office" night, so I feel like I may never talk to Travis again…It’s a sad life!  On the other hand,  I have gotten a lot accomplished since he’s been gone and while he was preparing to be gone.  But, I’d much rather have him than accomplish  stuff any day!!!  Anyway, I love you baby and I’m thinking about you!!!!

Personal Updates

Luckiest Man in the World!

My great uncle Bill passed way on Tuesday, and I’ve been really stressed out about it.  He was more like my grandpa than an uncle, so I’ve taken it hard. 

Once again, Becca has proven why she’s the girl I should marry and no one else.  She literally ditched three classes and skipped a test so she could come get me through this difficult time.  I would like to thank her so much. 

Personal Updates

Great Week!!

Today was my first day back at UK after a fabulous spring break.  It sucked pretty bad to have to leave Travis yesterday after spending all week with him last week.  I know that May will come soon enough, but right now it seems like the next 1 1/2 months are going to take forever to pass.  I know it will be a busy 3 weeks from the end of finals to the wedding day, but it’s going to be so great having Trav there with me!

Tech Tips

Formatting Cells in Excel

What do I mean when I say formatting cells in Excel? To format a cell means to change how what’s in the cell looks. Formatting a cell does not change what’s in the cell, only how it looks.  This is a very important thing to remember.

The Big Three

You already know (I hope) how to use the Big Three of formatting: bold, italics, and underline. In case you forgot, you can manipulate those using these three buttons:

 
Bold, Underline, and Italics Symbol

Color Me Crazy!

You can change the colors of your text and background in Excel very easily. To change the text color, you can highlight the cell you want to change the color of and click on the   Font Color Button  button.  Clicking on the Drop Down Button Symbol will give you a list of colors to choose from. The bar under the “A” will always show the currently selected color.  To change the background color of a cell, click on the Background Color Button button. Again, clicking on the Drop Down Menu Button  will give you a list of colors.

A Different Kind of Formatting

In Excel, we work with all kinds of data. Data are simply pieces of information.  Some different kinds of data are regular numbers (i.e. 1, 2 13, 233, and so on), dates, currency (i.e. how much was your electric bill), ZIP codes, a list of names, and so on.  Excel can format your data in dozens of ways.  For example, if you type March 1, 2005 into Excel and press enter, Excel changes it to 1-Mar-05.  This is just one way Excel can format a date.

>> Important Information: To format a cell to hold a certain type of data, right-click on the cell and select Format Cells… tthen click on the Number tab. <<

Different Format Categories and a Description of Each

General:  This is used if you’re not really sure what kind of data is going into a cell. This is the default value. (A default value is the one that is selected when you start a new spreadsheet.)

 Number: This setting is used if you know you’re going to have numbers in your cells. You can change the following settings in the Number category

  • Decimal Places: This changes how many numbers there are after a decimal place. For instance, if you set Decimal Places to 2, the number 2.5456 would be displayed as 2.55.  Excel rounds to the nearest decimal place you set
  • Use 1000 separator (,): Use this setting if you want your numbers to have a , between each thousands place. For example, 1433 gets displayed as 1,433 if this box is checked.
  • Negative Numbers: This changes how Excel handles negative numbers. You can change them to show a negative sign, turn red, turn red in parentheses, etc.

 Currency: Use this setting if you’re going to be dealing with money but you don’t need the decimal places to line up. Currency works just like the Numbers category except you can choose the symbol that goes in front of the number. (The default symbol is the $ sign, which is the American symbol for money.)

 Accounting:  Use the accounting format if you want the decimal places to line up in the columns. Otherwise, it’s just like currency.

 Date: Use this category if your cell will hold a date. There are a bunch of Date types to choose from. For example, you can make March 1, 2005 look like:

  • 3/1
  • 1-Mar
  • Mar-1

Remember, formatting a date to look a certain way does not change the actual date.

Time: Use this category if you’re going to store a time (i.e. 5pm).  Like Date, there are a ton of ways to represent a time. 

Percentage:  Use this setting if you’re going to have percentages in your cell. It adds a percent sign and you can set the number of decimal places.

>> Important Information: You must enter your percentages in decimal form even if you format a cell as a percentage. For example, if you have formatted your cell as a Percentage and want your cell to show 50%, you must enter .5 in the cell.  If you try to enter 50, Excel will show 5000%  <<

Fraction:  Use this setting if you want decimal numbers to be shown in a fractional format. If you format a cell as a fraction and enter .5 in the cell, it will appear as 1/2.  This is very useful for converting fractions to decimals and vice versa. 

 >> Important Information: The best setting for the Fraction category is Up to Three Digits. This will give you the most accurate fractional representation of your decimal numbers. <<

Scientific:  This is used to display numbers in scientific notation. We won’t be using it in our class, but I would like you to know that it’s there. If you really want to know what scientific notation is, visit: http://www.nyu.edu/pages/mathmol/textbook/scinot.html or you can ask me.

Text: Use this setting if you want Excel to interpret anything you put in the cell as text. If you set the format to text, if you put 1 in a cell and 2 in a cell, you won’t be able to do any math on those numbers: Excel will treat them the same way as the letter “A” or the word “Hello!”

Special:  This is a really neat category. It has settings for all the following kinds of information:

  • ZIP Code
  • ZIP Code + 4 Extra Digits (used in bigger cities)
  • Phone Numbers
  • Social Security Numbers

Custom: The custom category is very powerful but beyond the scope of this class. See me after class if you would like to know more about how to use it!

Personal Updates

What would I do without you?

I just needed to brag a little bit on the most awesome fiance in the world!  I want everyone to know that while I was sick this weekend Trav was so sweet to me!  He stood by me in my hot/cold streaks where one minute I was burning up and didn’t want him near me to the next when I was covered up to my ears begging him to hold me closer and get me warm.  And then there’s the awful whining that I normally do for cuteness and because I’m spoiled rotten, but that I was physically unable to control from Friday night until just a couple of hours ago.  Not to mention making sure I took my meds (that he went and bought for me) every 4 hours just like I was supposed to.  Then of course, there was the fact that because I couldn’t sit my whole 4 hour shift on Friday night, I had to sit my 8 hour shift plus 2  more hours on Saturday to make up for my staff partner covering for me on Friday.  And Trav was right there by me, on the other side of the desk, for the entire 10 hours~and he didn’t even put up much of a fuss about it.  And then there’s today, in which he has called me at numerous random times throughout the day just to check on me.  Baby, thanks for being the best fiance ever, and thank you soooo much for all you did for me this weekend!  Just you being here with me was the biggest help ever, but I know that all the stuff you did for me has helped me get better faster!!  I Love You Always!

Scroll to Top