Duplicate in PowerPoint

Here’s a quick PowerPoint time saver: Press CTRL + D to duplicate an object.

  1. Insert, resize and move object (i.e., shape or picture) to desired location on slide.
  2. With the object selected, press CTRL + D. A duplicate will appear, slightly offset from the first.
  3. Move the duplicate to preferred distance from original; keep this object selected.
  4. Press CTRL + D again. The next duplicate (triplicate?) appears positioned equidistant from the last.

Repeat final step, as necessary.

Tip: CTRL + D is a CUA (common user access) instruction in many Graphic and Desktop Publishing programs (e.g., Visio, Photoshop).

 Cheers!

hɔuᴉnb

Comments and questions are always welcome!

Related:

Excel: Insert Tables From Web

Use the Insert from Web option, to quickly import tables from web pages into Excel.

Watch this 2 minute video to see all you need to know.


To Insert Data From Web into Excel

  1. Using your web-browser, locate the content to be imported.
  2. RIGHT + CLICK in the addressbar and select Copy.
  3. In Excel, on the Data tab of the Ribbon, click From Web. A New Web Query dialog will appear.
  4. RIGHT + CLICK in the addressbar, select Paste, and click Go. The source webpage will populate the dialog.
  5. Click the yellow arrow grnarrw next to the table(s) you wish to copy (the icon will change to a green check grnchk  ).
  6. Optionally, click Options and select formatting preference (i.e., None, Rich Text, HTML) then click OK.
  7. Click Import. The Import Data dialog will appear.
  8. Select starting cell to import data to or select “New Worksheet” to import into a new sheet.
  9. Click Properties, uncheck Save Query Definition*, and click OK.
    *Alternatively, to maintain a link to variable data, leave Save Query Definition checked; you will be prompted to ‘Enable Content’ each time the file is opened.
  10. Click OK to complete the import.
Additional reading..

Cheers!

hɔuᴉnb

Comments and questions are always welcome!

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 183 other followers

These headphones beam images directly into your eyes

Forget Google Goggles, Retina display with stereo! Is this the next thing?

avegant-glyph-white[1]

From Avegant, a Kickstarter company, promises full audio and beams the images directly on to your retina (ouch?)

For more read the Quartz article here

An Internet Minute

This infographic comes from the IntelScoop.com (March 2013)
The arrangement seems wholly arbitrary; I would’ve preferred if the items were placed in ascending order.
Click here for the full article.

For an updated (December 2013) version of an Internet Minute, click here for an equally horrendous infographic, courtesy of AlleyWatch.com

Enjoy, and remember; the minute you spend looking at this is a minute you could have spent greeting those 100 new LinkedIn members.

An Internet Minute
click image for full size

MS Office: Insert Screenshot

Need to insert a screenshot into your presentation, document, spreadsheet or email? The Office 2010/2013 Insert Screenshot button makes this easy.

Watch this 60 second video to see all you need to know.


To Insert a Screenshot

  1. Display content window that has the material to capture. Do not minimize this window.
  2. Open or switch to destination application (i.e., MS Word, PowerPoint, Excel, or Outlook).
  3. Place cursor where you wish to insert the screen capture.
  4. On the Insert tab of the Ribbon, click Screenshot button. The available (i.e. not minimized) windows will display as thumbnails.
    • To insert an entire window; select associated thumbnail from the drop-down.
    • To insert a portion of the window previously displayed; select Screen Clipping, then CLICK + DRAG cross-hair around the portion to insert.
Additional reading..

Cheers!

hɔuᴉnb

Comments and questions are always welcome!

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 183 other followers

Mobile: Capture Screenshot

Your on the go and need to capture or produce an image from your phone? Let’s say, for instance, that you are planning of finally redeeming that Groupon you purchased. Or, perhaps, you plan on flashing your e-ticket to the airline check-in attendants. These would be bad times for your 4G or WiFi connection to fail. In preparing for hi-stress situations you are best served if you plan for technology to fail. Sure; one way to mitigate against an awkward moment by printing is by producing a printout of your ticket or voucher. My, how old skool! 

Another, less retro, failsafe involvles capturing a screenshot of your  e-ticket or voucher prior to use, while your internet connection is rock-steady. That way, if you lose connectivity, you still have the image on your phone to present when needed. And, yes, these methods also work with instant messenger apps (e.g. Snapchat).

phone_androidAndroid phone

At the same time, press the On/Off switch and the Volume down buttons.
The image is captured and added to your Picture album/gallery.

Newer Samsung users: In addition to the above Android instruction, with newer Samsung phones (e.g. Galaxy 4) you can capture a screen with a hand gesture. The setting activated by going into your System Settings, under Motions and gestures.

phone_iPhoneiPhone

At the same time, press the Power and the Home buttons.
The image is captured and added to your Camera Roll

windowsphoneWindows 8 phone

  • At the same time, press the Start and the Power buttons.
    The screenshot is captured and added to the Screenshots album in the Photos Hub
note: The methods listed here are neither model nor version specific and may not apply to all makes and models: your mileage may vary 🙂
Additional reading..

Cheers!

hɔuᴉnb

Comments and questions are always welcome!

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 183 other followers

Data Consolidation

Using Consolidate you can summarize data from separate worksheets onto one master sheet.  Data Consolidation performs a statistical function (e.g. Sum, Average) on a series of ranges (lists). And the best part:  the lists need not have identical content.

Watch this 2+ min. video to learn all you need to know.

Performing the Data Consolidation

Logo_Microsoft_Excel_2013 Click  here to open Toy List Consolidation.xlsx sample spreadsheet

Prep: Sort each list by the first column and remove all blank rows and columns within the lists.

Tip: Use Define Name to set name each list.

  1. On the summary sheet, select the upper-left cell where the consolidation is to appear.
  2. On the Data tab, in the Data Tools group, click Consolidate.
  3. In the Function box, select function (i.e., Sum).
  4. In the Reference field, type the name or cell references of first list (including column and row headings), then click Add. Repeat this step for each list to be summarized.
  5. Check Use labels in Top row and Use labels in Left column.
  6. Click OK.

Cheers!

hɔuᴉnb

Related reading:

Comments and questions are always welcome!

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 183 other followers