|
Course overview
The aim of this module is to enable you to enter and manage data lists
on your worksheet.
Who should attend
Delegates should feel confident in the topics covered in the Microsoft
Excel Creating and Editing module.
Learning outcomes
At the end of the module, you will be able to:
• Create data lists according to Excel layout guidelines to analyse
and manage data effectively
•
Design a data form to input and navigate data, demonstrating the use of
time-saving features for input and retrieval
•
Arrange data alphabetically and left to right using toolbar and menu sort
options to display data in required order
•
Choose simple criteria using top 10 and other filter options to present
data meeting specific conditions
•
Extract data meeting specific criteria making it available in another
location
Course contents
Understanding data lists
Understanding data lists
Creating a data list
Using data forms
Understanding the data form
Using the data form to input data into the data list
Navigating records
Finding records
Sorting data
Using the sort buttons
Sorting by multiple fields
Header rows
Sort orders and sorting by custom lists
Sorting left to right
Using AutoFilter
Enabling AutoFilter
Filtering records using simple criteria
Top 10
Custom AutoFilter
And vs. Or
Advanced filtering
Filtering records using more complex criteria
Creating a criteria range
Filtering a data list in place
Copying to a new location
Filtering unique records only
Using And/Or in the criteria range
Related courses
Creating
and Editing
Worksheets
and Workbooks
Basic Formulas
Charts
Linking
Spreadsheets and Formulas
Advanced Formulas
Summarising
Data Lists
Templates
and Macros
PivotTable
and PivotChart Reports
Home
© Alpha Training | Telephone
020 8658 6994 | Email admin@alphatraining.com
|
