Description
COURSE OBJECTIVE:
Throughout this course you will learn how to create and manipulate a
Pivot Table to generate statistics and summarise large amounts of data
without the need to write formula.
COURSE FORMAT: Part 4 is the final part of a series of 4 online 'Excel
for Research' sessions. Parts 1, 2 & 3 are not required as a pre-
requisite however, if you would like to attend all 4 sessions then it is
recommended that they are undertaken in order.
The online course is delivered by a facilitator completely online via
Microsoft Teams and the "virtual classroom" is accessed through the
internet.
Practice exercises and tasks are included in the session to help you
master Pivot tables in Excel. You will need the Excel software installed
on your computer to complete the exercises. (If you do not have the
software, please install it well in advance of the session):
Excel for home use can be downloaded for free and instructions are
included on the following page: https://it.leeds.ac.uk/it?
id=kb_article&sysparm_article=KB0011037
Windows 10 & Excel 365 for PC are used throughout the course. If you
are using Excel for mac, you may find that not all of these features are
available on mac.
PREREQUISITES
Participants should be familiar with the Excel interface (Ribbon,
Quick Access Toolbar, Formula bar etc.) and possess a basic knowledge of
Excel. Before attending this course you should be able to complete the
following tasks:
• Open, save and close Excel files
• Select cells, columns & rows
• Insert/delete cells, columns, rows, or worksheets
• Enter, Edit, delete & Format data
• Move or copy data to other worksheets
• Amend column width and row height
• Use Autofill and the various Autofill options
• Create a basic formula using Brackets, Divide, Multiply, Add, and
Subtract
• Create Descriptive Statistics
Please note: This course is not suitable for complete beginners.
CONTENT
• Understand the purpose of a Pivot Table
• Create a Pivot Table
• Work with Pivot Fields
• Change the calculation in a Pivot Table
• Show data as percentages
• Group Pivot Table Data
• Refresh Pivot Table Data
DURATION: 2 hrs
COST: Free of charge
|
