You searched "Excel"
        Page 4 of 313 results
blog post –

SQLIO analysis on Excel charts

I tend to use twitter when I have to notify an interesting link or tool. But sometimes a blog post (even if short) is better, because allows me to easily find it on search engines (Bing/Google/whatever) months or years later. I know PInterest is growing  Read more

article –

Automate PowerPivot Data Refresh in Excel

In many workshops and sessions about PowerPivot the most frequently asked question has always been: how can I automate the PowerPivot Data Refresh in Excel? I talked about that a few weeks ago.  Read more

blog post –

Automate PowerPivot Data Refresh in Excel

link In many workshops and sessions about PowerPivot the most frequently asked question has always been: how can I automate the PowerPivot Data Refresh in Excel? I talked about that a few weeks ago . The sad answer is that this feature is not supported  Read more

blog post –

Workaround for lack of PowerPivot API in Excel

A few days ago a post about VSTO-based PowerPivot Workbook in the PowerPivot Team Blog shown a workaround for the lack of PowerPivot API in Excel. In reality, I don’t like this workaround at all, because it relies on displaying message boxes to the end  Read more

blog post –

Parameterize Charts using Excel Slicers in PowerPivot

One new nice feature of Excel 2010 is the Slicer. Usually, slicers are used to filter data in a PivotTable. But they might be also useful to parameterize an algorithm or a chart! We discussed this technique in our book , but Alberto Ferrari wrote a post  Read more

blog post –

Self-Service BI: BI to Excel or Excel to BI?

I spend most of my time developing complex BI solutions and, doing that, I always talk with DBA, developers, CEO, data analysts and the many kind of people that work around a BI solution. Nevertheless, in these last months, publishing posts about PowerPivot  Read more

blog post –

Dynamic Ranking with Excel and PowerPivot

Ranking is useful and, in our book , I and Marco provide a lot of information about how to perform ranking with PowerPivot. Nevertheless, there is an interesting scenario where ranking can be performed without complex DAX formulas, but with just some  Read more

blog post –

A new Excel 2010 book for Data Analysis

Microsoft Press just announced the printing of Microsoft Excel 2010: Data Analysis and Business Modeling , which is the third edition of the book written by Wayne L. Winston covering many data analysis and modeling techniques using a very clear problem-solution  Read more

book –

Microsoft PowerPivot for Excel 2010: Give Your Data Meaning

Transform your skills, data, and business—with the power user’s guide to PowerPivot for Excel. Led by two Business Intelligence (BI) experts, you will learn how to create and share your own BI solutions using software you already know and love:…  Read more

blog post –

How to start with PowerPivot for Excel

Now that Office 2010 has been released, many people will start looking for resources to start learning PowerPivot. Of course, the book I’m writing will be helpful when it will be published (September 2010), but you can also start with some online content  Read more