Skip to content

100 Amazing Computer Tips


I wish I wrote this book, but I didn’t.  Anyhow, it’s great for the novice, slightly experienced or even someone like me who teaches and is always looking for something new.

You can buy the book in print or as an ebook.  100amazing

If you live in Sarasota, FL, you may wish to check out the classes that she teaches there.

 

make Word work for you


A few tips to help with Word – works with all versions!  Highlighting/selecting text can sometimes be a pain, these shortcuts will make life easier…stuff I thought EVERYONE knew!  I’ve taught basic and intermediate classes…very often the intermediate students are thrilled to learn them:

highlight a word:  double click on it

highlight a paragraph:  triple click in it

highlight a sentence:  put your mouse inside the sentence, hold down control key and left click.

highlight entire document to adjust spacing, font size, color, etc:  CTRL + A (selects all).  (command A on the Mac)

highlight a single line in a paragraph:  put mouse to the left of the line, you get a right pointing arrow.  click once.

highlight multiple ranges in a document:  select first range of text.  Hold down CTRL key and highlight second range.  Repeat this step.

Excel Essentials to keep (or get promoted at) your job!


This link is very helpful for those who know the basics of Excel.  There are so many additional features that you need to know that this link will help you.

Some of the many topics include the basics like sum, average.  etc.  However, it includes some functions that I forgot about which include LEN, TRIM, RIGHT, LEFT, MID, VLOOKUP, IF, SUMIF, COUNTIF, AVERAGEIF, CONCATENATE.  If you don’t know what they mean, check this out…instructions are very well written!

Conditional formatting in Excel 2013


The video is demo’d in Excel 2013 yet will work with 2010 and 2007.  Conditional formatting  allows the user to change the appearance of cells if they meet a specific condition – i.e. top 10 in a range will appear bright green.  As a bonus, this video also shows you how to toggle it on/off with a very simple step.  This way you can look at the information without being distracted by the color(s) being displayed.

Exercise


Exercise your optimism muscle every day

(paraphrased from Robin Roberts)

Puppet Warp in Photoshop or Elements


This has nothing to do with puppetry!  This allows you to adjust architecture, move arms, etc.  I did not do this video, it summarizes it much better than I ever would.  Discover many uses for this incredible feature.

“Frame” a photo in Photoshop or Photoshop Elements


Create a lovely gift for someone special in minutes with either program.  It’s fun, easy to do and will impress the recipient to no end!

Follow

Get every new post delivered to your Inbox.