Wednesday, August 16, 2017

Link to Word

Excel to Word connection


The Insert Hyperlink dialog will allow you to link to any file.

To link to a particular bookmark in a Word document, you can specify the bookmark by adding it yourself, adding a # (pound sign) plus the bookmark name to the path and file name.

C:\My Documents\MyDocument.doc#MyBookmark

To link to a page in a Word document, add a pound sign and the page number after the document path and file name:

C:\My Documents\MyDocument.doc#4

See Jon Peltier's hyperlink collection:
Hyperlinks



See all Topics

Tuesday, August 15, 2017

DNS Cache

Down the drain


Internet connection problems can, sometimes, be traced to a corrupted DNS cache.

Flushing this cache is an easy fix to many of these problems.

Here is how to fix that corrupted DNS cache.


  1. Click the Microsoft Start logo in the bottom left corner of the screen

  2. Click All Programs

  3. Click Accessories

  4. Right-click on Command Prompt

  5. Select Run As Administrator

  6. To view the DNS cache, type ipconfig /displaydns at a command prompt.

  7. In the command window type the following and then hit enter: ipconfig /flushdns

  8. You will see the following confirmation:

    Windows IP Configuration
    Successfully flushed the DNS Resolver Cache
    .




See all Topics

Monday, August 14, 2017

Presentation Review

Suggestions included


... (the) CEO of Whole Foods Market, John Mackey, gave a presentation called "Past, Present, and Future of Food" for an audience of 2000 in Berkeley, California.

... (he) was there to make a presentation and have a conversation that would . . . (show) a skeptical Berkeley audience that his large company still has the credibility to lead the food movement into the future.

. . .(the) 45-minute talk "aided" by 67 text-filled slides followed by an on-stage conversation

. . . Most people felt that the evening generally was successful given Mackey's sincerity, honesty, and general likability, but John Mackey's "multimedia presentation" as it was billed, could have been so much more.
----------------------------------------------------------------------------------------------------------------
. . . (the) presentation in Berkeley is a wonderful example of a presentation by an intelligent, personable, and passionate leader that easily could have been insanely great but was not. "[He] raced through the slides like a Ph.D. student presenting his dissertation," said the UC Berkeley reporter in the audience.

. . . it's a shame the presentation itself was not better planned and delivered given the importance of the topic and the profile of the speaker. Frankly, when you're trying to change the world, there is no excuse for being dull.
  • It's a story. This topic screams "Story" yet there was no story that I could follow.
    There were bits and pieces (some of it interesting) and way too much history and data-without-purpose.

  • Make it shorter. Cut the presentation part of the evening to 20-25 minutes and spend more time discussing on stage with the host, taking questions from the audience, etc.

  • Make it visual. There are no boring topics, but this topic is especially interesting and provocative.
Signal vs. Noise



See all Topics

Sunday, August 13, 2017

Unkept Secrets

From Microsoft

"After supporting Microsoft Excel for years, technical Support Professionals have found that some of the most powerful and useful features and functions in Microsoft Excel remain undiscovered by you, our users.

For example, you may create a new macro to perform a calculation when an existing formula or function can perform the task. Or, you may create a new macro to perform a task when you could use an existing feature that performs the task."

Undiscovered Tips About Microsoft Excel for Windows
Here are just a few:
  • Secret #1: Joining Text Together

  • Secret #3: Excluding Duplicate Items in a List

  • Secret #7: Using a Data Form

  • Secret #11: Linking a Text Box to Data in a Cell

  • Secret #12: Linking a Picture to a Cell Range

  • Secret #17: Using OFFSET to Manipulate Data in Cells that are Inserted

  • Secret #21: Using INDEX and MATCH to Look up Data

  • Secret #25: Returning Every Nth Number

  • Secret #29: Using One Keystroke to Create a new Chart or Worksheet

  • Secret #30: Setting up Multiple Print Areas on the Same Worksheet




See all Topics

Saturday, August 12, 2017

Ripple the Ribbon

Change the look


"Learn how you can create a custom Office Fluent Ribbon for an Access 2007-13 database by using only Office Fluent extensibility markup XML and macros.

Discover how to create a command space without writing any code and also learn about more advanced scenarios that require code."

Customizing the Office Fluent User Interface



Customize the Ribbon



See all Topics

Friday, August 11, 2017

Attachment Default Save

