Peltier Technical Services, Inc.
 

Excel Chart Add-Ins | Training | Custom Solutions | Charts and Tutorials | Peltier Tech Blog


Peltier Tech
Chart Add-Ins

Peltier Tech Waterfall Chart Utility
Peltier Tech Cluster-Stack Chart Utility
Peltier Tech Box and Whisker Chart Utility
Peltier Tech Marimekko Chart Utility
Peltier Tech Dot Plot Utility
Peltier Tech Cascade Chart Utility

 

Excel Dashboards

 

Books at Amazon.com

 

Excel Tips and Tricks

Here are a few miscellaneous tricks and techniques I've learned.

Property Procedures - Passing Information to and from Forms

This page give a simple example showing how property procedures can be used to pass information to and from a userform.


List and Print Excel Files (Zipped Excel File)

This workbook contains the code to:

  • Open a form with buttons and a list box for filenames,
  • Use Browse4Folder to let the user select a directory,
  • Allow the user to select one or more files from this directory, and
  • Print the selected files.

Convert Fahrenheit to Celcius (Zipped Excel File)

I got tired of manually entering a formula into a workbook, typing in a number, and pressing enter when I needed to convert those heathen Celsius numbers into my beloved Fahrenheit, and vice versa (I'm in the American metalworking industry, okay??). I designed this form to accept a number, then when it saw a letter corresponding to F or C, convert it into its equivalent.

This workbook contains the code to:

  • Open a form with a text box for numeric data entry,
  • Recognize when "F" or "C" is entered after a number, and
  • Convert the value preceding the letter into its corresponding value in the other system.

ASCII Table (Zipped Excel File)

This workbook contains a sheet of all ascii character codes from Alt-0033 (!) to Alt-0255 (ÿ) in four fonts of your choosing. Don't see a character you like? Click on the floating menu and select up to four new fonts.

 

 

Page copy protected against web site content infringement by Copyscape

 

Peltier Tech Waterfall Chart Utility Peltier Tech Cluster-Stack Chart Utility Peltier Tech Box and Whisker Chart Utility Peltier Tech Marimekko Chart Utility Peltier Tech Dot Plot Utility Peltier Tech Cascade Chart Utility

 

Create Excel dashboards quickly with Plug-N-Play reports.


Peltier Technical Services, Inc.

Excel Chart Add-Ins | Training | Custom Solutions | Charts and Tutorials | PTS Blog

Peltier Technical Services, Inc., Copyright © 2010. All rights reserved.
You may link to this article or portions of it on your site, but copying is prohibited without permission of Peltier Technical Services.

Microsoft Most Valuable Professional

Microsoft Most Valuable Professional

My MVP Profile