|
Provided by: INT Information Systems, Inc. Mastering: Microsoft Excel PivotTablesMicrosoft Windows |
 |
|
|
||||||||||||||
- B asked: Please provide information regarding scheduling and fees for this course
- A asked: Where can I enrol in Singapore?
- C asked: Additional information was not available via the site. Can you send me the information and pricing to my e-mail or call --
- H asked: What is your closest training offering to the East Texas area, or do you have online courses/ DVDs/ etc?
- D asked: I am looking for information to attend a hands-on conference regarding Microsoft Excel and/ or Access. Thank you!
- V asked: exact location dates cost of training Thanks
- M asked: final test
- C asked: Request info on upcoming classes for PivotTables (how many days? what times?). Please include cost for attending at your location and cost for setting up training at my company location. Also, do you have online courses for this subject (cost? times?). Thank you,
Excel data tends to be arranged into lists that run hundreds or thousands of rows. Within this forest of unorganized information, there are details to be analyzed, trends to be spotted and data points to be summarized. How do you spot that information?
PivotTables summarize, analyze and report on large lists of data by rearranging the data set into an easy-to-manage overview or summary. Easily built and fluid in their construction, they can be crucial in helping you better understand your data.
The process of creating a basic PivotTable is quite simple but this class covers aspects of PivotTables that are rarely documented in other Excel books or courses. This includes the creation of custom grouping systems (grouping a series of dates by month and year, for example) and frequently-overlooked options that provide powerful methods of reviewing data. Optional sections, covered at the class' request, include sections on working with data in an Access database and the use of the tricky "multiple consolidation ranges" option. As a full day class, there is ample opportunity to review every significant tool offered by PivotTables, as well as answer student questions. The class objectives include:
- Review the basic construction and manipulation of PivotTables: building, rearranging and formatting PivotTables, drilling down to specific information, updating and expanding PivotTables.
- Cover intermediate PivotTable features: arranging data into logical groups, setting up a PivotTable to print similar to an Access report, filtering in PivotTables.
- Discuss advanced PivotTable features: the Data field options, creating calculated fields and calculated items.
- Use PivotTables to analyze complex data: use Access data in a PivotTable, create a PivotTable based on multiple tables.
Visit the class' web page to review the class table of contents and sample pages from the presentation.
