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
Microsoft Office Button and Quick Access Toolbar
Ribbon, Tabs and Groups
The name box and formula bar

Creating workbooks
Creating and saving workbooks
Opening and closing workbooks
Navigating workbooks
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
Using AutoSum
Using AutoFill

Editing and formatting workbooks
Editing cells
Using 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

Home

© Alpha Training | Telephone 020 8658 6994 | Email admin@alphatraining.com