Description
COURSE OBJECTIVE:
Throughout this course you will learn some of the commonly used
fundamental techniques within Excel. This course is the first in the
series for Excel and provides a good base knowledge for participants.
COURSE FORMAT: This is Part 1 of a series of 4 online 'Excel for
Research' sessions. Part 1 is 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 the fundamental features of 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
The sessions are conducted via the internet and can be attended from any
computer that has an internet connection.
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
Please note: This course is not suitable for complete beginners.
CONTENT
• Use different Excel views
• Keep column and row titles visible at all times whilst scrolling
• Hide and Unhide rows or columns of data
• View multiple worksheets simultaneously
• Organise data by listing in alphabetical or numerical order (Sort)
• Extract subsets of data using criteria (Filter)
DURATION: 2 hrs
COST: Free of charge
|
