Online Safety Community

How to create Slicers which are the New Visual way to Filter a Pivot Table

Microsoft Excel can be used to carry out a number of functions such as sorting, filtering, and subtotal to manage large lists of data. Yet, its MS Excel PivotTable is a very useful feature when it comes to analyzing all that data and doing it quickly. Its use is all the more pronounced when the user is required to quickly create a compact summary report (based on lots of data) without having to write complex formulas or rely on lengthy techniques.

Being very versatile, MS Excel PivotTable is often considered Excel’s best analytical tool because it complements speed with amazing flexibility and dynamism, by which the data interrelationships that are being viewed can be changed. It is so practical that its features can be put to practical use by actually getting down to work on it, even if a user doesn’t go through the instructions on the printed page, which is a visually-oriented feature based on displaying fields in different locations. With MS Excel PivotTable, it is possible to create a complete summary report with heaps of data in very little time without having to write complex formulas and rely on obscure techniques.

Thorough learning about all the features and aspects of PivotTable from the MS expert

A webinar that is being organized by Compliance4All, a leading provider of professional trainings for all the areas of regulatory compliance, will offer complete learning on the numerous PivotTable capabilities and its many tools and features.

The speaker at this session is Dennis Taylor, an Excel expert who has worked extensively with Microsoft products (especially spreadsheet programs) since the mid-1990’s and has taught hundreds of workshops and authored numerous works on this program. Please register for this webinar by visiting best ways to create PivotTables and gain complete insights into the ways by which to put the full range of functionalities of MS Excel PivotTable to use.

PivotTable simplified

Teaching participants the quickest and best ways to create PivotTables and Pivot Charts is the main objective of this webinar. These include the following capabilities:

o  How to compare two or more fields in a variety of layout styles

o  How to sort and filter results

o  How to perform ad-hoc grouping of information

o  How to use Slicers instead of filters to identify which field elements are displayed

o  How to drill down to see the details behind the summary

o  How to categorize date/time data in multiple levels

o  How to create a Pivot Chart that is in sync with a PivotTable

o  How to add calculated fields to perform additional analysis

o  How to hide/reveal detail/summary information with a simple click

o  How to deal with dynamic source data and the “refresh” concept

o  How to create a PivotTable based on data from multiple worksheets.

All these aspects will be covered in detail. Dennis will also cover the following areas at this session on MS Excel PivotTable:

o  Pre-requisites for source data – preparing data so that it can be analyzed by PivotTables

o  Creating a PivotTable with a minimum number of steps, including the Recommended PivotTables option

o  Manipulating the appearance of a PivotTable via dragging and command techniques

o  Using Slicers to accentuate fields currently being shown (and which ones are not)

o  Using the new (in Excel 2013) Timeline feature

o  Creating ad hoc and date-based groupings within a PivotTable

o  Quickly create and manipulate a Pivot Chart to accompany a PivotTable

Apart from MS Excel users who are familiar with PivotTable concepts, but need expanded techniques to analyze lists of data; anyone needing to know how to create PivotTables from multiple sources and use Slicers, Timelines, Calculated Fields, and Conditional Formatting will also benefit from this course.

For Depth info

Views: 12

Comment

You need to be a member of Online Safety Community to add comments!

Join Online Safety Community

Take our poll!

Take our poll!

Latest Activity

Training Doyens posted events
1 hour ago
Training Doyens updated an event
Thumbnail

Form I-9 Compliance at 26468 E Walker Dr, Aurora, Colorado 80016-6104

January 25, 2018 from 1pm to 2pm
OVERVIEWDon't spend another day worrying that you and your organization might end up in legal trouble from immigration law violations. The crucial information provided in this one-hour webinar will give you the knowledge and know-how needed to ensure your documentation is filled out appropriately, your records are kept correctly and your organization is legally compliant.WHY SHOULD YOU ATTENDImmigration law is one of the most pertinent and publicized issues in the United States right now.…See More
2 hours ago
John Robinson posted a blog post

The FDA's requirements for non-IND Foreign Clinical Studies

The FDA grants marketing approval for certain types of medical products whose application is the result of foreign clinical studies, provided the products and the clinical studies meet certain conditions. The types of medical productshttps://globalcompliancepaneltraining.files.wordpress.com/2017/12/the-fdas-requirements-for-non-ind-foreign-clinical-studies-2.jpg?w=800&h=504…See More
21 hours ago
Training Doyens posted an event
Thumbnail

Excel - Pivot Tables 101 at 26468 E Walker Dr, Aurora, Colorado 80016-6104

December 20, 2017 from 1pm to 2:30pm
OVERVIEWPivot Tables are one of the most powerful tools in Excel’s data analysis and Business Intelligence (BI) armory. With just a few clicks of the mouse (and no complicated formulas!) you can quickly and easily build reports and charts that summarize and analyze large amounts of raw data and help you to spot trends and get answers to the important questions on which you base your key business decisions.WHY SHOULD YOU ATTENDLearning how to create Pivot Tables is one of the must have skills…See More
yesterday

Forum

PEGA Axis error: Parser already accessed

We have a PEGA frontend, from in which we're keying in double byte characters like japanese and being send to allotted java webservice through axis. this is working best when we ship singlebyte…Continue

Tags: pega_training, pega_online, pega

Started by Soujanya Naganuri on Thursday.

VMware player error on install vmware tools.

 I've installed the last version of VMware player (4.0.2) and created a virtual machine with ubuntu 10.04. However, some operations with …Continue

Tags: training, online, vmware

Started by emmablisa Dec 1.

All About QlikView

QlikViewQlik relies on sophisticated analytics that enables data discovery using an in-memory engine to analyze data for patterns not visible via SQL data structures or queries. The company’s two…Continue

Tags: Safety, Qlikview

Started by nicolewells Nov 25.

Occupational Health and Safety 5 Replies

Health and safety are important aspects of an organisation’s smooth and effective functioning.  Did you know that workplace health & safety injuries cost Australian businesses over $60 billion…Continue

Tags: Safety, and, Health, Occupational

Started by WHS Solutions. Last reply by Tara safe Nov 16.

QlikView for its Safety Strategic Business Intelligence Solution Worldwide

QlikTech (NASDAQ:QLIK), a leading…Continue

Tags: Qlikview, safety

Started by nicolewells Nov 15.

Badge

Loading…

© 2017   Created by Safety Community.   Powered by

Badges  |  Report an Issue  |  Terms of Service