Categories
Microsoft Excel

Creating Slicers in Excel

Slicers are special field filters that can be applied to Excel tables. They are most useful for further dissecting an existing PivotTable report in a worksheet. Slicers are actually graphics objects comprising of a rectangle and special filter buttons. Slicers are inserted into the worksheet from the Slicer command on the INSERT tab of the ribbon.

Categories
Microsoft Excel

Understanding Power Pivot in Excel

Excel’s reputation as an analysis tool grows with each successive upgrade. While data analysis was originally confined to data in a worksheet, Excel is now being used for analysing data from a variety of sources including databases and larger corporate data sources. Whilst this can be done using Excel itself, Power Pivot is an add-in that consolidates the steps towards achieving this.

Categories
Adobe Captivate

How to use the Skin Editor in Adobe Captivate

Adobe Captivate has provided its users with a set of default Skins. You are able to fiddle around and change the options available to customise these Skins to suit your preference. The underlying elements of Skins within Adobe Captivate include, playback controls, border and table of contents.

Categories
Adobe Captivate

How to create a Quiz in Adobe Captivate

Adobe Captivate allows users to create interactive Quizzes. These can be added at the end of an information presentation or a quiz in itself. All in all this feature has geared much speculation and applause from users. Continue on to learn how to create a simple quiz.

Categories
Adobe Captivate

How to use Conditional Actions with Quiz in Adobe Captivate

Advanced Actions within Adobe Captivate enable users to work with objects and use them to trigger actions. These actions on objects can be achieved through selection. If you come from a programming you might perceive majority of what advanced actions is dealing with logic through the use of variables, if/else statements, etc. There are two types of actions provided by Adobe Captivate for interactive objects: