Tag Archives: MS Excel

Microsoft Phases Out Semi-Annual Update Channel for Some Microsoft 365 Installations

Microsoft is quietly making a notable change to how Microsoft 365 Apps are updated in enterprise environments, specifically affecting the slower “Semi-Annual Enterprise Channel.”

According to Office Watch, Microsoft is removing this channel as an option for unmanaged devices in the Microsoft 365 admin center. In practical terms, this means administrators will no longer be able to choose the traditional six-month feature update schedule when setting up Office installations for those devices.

The Semi-Annual Enterprise Channel has long been used by organizations that prefer stability over speed. Instead of receiving new Office features every month, users on this channel typically got updates only twice a year, giving IT teams more time to test changes before rolling them out broadly.
 
Continue reading →

Microsoft Office Icons Get a Modern Refresh

Microsoft Office has just rolled out a fresh new look, with its suite of apps receiving a long-awaited facelift. As of yesterday, the familiar icons for Word, Excel, PowerPoint, Outlook, and more have been refreshed, giving the productivity tools a modern, streamlined design.
 
Continue reading →

Microsoft Answers Is Being Retired

Did you see the new heading banner that appears when you go and access the (Microsoft) Access (Database) forum on Microsoft Answers?

Microsoft 365 and Office forum Moving to Microsoft Q&A

We are excited to announce that soon, the Microsoft 365 and Office forum will be available exclusively Microsoft Q&A. This change will help us provide a more streamlined and efficient experience for all your questions and discussions.

Starting July 16, you will no longer be able to create new questions here in the Microsoft Support Community. However, you can continue to participate in ongoing discussions and create new questions on Microsoft Q&A. Thank you for your understanding and cooperation.

Continue reading →

Generate a CSV From an Excel Column of Data

Every once in a while I am provided data from client in Excel and want to use that information in SQL (SSMS, MySQL, …) to build some WHERE clause in a query. So I go back and forth, copy/paste, over and over. It’s tedious and time consuming!

There has to be a better approach.

Now, if you’re running Excel 365 then there’s a new function you can actually employ TextJoin(), but I’m not going to be discussing that here.

I wanted, needed, a universal solution for when on-site at clients, some of whom are running Excel 2003.

Continue reading →

Working With Dates and Times

This is something I’ve been wanting to do for quite a while, that is, to create a page dedicated to working with Dates and Times.

I was doing a little more advanced Date/Time VBA programming and decided that now was as good a time as ever to start creating such a page.  So here it is.

This article will evolve with time, so come back from time to time.

Continue reading →

What is the Difference Between Office 2024 and MS365?

After my recent post and video regarding Office 2024’s release:

Microsoft Office 2024 Released!
Did you know, Office 2024 launched yesterday! That’s right, if you want a perpetual license (1 time purchase rather than the MS365 Subscription model) of the latest and greatest version of Office then 2024 is now on the market. Here’s Microsoft’s official announcement:  

I’ve seen a few questions on my YouTube channel and in various forums where people are trying to understand the difference between Microsoft 365 (also referred to as MS 365 or MS365) and this latest release of Office 2024.

As such, I thought this an important subject to cover.

Continue reading →

Microsoft Office 2024 Released!

Did you know, Office 2024 launched yesterday!

That’s right, if you want a perpetual license (1 time purchase rather than the MS365 Subscription model) of the latest and greatest version of Office then 2024 is now on the market.

Here’s Microsoft’s official announcement:

Office 2024 for consumers available October 1 | Microsoft 365 Blog
Office 2024 includes updated, locked-in-time versions of Word, Excel, PowerPoint, OneNote, and Outlook for PC and Mac. Learn more.

 
Continue reading →

Randomly Delete/Clear Rows of Data Within a Column(s) in Excel

A bit of a weird one today.

I was in need to deleting some data in various columns within an Excel Workbook and instead of undertaking this task manually, I decided a little VBA function would do the trick and be much faster than I ever could be manually.

So basically, I wanted to randomly delete value from within a single column, or possibly randomly delete rows of data within a series of columns. For my needs, I came up with the following procedure:

Continue reading →