Set the solution



Here's how to set the default location that Outlook will use to save attachments:

  1. Click Start, and then click Run.

  2. In the Open box, type regedit, and then press ENTER.

  3. In Registry Editor, locate the following subkey in the registry:

    HKEY_CURRENT USER\Software\Microsoft\Office\11.0\Outlook\Options 

  4. On the Edit menu, point to New, and then click String Value.
  5. Type DefaultPath, and then press ENTER.

  6. Double-click the DefaultPath value.
    In the Edit String dialog box, in the Value data box, type the path, including the drive letter, to the folder that you want to use for your Outlook saved items, and then click OK.

  7. Exit Registry Editor.
Office.Microsoft.com



See all Topics

Thursday, August 10, 2017

New Excel Web Grabber

Web Toy


"The Excel 2007 Web Data Add-In makes it easy to use a Web page as a data source in Excel. The add-in plugs into Excel 2007 seamlessly, its entry point located on the Data Tab under the From Web option.

The system extracts data by learning from a user's selection of data they wish to capture into Excel. The more selections, the more the system is trained.
An example scenario: You wish to import and track data from MSN's weather page. Visit the site using the tool, enter Data Capture mode, and select a row or two of data from the table. Then click Select Similar, and the system will find similar data based on your previous selections.

You then can click Import and leverage Excel's rich data-editing capabilities, including the Refresh command, which will revisit the Web page and extract potentially new, updated data."

Web Data Add-In

(Webservices 2013)

From the Excel Blog team



See all Topics

Wednesday, August 09, 2017

Icon Tile Opacity

See through


To make the background of desktop icons transparent, go to:

Control Panel > System > Advanced

Click Settings in the Performance section.



On the Visual Effects tab, check "Use drop shadows for icon labels on the desktop".



See all Topics

Tuesday, August 08, 2017

Secret Slide Numbers

PPT does not forget


"PowerPoint numbers slides in several ways and it pays to know the difference.

When you create a new slide, it gets a unique SlideID, a unique number that's read-only… you can't change it manually or programmatically. Reordering the slides won't cause it to change. Once a slide is created, it keeps the same SlideID forever.

SlideIndex is the ordinal number of the slide in the presentation as it's currently arranged. Move a slide around in slide sorter and its SlideIndex changes to reflect its new position in the show."

Slide number, SlideID, SlideIndex and all that jazz

From Informit.com:
Sample Code to Print Slide Numbers for a Custom Show


"Microsoft PowerPoint has the ability to create custom slide shows, which are subsets of existing slides within your presentation. When you print a custom show, PowerPoint prints the page number defined for that slide. For example, if you print a custom show named My Show that consists of slides 2, 8, and 13 of your presentation, the numbers 2, 8, and 13 appear on the printed output.

This article provides a sample Microsoft Visual Basic for Applications macro that prints out a specified custom show and numbers the pages consecutively, beginning with the number 1."

Also:
Working with Slide Objects
and

Microsoft PowerPoint Objects



See all Topics

Monday, August 07, 2017

Themes and Templates

Need a look?



Themes are a collection of design elements and color schemes that can be applied to your web site to give it a unified appearance.

Templates include themes and layout modules to aid in quickly creating a web site. Templates can be purchased through the web, but here is one of the locations that provide free design help.

FreeLayouts.Livejournal.com
"Want a great new look for your website? Free Layouts.com offers you just that - select from our huge database of complete "look and feel" designs. Professional, sports, technical and others - they are all here. Free Web Templates are available for you to download now.

Look around and download your favorite page layouts - for free. Also, submit templates of your own and increase traffic to your website greatly. Currently over 500 free HTML templates and 50 Flash templates for you to download!"




See all Topics

Sunday, August 06, 2017

Highlight the Current Control

Code vs. property


Many users have trouble knowing which text box on a form they're currently working with. One way to make it clear for users is to highlight the current one, for example, with a yellow background.
Access allows you to do this with conditional formatting, but you can also get a similar result using code.

To do so, create a new module and add the following code:

Function Highlight(Stat As String) As Integer
Dim ctrl As Control
On Error Resume Next
Set ctrl = Screen.ActiveControl
If Stat = "GotFocus" Then
ctrl.BackColor = 65535
ElseIf Stat = "LostFocus" Then
ctrl.BackColor = 16777215
End If
End Function

