What I Learned

I am a very curious person, or so I have been told. Some people like that about me, but I am sure that I annoy the crap out of others by asking too many questions. I just want to get to the meat of things, and if I have a problem to solve, I do not quit until I find the answer. This can lead to some pretty grim rabbit holes, and some frustration on my part, but the maximizer in me will oftentimes not let go. Many times, these searches or questions come because something goes wrong. Other times, it is my need for perfection that drives the search. I will give you examples of both. The first one on my list is the latter, and the second one on the list is the former. The third is one I learned a long time ago, but one that I find useful for blogging or journaling. So read on for what I learned, the computer shortcuts and blogging edition. 

Putting a hyperlink in a comment. I wanted to link a pair of shoes for Rick in Nance's blog about buying shoes for her husband, but I did not want that super long annoying link to show up; I just wanted a tidy hyperlink. I have done this before, but it is one of the things I promptly forgot afterwards. One thing that I am trying to do (#lifegoals) more is to keep track of things in an organized way so I can either find them later or use them again or not look up the same thing over and over (definition of insanity, right?) So now I (and you!) will have notes on how to do this right here: 

In the area you want the hyperlink, type this: <a href="PUT WEBSITE ADDRESS HERE">PUT WORDS YOU WANT DISPLAYED HERE</a> 

For example, you would type: why not hop over to <a href="https://www.travelspot06.blogspot.com">this excellent blog</a> for more information about coding? And what will show up will be --> Why not hop over to this excellent blog for more information about coding? FYI: This will work on both WP and Blogger blogs. 

Copy + paste clipboard. Sometimes I am commenting on blogs and when I click submit, I get an error and then sometimes I cannot go back and resubmit, so I have to type out the entire comment again and that is frustrating! So I researched how to get my clipboard (aka previously copied information) and it is super easy on a PC (sorry Mac users, you have to figure out your own issues). 

Just click the Windows Button + V, it will ask if you want to start saving your clipboard, say yes. Then what I do is right before I hit submit on the comment, I use CTRL-A, CTRL-C to copy the comment and then if I need to access it again later, I click Windows-V and there I have my list of saved items. To use it, just click on the one you want and voila! No repeating comments or other things. You can also pin ones you use a lot! This also works for clipped snippets (like the Excel clips pasted below!!)

A quick warning though: The Windows clipboard history is available until you restart your computer, except for any items you've pinned. The clipboard history only stores the last 25 items you've copied, and when you copy a new item, the oldest item is deleted.

Excel formula of the week. I love Excel; I use it for travel and packing lists and organization, collecting information, keeping track of things and obviously for adding up costs and doing budgets and things like that. The IF function is one that I use in various forms! You all may know how to use these already, and if so, yay! If not, here they are. And if these seem exciting, just wait until we get to nested IFs! Prepare to be wowed! 

SUMIF --> Used to sum by category when you have a list of numbers or costs etc. In the below example, I want to sum up costs by category. I am telling it to sum the list in column C if the category in column B matches the word in cell E3. 

COUNTIF --> in the same example, I now want to count how many of each category there are. So basically count how many in column B match cell E3. 

IFERROR --> Now that I have my counts, I want to calculate a per day cost. This all well and good but if I remove the word Motel, now I have an error (#DIV/0) for Motel because the count is zero. To fix that, I put the words IFERROR before the formula and then tell it what phrase or number I want it to return if there is an error. In this case I am being silly, but usually I just put 0, or "", which will return a blank. 

Once that formula is done, here is the result. Isn't that fun! 

Oh you want one more you say? Fine! I also love the shortcut ALT = (ALT and equal key) which is used to sum up a column instead of typing out =SUM(H3:H9). Just put it where you would normally put the formula and you are good to go! Okay, admit it; did your eyes glaze over? Or are you excited to share your favorite Excel tip with me? 

Do you use any of these tricks? Or do you have any other shortcuts you use while blogging or commenting? Do you have any fun Excel tricks you want to share? If you are a Mac (or cell phone) user, do you know where to find your clipboard? 

This post is part of NaBloPoMo. You can find the rest of my posts for this challenge here. You can find the list of participants and their information here.