Unofficial Excel Stuff

Book

Suggestions

Home Page

Bloglines

1906
CelebrateStadium
2006

OfficeZealot

Scobleizer

TechRepublic

AskWoody

SpyJournal

Wednesday, September 29, 2010 – Permalink –

Statistical Functions

Definitions and list

Excel contains a slew of functions relating to statistical analysis.

That's a slew not a skew.

SKEW(number1,number2,...)

Returns the skewness of a distribution. Skewness characterizes the degree of asymmetry of a distribution around its mean.

Positive skewness indicates a distribution with an asymmetric tail extending toward more positive values.

Negative skewness indicates a distribution with an asymmetric tail extending toward more negative values.

Statistical Functions

Training - Statistical
See all Topics excel
Labels: Functions, Tutorials

<Doug Klippert@ 3:15 AM

Comments: Post a Comment

Thursday, September 23, 2010 – Permalink –

Font Properties Plus

Everything you need to know

To embed a font in a document or slide show so it can be displayed on any other machine, the font must support that action. The standard Windows properties statement does not show all the needed information.

The bottom of this illustration shows the standard information shown when you right-click a font file, and choose properties. The two views at the top are what appear when the Microsoft Font properties extension is installed.

If you right click on a font file in Windows its basic properties are displayed. The Font properties extension adds several new property tabs to this properties dialog box. These include information relating to font origination and copyright, the type sizes to which hinting and smoothing are applied, and the code pages supported by extended character sets.

It also will tell you if the font can be embeddedand/or edited in a document.

Protected

The font may not be embedded, copied, or modified. If you use a protected font in a document and if the document is opened on a computer that does not have the font installed on it, a font substitution occurs. Word substitutes the closest font available on the computer for the missing protected font.

Print/Preview

The font is embedded and temporarily loaded on the target computer. Documents that contain print/preview fonts must be opened read-only, and no edits are stored in the document. Embedding a font of this nature has the least impact on file size increase.

Editable

The font behaves just like the print/preview fonts, except that you may also apply the font to other text in the same document.

Installable

The font is installed on the target computer permanently when you open the document. This allows you to use the new fonts as if you installed the fonts directly into Windows yourself. This type of embedded font has the greatest impact on file size because the entire font or fonts are included with the document.

Versionand Features tabs

The Version tab includes version and date information. The Features tab describes the font in terms of number of glyphs, number of kerning pairs, the possible existence of a euro symbol and the presence of embedded bitmaps within the font.

Linkstab

If a font doesn't include a Web site URL, but does include a 'vendor ID code' a link will be provided to Microsoft's font vendor database.

The latest version is 2.3 as of December, 2006.
Font properties extension, version 2.3
(32-bit only)

See all Topics excel
Labels: Fonts, General, Reference

<Doug Klippert@ 3:44 AM

Comments: Post a Comment

Wednesday, September 22, 2010 – Permalink –

Result is a Picture

If 4, show kumquat

Allen Wyatt has a cool procedure that will let you show a picture of an object on your spreadsheet depending on a value.

Maybe a snow suit when it's 29 or, say, a pair of bloomers when the computed temperature is 70.

The procedure does not use any VBA, just equations and bright thinking.

ExcelTips.VitalNews.com:

Display Images based on a Result

See all Topics excel
Labels: Formats, Graphics, Tips, Tutorials

<Doug Klippert@ 3:56 AM

Comments: Post a Comment

Tuesday, September 14, 2010 – Permalink –

Worksheet Names

Formula construction

There may come a time when you need to display the name of a worksheet.

This formula will do the job:

=MID(CELL("filename",$A$1),FIND("]",CELL("filename",$A$1))+1,31)

=CELL("filename",$A$1)
returns the path, the Workbook name and the Worksheet name. (C:\Documents\[April.xls]\Costs)

=MID(text,start_num,num_chars)
selects the text that starts at a certain point and goes on for a certain number of characters.

The formula, as written, looks at the full path and selects the first time a closing bracket (]) is found.

It then moves 1 character to the right and displays the results up to 31 characters.
(A worksheet name cannot be more that 31 characters long.

You could include a reference to that cell on other worksheets.

See all Topics excel
Labels: Formulas, General, Tips

<Doug Klippert@ 3:34 AM

Comments: Post a Comment

Monday, September 06, 2010 – Permalink –

Custom Lists

Your Way

At times, you will want to enter the same information repeatedly in a spreadsheet.
It could be employee names, products or State names.

Here is a way to produce the information when needed.

Make a list of the items.
Enter the data in, say, A1, B1, C1 etc.
Be sure to enter in the right order; maybe Supervisor and then team members in alphabetic order.

Select all of the cells.
Go to Tools>Options and choose the Custom lists tab.
Click Import.
OK your way out.

Now you can delete the entries on the spreadsheet.

Choose any cell and type one of the items that are on your Custom List.
Click and drag on the fill handle; the tiny square at the bottom right corner of the selected cell.
As you pull, Excel will duplicate your list.

(In Excel 2007+, go to the Office Logo. Choose Excel Options. Edit Custom Lists will be on the Popular page.)

Also see:

The First Shall Be Last
by Dick Kusleika

Sorting by Color
by Chip Pearson

See all Topics excel
Labels: Customize, General, Reference, Tips

<Doug Klippert@ 3:29 AM

Comments: Post a Comment