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”.
For years, Microsoft has been trying to replace VBA (Visual Basic for Applications), the programming language that “lives” in the background of Excel. As they say, the reasons are of a security nature. This is not entirely without merit, but it seems to me that the motive of the Excel development team, to a greater extent, was to create scripts that would fit better into the Microsoft 365 and Power Platform ecosystem. Whether they succeeded in this is up to you to try.
This function, for given start and end date, calculates how much time has passed in years, and as a result returns a decimal number. It can be used to calculate annual interest, future value and in other cases when it is necessary to know how many years have passed. In the text that follows, through a simple example, you will get to know this function.