Top 10 Excel Tricks for Increased Efficiency
Mar 29,
2017
Considering the time today’s IT professionals spend staring at Microsoft Excel spreadsheets, one might think we’d all be Excel wizards by now. The truth is that while Excel has a low barrier to entry, to become a true super user takes a lot of time, energy, and dedication. While you may think you’re an above-average […]
Writing DAX Summary Queries Using PowerPivot and Excel QueryTable Objects
Feb 15,
2015
Don’t get me wrong. Excel PivotTables are one of the best things since pizza and beer. (And considering how much I enjoy that particular combination of snack and beverage, that’s really saying something.) Nevertheless, there are times when you want to take full control, write your own DAX query, and display the results in a […]
Windows Azure Marketplace DataMarket
Jul 3,
2013
As I prepare to teach Learning Tree’s Power Excel course in Rockville next week I have been taking a closer look at PowerPivot. Since the course now uses Excel 2013 we have expanded the coverage of PowerPivot which is now included with Excel. In 2010 it had been a separate add-in. So what, you may […]