To quickly combine text and numbers from multiple cells in Excel, use the TEXTJOIN Excel function. I’ll show you two examples, and you can scroll down to watch the video…

1. Introduction Insurance is a perfect industry for data analysis. There is plenty of data – right from lead generation to to underwriting to policy issuance to administration to claims…

JSON (JaveScript Object Notation) is a popular and easy format to store, share and distribute data. It is often used by websites, APIs and streaming (real-time) systems. But it is…

DAX offers powerful way to analyze “new” vs. “returning” customers. In this article learn easy and simple DAX measure patterns to count number of new customers and number of returning…

Let’s say you have two lists of values in Excel and want to find out all the common values (ie duplicates) and extract them. In this article, let me explain…

Ever have a report that is too big to fit in one screen but when you scroll you loose the context? Something like this.. Use FREEZE PANES option in Excel…

Usually, it’s easy to sort an Excel pivot table, but you might run into one that just won’t sort correctly! For example, employee names are listed alphabetically, but there’s a…

Do you want to lookup in any column and return the result? Something like this: In this article, learn how to write necessary Excel formulas to get the result. Data…

Where does the time go? Two years ago, we were celebrating Excel Day 45000, and suddenly it’s Excel Day 45678! Do you have any special events planned? If not, you…

Pin your Excel files, make decisions with a spreadsheet, and more, in this month’s Excel news. Visit my Excel website for more tips, tutorials and videos, and check the index…