By the end of this course you will be able to design spreadsheets utilising basic functions, formulas and graphs.
What skills will the delegate gain?
This course will enable delegates to:
Navigate around Microsoft Excel.
Enter and Edit data.
Use Copy, Cut and Paste in Excel.
Create basic formula using functions.
Create charts and graphs.
Understand the Web functionality of Excel.
Who will the course benefit?
Anyone wishing to learn the essential skills in using Excel 2002 proficiently for the creation of spreadsheets, data manipulation and presentation.
This course requires that you have a good working knowledge of Microsoft Windows.
This course, along with Intermediate and Advanced, covers the curriculum for the ECDL exam.
Training is available on previous versions.
Exploring the Excel window.
Opening and navigating a workbook.
Closing a workbook.
Entering and Editing Data:
Creating a new Excel workbook.
Entering and editing labels and values.
Entering and editing formulas.
Saving and updating a workbook.
Preparing to print.
Page set up options.
Modifying a Worksheet:
Moving and copying data.
Moving and copying formulas.
Using absolute references.
Inserting and deleting ranges.
Using AVERAGE, MIN, MAX, and COUNT.
Formatting rows and columns.
Other formatting features.
Creating a chart.
Saving a worksheet as a web page.
Sending a workbook via email.