September 12, 2019 - by Bill Jelen
There are several dynamic array that get better with an array constant. Here is a simple way to understand them. A comma inside an array constant means to move to the next column. A semi-colon means to move to the next row. How do you remember which is which? The semi-colon on your keyboard is located near the Enter or Return key which also goes to the next row.
Excel 2019: Filter with a Formula »
September 11, 2019 - by Bill Jelen
The FILTER function is new as part of the dynamic arrays feature. There are three arguments: array, include, and an optional [if empty].
Excel 2019: Sorting with a Formula »
September 9, 2019 - by Bill Jelen
Sorting data in Excel is easy. Unless, you are building a dashboard for your manager's manager. You can't ask that person to select C3, go to the Data tab and click the AZ button every time they want an updated report. The new SORT and SORTBY functions allow you to easily sort with a formula.
The Absolute Guide to Dashboarding & Reporting with Power BI »
Learn Power BI Dashboarding Techniques by Watching A Pro!
Excel JavaScript UDFs Straight to the Point »
JavaScript custom functions - UDFs can be used like any other native functions or UDFs in Excel. This book shows the process of creating JavaScript UDFs in Excel Developer Preview for Office Insider program subscribers.
Supercharge Excel When You Learn to Write DAX For Power Pivot »
Hands-on book to learn and master the DAX language!
Microsoft Excel 2019 Inside Out »
Dive into Microsoft Excel 2019–and really put your spreadsheet expertise to work. This supremely organized reference packs hundreds of timesaving solutions, tips, and workarounds–all you need to make the most of Excel’s most powerful tools for analyzing data and making better decisions.
Excel 2019 Business Basics & Beyond »
Are you tired of tracking financial elements of your business manually, do you have to prepare staffing schedules by hand, or do you simply want to know how to get more information from your business data? Learn how to harness your business data and put it to use for you.