Python has finally become part of Excel, and from now on you can add pieces of Python code to a sheet to define datasets, process and visualize them. If you have a Microsoft 365 subscription and have downloaded update 2405 (Build 17628.20164), you will be able to use Python normally (no longer reserved for testers only). In this short intro you will learn what Python is and how it can enrich your reports.
A few years ago, Excel, which comes as part of a Microsoft 365 subscription, got the Ideas option. Now this option has been improved and is called Analyze Data. It enables, with the help of artificial intelligence, simple and fast data analysis to generate tables, pivot tables or charts according to user questions, which help user to visualize data in appropriate business reports.
Checkbox is not a new Excel feature. We were able to add checkboxes to Excel reports earlier, by choosing some of the controls offered in the Developer ribbon (Form Controls, ActiveX Controls). Recently, Microsoft has made this option much more accessible, and in the following post you will find out how to add a checkbox to your report and how you can analyze such reports.
When you enter phone numbers in a cell, you must enter them as text which means that you should add an apostrophe before entering the number. In this case, it is best to enter the number in international format. If you don’t want to think about codes and calling numbers, you can retrieve this data from the auxiliary records, and then join them with the help of the TEXTJOIN function. You will find out how to enter email addresses and phone numbers in the following text.
How to count words? There is no longer a need to send telegrams, and the need to count words seldom arises. However, this is a nice opportunity to try out how to use the TEXTSPLIT function in combination with some other Excel functions. Who knows, maybe this will be useful to you one day? In honor of Pink Floyd, let’s count the words in the song “Shine On You Crazy Diamond”.