![]() ![]() When Microsoft began trying to convince us that subscribing to Office 365 was a better idea than repurchasing new versions every few years, the ability to update the productivity suite regularly at no extra cost was one of the main selling points. These new functions eliminate the need and make your life just that much simpler. In the past you may have had to use the IF function to create your filtered conditions. They are designed to supplement the MAX and MIN functions by allowing users to apply conditions to the maximum and minimum calculations and thereby filter results. The last two new functions are MAXIFS and MINIFS. The more nested IF functions the more complicated the formula and the more likely you are to make a mistake. You know what I mean: If this is larger than this, than this but if it is larger than this but less than that, then this, etc. The old IF function was the mainstay for Excel coders looking to apply logic to sets of data. The next two new functions are IFS and SWITCH, which provide an alternative to using the infamous series of nested IF functions. This is just one example of how these new functions are designed to simplify users’ lives when it comes to advanced Excel tasks. With the new TEXTJOIN formula, the same process would look something like this: ![]() In the past, the formula would look something like this: This comes up with addresses all the time-a common task for spreadsheets since they were invented. The first updated functions are TEXTJOIN and CONCAT, and they are replacements for the old concatenate function, which gave the user the power to join strings of separate text into one cell. This is where the six new functions are supposed to help. Of course, while there is great satisfaction when you figure out the perfect formula, a certain amount of despair also goes with it-because now you have to apply that complicated nested formula over and over again. So when Microsoft adds six new functions to Excel in one month it is a very big deal. For an Excel aficionado, the satisfaction of creating the perfect nested formula is second to none when it comes to Excel coding. Using, combining, and creating formulas in Microsoft Excel is where true Excel gurus separate themselves from the pretenders and wannabes. Microsoft rolled out numerous improvements to Office 365, like better pen annotation integration, the ability to pin documents to the Start menu, a new feature that allows images to be inserted into documents directly from the camera, and the best- adding more functions to Excel. ![]() When it comes to general updates to Microsoft Office 365, February 2016 was a fairly significant month. Microsoft made several new updates to Office 365 in February, including the addition of six useful functions for Excel. ![]()
0 Comments
Leave a Reply. |