 |
NavegaciónInicio de sesiónEn lÃneaEn este momento hay 0 usuarios y 22 invitados en lÃnea.
|
InglésUnderstanding the Document MapThe Document Map is a handy way to view the overall organization of your document as you are working with it. It is like viewing the document's outline as you continue to work in the document itself. Read this WordTip: Understanding the Document Map Using external software packages to manage your spreadsheet risk [Part 4 of 4]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... Five Years of Live Training EventsI’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... Infinite Loop of ErrorsThis 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... Word and Character Count InformationUsing fields you can easily insert both the word and character counts for a document into the document itself. As those counts change (during editing), Word automatically updates what is displayed by the fields. Here's how to put them to work. Read this WordTip: Word and Character Count Information Running Out of MemoryDo 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 Creating an Excel MashupFollowing up on my previous posts sharing my initial Excel mashups (http://www.dailydoseofexcel.com/archives/2012/01/29/excel-mashup-2/ and...
continue reading... Using Go To with a PercentageNeed to jump a certain percentage of the way through a document? You can do it using the familiar Go To tab of the Find and Replace dialog box, provided you use the technique described in this tip. Read this WordTip: Using Go To with a Percentage Colorizing ChartsNeed 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 Comparing 2 Lists with a TwistWe 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... Decreasing File Sizes of Documents with GraphicsOne challenge faced by anybody adding graphics to a document is to manage the resulting file size of the document. Adding graphics can make a file huge, as this tip points out. Also covers different ways you can reduce the file size while still working with your graphics. Read this WordTip: Decreasing File Sizes of Documents with Graphics Pixels in a Text StringDetermining 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 Cropping GraphicsNeed your hide some of the outside edges of a graphic? You can instruct Word to crop (or hide) those outside edges by following the steps in this tip. Read this WordTip: Cropping Graphics Non-Tiled Background PicturesBackground 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 Tell Tale SignsThere 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... Editing Individual CellsNeed 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 Understanding Outlining in WordRemember when you needed to create outlines for your writing when you were in school? Word includes outlining capabilities that can make it easy for you to organize your thoughts and improve your writing. Read this WordTip: Understanding Outlining in Word Shading Based on Odds and EvensYou 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 MS-DOS with Line Breaks Format in Word 2002 and Word 2003Finding the built in functionality in Word 2002 & 2003 for saving your document as a MS-DOS format. Read this WordTip: MS-DOS with Line Breaks Format in Word 2002 and Word 2003 Chart Busters: What Planned Parenthood Actually DoesAccording 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...  |
cargando...
Buscar en necesitomas.comExcelómetroTemas nuevosLo más vistoHoy: |
