Translation in Excel documents is not a new feature, and with the advent of artificial intelligence, it works incomparably better than before and can be said to be competitive with the Google Translate service. Recently, we also got a TRANSLATE function that translates text from one language to another, and allows you to create reports that are dynamically translated.
Excel has recently gained several new features that make it easier to focus on the content, i.e. the tables we work with. First, the menu with color palettes is now much larger and more noticeable, and the choice of colors is more adapted to visually impaired people or those who do not perceive the differences between colors well. Then there is a new option that allows you to focus on the cell, making it easier to work with large tables.
Everyone knows that at the end of the year I often post “recipes” that have something to do with the Christmas and New Year holidays. This time I decided to show you how to combine Excel and Microsoft Forms, a Microsoft 365 service used to create questionnaires, quizzes, polls… In this text, you will find out how to create a New Year’s questionnaire by creating a form directly from Excel.
Pivot tables have been with us for a long time and allow us to easily analyze data by changing the perspective from which we look at them. Recently, there is also a PIVOTBY function that allows us to get a similar report, but in an Excel spreadsheet. By marking rows, columns, values and other parameters, a dynamic report is generated. Here’s a post about how to use this function…
If writing SQL queries is in your job description I am certain that you, in great extent, inside SELECT command, use a GROUP BY clause that allows you to group row values by a given column and then apply an aggregation function, e.g. SUM, COUNT, AVERAGE, MIN, MAX… I have good news for you: we can achieve almost the same thing within an Excel report by using the GROUPBY function…