Book

Suggestions


Enter your email address:

Delivered by FeedBurner


Home Page

Bloglines

1906
CelebrateStadium
2006


OfficeZealot

Scobleizer

TechRepublic

AskWoody

SpyJournal












Subscribe here
Add to 

My Yahoo!
This page is powered by Blogger. Isn't yours?

Host your Web site with PureHost!


eXTReMe Tracker
  Web http://www.klippert.com



  Monday, March 27, 2017 – Permalink –

Stacked Columns

On on another

Instructions how to put one column on top of another in a chart.



People.stfx.ca


See all Topics

Labels: , , , , ,


<Doug Klippert@ 3:15 AM

Comments: Post a Comment


  Sunday, March 19, 2017 – Permalink –

Dynamic Charts

Keep on changing

Instructions and examples of charts that change as the data changes.

Tushar-Mehta.com


See all Topics

Labels: , , , ,


<Doug Klippert@ 3:12 AM

Comments: Post a Comment


  Friday, March 17, 2017 – Permalink –

Speed up your Macro

Wha's a macro?

"The purpose of this column is simply to provide information to anyone interested in how to make their work life more efficient through the use of macros. When your average computer user finds out that macros are all about little bits of code, the fear in their hearts becomes palpable, all the way from here. And so today I want to ease those fears and invite those of you who've been curious about macros to take the plunge and finally learn about them."

Dummies.com


See all Topics

Labels: , , , ,


<Doug Klippert@ 3:33 AM

Comments: Post a Comment


  Monday, March 13, 2017 – Permalink –

Why Pie Charts

Why Pie?

"The popularity of pie charts is a bit of a mystery. The data visualization goals of a pie chart can easily and more effectively be shown with a bar chart or even a simple table. In the worst of cases, a whole pie chart is used to show a single number."

JuiceAnalytics.com


See all Topics

Labels: , , ,


<Doug Klippert@ 3:12 AM

Comments: Post a Comment


  Sunday, March 05, 2017 – Permalink –

Conditional Axes Labels

Custom

Here is how to change axis formatting based on values.




AndyPope.com


See all Topics

Labels: , , , ,


<Doug Klippert@ 3:49 AM

Comments: Post a Comment


  Monday, February 27, 2017 – Permalink –

Positive Negative Colors

Vary

Change the color when going from positive to negative.


AndyPope.info


See all Topics

Labels: , , , , , ,


<Doug Klippert@ 3:38 AM

Comments: Post a Comment


  Sunday, February 19, 2017 – Permalink –

Formatted Input Boxes

Use text boxes


"You can use a Data Validation Input Message to display a message when a cell is selected. However, the font can't be changed, nor can message box size be controlled.

To overcome these limitations, you can create a text box to display the message, and use programming to make it appear if cells that contain a data validation Input Message are selected."


Contextures.com


See all Topics

Labels: , , , ,


<Doug Klippert@ 3:24 AM

Comments: Post a Comment


  Wednesday, February 08, 2017 – Permalink –

Excel to PPT

And Access

This example shows how to place the VBA code in PowerPoint, retrieve data from Excel and or Access and display it in a PowerPoint table.

PPTFAQ.com


See all Topics

Labels: , , ,


<Doug Klippert@ 3:58 AM

Comments: Post a Comment


  Tuesday, January 31, 2017 – Permalink –

Code Copy

Excel to Word

You can select, copy, and paste to put Excel data into a Word document, but this piece of VBA automates to process.


VBAExpress.com


See all Topics

Labels: , , , ,


<Doug Klippert@ 3:27 AM

Comments: Post a Comment


  Tuesday, January 24, 2017 – Permalink –

Custom Functions

Write your own

Excel allows you to create your own functions. If =SUM() is not enough for you, look at this link:

Custom Functions - User Defined Functions


See all Topics

Labels: , , , , ,


<Doug Klippert@ 3:10 AM

Comments: Post a Comment


  Tuesday, January 10, 2017 – Permalink –

Mail a Range

Combine Excel and Outlook

"The subs will send a newly created workbook with just the visible cells in the selection or range.
The cells will be PasteSpecial as values in the workbook you send. 
It saves the workbook before mailing it with a date/time stamp. 
After the file is sent, the workbook will be deleted from your hard disk."
RondeBruin.nl


