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.
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
On the Developer tab, in the Controls group, click Insert Check box (Form Control).
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.
Right + Click on the Check box control and select Edit Text. An insertion point appears.
Delete the Check box label text (e.g. Check Box 1).
Click & Drag rightmost selection handle to reduce the size of the Check box control.
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.
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.
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?
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!
Insert Page x of y Numbering in a Multiple Section Document.
On the Insert tab, click Footer and select Edit Footer. The cursor will move to the footer of the current section.
Position your cursor where you want to place the page number.
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.*
Type ‘ of ‘ (no quotes) after the page number.
On the Header & Footer Tools: Design tab, in the Insert group, click Quick Parts, and select Field.
Select Numbering in theCategoriesdrop-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.
Try this: Suppress the number on your first (title) slide, and renumber the second slide Slide 1. This 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.
On the Insert tab, in the Text group, click Slide Number. The Header and Footer dialog appears.
Check Slide number and Don’t show on title slide check boxes.
Click Apply to all.
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)
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.
At this month’s Build Conference, Microsoft 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).