Get & Transform is a powerful data analysis tool in Microsoft Excel that lets you import, refine, and work with data from a range of sources, including files saved on your computer and web pages. You can shape data to display the details relevant to your purposes and hide information that is not required, without making permanent, irreversible changes to the data.
Category: Training (Page 16)
Many documents created today need to be re-purposed for use in different ways. A document originally intended for print will usually be required in a digital format. A document intended for a mobile device such as an iPad will need to be produced in both landscape and portrait orientations. All of this is made possible in InDesign through the use of alternate layouts.
Excel worksheets can be used to keep lists of information such as employee details, subscribers, accounts, sales, or even bird sightings if need be. The Advanced Filter in Excel enables you to analyse data in a list by filtering it based on specific criteria. Excel worksheets can be used to keep lists of information such as employee details, subscribers, accounts, sales, or even bird sightings if need be. The Advanced Filter in Excel enables you to analyse data in a list by filtering it based on specific criteria.
Categories
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.
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.