Tag: AskQ

Happy New Year 2019

 

happy new year message, keyboard enter key

By now, I am likely suffering the ill effects of an Egg Nog induced coma, so in my cognitive absence, I present the most read posts from the year. Enjoy and thanks for reading!

and because nothing cures a New Year’s hangover better than an AskQ post!

Most Read ASKQ Posts: 2018

Find Your Phone using Google

*updated May ’18

Lost your android phone? You can have your phone send out a Here I am! ring, or lock the device with an “If found, please return” message.

To Locate your Android Phone

  1. Go to https://www.google.com/android/find.
    Note: you will be prompted to log into your Google account.
  2. Your phone’s locationlocation-icon-png-14will appear highlighted.
  3. Select preferred option(s):
    a. Click Ring to have your phone ring.
    b. Click Lock to secure your phone with a message and callback number.
    c. Click Erase to wipe your personal data.

Cheers!

hɔuᴉnb

Related posts:

Comments and questions are always welcome!

Managing Your Android Phone and other Devices

The Android Manager is accessed through the Play Store. Use this site to rename your devices (e.g., phones, tablets, wearables) or remove a lost device from the Play Store list.

To Managing Your Android Phones

  1. Go to https://play.google.com.
    Note: you will need to be logged into your Google account.
  2. Click the Gear icon googlesettingsgear.  Your Devices will appear under My Devices.
  3. Click to rename device.
  4. Uncheck ‘Show in Menus’ to hide device to apps (i.e., Google Play).
  5. Click Update.

Cheers!

hɔuᴉnb

Related posts:

Comments and questions are always welcome!

Midyear Roundup: My Best Dates

Some of my fave Excel Date Functions. Some old, some new; all designed to help track the passage of time.

Date Functions:

EOMONTH
returns the last day of the month		 EOMONTH ( start_date , month )
EDATE
returns the date x number of months before/after a given date		  EDATE ( start_date , months )
NETWORKDAYS
calculates the number of working days
(see also NETWORKDAYS.INTL)		  NETWORKDAYS ( start_date , end_date , [holidays] )
TODAY
returns the current date		  TODAY( )
WEEKNUM
returns serial number for a given week		  WEEKNUM ( date , [week_start] )
WORKDAY
calculates the next valid work day
(see also WORKDAY.INTL)		 WORKDAY( start_date, days, [holidays] )

 
YEARFRAC
returns the date as a fraction of the year		  YEARFRAC ( start_date , end_date , [basis])

Cheers!

hɔuᴉnb

Additional reading:

Comments and questions are always welcome!

Hidden Excel: Find Date Differences with DATEDIF

In honor of the 40th anniversary of J.K. Rowling’s seminal classic, Harry Potter, this post magically exposes a hidden excel function!

Date Difference between J.K. Rowling’s Birthday and Harry Potter Movie Debut

Ever wonder if your spreadsheet is keeping something from you?

DATEDIF is an under-documented function. It allows  you to calculate the difference between two dates. Although it doesn’t appear in the Function Wizard (it exists to insure backward compatibility with Lotus and earlier Excel versions) it is a powerhouse when it comes to calculating date differences.

Using DATEDIF function:

  • Format: =DATEDIF ( date1, date2, “interval”)
  • date1 must be the earlier of the two dates or an #NUM error is returned.

Interval Arguments:

y Years
m Months
d Days
ym Months, years excluded
yd Days, years excluded
md Days, years and months excluded

Cheers!

hɔuᴉnb

Additional reading:

Comments and questions are always welcome!

Acrobat Page Numbering

Often times, a PDF’s pagination doesn’t match the pagination as displayed in document. For example, a document containing caption, contents and authorities pages, may have its first narrative page set 7 pages into the file. This makes navigation problematic.

Many courts now require that the PDF page numbering match the original document pagination. Follow these instructions to renumber your PDF.

To Renumber Pages in an Acrobat PDF

To label or suspend numbering for an un-numbered page
(e.g. Caption pages)

  1. Display Page Thumbnails by clicking Thumbnails icon at left.
  2. RT+CLICK on the page thumbnail and select Number pages. The Page Numbering dialog appears.
  3. In the Pages section choose ‘Selected’.
  4. In the Numbering section select ‘Begin new section’.
  5. Click Style drop-down and select None.
  6. Set Prefix to appropriate label (e.g., Caption, CoverPg, etc.) or leave blank.
  7. Click OK.

To renumber pages within a section (e.g., Table of Contents)

  1. Display Page Thumbnails by clicking Thumbnails icon at left.
  2. To select multiple pages, click on the first page of the section, then scroll down and SHIFT+CLICK on the last page.
  3. RT+CLICK on one of the selected thumbnail pages and select Number pages. The Page Numbering dialog appears.
  4. In the Pages section choose ‘Selected’.
  5. In the Numbering section select ‘Begin new section’.
  6. Click Style drop-down and select desired format (e.g., i ii iii).
  7. Set Prefix to blank (i,e. leave this field empty).
  8. Set Start to ‘1’.
  9. Click OK.

Cheers!

hɔuᴉnb

Related posts:

Comments and questions are always welcome!

Dude, Where’s My Car? Parking with Google Maps

Although I’ve not had the cinematic misfortune to see Ashton Kutcher utter this titular question, I have, occasionally, misplaced my car.

But no more; with the latest update to Google Maps  you can record where you parked your car, and when.

Click image for video.

To Record Your Parking Spot

  1. Open Google Maps.
  2. Press the Blue dot . A menu will appear.
  3. Select Save your parking.

Notifications remind you when it’s time to feed the meter, and a map directs you back to your vehicle.

Cheers!

hɔuᴉnb

Related posts:

Comments and questions are always welcome!

%d bloggers like this: