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


  Wednesday, January 27, 2010 – Permalink –

Color Scales

Conditional colors

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

Microsoft Excel 2010 Blog 1

Microsoft Excel 2010 Blog 2

Microsoft Excel 2010 Blog 3



See all Topics

Labels: , , ,


<Doug Klippert@ 3:42 AM

Comments: Post a Comment

  Tuesday, January 26, 2010 – Permalink –

Where's the Template

Find and/change storage spots



Describes the different template categories and the locations of templates in 2007 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:48 AM

Comments: Post a Comment

  Wednesday, January 20, 2010 – Permalink –

Help ID's

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.

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:00 AM

Comments: Post a Comment

  Wednesday, January 13, 2010 – 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."


MSDN Excel Blog





See all Topics

Labels: , ,


<Doug Klippert@ 3:53 AM

Comments: Post a Comment

  Sunday, January 03, 2010 – Permalink –

Keyboard and Key Tips

Finger it out



2007 apps look different because of the ribbon, but the keyboard can still be used to speed up tasks.
Microsoft has an online course that may help

After completing this course you will be able to:
Accomplish tasks by using sequential shortcut keys, known as Key Tips, shown on the Ribbon.
Navigate around the Ribbon using the TAB key and arrow keys.
Accomplish tasks by using key combinations — keys you press at the same time - exactly as you've done in previous versions of Office.
Office.Microsoft.com/Training




See all Topics

Labels: ,


<Doug Klippert@ 3:54 AM

Comments: Post a Comment

  Saturday, January 02, 2010 – Permalink –

New Calendars

Another year

Here are free Excel calendars for downloading.

Twelve months on one sheet or one month per tab.



DotXLS.com





See all Topics

Labels: ,


<Doug Klippert@ 3:24 AM

Comments: Post a Comment