Content Preview: rss
26 days ago
Quote of the Day: Copy from one, it's plagiarism; copy from two, it's research . --Wilson Mizner I tried a little experiment yesterday and was pleasantly surprised by the results. A while back I had learned how to link a chart title to data stored in an Excel worksheet. That in itself is an enhancement to charting. If you have done any charting (graphing) in Excel, you will know that most of the chart’s values are stored in a worksheet. Change the worksheet values, and the chart will automatically update. Here’s an example. Let’s say that I am using a worksheet to prepare a monthly sales presentation to management. Management want to see the relative contribution of each salesperson to year to date sales. So I have set up a simple pie chart to display the information. Obviously, I have much more to do in my job than just to prepare this once a month presentation so I want to produce this chart as efficiently as possible. Now, when I created the chart, using the chart ...
31 days ago
This article, John R. Durant's WebLog : Why VBA Still Makes Sense , presents a solid case for why VBA is the ‘next level’ when it comes to application development in Access and other members of the Office suite. John provides an excellent of VBA since its early days to the present and on into Office 2010 including his perspective on the ‘fit’ between .NET and VBA. John R. Durant's WebLog : Why VBA Still Makes Sense is definitely a worthwhile read.
37 days ago
If you are a Project user or are interested in the latest developments in Microsoft Project, check out this Office Team Blog overview. The new version looks exciting.
40 days ago
Quote of The Day Ask not what the world needs. Ask what makes you come alive... then go do it. Because what the world needs is people who have come alive. Howard Thurman One day I was teaching an Introduction to Excel class when one of the participants questioned why it was important to ‘do everything quickly.’ I had discussing ways to efficiently create a workbook. I took the comment as coming from the perspective that many North Americans and Canadians, specifically, live life at too fast a pace. I happen to agree with that point of view but at the same time I prefer to get the drudgery of a task quickly out of the way so that I can dedicate more time to parts of the task that I find more interesting. Autofill is an Excel feature that many self-taught users are not aware of. It’s easy to miss the tiny clue that the feature even exists. Autofill has two main purposes in Excel, extending a series, and copying formulas. The Autofill handle Unless you look very ...
50 days ago
Perhaps not as sensually satisfying as raindrops on roses or whiskers on kittens, but when it comes to Excel, these are a few of my favourite things: autofill Quickly copy formulas or create a series of months, days, quarters, or other custom series. cell and range names Use cell or range names to make formulas easier to understand at a glance. templates Stop re-inventing the wheel when you need new workbooks to handle data with tried and true formulas and layouts lookup functions Reduce the amount of repetitive data in your workbook absolute references Make it easier (and faster) to copy formulas that need to refer to the same value regardless of where you copy them to 3-D formulas Create a worksheet to summarize data from detail worksheets using simple formulas. header and footer improvements (Excel 2007) Custom headers and footers made a giant step forward with Excel 2007 tables (Excel 2007) ...
