Tag Archives: excel 2010

Slicers, newest excel solution for business intelligence

  By iip | December 23, 2010 - 9:25 pm | Spreadsheet tips
Comments Off

The world most popular spreadsheet application has new feature for business intelligence. It’s call slicers, a visual controls that allow excel 2010 user to quickly and easily filter data in an interactive way. Yes, it only available in latest Microsoft Excel 2010. Slicers float above the , just like charts.

Some reviewers highlight the tool as main reason if user really want to move from previous Excel. There are some changes from Excel 2007, but slicers is one of the stunning change. Users who always optimize their work with charts, pivot table  will benefit more from slicer. Slicers also linkable to pivotchart and cube function — a path to develop interactive dashboards.

Some brief explanation below you may find in online excel training or  in the best selling book on Excel 2010:

(more…)

Related terms
    excel 2007 slicer, slicer in excel 2007, slicers excel 2007, advatages excel slicers, slicers en excel 2007, slicer 2007, from where do i download slicer for excel 2007, excel 2010 slicers tips, excel 2010 slicer examples

10 tasks completed by VBA

  By iip | July 22, 2010 - 11:55 am | Spreadsheet tips
1 Comment

Here some tasks that can handled by Visual Basic Application (VBA) –a programing language developed by Microsoft.  Experts say, VBA is the tool that people like to develop programs that control Microsoft Excel.

I realize, that some of you maybe have read Excel VBA Programming for Dummies –this is a good guidance for most of us who like to learn VBA from the begining. That’s okay, I’ll only put a few things of the VBA capacity to finnish some tasks. Here:

(more…)

Related terms
    tasks vba, vba task respond, vba tasks