On completion of this course, delegates will be able to create, modify and format Spreadsheets using a number of features, as well as creating basic charts. A number of commonly used timesaving features are also introduced giving the necessary skills to use the product effectively.
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 with a need to acquire the basic skills to use Excel 2003 for the creation of spreadsheets and data manipulation. It would also benefit those working towards the ECDL certification.
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 spreadsheet module and 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.
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.