Insights in Excel is a new feature of Excel 2016 with an Office 365 subscription that give you fast, automated, insightful analysis of your data.
Excel’s PivotTables are great, but sometimes we get subtotals within subtotals and you want to lose only the 2nd subtotal.
Extracting email address from a text string in Excel can be tricky. I made a video demonstrating three methods of extracting the email addresses.
Create a break-even analysis with multiple products in Excel. Create a contribution margin income statement using a product mix.
Vlookup is a powerful function but even better but less frequently used is Index and Match. Explained are two reasons to use Index and Match over Vlookup.
Need to calculate weekly revenue or orders in Excel? You either Vlookup or PivotTables. PivotTables have a grouping features that will calculate it.
When you import data into Excel from a database, often dates and numbers will import as text. The issue is you can't analyze the data.
Break Even is when you making neither a profit nor a loss. This was a question from one of my MBA students. We will use the contribution margin
If you need to select an entire row using two conditions with Conditional Formatting in Excel, you need to write a formula using the AND function.
