Excel 2000 Proficient

Designed for: Beginners new to spreadsheets who wish to progress to learn Excel 2000 to the Microsoft Office Specialist (MOS) proficient syllabus. Prerequisites: Experience of using a Windows operating system and ideally keyboarding skills.

Objectives: To teach elementary and intermediate spreadsheet skills using this current Microsoft program. Course Content

• Lesson 1: Creating a spreadsheet.  Entering text and numbers.  Navigating a spreadsheet. Saving, naming and closing a spreadsheet.  Opening an existing spreadsheet.  Editing cell contents.
• Lesson 2: Formatting and selecting cells and ranges.  Text alignment, merging and centring.  Printing.  Inserting and deleting rows.  Simple formulas.  Moving and copying cells.  AutoFill and editing formulas.
• Lesson 3: Using AutoComplete.  Freezing and unfreezing panes.  Text orientation and page break preview.  Changing page orientation.  Adjusting margins and scaling.  Centring horizontally and vertically.  Displaying gridlines.  Inserting headers and footers.  Printing selected data.  Naming a worksheet and deleting a worksheet.
• Lesson 4: Using AutoCalculate and applying absolute cell references.  Cell formatting.  Using more complex formulas.  Applying borders. Using styles.
• Lesson 5: Inserting a new worksheet. Naming a worksheet.  Grouping and ungrouping worksheets.  Applying wrap text formatting and indenting text.  Creating linked formulas.  Printing row and column headings.  Centring text horizontally and vertically.
• Lesson 6: Using the SUM and COUNT functions.  Using the formula palette to enter formulas for AVERAGE, MAX and MIN.  Sorting columns.  Using the NOW, DATE, IF, PMT and FV functions.
• Lesson 7: Using the Chart Wizard. Formatting and editing charts.  Saving selected data and a workbook as a web page.  Inserting and using a hyperlink.  Sending a workbook via email.  Deleting an object.  Using find and replace

Benefits

• Know how to use Excel 2000 in order to sit the MOS examination at core user level
• The flexibility and value of a self-study course designed to enable you to work at your own pace
• A personalised workbook to use and keep as a reference guide on completion of the course
• The opportunity to gain a widely recognised Pitman Training Certificate

Course duration: 18-20 hours What next: Excel 2000 expert

Current Course Dates

As many of our Courses have flexible start dates, or are run as closed events, all available dates may not appear below.  Please Contact Us for details.