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

Creating a sorted list of a worksheet's unlocked cell addresses onto another worksheet, in absolute and relative referen...
08/31/2026

Creating a sorted list of a worksheet's unlocked cell addresses onto another worksheet, in absolute and relative reference notation.

Finding the position and character of the first number in an alphanumeric string.
08/19/2026

Finding the position and character of the first number in an alphanumeric string.

Counting how many numerical digits are in an alpha-numeric string.
08/12/2026

Counting how many numerical digits are in an alpha-numeric string.

Lookup highest number in one column to return value in the cell on that same row in another column.
08/06/2026

Lookup highest number in one column to return value in the cell on that same row in another column.

Conditional formatting top 5 scores (5 highest numbers) in a list.
08/04/2026

Conditional formatting top 5 scores (5 highest numbers) in a list.

Counting and summing data between dates in Excel.
08/03/2026

Counting and summing data between dates in Excel.

Check out What's New in Excel (July 2026) https://techcommunity.microsoft.com/blog/ExcelBlog/whats-new-in-excel-july-202...
07/31/2026

Check out What's New in Excel (July 2026) https://techcommunity.microsoft.com/blog/ExcelBlog/whats-new-in-excel-july-2026/4523403
This month, Copilot in Excel adds support for two new frontier models: GPT-5.6 and Opus 5. You'll also find inline citations, synced connectors, Power BI grounding, brand kit and theme design skills, plus support for workbooks with AutoSave turned off.

Welcome to the July 2026 edition of What's New in Excel!

Showing Excel VBA's UNION method to simultaneously select (or operate upon without selecting) non-contiguous ranges.
07/29/2026

Showing Excel VBA's UNION method to simultaneously select (or operate upon without selecting) non-contiguous ranges.

Consolidating a range of data into a single list.
07/28/2026

Consolidating a range of data into a single list.

Using a VBA macro to sum noncontiguous ranges of varying rows in a column.
07/24/2026

Using a VBA macro to sum noncontiguous ranges of varying rows in a column.

Address

Lafayette, CA
94549

Telephone

+19253104170

Website

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.

Shortcuts

Share