I want help doing a short instructional presentation and paper for any simple thing in excel.

User Generated

Qbnu0w

Business Finance

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.  

User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

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...


Anonymous
I was having a hard time with this subject, and this was a great help.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags