|
Course overview
The aim of this module is to enable users to effectively understand and
use the concepts of a multiple sheet workbook.
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:
• Manage worksheets by inserting/deleting worksheets and identifying
with different sheet tab colours, to present information in a clear and
concise manner
•
View worksheets utilising zoom, page break preview and custom views to
investigate the most effective way to view worksheets
•
Practice keyboard shortcuts, navigating worksheets and menu options to
determine the most efficient methods of working with worksheets
•
Create name ranges for cells and cell ranges and use within calculations
and for navigation
•
Change page setup adjusting margins, alignment and sheet options to ensure
professional presentation, first time
•
Choose locking features to lock cells, worksheet and workbook ensuring
protection against changes
Course contents
Managing worksheets
Inserting and deleting sheets
Moving and copying sheets within and between workbooks
Renaming and colouring sheet tabs
Selecting and grouping sheets
Working in different views
Full screen and zooming
Normal and page break preview
Custom views
Splitting the screen and freezing panes
Save workspace
Keyboard shortcuts
Navigation shortcuts
Selection shortcuts
Naming ranges
Naming cells and cell ranges
Navigating cell ranges
Using range names in simple calculations
Changing page setup
Changing page margins
Centring on page
Headers and footers
Sheet options, e.g. print area and titles, gridlines and page order
Locking and protecting
Locking cells
Protecting the workbook
Protecting the worksheets
Related courses
Creating
and Editing
Basic Formulas
Charts
Linking
Spreadsheets and Formulas
Advanced Formulas
Sorting
and Filtering Data Lists
Summarising
Data Lists
Templates
and Macros
PivotTable
and PivotChart Reports
Home
© Alpha Training | Telephone
020 8658 6994 | Email admin@alphatraining.com
|
