OneNote is used to take notes. It comes as a free desktop app with Windows, but also as part of the Microsoft 365 suite or a web service. Notes are captured in notebooks, and each of them can have multiple sections and parts. In notes, we can write down text, keep To Do lists, add images, video or audio recordings, links… Notebooks are stored as documents in the OneDrive repository, which means that notes can be easily accessed from any device.
In the “Excel Kitchenette” blog so far you could have met many text manipulation functions. As of August 2022 (unofficially), and officially as of a few weeks ago, Microsoft 365 subscribers have some new functions at their disposal that increase productivity and can help you more easily to retrieve individual parts of a given text, before or after the delimiter.
Sometimes, while using Excel, you need to specify the date on which a particular month starts or ends in order to perform the desired calculation on that day. Although, with a little effort, these dates can be calculated in the traditional way, you will be greatly relieved by using the EOMONTH function. You will learn more about this function in the following text…
Myers–Briggs test is the one you have probably already met on some of the job interviews, when completing the test where it seems that questions are repeated. It is a personality type indicator, on the basis of which the respondent is classified by four types and two subtypes: an extroverted-introvert, experienced-intuitive, thinking-feeling, judging-perceiving. The ideal tool for displaying the results of this test is the Radar chart.
Although Excel is the best software to work with tables, we often create them in other software. Also, tables are commonly used for data exchange, when they are exported as tables in a text file as “Comma Separated Values”. In this file, each row of the table is a separate line in the text, and the values that are in the columns are separated by commas (hence the name). In the text that follows, we will show how to import text from one such file …