Posts Tagged ‘Excel’

Last week while at the annual Microsoft Dynamics Convergence in New Orleans (with 10,000 other people- partners, clients and MS employees) there was a great session on Advanced Analytics for Microsoft Dynamics CRM. Many of these options have been available for the last few years since the release of CRM 2011 (both online and on-premises) […]

In B.E Aerospace project, we have to deal with lots of complicated SmartView Reports (SmartView is a plugin on Excel for Hyperion which is a BI suite of Oracle). And it would be a great advantage if you are familiar with the various Excel functions and how to make good use of them. Now I […]

  If you are new to SQL Server 2012 like me, you might run into some issues when you are trying to create some Tabular Model projects.A Tabular Model is simply a new type of server mode in SQL Server 2012. It utilizes a new storage mode known as the Vertipaq storage engine that enables […]

The Quandary I’ve literally written a ton of VBA code over the years to “enhance” my end user’s experience. For example, I’ve often slapped a button on a worksheet or toolbar and used the E_PICK to pop-up a dimension subset editor allowing a selection of particular element and then using that selection to drive changes […]

As observed, many projects are using Excel as the tool to manage test cases and test results, as well as other assets. Admittedly, Excel can work out if these testing assets are properly organized and maintained. However, from a teamwork perspective, Excel can be difficult to work with in this particular area. The fundamental thing […]

Introduction PowerPivot builds on existing Excel features and extends their functionality. Those familiar with Excel are aware of Pivot tables. Excel typically involves creating a pivot chart with one single data source. PowerPivot allows users to extract data from various sources. These data sources can also be linked to one another with in a PowerPivot […]