Background - Spreadsheet Risk Management In the Managing Spreadsheet Risk series so far we have looked at the concept of spreadsheet risk and how to manage it both at a company level and at a...

continue reading...

Conocer la dirección que toman nuestros ingresos y gastos a lo largo de año es importante para obtener previsiones sobre  nuestra economía familiar. Esto se puede determinar mediante la...

sigue leyendo...

I’m back for 2012! I’m ending the radio silence today. I almost forgot my WordPress password. . What have I been doing? I’ve been doing some year-end stuff at work, and finishing up...

continue reading...

This morning one of my add-ins kept giving me Run-time error ’438′; Object doesn’t support his property or method. I would click OK, and the error would immediately pop up again....

continue reading...

Do you get an error when you try to insert just one more chart in your workbook? It could be because of an obscure resource-related problem in Excel, or it could just be that you are running out of resources. This tip explains how to track down what the problem may be.

Read this ExcelTip: Running Out of Memory
Microsoft Excel Tips - Learn Excel Faster!

Following up on my previous posts sharing my initial Excel mashups (http://www.dailydoseofexcel.com/archives/2012/01/29/excel-mashup-2/ and...

continue reading...

Need to change the color of different parts of your chart? It's easy to do when you apply the technique described in this tip.

Read this ExcelTip: Colorizing Charts
Microsoft Excel Tips - Learn Excel Faster!

We love to compare. The instinct to compare leaves no one. Even my two year old twins compare their toys with each other (and fight). It would make Excel hugely popular if Microsoft builds a handy...

continue reading...

Determining the length of a text string is easy, but figuring out how many pixels are represented by those characters is quite difficult. Here's a discussion of why this difficulty exists.

Read this ExcelTip: Pixels in a Text String
Microsoft Excel Tips - Learn Excel Faster!

Background images for a worksheet are automatically repeated over and over (tiled) by Excel. This tip describes a workaround you can use to minimize the distracting effect of tiling.

Read this ExcelTip: Non-Tiled Background Pictures
Microsoft Excel Tips - Learn Excel Faster!

There are a few programs whose output I can identify immediately. One is Quickbooks. When I get an invoice or a quote from someone using Quickbooks, I know it right away. Today, I was admitted to the...

continue reading...

El coche es un bien de consumo duradero de nuestro tiempo. Hoy en día no podemos imaginarnos la vida sin coches. Todos, de alguna forma, lo utilizamos habitualmente como medio de transporte. ...

sigue leyendo...

Need to edit the data within a cell? There are any number of ways you can perform the edit; this tip documents them all.

Read this ExcelTip: Editing Individual Cells
Microsoft Excel Tips - Learn Excel Faster!

You can use conditional formatting to add shading to various cells in your worksheet. This tip shows how you can shade cells based on whether a value is odd or even.

Read this ExcelTip: Shading Based on Odds and Evens
Microsoft Excel Tips - Learn Excel Faster!

According to Do You Know What Planned Parenthood Actually Does?, “the Susan G. Komen Foundation has announced they will stop funding Planned Parenthood for breast cancer exams and other...

continue reading...

For those of us who crunch words instead of numbers, Excel can be intimidating. We don't know the difference between a workbook and a worksheet, and for sure don't know to ask about conditional...

continue reading...

Need to get rid of extraneous spaces before or after the text in a string? VBA provides three different functions you can use to make the removal quick and easy.

Read this ExcelTip: Trimming Spaces from Strings
Microsoft Excel Tips - Learn Excel Faster!

Count How Many Times a List of Values Occurs in a Range (or How Can I Simplify My Formula) Today in Formula Forensics we look at how to count how many times a range of values occurs within a Range...

continue reading...

Excel can, once in a while, try to be a "multimedia program." Here's how you can add short sound files to your worksheet that can act as annotations.

Read this ExcelTip: Inserting a Voice Annotation in Your Worksheet
Microsoft Excel Tips - Learn Excel Faster!

In the past here at Chandoo.org and at many many other sites, people have asked the question "How can I display a number multiplied or divided by 10, 100, 1000, 1000000 etc, but still have the cell...

continue reading...