Category Archives: Office 365

Excel VLookup Common mistakes

Posted on May 3, 2024 by chanmingman

This blog article shows you the common mistakes that people make when creating VLOOKUP in Excel. For example, we want to find the price of the server like below. The first mistake is to start with the wrong column, The … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform, Microsoft Office, Office 365 | Tagged | Leave a comment

VBA Loop to Office.js Loop

Posted on April 27, 2024 by chanmingman

This blog article shows you how to do the VBA Loop in Office JS. This article expects you to have basic VBA knowledge. I have a VBA to loop through the column A as follows: Sub LoopA() Range(“A1”).Select While (ActiveCell.Value … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform, Microsoft Office, Office 365, programming | Tagged | Leave a comment

Using SWITCH to Replace CHOOSE in Power Query Excel

Posted on April 12, 2024 by chanmingman

This blog article shows you how to use SWITCH in Power Query Excel. In Excel, you have Choose function. An example is like the following. = Choose (Weekday(A2), “Sunday,”, “Monday,” “Tuesday,” “Wednesday,” “Thursday,” “Friday,” “Saturday”). Unfortunately, there is no Choose … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform, Microsoft Office, Office 365 | Tagged | Leave a comment

SQL Server generate SELECT script using Excel VBA

Posted on April 7, 2024 by chanmingman

This blog article shows you how to build the SQL statement using VBA. The code needs to follow the following format of the Excel sheet. – The Sheet name is the table name. – Column A is the column name. … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet, Microsoft Office, Office 365, programming | Tagged | 1 Comment

Run Python Script Image Save Not Working in Power Automate Desktop

Posted on January 14, 2024 by chanmingman

This blog article shows you the workaround when you have a component Run Python Script in Power Automate Desktop and when you save the image to a local drive, and it will not save. For example, I copy and paste … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet, Office 365, programming | Tagged | Leave a comment

Distinct Count in Excel Pivot Table is not showing

Posted on October 3, 2023 by chanmingman

This blog article shows you one of the possibilities the Distinct Count is missing in Excel Pivot Table. When you right click on a Values field in Pivot Table. Go to Value Field Settings… You realize there is no Distinct … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet, management, Microsoft Office, Office 365 | Tagged | Leave a comment

Ask Generative AI to Generate Python Code for Microsoft Access

Posted on September 26, 2023 by chanmingman

This blog article shows you how to ask Generative AI to Generate Python Code to access Microsoft Access database table. In the article Create a Microsoft Access Database and Query using BING we have created a database, Type the following … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform, Microsoft Office, Office 365, programming | Tagged | 1 Comment

Write a VBA program to Generate Test Data using Generative AI

Posted on September 24, 2023 by chanmingman

This blog article shows you how to ask Generative AI to write a VBA program to generate test data, Many people use ChatGPT as for generative AI somehow it this sample I use Bing like in Ask Bing to Extract … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet, Microsoft Office, Office 365, programming | Tagged | Leave a comment

Ask Bing to Extract Text from Excel Cells

Posted on September 21, 2023 by chanmingman

This blog article shows you how to ask Bing to Extract Text from Excel Cells. I have a list of email addresses as follows. Assuming prior to @ is the First Name. Open Microsoft Edge, click on the Bing icon. … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform, Microsoft Office, Office 365, programming | Tagged | 1 Comment

Ask Bing to Write an Excel Formula to Find Data

Posted on September 20, 2023 by chanmingman

This blog article shows you how to ask Bing to Write an Excel Formula to find data. I have the following worksheet. I want to find the price of sugar Cookie. Open Microsoft Edge, click on the Bing icon. At … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet, Microsoft Office, Office 365 | Tagged | 1 Comment