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

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 an event
Thumbnail

The Do’s and Don’ts of Records Retention and Destruction at 26468 E Walker Dr, Aurora, Colorado 80016

May 15, 2018 from 1pm to 2:15pm
OVERVIEWEmployers have lots of information on their employees – from social security numbers to disciplinary records.  It is impossible to keep everything indefinitely. Destroying documents too soon, however, will inevitably lead to serious consequences. When can you destroy documents safely and legally?WHY SHOULD YOU ATTENDThe process of organizing, saving, and destroying company records can be confusing even for a seasoned professional. Save too many files, and your company will pay…See More
56 minutes ago
Nicole J Gomez posted a blog post

Instant Drug Testing versus Laboratory Testing at a Workplace: How Do They Compare?

The much-awaited 2016 report on the latest substance abuse trends in the U.S. reveals that nearly 29 million Americans are dealing with drug addiction and a huge proportion of…See More
3 hours ago
Training Doyens posted events
Friday
Tytti posted a blog post

Pro-Sapien announces new hosting service for Office 365 EHS software deployments

The new hosting service will open up the award-winning EHS system to mid-market organizations using Office 365 but who have not invested in Azure, the Microsoft Cloud.APRIL 19, 2018GLASGOW, UK • Pro-Sapien, provider of enterprise EHS&Q software on SharePoint and Office 365, has today announced an additional hosting option for clients. New customers can now opt to have Pro-Sapien manage the IT infrastructure, Microsoft Azure, required to access the EHS program.Up until now, clients using…See More
Friday

Forum

Python Condition Objects Tutorial in 2018

If you have knowledge of other programming languages, then you would know the importance of conditional statements. Conditional statements are required for taking decisions. Whenever we operate the…Continue

Tags: course, certification, training, languages, programming

Started by Elena Lauren Apr 2.

Automation Anywhere. How do I pick a value from dropdown 1 Reply

Automation Anywhere. How do I pick a value from dropdown. I tried 'set text' from a copied variable. Its very slow, and also doesnt…Continue

Tags: anywhere, automation

Started by emmablisa. Last reply by venkatesh Mar 29.

Agile overcome common software security challenges

Paradoxically, security is a negative goal. To secure something, you must understand how insecure it is. Start by trying to break it or by figuring out how other people might break it. The same is…Continue

Tags: agile, scrum, security

Started by nicolewells Mar 23.

Understanding Data Parallelism in MapReduce

In order to understand the goals of MapReduce, it is important to realize for which scenarios MapReduce is optimized. The MapReduce programming model is created for processing data which requires…Continue

Tags: program, Implementation, Mapreduce

Started by gracylayla Mar 14.

TensorFlow serving vs TensorFlow service

I have a question regarding the difference between TensorFlow Serving versus TensorFlow service. (Sorry that I'm not familiar with this at all.)I found TensorFlow serving's definition, which is "…Continue

Tags: training, online, tensorflow

Started by emmablisa Feb 27.

Badge

Loading…

© 2018   Created by Safety Community.   Powered by

Badges  |  Report an Issue  |  Terms of Service