Author: quincy harley jr

Quincy is a technophile, coach and Learning Development expert. He has an extensive legal IT background and is practiced in MS Office application support and product development. As a project leader he has been integral in numerous new application rollouts. Whatever spare time he has, is spent with reading, archery and watching his young sons grow.

PowerPoint Photo Album

Here’s a quick tip that highlights PowerPoint’s easy to use Photo Album.

Remember the time when slideshow, meant a carousel of slides with you sitting in a dark room while [insert familial relation here] clicked through a series of pictures from some vacation?

No?  Hmm, I may be dating myself. 😦

Take a retro moment; throw-away that text based presentation you have been struggling with (let’s face it, no one reads that stuff anyway) in favor of an old fashioned picture slideshow.

Create a Photo Album Slideshow:

  1. On the Insert tab, in the Images group, click the top split of the Photo Album button. The Photo Album dialog appears.
  2. Click the File/Disk button. The Insert New Pictures dialog appears.
  3. Navigate to the folder that contains the pictures to be included and select those images.
    Note use CTRL + CLICK to ‘cherry pick’ images, or CLICK on the first picture and SHIFT + CLICK on the last to select that set of pictures.
  4. Click OK to return the Photo Album dialog.
    New Album Screen Shot
  5. Optionally, adjust a picture’s settings by selecting that picture and then clicking the appropriate Move, Contrast or Rotate option.
  6. Select a Picture layout (e.g., Fit to slide, 2 Pictures, etc.) and select a Theme.
  7. Click Create.

Voila! Press F5 (shortcut) to run the slideshow

Should you need to edit the Photo album, click the bottom split of the Photo Album button and select Edit Photo Album.

Cheers!
hɔuᴉnb

Comments and questions are always welcome!

Homage to ‘old skool’ video games

Here’s a stop motion animation done by artist PES. Using household objects, lost of time and patience, he has recreated the thrill of whiling away time (or quarters) on those classic video games.

Enjoy!

For more on him and his work check out his Facebook page, here.

Excel: Using Conditional Formatting to Highlight an Entire Row

Conditional Formatting a Row

Conditional Formatting makes it easy to visually highlight cells, based upon conditions (criteria) that you set. The conditional formats are dynamic, so as the data is edited, the criteria is tested, and the formats reapplied.

In a prior post, I mentioned how you can format an entire row or record based upon criteria found in one of that row’s fields.  Here’s the step by step example, using the Charity Guest List data, used in the prior post.

Let’s demonstrate the COUNTIF using the first scenario. Count the number of guests who have donated more than $100

CountIF..click to zoom in
Rows conditionally formatted gold where donation is greater than or equal to $100

The intent is to format gold, those rows where the value in column D is $100 or greater.

A copy of this spreadsheet can be found here, on Google Drive. The file will open in a browser window/tab, in view mode. Click CTRL + S (PC) or select FILE, SAVE AS to download the file.  

  1. Open the file in Excel.
  2. Select the donation data, cells A3:D15.
  3. On the Home tab, in the Styles group, click the Conditional Formatting drop-down and select New Rule. The New Formatting Rule dialog will appear.
  4. Select Use a formula to determine which cells to format.
  5. In the Edit the Rule Description section, click in the Format values where this formula is true, field, then type or select the first criteria value, the donation in cell D3, followed by the criteria, ‘>=100’ (no quotes).
    Note if using your mouse to select the cell, Excel will add ‘$’ to indicate absolute references. It is important that you remove the absolute reference indicator before the row number.
  6. Click the Format button. The Format Cells dialog appears.
  7. Click Fill tab, and select a Background Color.
  8. Click OK. The dialog should look like this:
    Conditional Format Dialog
  9. Click OK.

A few more notes on Conditional formats.

  • To edit or delete the conditional formats: On the Home tab, in the Styles group, click Conditional Formatting and select Manage Rules.
  • You can create multiple rules and order how they should be applied.

Experiment: change some contributions in the spreadsheet and see how the conditional formatting reformats the row.

Cheers!
hɔuᴉnb

Comments and questions are always welcome!

Excel: CountIF Function

COUNTIF:

If you ever find yourself trying to perform a count on a select subset of items in a larger range, then you have reason to use the COUNTIF function. Continue reading “Excel: CountIF Function”

Personal interest

Check out what shiny bauble now has my interest.

Search Engine Optimization.

Great layman’s article can be found here

%d bloggers like this: