Skip to content

Photoshop – take off a few lbs. with the liquify filter


Too bad this filter doesn’t work in real life!  If you need to take off the few pounds that the camera put on, this video will show you how.  It also includes a brief tutorial of the clone stamp tool as well as adjusting lighting/color.

Remove skin imperfections in Photoshop


Sometimes we have a blemish that needs to be removed so that a photograph looks dynamic – or possibly a tattoo that one has regretted getting but doesn’t have the $$ to have it laser removed.  This video uses both the healing brush tool and the clone stamp tool to fix the portrait of a young gentleman.

Resize an image for publication/internet in Photoshop (or Elements)


This is important for those who are artists and are either submitting work for a juried or curated  show – they often have standards with

a) naming
b) size of image (either in inches or pixels)
c) pixels
d) type of file – JPG, PSD, TIF, GIF

Even if you are not an expert at Photoshop, these tips will help you accomplishing this work correctly so you will be accepted and/or published.  The tips also work with any version of Photoshop or Elements – even their earliest versions!

Even if you’re a blogger, you need to know how to get the images correctly sized so download speeds are not slow and the image doesn’t go across 7 screens!

 

Create random numbers in Excel


Many of you probably know how to create a set of random text in Word – it is =rand()

This same function works in Excel – you will get this with each entry (of course you can copy to fill a range and get varied results – a great way to help test some formulas.

=rand() – results less than 1

=rand()*100 – values between 0 and 100

=randbetween(low,high) will gives results between a specific number range, i.e., 25 to 50

This demonstrated in this video – and I also show how to convert this into regular numbers with copy, paste special

Summarize data in an Excel Pivot Table


Pivot tables are very powerful in summarizing data…..sometimes you may wish to do more than just display the actual numbers. This example shows you how to show % of either column (category) total or the grand total.  In addition, discover how to change the formatting of the numbers.  You will also know how to refresh data – if there is ever a change in the source data, the pivot table will NOT show it until it is refreshed.

2017 Photographer(y) Resolutions


For those of you who enjoy photography, below are a few resolutions that I am hoping to follow next year!  Some are tongue-in-cheek, yet serious

  1.  When I take pictures, I promise not to take 37 shots of the same image – I will take a moment or two to look at the area, take my picture(s) yet not overdo it.  Back in the days of film (and it could be costly!), I’d think things out first.  Even though it is “free,” it can be very time consuming to delete excess photos or to just waste time wading through all of the images.  This rule can be broken when you’re in a once-in-a-lifetime experience such as being at the top of Mt. Everest.
  2. Deciding what accessory, lens, gadget I need rather than want.  Too often the gadgets get in the way and can slow you down (either in weight) or deplete the checking account.  If it is something you need, get it.  If it is a want, wait about 90 days and then you’ll decide whether or not it’s worthwhile.
  3. Try to learn a shortcut or two in your post production processing – actions and batches can be huge time savers when you ignored resolution #1!
  4. Try to spend some time just looking and enjoying the sights, vistas, beauty.  We can get more joy and pleasure by admiring what we see rather than trying to recapture it!  This is a great idea especially when you forgot your camera.
  5. Get a picture (or 2 or 3) off of the camera/computer – print it out – hang it so you (and everyone else) can enjoy the image!  Change the images in the frame every few months or weeks – it’s an inexpensive way to keep your personal momentum going (as well as decorating your home or office).

10 essential Excel basics to know


if you have some time off during the holidays and are planning on improving your skills for your current (or future) job, these are the 10 basics you need to know:

  1. How to enter basic formulas and calculations
  2. Add up a column or row of cells
  3. Absolute and relative references
  4. Rounding numbers
  5. Scale your spreadsheet to fit on one page when printing
  6. Print a spreadsheet with page numbers (and knowing footers with dates, sheet name, file name)
  7. Freeze or lock rows and columns in
  8. How to use the IF function in Excel to calculate values based on different criteria
  9. How to use Autofilter in Excel
  10. How to create a Pivot Table – this is an intermediate function that is required more and more in the workforce – indicating knowledge of this topic on your resume  is more than slightly helpful!

There more than a few references on the internet on how to do any or all of these – if, like most people, you desire hands on tutoring, find someone to help or take a class – either in continuing education or at a local college.

info@big-pic.net