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 →