|
Overview
Who is this course for?
As a new user, with little or no experience of Microsoft Excel, the topics covered on this course will gently introduce you to spreadsheet concepts and empower you to create basic spreadsheets.
How long is this course?
1 Day
What do I need to know before attending?
It is assumed only that you have a basic knowledge and understanding of the Windows environment.
What will I expect to achieve at the end of the training?
At the end of this course
you will be able to:
- Use Excel to structure your data.
- Perform automatic calculations.
- Improve the appearance of your work with basic formatting.
- Produce simple charts.
- Produce well presented printouts of data, text and graphs.
- Save your work and retrieve it for future reference or changes.
Price Band:
General
|
Content
Introducing Excel
An overview of the benefits of spreadsheets.
Basic spreadsheet structure.
Tour of the Excel screen, including the ribbon and toolbars.
Using Search to get Help
Spreadsheet Basics
Moving around your spreadsheet
Entering and editing your data using some quick techniques.
Using undo and redo.
Understanding Ranges
Saving and Pinning Files
Calculations
Basic Excel functions including Sum and Average.
Using the Insert Function tool for more complex calculations.
Using Autofill.
Understand Absolute Cell references within formulas.
Tracing formulae.
Working with Spreadsheet Data
Moving, copying and deleting sections of your spreadsheet.
Setting row and column heights.
Inserting and removing columns and rows.
Checking your spelling and correcting mistakes.
Using the Find and Replace tools.
Changing the Appearance
Changing typeface style and size.
Aligning, bordering and shading your data.
Using Excel Themes and Cell Styles.
Charts
Create a basic bar chart.
Format a chart.
Filter a Chart.
Database Functionality
Rules for Creating Database Tables.
Sorting and filtering data.
Printing
Previewing and changing the page layout.
Printing all or part of your work. |
