Tom Urtis / Atlas Programming

Tom Urtis / Atlas Programming Expert consulting, training, project development for Microsoft Excel. Comprehensive skills testing wi

Atlas Programming Management is all about the business of Microsoft Office, particularly Excel. We provide a variety of services and support to business clients & individual Excel users at all skill levels. Our website is also an extensive resource offering expert information, tips and tools

Conditionally formatting every other group of "X" rows, in this example every other group of 4 rows.
06/18/2026

Conditionally formatting every other group of "X" rows, in this example every other group of 4 rows.

Installing two conditional custom number formats in the same cell.
06/17/2026

Installing two conditional custom number formats in the same cell.

Conditionally Formatting cells with comments/notes, with a user-defined function as the formula rule.
06/16/2026

Conditionally Formatting cells with comments/notes, with a user-defined function as the formula rule.

Further customizing a Social Security Number entry beyond its built-in Special format.
06/11/2026

Further customizing a Social Security Number entry beyond its built-in Special format.

Creating a named constant and using it in a formula, in this example adding a constant tax rate of 8.25%.
06/09/2026

Creating a named constant and using it in a formula, in this example adding a constant tax rate of 8.25%.

Disallowing a specified character using Data Validation, with the custom formula example =ISERROR(SEARCH(" ",E5))
06/08/2026

Disallowing a specified character using Data Validation, with the custom formula example =ISERROR(SEARCH(" ",E5))

Calculating the number of days in a month, with a proration and verification example.
06/05/2026

Calculating the number of days in a month, with a proration and verification example.

Data Validating time entry in 5-minute increments with example custom formula =MOD(MINUTE(C5),5)=0.
06/04/2026

Data Validating time entry in 5-minute increments with example custom formula =MOD(MINUTE(C5),5)=0.

Filling selected cells to the right with the Ctrl+R keyboard shortcut.
06/03/2026

Filling selected cells to the right with the Ctrl+R keyboard shortcut.

Customizing the right-click menu to modify your default double-click behavior by selecting an entire cell's contents for...
06/02/2026

Customizing the right-click menu to modify your default double-click behavior by selecting an entire cell's contents for fast and easy editing.

Address

Lafayette, CA
94549

Alerts

Be the first to know and let us send you an email when Tom Urtis / Atlas Programming posts news and promotions. Your email address will not be used for any other purpose, and you can unsubscribe at any time.

Share