See all Topics

Labels: , , ,


<Doug Klippert@ 3:35 AM

Comments: Post a Comment


  Tuesday, January 03, 2017 – Permalink –

Spreadsheets in Education

Samples and papers


"SIE is an electronic journal devoted to the publication of quality refereed articles concerned with studies of the role that spreadsheets can play in education. Our aim is to provide a focus for advances in our understanding of the role that spreadsheets can play in constructivist educational contexts.
Spreadsheets in Education (eJSiE) is a free facility for authors to publish suitable, peer reviewed articles and for anyone to view and download articles."

eSIE


See all Topics

Labels: , , , ,


<Doug Klippert@ 3:24 AM

Comments: Post a Comment


  Tuesday, December 27, 2016 – Permalink –

Excel to Outlook

Concatenate Excel Outlook

A common task is to bring a contact list into Outlook from Excel. Usually Excel will have names separated into columns. Other information, such as addresses may also be divided.
Here’s how to format the Excel file for a seamless import.

Howto-Outlook.com


See all Topics

Labels: , , ,


<Doug Klippert@ 3:54 AM

Comments: Post a Comment


  Saturday, December 24, 2016 – Permalink –

Windows Split

Easy trick

Here's how to split the open window and/or create new windows.

SaraFord


See all Topics

Labels: , , , , ,


<Doug Klippert@ 3:38 AM

Comments: Post a Comment


  Monday, December 12, 2016 – Permalink –

Dates with Bill G

What it was like

February and March are incorrect in Excel.
Joel Spolsky talks about dates with Bill G.

Bill G


See all Topics

Labels: ,


<Doug Klippert@ 3:11 AM

Comments: Post a Comment


  Sunday, December 04, 2016 – Permalink –

Timelines

Process and sample

The need to create a graphic view of a timeline can occur often.



Here are the instructions:
Vertex42.com


See all Topics

Labels: , , ,


<Doug Klippert@ 3:03 AM

Comments: Post a Comment


  Sunday, November 27, 2016 – Permalink –

Spreadsheets for Schools

Classroom samples

"The purpose of LT Technologies, Inc. is to link technology with teaching in order to maximize student achievement in the classroom."
Spreadsheets


See all Topics

Labels: ,


<Doug Klippert@ 3:31 AM

Comments: Post a Comment


  Saturday, November 19, 2016 – Permalink –

Sparklines 2013

Hail Tufte

New for Excel 2010-13




See all Topics

Labels: , , , , , ,


<Doug Klippert@ 8:22 AM

Comments: Post a Comment


  Thursday, November 17, 2016 – Permalink –

Auto Backup

Beep, beep


Automatically creates backups on every save.


AutoHistory: Every time you save your document (and something has changed), a backup (of the history) is created.

AutoHistory


See all Topics

Labels: , , ,


<Doug Klippert@ 3:47 AM

Comments: Post a Comment


  Saturday, November 12, 2016 – Permalink –

Short Menu Change

In context

Right clicking an object can display a shortcut menu.
Here are some instructions about how to write a macro that will edit that menu.

Right Click


See all Topics

Labels: , , , , , , ,


<Doug Klippert@ 3:55 AM

Comments: Post a Comment


  Friday, November 04, 2016 – Permalink –

Conditional Formatting II

If, then

Jon Peltier offers a number of ways to format conditional charts.
PeltierTech.com


See all Topics

Labels: , , , , , ,


<Doug Klippert@ 3:21 AM

Comments: Post a Comment


  Saturday, October 29, 2016 – Permalink –

Mail Excel

VBA + sample

Excel Guru Ron de Bruin has put together the VBA code needed to send Excel via email.
He has also included the sample workbooks for those that are not VBA literate.

Also:
". . . a new add-in named RDBMail for Excel/Outlook 2007-2016
RDBMail

The add-in create a new tab on the Ribbon named RDBMail with a lot of mail options.
You have the option to send as workbook or PDF for every mail option."
Code to send mail from Excel


See all Topics

Labels: , , , ,


<Doug Klippert@ 3:16 AM

Comments: Post a Comment


  Thursday, October 27, 2016 – Permalink –

Video Tutorials Too

What you see

