Automatic saving of Excel documents has been around for a very long time. If you go to Excel Options, in the Save section, you will see the option to Save Autorecover Information Every… and the number of minutes after which the saving is performed. However, this works if your computer resets or for some other reason stops working. With the advent of the OneDrive repository and storing documents on it, we got a new, better Autosave…
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.
Version History is a great feature that can be used by all Microsoft 365 subscribers who store files on a SharePoint or OneDrive repository. Storing files in the cloud brings a lot of benefits, one of which is the overview of all versions and the ability to restore a previous version of an Excel document that was worked on by one or more users.
In an old cartoon was promoted a saying: “Cats and mice can be friends”. Consequently, Excel and Power BI can also be friends! Power BI allows you to import Excel reports, whether traditional, Pivot or Power Pivot reports. This is not a whole new topic, but I think it would be nice to remember it in a new light, with an emphasis on what you can do for free and when you definitely have to buy licenses.
Comments in Excel are not new option. Nevertheless, from the version to the version, there was more and more work to improve the possibility of collaborative work on the documents. Consequently, Excel has a new type of comment. They refer to commenting on shared documents, which in most cases are on the OneDrive repository, and you can view them in a simple way: by clicking the Comments button in the upper right corner of the window.