Excel trick: Search for multiple keywords from a list
Recently I was given a large spreadsheet with people’s expertise written in long phrases, and I had to identify those people who have AI-related expertise. The issue...
Category
analytics
Google Colab is an awesome Python programming tool for AI and data analysis
Picture credit: Microsoft Bing Co-Pilot Image Generator One of the problems associated with learning to code is that the initial hurdle of just getting your first line of code...
Will Robots kill human jobs? Yes and No
I have been long perplexed by this question of whether automation and robots will replace human workers. My intuition is that while they will no doubt replace many jobs, they...
Should I Buy or Lease a Tesla Part 6: The Saga Continues
Photo: A rainy day in Cambridge, MA, Summer 2022. Last year, I wrote a series of articles about the uncertainty around the decision of buying vs leasing a Tesla model Y. In...
Steps to calculate the carbon footprint of a supply chain
The steps of calculating the carbon footprint of a supply chain is straightforward: 1- You need to map out your supply chain. This also defines the boundary of your...
How much do you pay charging an EV on a monthly basis?
I always knew it is a bit cheaper to drive an EV as opposed to a gasoline car (not the owning part, which deserve a separate calculation, but just the day-to-day cost of using...
Excel Trick: Import Data From a Picture!
Have you ever looked at a table in a PDF file (or a picture) and wanted to import it into Excel? This video tells you how! As shown in the short video, this function is not...
Clustered bar chart and stacked barcharts, switch rows/columns, overlap and customize shapes
Bar charts are one of the most frequently used charts. To use them effectively to generate on-the-point graphs that deliver exactly the right message, however, requires some...