"MIStupid.com is The Online Knowledge Magazine that publishes information that everyone should know, wants to know, or forgot.
MIStupid.com was created in 2001 by Greg Renza with the desire to eradicate the world's stupidity."
A few of the lessons include:
  • Concatenating Cells
  • Conditional Formatting
  • Subtotals
  • Data Sorting
  • Formulas and Named Cells
  • Create Graphs and Charts
MIStupid.com


See all Topics

Labels: , , ,


<Doug Klippert@ 3:01 AM

Comments: Post a Comment


  Wednesday, October 19, 2016 – Permalink –

Selection Address

What's the count

". . . know what range is selected at any given time. You can look at the Name Box, but that only show the active cell."

Display number of Rows and Columns


See all Topics

Labels: , , ,


<Doug Klippert@ 3:28 AM

Comments: Post a Comment


  Monday, October 17, 2016 – Permalink –

Custom QAT

Access additions


Applications put most of the most-used commands on the Home tab's Ribbon, not everything is there. You may want to add Close, Close All, or Print commands, for example.

In the upper Left corner is the Quick Access Tool bar.

To update the QAT:
Click the down-pointing arrow to the right of the QAT.
Choose any common commands (New, Close, Print, etc.) by checking the option.


See all Topics

Labels: , , , , , ,


<Doug Klippert@ 3:04 AM

Comments: Post a Comment


  Thursday, October 06, 2016 – Permalink –

Command Reference

2003-2007-2010-2016

Those of you that are just now making the switch to the Ribbon world, will find this valuable.

ComputerWorld.com


See all Topics

Labels: , , , ,


<Doug Klippert@ 3:01 AM

Comments: Post a Comment


  Tuesday, October 04, 2016 – Permalink –

Tips for Office

Suggestions

TechRepublic lists a number of areas that you might explore when training is needed for a new Office version.

Here are a few:
  • LINKS TO TIP SHEETS AND ARTICLES
    "Instead of telling your users to go out to Microsoft.com and do a search, put hyperlinks to the printer-friendly version of tip sheets and articles on your company's main portal page. Providing links to information you know they need will help you cover the training bases. And presenting the links on an internal web site they already use will show your users that it's okay to go outside of their four firewalls to learn something new. Include your favorite hyperlink in your signature line so it goes out in every e-mail you send."
  • ONLINE TRAINING
  • E-LEARNING
  • WEBCASTS
  • VIRTUAL TRAINING
  • MULTILINGUAL SCREENTIPS AND TRANSLATIONS
  • COMMAND REFERENCE GUIDES
  • OFFICE ONLINE AT WORK
10 ways to train your users on Office for free


See all Topics

Labels: , , ,


<Doug Klippert@ 3:25 AM

Comments: Post a Comment


  Thursday, September 29, 2016 – Permalink –

Color Scales

Conditional colors

Here is some information on Conditional color scales in Office 2010.

Excel-Easy


See all Topics

Labels: , , , , , ,


<Doug Klippert@ 3:29 AM

Comments: Post a Comment


  Wednesday, September 28, 2016 – Permalink –

Where's the Template?

Find and/change storage spots



Describes the different template categories and the locations of templates in 2007 & 2010 Office programs. Also describes the registry settings that control where to find your custom templates.

Support.Microsoft.com


See all Topics

Labels: ,


<Doug Klippert@ 3:42 AM

Comments: Post a Comment


  Thursday, September 22, 2016 – Permalink –

Help IDs

VBA code

When you build a macro, you can call up information from the Excel Help file.
Ron DeBruin has the information needed through 2007-2013.

Right clicking the Helpfile and choosing Properties will show the HP####### number in 2010+.

Help Context IDs for Excel


See all Topics

Labels: , , , ,


<Doug Klippert@ 3:50 AM

Comments: Post a Comment


  Thursday, September 15, 2016 – Permalink –

Text Files to Excel

A hard way to do an easy job

Text files can be imported or just pasted into Excel. If you want to learn more about SQL statements and non-code coding, look at this blog:
"Excel doesn't have an easy way to append multiple text files into one worksheet through the user interface. From time to time I hear customers asking how to do this in an easy way. Do you have to use Access or VB code to solve this problem? No. There's a way to do it in Excel by using a simple SQL statement in the connection string."
Use a text file:

Blogs Office.com


See all Topics

Labels: , , , ,


<Doug Klippert@ 3:39 AM

Comments: Post a Comment