Find Seminars by Online Compliance Panel and others

 

 

Mastering Excel PivotTables: Crunch Data More Efficiently Now!  

By:

Online Compliance Panel

Mastering Excel PivotTables: Crunch Data More Efficiently Now! seminar agenda print utility

dates/locations

For:

This webinar will be beneficial for anyone familiar with many of Excel's features, but who might have had little or no experience with using PivotTables

Cost:   

Visit FindaSeminar.com for seminar cost, group discount etc.

Seminar Summary:

In this session by expert speaker Dennis Taylor, you will learn the quickest and best ways to create PivotTables and Pivot Charts in Excel to analyze and represent data. This will be presented in Excel 2013 with references to Excel 2010 & 2016. Tools such as Sorting and Filtering in Excel allow users to easily manage large lists of data. However, if you require analyzing every data quickly, PivotTable is the best available option. Based on the huge data, you can quickly create a compact summary report without the use of complex formulas or lengthy techniques. (see full course description)

 

View dates/locations for this event on FindaSeminar.com then register online

 
 

Training Course Syllabus:


Mastering Excel PivotTables: Crunch Data More Efficiently Now! Webinar

The PivotTable feature is perhaps the best analytical tool in Excel. You get amazing dynamism and flexibility, in addition to its speed, which lets you to quickly change the data interrelationships that you are viewing. It has been noticed that most PivotTable users find the feature relatively easy to learn; however, not so easy if you are simply reading the instructions from a printed page. This is a visually-oriented feature which is based on displaying fields in various locations. You will be amazed to see how in very little time, you can create a complete summary reports with tons of data and you won´t even require to rely on obscure techniques or complex formulas.

Objectives of the Presentation

In this webinar, you will learn how to:
Use the Recommended PivotTables button to create PivotTables that will best suit your data so you don´t spend time building features manually
Learn the concept of drill-down to instantly see the detail records that comprise a summary total
Sort PivotTable data by field or content without command or formulas
Analyze your data by year, quarter, month, or hour with one click
Use Slicers as interactive filters
Create and manipulate a visual display of your data with Pivot Charts
Group data spontaneously to reveal new summary information not in the source data
Utilize the Timeline feature to simplify time-based filtering

Why Should you Attend

When you need to crunch database-like data, you can only go so far with sorting, filtering, and inserting subtotals.

What you need are ways to create summary totals based on multiple criteria and the ability to interchange fields, add other fields, and sort results in a flash. Moreover, how great would it be if you could do all these things and never need to deal with complex, lengthy formulas?

The Microsoft® Excel PivotTable tool gives you all of these capabilities, plus dozens of display and manipulation features.

Consider this scenario: You have thousands of detailed rows of sales data covering a five-year period, containing the names of salespersons, sales dates, items sold, location of sales by state and region, names of buyers, dollar amounts, and more. Imagine if you could quickly create a table to show the total sales by salesperson by state without writing any formulas and complete the task in less than 10 seconds!

Then, without skipping a beat, alter that table to show total sales by month or by year simply by changing a field´s location! The possibilities are seemingly endless, and you can apply these same tools just as easily to a variety of data; perhaps an HR list, an inventory list, a detailed budget, a contact list and so on.

This webinar shows you exactly how to use the PivotTable tool to quickly analyze even huge amounts of data in less time than you ever thought possible.

Areas Covered

A PivotTable is Excel´s premier analytical tool for quickly creating summary information that you can easily drag-and-drop to manipulate and show multiple levels of totals in a variety of layouts.

PivotTables offer total flexibility:
Compare multiple field summary contents
Change row/column layouts
Perform ad hoc grouping of information
Drill down to see the details behind a summary
Categorize date/time data on multiple levels
Create visual displays with pivot charts

Who will Benefit

This webinar will be beneficial for: Anyone familiar with many of Excel's features, but who might have had little or no experience with using PivotTables and those users familiar with PivotTables but new to Excel 2013 or 2016. Although widely used with financial data, you can create PivotTables based on a variety of source data-the feature is potentially valuable to nearly all Excel users.

Seminar Summary:

In this session by expert speaker Dennis Taylor, you will learn the quickest and best ways to create PivotTables and Pivot Charts in Excel to analyze and represent data. This will be presented in Excel 2013 with references to Excel 2010 & 2016. Tools such as Sorting and Filtering in Excel allow users to easily manage large lists of data. However, if you require analyzing every data quickly, PivotTable is the best available option. Based on the huge data, you can quickly create a compact summary report without the use of complex formulas or lengthy techniques. (see full course description)

 

Findaseminar.com seminars and training FindaSeminar.com is a member of the Seminar News Network and Training News Network Copyright 2008-2014.

FindaSeminar is a registered Trademark of FindaSeminar.com a division of Allied Internet Solutions Inc.