Excel 2003 | Excel Semi-Pro

Excel 2003

How to Update a List or Range without OFFSET

March 22, 2012 Formulas

I avoid the use of Volatile Functions, especially OFFSET, which is commonly used to update a list or range. They can slow down the operation of your workbook. For very large workbooks with lots of data, it can be significant and irksome. Worksheet cells that use Data Validation for a drop-down list can simplify the […]

Get the full story …

Check the Analysis ToolPak Add-In in Excel 2003 [VBA Code]

February 28, 2012 Advanced

I recently began using the NETWORKDAYS function in Excel 2007, yet my file was going to be widely used by people with Excel 2003 (both are Windows versions). The NETWORKDAYS function is a standard function in Excel 2007, but with 2003 you have to install the Analysis ToolPak, otherwise you get an error. The only […]

Get the full story …

An Excel Crossroads – Mac and Windows

January 5, 2012 General Update

I bought a MacBook Pro and installed Windows 7 with Boot Camp Assistant so I could access the “normal” Excel. This was important to me at the time because I was doing Excel development work in versions 2003, 2007 and 2010 on a Windows PC. I love my MacBook Pro, which I consider my computer […]

Get the full story …

Create a List in Excel 2003

April 30, 2011 Features

The forerunner of the modern Excel Table is know as a List Object. Excel 2003 has this feature, and I’ll simply refer to it here as a List. To create a List in Excel 2003, select your existing data table and choose Data > List > Create List…, or use the keyboard shortcut Ctrl+L. Excel […]

Get the full story …

What Version of Excel am I Using?

January 3, 2011 Beginner

If you’re curious about the version of Excel you’re using and don’t know how to go about it, you’ve come to the right place. It could be as simple as selecting the Help Menu and clicking About Microsoft Office Excel, but then again, maybe not. The five options below will help you sort things out. […]

Get the full story …

Recently Used File List in Excel

December 17, 2010 Beginner

How many files will Excel show in the Recently Used File List? Well, it depends on the version of Excel you’re using and vary between 9 and ninety-nine files. Here is a list of Excel versions, menu navigation to the recent file list, and the max files allowed. Excel 2010, 2007 File>Options>Advanced tab>under the Display […]

Get the full story …

Calculate the Xth Weekday of Any Month in Excel

December 8, 2010 Advanced

I’ve a simple formula for calculating the Xth Weekday of ANY month. It takes four inputs: Year, Month, Week, and Day. And requires a couple of lookup tables for data validation, one with special formatting. The History It all started when my wife mentioned there were a couple of meetings she had to schedule at […]

Get the full story …

My Spreadsheet Challenge Picture

November 26, 2010 General Update

Here’s the picture I entered for the Spreadsheet Challenge. I’ll point out the obvious and not so obvious stuff in this picture. Me Two monitors showing Excel 2007, Excel 2003, and Excel 2010 spreadsheets, and PDF versions of Excel 2007 Formulas, Excel 2003 Power Programming with VBA, and Excel 2010 Bible A MacBook Pro showing […]

Get the full story …

Copy a Worksheet Picture in Excel 2003 or Excel 2008

September 18, 2010 Intermediate

There’s a neat trick you can use to copy a picture of a spreadsheet in Excel 2003 or Excel 2008 for Mac. It’s great for getting a spreadsheet snapshot into your presentation software. First you select the range you want to copy, then hold the shift key down while you click the Edit menu. What […]

Get the full story …

Expand Menus in Excel 2003

June 15, 2010 Beginner

Short article and video of how to expand menus in Excel 2003 so you can see all items on each menu.

Related Posts Plugin for WordPress, Blogger...
Get the full story …