![]() ![]() I don’t think I mention this in the webinar or put much emphasis on it in the spreadsheet but you can use the FILTER function a bit like you would use a VLOOKUP if you wanted to add multiple lookup criteria. ![]() I’ve approached this spreadsheet and webinar from the point of view of someone who has gone from Excel 2010 to Excel 365 so there are some formulas featured that you may have already come across if you were on a more modern version of Excel previously but the array formulas are all brand new to Excel 365 and they are what I cover in the webinar linked below.Īttention: the Excel 365 Array Formulas section of the webinar is only from 00:00:00 to 00:53:30 with the remaining part of the webinar to do with how those formulas came in handy when developing a method of showing how costing systems do Overhead Allocation. The formulas featured on the spreadsheet are as follows with only the ones highlighted being demoed in the webinar linked below. ![]() I’ve created a spreadsheet which covers a wide range of these new formulas which you can use to see them in action. Office 365 brings forth a new wave of formulas that you can use in Excel. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |