Teaching analytics with modern Excel
If your voluminous VLOOKUP()s and rickety reports are making you think it's time to retire Excel for good and pick up an expensive analytics tool, not so fast. Power Pivot can help you build quick, …
Continue Reading about How to install Power Pivot and DAX for Excel →
One of the best things you can do as an analyst is add context to your numbers. As Edward Tufte put it, frame the problem with the question "Compared to what?" in mind. Often in business …
Continue Reading about How to add a date table to the data model in Excel Power Pivot →
Het kopen van Cialis Generiek, ook wel bekend onder de naam Tadalafil, is een goedkoper alternatief voor het bestellen van de originele merkgeproduceerde hulpmiddel. Dit houdt echter niet in dat er …
Continue Reading about How to add tables to the data model in Excel →
Excel PivotTables are great for summarizing a variety of columns of a dataset in a variety of ways. But there's one particular use case where the classic PivotTable falls short. Let's take a look at …
Continue Reading about How to get the count of distinct items using Excel PivotTables →
Excel's vision fulfilled Think Excel is obsolete? You may want to have a word with Microsoft CEO Satya Nadella, who has called it the organization's most important consumer product. And features …
Ah, the "Franken-Table." You've probably created one: a worksheet with umpteen VLOOKUP()'s referencing various other worksheets and perhaps (gasp!) even other workbooks. It's ugly and inefficient: …
Continue Reading about Learning guide: Introduction to Power Pivot in Excel, one-day workshop →