Save and close the module, then open the form you want to apply the highlighting to in Design view.
Click the Code button and insert

Highlight("GotFocus")

in each text box control's GotFocus event procedure. Likewise, add

Highlight("LostFocus")

to each text box's LostFocus event procedure.
When you've finished,save the changes, close the VBE, and switch to Form view.

When you tab to a field, it's shaded yellow. When you tab away from the field, its background is restored to white.



See all Topics

Saturday, August 05, 2017

Wage is Too Minimum

Low pay by state


Since 1997, the federal minimum wage has been stuck at $5.15. The new Congress plans to introduce legislation raising the minimum wage to $7.25-an increase that is long overdue.

This minimum wage increase would boost earnings for 13 million American workers-9.8 percent of the United States workforce.

Six million families with children-46 percent of the total low wage-earning families with children-currently receive all of their earnings from minimum wage jobs.

Raising the minimum wage will increase annual earnings to $15,000 from $10,700.

Without this increase, a family of three supported by one minimum wage earner will live roughly $5,400 below the federal poverty line.

At the 350 largest public companies, the average CEO total direct compensation was $11.6 million in 2005. At this rate of compensation, it takes the average CEO only one hour and 55 minutes to earn the annual pay of a minimum wage worker.

Here is an interactive map that will show how your state relates to the others.

Minimum wage map



See all Topics

Friday, August 04, 2017

Calendars - Perpetual

It's that year again


One Month and One Year perpetual calendars are available.

These Excel file calendars do not use macros and can be used in OpenOffice or other Excel compatible software.

  • Perpetual calendars with Week starting on Sunday

  • Perpetual calendars with Week starting on Monday

  • A simple "universal" one month calendar that will update for any month and any year (after 1900) just by changing a date cell.

  • A "universal" one year calendar that will show 12 months starting with a user defined Month and Year.
Start dates can be at the beginning of any year and any month.

DotXLS.com: Perpetual calendars
 
Microsoft: How to make calendars



See all Topics

Thursday, August 03, 2017

Custom Forms

Template collection



"At one time, Microsoft had a pretty nice collection of custom Outlook forms anyone could download. While a number of the forms are no longer available from Microsoft, a sizable collection remains. You can use these as-is or as a basis for your own custom forms."

See Slipstick.com - Sample Forms for the forms that are available.
  • Calendar Corporate Calendar
  • Expense Report
  • Help Desk
  • Holiday Card List
  • Job Candidates
  • Purchase Order Request
  • Real Estate Listings
  • Software Inventory Form
  • Student Attendance
  • Technical Repair Request
  • Time Card
  • Travel Request
  • Vacation Request
  • Web Site Listing
While they were all designed for Outlook in the Outlook 97/98 time frame, every one I've tried works with all versions of Outlook. However, the self-installers may not work due to security settings and you'll need to publish the form yourself. If you need step-by-step help to publish a form, see:
Outlook.net - Publish Form

OutlookCode.com - Send Form  

OutlookCode.com - Microsoft Outlook Custom Forms



See all Topics

Tuesday, August 01, 2017

Equations = Word 2007, 2010, 2013 and 2016

Real text


Remember, back in the old days of pre-2007-10 Word. Equations were a pain. Messy to set up with the Equation Editor and difficult to edit and reformat.


Brace {yourself} there have been changes.



  • Equations are regular Word text (not objects), so they're integrated with regular Word formatting.

  • High-quality display and typography: we're using TeX standards and a brand-new Math Font to produce great-looking equations

  • Two input methods: UI and Linear Format (keyboard syntax)

  • MathML support: now you can write an equation in Word, paste it into a calculating or graphing application, and get results!

Equation Demo
 
Equations in Word 2007, 2010, 2013 and 2016



See all Topics

Classroom Ideas

Ideas and tutorials



If you're looking for student projects and tutorials involving PowerPoint and more, look here:

PowerPoint - Creating Classroom Presentations

More information is located at:
EducationWorld.com

  • a search engine for educational Web sites only, a place where educators can find information without searching the entire Internet;
  • original content, including lesson plans, practical information for educators, information on how to integrate technology in the classroom, and articles written by education experts;
  • site reviews;
  • daily features and columns;
  • teacher and principal profiles;
  • Wire Side Chats with the important names in education;
  • employment listings.




See all Topics