Mastering Excel Pivot Tables
Short course
Online
*Indicative price
Original amount in USD:
$ 150
Description
-
Type
Short course
-
Level
Advanced
-
Methodology
Online
-
Class hours
1h
-
Duration
1 Day
-
Start date
January
-
Virtual classes
Yes
How to create a pivot table from multiple tables and multiple data sources, including linking to external data.
Facilities
Location
Start date
Start date
Reviews
Subjects
- Excel
- Technology
- MS Excel
- Education
- Compliance programs
- Online Trainings
- Medical courses
- Excel courses
- Future Education
- Best trainings
Teachers and trainers (1)
Adam Fleming
Event Manager
Compliance4All is a professional trainings provider for the regulated industries. It offers professional trainings for regulatory compliance professionals and offers innovative strategic consulting and advice to a broad range of organizations. These services help them to be compliant with regulatory requirements. . Compliance4All has a panel of acclaimed Experts whose professional trainings help regulatory professionals and organizations in a number of ways and take them to their goal of meeting regulatory requirements.
Course programme
Why should you Attend:Excel has a variety of tools like sorting, filtering, and subtotal to manage large lists of data, but if you need to analyze all that data and do it quickly, there's no better feature than a PivotTable. You can quickly create a compact summary report (based on tons of data) without needing to write complex formulas or rely on lengthy techniques.
Areas Covered in the Session:Manipulating the appearance of a PivotTable via dragging and command techniquesUsing Slicers to accentuate fields currently being shown (and which ones are not)Using the new (in Excel 2013) Timeline featureCreating ad hoc and date-based groupings within a PivotTable
Who Will Benefit:Excel users who are familiar with PivotTable conceptsNeed expanded techniques to analyze lists of dataCreate PivotTables from multiple sourcesCalculated Fields, and Conditional Formatting
Speaker Profile:Dennis Taylor has worked extensively with Microsoft Excel since the mid-1990s. He’s traveled the United States and Canada presenting seminars and classes to help attendees unlock the full potential of Excel.
Event Fee: One Dial-in One Attendee Price: US $150.00
Contact Detail:Compliance4All DBA NetZealous,Phone: +1-800-447-9407Email: compliance4all14@gmail.com
Additional information
Mastering Excel Pivot Tables
*Indicative price
Original amount in USD:
$ 150