Description
Conduct a simulated “Training Video Conference Call”. The intent of this presentation is to conduct a 5 min training session on a piece of software of the student’s choice. However the software does not have to be engineering related but must be class room appropriate. Finally the training presentation will be accompanied by a supplementary instructional document. The intent of this document is to simulate a hand out supplied to a work group audience for reference BOTH during the training and after as reference material that a co-worker could go back to when they try to use the software that they were training on. There is no page requirement for the instructions but they are expected to be thorough and have the appropriate visual aids to be used as a stand alone set of instructions.
Explanation & Answer
Attached.
Creating Pivot
Tables
NAME:
INSTITUTION:
Introduction
A pivot table is a strong Excel tool
It is used to summarize data
It is helpful in extracting significant information from a large data file
It is helpful in the analysis of data without formulas
Introduction Cont…
A pivot table is also helpful in easing the presentation of data.
It enables one to attain the idea of what the entire data is all about.
Its multifaceted view of data is imperative.
It enables one to make wide conclusions regarding a dataset.
Create a data list of at
least three columns to
which will be used to
develop the pivot table
Highlight the data and click
on the insert button then click
on the pivot table located on
the far left
Once you click on the pivot table button, a dialogue box appearing on the right side will
appear
On the dialogue box which appears on the right side, click on the “OK” button located at the
bottom
A dialogue box will appear on the
right end to show where the pivot
table will appear once the “OK”
button is clicked.
Check all the boxes showing the titles of variables appearing on the dialogue box on the right side
A pivot table bearing a summary of information in the dataset appears on the left side.
Running head: CREATING PIVOT TABLES
Creating Pivot Tables
Name
Institutional Affiliation
CREATING PIVOT TABLES
2
Introduction
A pivot table is a strong Excel tool used to summarize data. It is helpful in extracting
significant information from a large d...