Online Safety Community

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

Microsoft Excel comes with a myriad of tools such as sorting, filtering, and subtotal to manage large lists of data. Yet, when it comes to analyzing all that data and doing it quickly, the MS Excel PivotTable is a very useful feature. It is particularly important and useful when the user is required to quickly create a compact summary report (based on lots of data) without needing to write complex formulas or rely on lengthy techniques.

Excelhttps://compliance4all14.files.wordpress.com/2017/07/excel1.jpg?w=150&h=84 150w, https://compliance4all14.files.wordpress.com/2017/07/excel1.jpg?w=3... 300w, https://compliance4all14.files.wordpress.com/2017/07/excel1.jpg 750w" sizes="(max-width: 490px) 100vw, 490px" width="490" height="276" />

MS Excel PivotTable is very versatile. It is considered Excel’s best analytical tool because in addition to speed, it also comes with amazing flexibility and dynamism the data interrelationships that are being viewed can be changed. It is easier to put the PivotTable MS Excel features into practical use by actually getting down to work on it, rather than trying to pore through the instructions on the printed page, which is a visually-oriented feature based on displaying fields in different locations. It offers the ability 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.

Learn about all the features and aspects of PivotTable from the MS expert

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

excel-pivot-table-tutorialhttps://compliance4all14.files.wordpress.com/2017/07/excel-pivot-table-tutorial.png?w=150&h=88 150w, https://compliance4all14.files.wordpress.com/2017/07/excel-pivot-ta... 300w, https://compliance4all14.files.wordpress.com/2017/07/excel-pivot-ta... 600w" sizes="(max-width: 361px) 100vw, 361px" width="361" height="212" />

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; will be the speaker at this session. Just visit Excel PivotTables to register for this webinar and gain complete insights into the ways by which to put the full array of functionalities of MS Excel PivotTable.

Simplifying the use of PivotTable

The main objective that Dennis Taylor has for this webinar is to familiarize participants with the quickest and best ways to create PivotTables and Pivot Charts. These include the following capabilities:

  • How to compare two or more fields in a variety of layout styles
  • How to sort and filter results
  • How to perform ad-hoc grouping of information
  • How to use Slicers instead of filters to identify which field elements are displayed
  • How to drill down to see the details behind the summary
  • How to categorize date/time data in multiple levels
  • How to create a Pivot Chart that is in sync with a PivotTable
  • How to add calculated fields to perform additional analysis
  • How to hide/reveal detail/summary information with a simple click
  • How to create a PivotTable based on data from multiple worksheets.

He will cover these in detail. In addition, he will cover the following areas at this session on MS Excel PivotTable:

  • Pre-requisites for source data – preparing data so that it can be analyzed by PivotTables
  • Creating a PivotTable with a minimum number of steps, including the Recommended PivotTables option
  • Manipulating the appearance of a PivotTable via dragging and command techniques
  • Using Slicers to accentuate fields currently being shown (and which ones are not)
  • Using the new (in Excel 2013) Timeline feature
  • Creating ad hoc and date-based groupings within a PivotTable
  • Quickly create and manipulate a Pivot Chart to accompany a PivotTable

MS Excel users who are familiar with PivotTable concepts, but need expanded techniques to analyze lists of data are among the primary beneficiaries of this webinar, but 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.

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

nicolewells posted a discussion

Security Storage SAN Performance

Hello All,Have a question regarding SAN performance specifically EMC VNX SAN. I have a significant number of processes spread over number of blade servers running concurrently. The number of processes is typically around 200. Each process loads 2 small files from storage, one 3KB one 30KB. There are millions (20) of files to be processed. The processes are running on Windows Server on VMWare. The way this was originally…See More
yesterday
Rebecca Lewis posted a discussion

What safety signs should I acquire for my shop’s construction?

Hello everyone! The construction of my new flower shop will start next month, and it’s a big project for me. Since the shop’s location is near the main road, I want to make sure that everyone is safe during the work. I can’t afford any accident like people getting injured. So I’m thinking of purchasing construction health and safety signs from a supplier that my friend recommended.…See More
Friday
Rebecca Lewis joined Safety Community's group
Thumbnail

Construction

For those working in Carpentry, Drywall, Electric, General Labor, HVAC, Landscaping, Masonry and Plumbing.
Friday
Adam Fleaming posted a blog post

FMEA in medical devices can work better when mated with ISO 14971

Failure Mode and Effects Analysis (FMEA) is a core aspect of risk management and risk analysis in medical devices. FMEA is essentially about analyzing the reasons for which a problem arises and the effects it has on the system. In the field of medical devices, it is absolutely critical to understand the failure mode and effects because the consequences of not doing this can be disastrous and many times, even…See More
Friday

Forum

Forklift Operator Requirements 1 Reply

At our company we have a lot of forklift traffic that has to share the same aisles as our pedestrians. We limit the speed of our lifts to 3 mph.  I am wanting to find out what requirements for…Continue

Started by Rick Briggs. Last reply by Tony Ferraro 1 hour ago.

What safety signs should I acquire for my shop’s construction? 1 Reply

Hello everyone! The construction of my new flower shop will start next month, and it’s a big project for me. Since the shop’s location is near the main road, I want to make sure that everyone is safe…Continue

Started by Rebecca Lewis. Last reply by Tony Ferraro 1 hour ago.

Security Storage SAN Performance

Hello All,Have a question regarding SAN performance specifically EMC VNX SAN. I have a significant number of processes…Continue

Tags: san, vmware, emc

Started by nicolewells yesterday.

Gig Economy

The career world has rapidly changed and these days, long-term careers and people working in just one job are slowly but steadily becoming a thing of the past. In fact, according to research, in the…Continue

Tags: field, engineer, IT, freelance, economy

Started by Mohd Azher on Wednesday.

How to Repair MySQL InnoDB Table That Has Issues?

When trying to run: delete IdentityRequest *I get an error of sailpoint.tools.GeneralException: null index column for collection: sailpoint.object.IdentityRequest.itemsDoing a select * from…Continue

Tags: course, sailpointonline, sailpoint

Started by Soujanya Naganuri on Tuesday.

Badge

Loading…

© 2018   Created by Safety Community.   Powered by

Badges  |  Report an Issue  |  Terms of Service