General
Create a Pivot Table in Excel 2007
An introduction video (youtube) description the use and creation of pivot tables in Excel 2007. Send post as PDF to Read More →
How to configure Office 2007 to save files using the old Office 97-2003 format
Personally, I use Excel 2003 at work and Excel 2007 at home. I am constantly (as in 3 or 4 times a weeks) using Excel 2003 files in Excel 2007. I found this tip at vista4beginners.com showing how to have Office 2007 automatically have files in the Office 2003 format: Configure... [Read more...]
Pivot Tables
Create a Pivot Table in Excel 2007
An introduction video (youtube) description the use and creation of pivot tables in Excel 2007. Send post as PDF to Read More →
Pivot Tables - A powerful tool.
At work I use pivot tables nearly every day. My work does not involve analyzing business or financial data and still I find pivot tables very useful in manipulating data sets, performing on-the-fly calculations, and preparing final reports. So, what is a pivot table? A pivot... [Read more...]
Data Analysis
Create a Pivot Table in Excel 2007
An introduction video (youtube) description the use and creation of pivot tables in Excel 2007. Send post as PDF to Read More →
Bar Chart using REPT function
The REPT function repeats text a given number of times. For example, =REPT(”*”,10) repeats * 10 times in a cell. You can use this function to create a simple bar for values in multiple cells. Here is a short video on YouTube: Send post as PDF to Read More →
VBA
July 2005 Update of the Microsoft Excel 2003 VBA Language Reference
The Excel 2003 VBA Language Reference has been updated. Welcome to the Microsoft Excel 2003 Language Reference. This reference contains conceptual overviews, programming tasks, samples, and references to guide you in developing solutions based on Microsoft Excel. Publish date... [Read more...]
Migrating Excel VBA Solutions to Visual Studio 2005 Tools for Office
Microsoft Visual Basic for Applications (VBA) is the programming environment and language for Microsoft Office that has been available for several years. Microsoft Office 2003 Editions have a new environment for building applications, called Visual Studio Tools for Office, which... [Read more...]
Tools
Pivot Tables - A powerful tool.
At work I use pivot tables nearly every day. My work does not involve analyzing business or financial data and still I find pivot tables very useful in manipulating data sets, performing on-the-fly calculations, and preparing final reports. So, what is a pivot table? A pivot... [Read more...]
Name Manager for Excel
Name Manager, now at Version 4, is a Excel Add-In that I find useful. Many times I have had to deal with workbooks with more than 100 names, many that are no longer valid. Name Manager helps manage such a mess. If you are in need of a utility to manage defined names in your... [Read more...]
Functions and Formulas
Bar Chart using REPT function
The REPT function repeats text a given number of times. For example, =REPT(”*”,10) repeats * 10 times in a cell. You can use this function to create a simple bar for values in multiple cells. Here is a short video on YouTube: Send post as PDF to Read More →
Excel 2007
Create a Pivot Table in Excel 2007
An introduction video (youtube) description the use and creation of pivot tables in Excel 2007. Send post as PDF to Read More →


