Accents made easy in Word

JasonUnderwood
loved your pate!

Our world shrinks and our community becomes increasingly global. For those using the 26 letter (aka, US 101) keyboard, proper communications can be challenging.

Master these easy keyboard shortcuts so as not to mistake pate with pâté, fur with für, or Crème fraîche with, well, anything. 

To avoid a lot of memorization, remember: look for the key that looks like the accented character and match it with a CTRL (and sometimes SHIFT) stroke. Many of the special characters can be created by using apostrophe ( ′ ),  colon (:)  caret (^) and tilde (~).

Char

Name

Keystroke

Example

´

acute accent CTRL +, followed by letter más (Sp., more)

`

grave accent CTRL + `, followed by letter (Fr., where)

¨

diaeresis/umlaut CTRL + SHIFT + :, followed by letter Tür (Gr., door)

^

circumflex CTRL+ SHIFT ^, followed by letter tête (Fr., head)

~

tilde CTRL + SHIFT ~, followed by letter Piña Colada (a dreadful 70s song)
Bonus language-specific shortcuts:

ç

(Fr.) cedilla CTRL + , (comma), followed by c garçon (boy)

ß

(Gr.) eszett CTRL + SHIFT + &, followed s groß (large)

Related

Cheers!

hɔuᴉnb

Comments and questions are always welcome!

Excel NCAA templates

March Madness is upon us!

In 1892 Coach James Naismith hammered two peach baskets into the gym balcony, and forever changed how we use Excel!

NCAA_LooneyToons

Using these free templates available in Excel, you can plot out your final four projections!

To access NCAA templates

  1. Click File and select New.
  2. In the Search Office Templates field type ‘NCAA‘ (no quotes) and press the search arrow. The search results will populate the dialog.
  3. Select preferred template and click Download.

ncaa

from Wikipedia:

[Naismith] divided his class of 18 into 2 teams of 9 players each and set about to teach them the basics of his new game of Basketball. The objective of the game was to throw the [ball], into the fruit baskets nailed to the lower railing of the gym balcony. Every time a point was scored, the game was halted so the janitor could bring out a ladder and retrieve the ball. Later, the bottoms of the fruit baskets were removed. The first public basketball game was played in Springfield, MA, on March 11, 1892. That day, he asked his class to play a match in the Armory Street court: 9 versus 9, using a soccer ball and two peach baskets.

Cheers!

hɔuᴉnb

Additional reading:

Comments and questions are always welcome!

Meet the man who gave the world email attachments

Everyone loves a MIME. Happy anniversary to the world’s first email attachment.

iOS 7 Tips

April is upcoming and I am handing out Easter Apples Eggs! iOS7 has been out for some months now, so this post may seem overdue. In defense, I was initially an un-fan of the new OS. Over time it has shown itself to be ‘a good thing’. So now, having made my peace with it, I am highlighting some of the better and under-exposed features.

My favorite of iOS7 features. 

Spotlight Search
SpotlightSearch2
Swipe down from Home screen. Previously, you had to swipe all the way to the left most Home screen page. Now you can access Spotlight Search from any Home screen page. Use this to locate everything (i.e., apps, messages, contacts).
Control Center
Control Center
Swipe up from bottom of the screen to access Control Center. From here you have access to key features (camera, airplane mode, music) without having to navigate to the Settings app.This feature can also be disabled if it interferes with a particular app’s swipe gesture. To manage settings, open the Settings app and tap Control Center.Settings
Flick to stop running apps
Flick
Double press the Home button to display running apps, then Flick app up & away to terminate. This gesture is far more satisfying than the previous ‘click the x‘ method.Bonus: you can flick-close multiple apps at a time!
Camera Burst Mode
SwishBurst
From the Camera app, Press & Hold Capture button to take rapid fire shots. Release button to stop.
This makes it easier on us iShutterBugs to capture that three-pointer.
Gesture back*
Gesture Swipe

*also a release mechanism to cope with road-rage.
Give your Home button a rest. Gesture (five-fingered** swipe) left or right to get back to your previous apps.


**(four fingers, for Disney execs)

hɔuᴉnb

Comments and questions are always welcome!

Excel Indents

Excel Indents

Want to make your spreadsheet more legible? Indents, added where appropriate, will make your spreadsheet easier to mentally digest.
Sadly, it won’t make bad financial news easier to swallow.

Watch this 15 second video to learn the what you need to know.

Indent a cell

  1. Select the cell(s) to indent
  2. On the Home tab, in the Alignment Group, click the dialog launcher Dialog Launcher
    (or press CTRL + SHIFT + F to display the Font dialog and click the Alignment tab).
  3. In the Text alignment section, click the Horizontal drop-down and select Left (Indent).
  4. In the Indent field, type or select preferred indent increment (i.e., 1, 2).
  5. Click OK.

Cheers!

hɔuᴉnb

Additional reading:

Comments and questions are always welcome!

PowerPoint: Customize Bullets

Want to make an Oscar worthy, award-winning presentation? The difference between your presentation and all others is design and style. Don’t limit yourself to cookie-cutter, off the shelf bullets. Any saved image can be a source for better bullets.

Watch this 60 second video to learn all you need to know

  1. Select text to be formatted.
  2. On the Home tab, in the Paragraph group, click the Bullets drop-down and select Bullets and Numbering. The Bullets and Numbering dialog appears.
  3. Click Picture. The Picture Bullet dialog appears.
  4. Click Import. A file browser window opens.
  5. Navigate to saved image file (i.e. JPG, GIF) and select picture.
  6. Click Add. The image is added to the picture gallery.
  7. Click OK.

Cheers!

hɔuᴉnb

Comments and questions are always welcome!

Related:

Excel Sparklines

Be Trendy!

Sparklines

Sparklines are an easy way to add visual trend-lines to your tabular data.
And what better way to distract your audience than by dangling something sparkly in front of them!

Watch this 60 second video to learn the what you need to know.

Inserting Sparklines to your Excel data

  1. On the Insert tab, in the Sparklines group, click Sparkline type (e.g., Line). The Create Sparklines dialog appears.
  2. In the Data Range field enter the values to be charted.
  3. In the Location Range field enter cell range where char is to be displayed.
  4. Click OK.

Tip: With an inserted sparkline selected, the Sparklines Tools: Design tab appears on the Ribbon. Use the tools on this tab to change colors and add markers.

Cheers!

hɔuᴉnb

Additional reading:

Comments and questions are always welcome!