These functions are for stringing together pieces of text across a range of cells. Here are some examples of how these can be used in practice:
In the meantime, the full list of new functions currently available only in Excel 365 or Excel 2019 is: CONCAT, IFS, MINIFS, MAXIFS, SWITCH, TEXTJOIN and some specialist FORECAST functions. You need to make sure that your file only uses functions that are compatible with the earliest version of Excel that the people who open your file have. As always, if you want to share a spreadsheet with users who are not on Excel 2019 (or 365) then do not use the new functions.If you have Microsoft 365/Office 365 but you are using an earlier version than Windows 10, then you won’t have all of the new Excel 2019 features.It is compatible only with Windows 10 onwards (or Mac). Excel 2019 is not compatible with Windows 7 or 8 or 8.1.If you have Microsoft 365 (what was called Office 365) then you will probably already have the new Excel functions for 2019 now.We’ll write up more about these new features once we have experience of using them in practice.Ī couple of big points to note now though are: Excel 2019 has a few new features coming, including some new handy functions which will probably be the newcomers that you are most likely to use.
0 kommentar(er)
