peltier tech utilities
Learn how to create Excel dashboards.

Categories

30 Excel Functions in 30 Days

Archives

Show More Characters in an Excel Cell

I saw this question in Twitter this week:

Anyone know a way to get an Excel cell to take over 255 characters w/o converting to pound signs ###? Wreaking havoc on something I'm trying

Here's an example – in the following screenshot, cells B2 and B3 contain the same long string of characters.

[...]

Use Excel to Plan Your Garden

It's almost April, and the snow tires are coming off my car today, so spring must be just around the corner. That means it's time to start planning the garden. We don't actually plant anything in southern Ontario until the May 24th weekend, but a bit of planning will make it easier to survive the [...]

YouTube University

Well, you might not get a degree when you complete your courses, but there's lots of educational material available through YouTube.

It's organized in a special section of the website:  www.youtube.com/edu

which features videos from YouTube's college and university partners.

You can search for a specific topic, or view a list of [...]

Excel Twitters 20090327

Moved to the Excel Twitters archive:

Excel Twitters 20090327

Split First and Last Names in Excel

If you have a list of names in Excel, with first and last names separated by a comma, you can use an Excel feature to split the first and last names into separate columns.

Select the List

To start, select the cells that contain the names.

On the Ribbon in Excel 2007, click the [...]

Convert Number to Words In Excel

Ron Coderre has updated his Convert Numbers to Words sample file, to fix some international issues that a user reported recently.

The file uses a VBA function to convert a number to words, with options to specify a major currency, such as dollars and a minor currency, such as cents.

  

The workbook has [...]

Show Excel Formulas Instead of Results

When you're troubleshooting an Excel worksheet, it may help to see the formulas temporarily, instead of the results. With the formulas visible, you can quickly check that the cell references are correct and the formulas are consistent.

Tip: The keyboard shortcut to show or hide the formulas is Ctrl + ' (accent grave, may [...]

Change Google RSS Folders

In the Google Reader, you can see a list of your RSS feeds, and group them into folders. Usually I assign a feed to a folder as soon as I subscribe to it. If I forget, then I can assign it later.

One way is to click the Manage Subscriptions link, at the bottom [...]

Excel Twitters 20090321

Moved to the Excel Twitters archive:

Excel Twitters 20090321

Change Signatures in Outlook

I've got a few different Signatures set up in Outlook 2007. Most of the time I use my business signature, but occasionally I'd like to use one of the others. Usually I use the Ribbon commands, but I've just discovered a mouse shortcut that makes it much easier. I'll be using the shortcut from now [...]

Related Posts Plugin for WordPress, Blogger...