Excel can use past data to project possible future results with the Forecast feature. It’s a very simple version of statistical ‘modelling’. The Forecast function will let you predict future values and data trends, such as consumer trends, future sales and or inventory needs, based on seasonality. Here’s a simple guide on how to use the Forecast feature. Although the data below looks fairly complicated, […]
Previously we talked about How to add a Drop-down List in Word, but you can also work more efficiently in Excel worksheets by making use of drop-down or pull-down lists. We will show you how to use Microsoft Excel’s data validation function to create useful lists within your spreadsheets. How to avoid the trap that lies waiting for the unwary who follow Microsoft’s ‘simple’ instructions. […]
In addition to the general Office 2021/LTSC features there are some useful additions to Excel 2021/LTSC including the dynamic array functions, improved XLookup()/XMatch() and Let() but sadly no Lambda(). All these features are in Excel 2021 and Excel LTSC for both Windows and Mac in addition to the overall updates that apply to all the […]
As if Lambda() was already a great addition to Excel 365, Microsoft is adding what they call ‘helper’ functions to add even more abilities. Here’s a very short overview of each helper function with links to more information. In some cases, the helper functions are a new and better way to do things already possible in Excel. Some others add […]
Excel 365’s nifty LAMBDA feature is getting an interesting, literally optional, improvement plus ‘Helper’ functions to extend its usefulness. LAMBDA, a powerful tool that allows users to create their own Excel 365 custom functions without VBA. The feature allows longer formulas to be written once then referenced in a worksheet to a shorter name of the user’s choosing. LAMBDA isn’t just another Excel function, it’s an important change in how Excel works. With Lambda() Excel understand functions as […]
