|
Course overview
By the end of this module you will be able to navigate the screen, create
spreadsheets, perform basic calculations, edit existing spreadsheets,
and view and print spreadsheets - and apply these skills within the context
of your job.
Who should attend
Users who are new to Excel and wish to create worksheets from scratch.
Learning outcomes
At the end of the module, you will be able to:
• Navigate the screen elements available within the main Excel screen
to investigate the most effective way to select commands
•
Create spreadsheets within Excel workbooks, entering different types of
data, and save in the most appropriate location
•
Perform basic calculations to divide, multiply, add, subtract and AutoSum
data within selected cells and ranges
•
Edit existing spreadsheets controlling the accuracy and layout of data
to present business information in the most effective way
•
View and print spreadsheets managing the core page layout features to
ensure professional presentation, first time
Course contents
Navigating screen elements
Starting Excel
Toolbars and menus
The task pane
The name box and formula bar
What is a spreadsheet?
Creating workbooks
Creating workbooks
Navigating the workbook
Selecting cells
Understanding data types
Entering text and numbers
Saving workbooks
Performing basic calculations
Entering simple formula, e.g. to add, subtract, multiple and divide
Entering simple functions, e.g. SUM
AutoSum
Using AutoFill
Editing and formatting workbooks
Opening workbooks
Editing cells
Undo, redo and repeat
Resizing column width and row height
Inserting and deleting columns and rows
Moving and copying data
Applying basic cell formatting, e.g. font, bold, size, colour
Printing workbooks
Page Setup - orientation and scaling to one page
Previewing worksheets
Printing workbook
Related courses
Worksheets
and Workbooks
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
|
