Adding Check Boxes

1 of 4: Adding Check Boxes

In these four post we will will create an interactive report using Check boxes and DSUM (and without the using macros). In this first of four, we start with adding Check Boxes.

Since Excel 2007, the use of macros in spreadsheets have added an additional element of complexity. Macros must now be stored in XLSM format, which raises a red flag in excel as a potential threat. In this series of posts, we eschew VBA and ActiveX automation, in exchange for ‘old fashioned’ excel programming, using form controls and statistical functions.

Check Box

Adding Check boxes to your spreadsheet can make it easier for you and your reviewers to edit spreadsheet data. The Check box tool is found on the Developer Tab. To add the Developer tab, click File, Options, Customize Ribbon, and check Developer.

To Add a Check box

  1. On the Developer tab, in the Controls group, click Insert Check box (Form Control).
  2. Using the mouse, Click & Drag to draw a Check box control. A Check box control is placed, consisting of the Check box and the label text.
    Tip: Hold down the ALT key as you Click & Drag to draw an object equal in size to the selected cell.
  3. Right + Click on the Check box control and select Edit Text. An insertion point appears.
  4. Delete the Check box label text (e.g. Check Box 1).
  5. Click & Drag rightmost selection handle to reduce the size of the Check box control.
  6. Enter your text into the cell that contains the Check box.
    Tip: To indent the text, on the Home ribbon, click the Alignment dialog launcher and increase the cell Indent to 2.

 

alignmentNext: Linking the Check Box to a Cell!

Cheers!

hɔuᴉnb

Additional reading:

Comments and questions are always welcome!

Withings made a smartwatch you might actually want to wear

The Activité, by Withings, is a fashionable analog device (designed in France, and built in Switzerland), that leverages a retro design, while offering the activity and gps-enabled features of wearble-tech gadgets. And it looks smart, without looking like a smartwatch.

Watch the global hacking war in real time with a weirdly hypnotic map

If you thought Wargames was cool (back in the day) you’ll love this interactive map of Cyberattacks. Click the graphic to view iteractive imaging. Though engaging to watch, I can’t vouch for the credibility; Just why is Iceland attacking St Louis, anyhow?

Numbering Section Pages

Want to show page count in a multi-section document?

On the distant heels of my renumbering slides post, here are instructions to create Page x of y style numbering in a multiple section document. In a simpler document (one without section breaks), you could easily create the ‘Page 3 of 7’ type numbering using the NumPages field.  NumPages, however, counts total number of pages in the document and not in each section.

‘SectionPages,’ to the rescue!

sectionPages
click to enlarge

 

Insert Page x of y Numbering in a Multiple Section Document.

  1. On the Insert tab, click Footer and select Edit Footer. The cursor will move to the footer of the current section.
  2. Position your cursor where you want to place the page number.
  3. On the Header & Footer Tools: Design tab, in the Header & Footer group, click Page Number, Current Position, and select Plain Number. The page number field is inserted, reflecting the current page number.*
  4. Type ‘ of ‘ (no quotes) after the page number.
  5. On the Header & Footer Tools: Design tab, in the Insert group, click Quick Parts, and select Field.
  6. Select Numbering in the Categories drop-down and SectionPages from the Field names area, then click OK. The SectionPages field is added to the footer using the default numeric format.

*Restart numbering , if necessary: Click Page Number, select Format Page Number, and change Page Numbering to Start at: 1.

 

Related

Cheers!

hɔuᴉnb

Comments and questions are always welcome!

 

Suppress Number on Title Slide & Renumber slides.

Try this:  Suppress the number on your first (title) slide,  and renumber the second slide Slide 1This makes referring to talking points easier since it is unlikely there is anything you will refer to on the title slide.
Follow these steps or view this 30 second video.

  1. On the Insert tab, in the Text group, click Slide Number. The Header and Footer dialog appears.
  2. Check Slide number and  Don’t show on title slide check boxes.
  3. Click Apply to all.
  4. On the Design tab, in Customize group, click Slide Size and choose Custom Slide Size. The Slide Size dialog appears.
    (PowerPoint 2003/07 users: Click Page Setup to display the Page Setup dialog)
  5. In the Number slides from field type ‘0’ (zero).
  6. Click OK.

 

 Cheers!

hɔuᴉnb

Comments and questions are always welcome!

Related:

Phone Smack-down: Cortana vs. Siri & Google

Wondering how the different mobile virtual assistants fare?

Dan Rubino, of Windows Phone Central, put together a tête-à-tête-à-tête  comparison, pitting newcomer Cortana (Windows phone 8.1) against veterans Siri (Apple) and  Google Now (Android).  Although presented fairly objectively, consider the source when reviewing, and judge for yourself.

If you want to skip the 7 minute video, here’s the the blow-by-blow. In many cases each assistant handled its task slightly differently. For more details view the video, or follow this link to wpcentral.com’s article.

 

Siriapple

Cortanawin8logo

Googlephone_android

Settings
“Turn off WiFi.”
blue checkmark blue checkmark blue checkmark
Social media
“Four Square, check-in.”
blue checkmark blue checkmark
Connect
“Call _____ using Skype?”
 blue checkmark  blue checkmark
Events
“When’s the next Miami Heat game?”
blue checkmark blue checkmark blue checkmark
Flights
“Flight status, AA125.”
blue checkmark blue checkmark blue checkmark
Appointments
“What’s my schedule?”
blue checkmark blue checkmark
Web Browser
“Go to CNN.com.”
blue checkmark blue checkmark blue checkmark
Notes
“Note: I need to repark the car.”
blue checkmark(w/Notepad) blue checkmark(w/One Note) blue checkmark(w/email)
Navigation
“Where’s the nearest Dunkin Donuts?”
blue checkmark blue checkmark blue checkmark
Weather
“Whats the weather like Tuesday?”
blue checkmark blue checkmark blue checkmark

Cheers!

hɔuᴉnb

 Windows Phones 8.1

Windows Phone 8.1

At this month’s Build ConferenceMicrosoft debuted their newest mobile operating system,Windows Phone 8.1. This OS will appear on select new phones, with an update for existing phones targeted for later this year.

Here are some highlights:

  • Swype Keyboard Input. Something android users have long enjoyed, this slip-slidemethod of typing and pattern recognition will speed up your mobile typing.
  • Action Center. Pull-down access to key settings (e.g., WiFi, Bluetooth). The Center can be customized, allowing you to select what features you want to access more easily.
  • Cortana, voice recognition IA (named after the character in Microsoft’s HALO game). Speak your request and Cortana responds. Cortana (whose search is, not surprisingly, powered by BING) has both a sense of humor (ask her if she knows Siri) and a decent singing voice.
  • Additional Improvements have been made to the Windows Phone Camera (now featuring a Burst Capture) and Kids Corner (now simplified, so you can easily hand junior your phone for games without worry that your data will be deleted).

To read the full review visit Pocket-lint

 

Cheers!

hɔuᴉnb