Description
COURSE OBJECTIVE:
This online course introduces a range of practical Excel techniques
designed to help you work more efficiently with worksheets and data.
You will learn how to use different worksheet views to focus on your
work, freeze rows and columns to keep important information visible
while scrolling, and split worksheets into separate panes for easier
navigation.
The course also covers how to hide and unhide rows and columns to manage
large datasets, configure page setup options for printing or creating
PDF copies, and use Find and Replace to quickly locate and update
information throughout a workbook.
These skills will help you navigate, manage and present your Excel data
more effectively
COURSE FORMAT:
The course involves explanation, demonstration and hands-on practice,
working through exercises that build on your existing skills and
increase the functionality of spreadsheets.
PREREQUISITES:
Participants should have a basic knowledge of Excel and be able to
select cells, enter & edit data, format data and use the cut/copy &
paste technique.
CONTENT
• Work in different worksheet views
• Freezing rows and columns to keep titles visible
• Split the window to view different parts of the worksheet at the same
time
• Hiding/displaying columns and rows
• Find and replace data
• Change page set up for printing (including PDF)
Duration: 2 hrs
Cost: Free
Suitability: Staff
|
