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: 37

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

Russel Stuart posted a blog post

Diversity in the Workplace is all About Embracing Differences

Diversity in the workplace brings different perspectives and thinking into the workplace. It helps employees learn to understand each other better and removes insularity.If there is one mantra that is most commonly associated with the modern workplace, it has to be diversity in the workplace. Diversity in the workplace has gained greater momentum in this age of globalization. World over, there is a tendency to accommodate multiculturalism through a diverse workplace. Diversity at the workplace…See More
3 hours ago
Russel Stuart posted events
5 hours ago
Adam Fleaming posted a blog post

Facts about the (food and beverage) industry that could [surprise] you

Like any other industry, the food and beverage industry too, is unique in its own way, carrying its own set of characteristics. It is a curious mix of the big and the small, not only in terms of the size of companies in it, but also the reach of these companies.In a sense, the food and beverage industry is a global one, if only because almost no part of the world is excluded from it. It can be said to global from another perspective: Many players in the food and beverage industry are real…See More
5 hours ago
Nakul Pratap posted a blog post

Why Choose GWG is a Right Choice take Nebosh Course in Chennai?

NEBOSH International General Certificate is a globally regarded health and safety Certification which is expected for firms or folks being employed to international standards with respects to Health, Safety & Environment as this program focuses on the International Labor Standards (ILO) codes of training. It offers a important overview, and is a sound basis for promote skilled study and is a…See More
5 hours ago

Forum

Workplace health and safety Signs 4 Replies

You cannot ignore the importance of safety signs at your workplace. There is no scope to underestimate the important to health and…Continue

Tags: Prohibition, Workplace, Warning, Signs, Safety

Started by healthandsafetysigns. Last reply by Jen McDade on Monday.

Jewellery policy - breakaway pins

Hello,Hopefully someone has come up against this, my employers have implemented a jewellery policy; its a bit over the top but they are keen on enforcing it.As is the tendency with anything…Continue

Tags: watches, heavy machinery, industry, Jewellery

Started by Brent Sep 10.

Secure Yourself From The Impending Danger 3 Replies

The most important thing in life is one’s protection against the impending dangers of life. While working or even at home we all feel the need to be safe because if we have good and safe life, only…Continue

Tags: coverings, Protective

Started by Enna Henry. Last reply by Jen McDade Sep 7.

How To Get The Safest Personal Protective Equipment? 2 Replies

Worried about the safety issues? Feeling a little concerned about the safety factors? Running a company and the safety problems are bothering you? Feel relaxed and look for the best safety solutions…Continue

Tags: equipment, protection, personal

Started by Enna Henry. Last reply by Jen McDade Aug 31.

Safety Books 1 Reply

Please view this brochure and let me know if you are ok with the condition before we can share full books of safety…Continue

Started by Binh, M.S, Grad.IOSH, MIIRSM. Last reply by Jen McDade Aug 31.

Badge

Loading…

© 2018   Created by Safety Community.   Powered by

Badges  |  Report an Issue  |  Terms of Service