Our range of one-day IT user courses are designed to give delegates the skills they need to increase productivity, and develop their role within the company. These include generic skills, such as word processing and spreadsheets, as well as more specialised skills for employees in specific roles, such as web design and project management.
 

Excel 2003 Level1
Excel Level1You have basic computer skills such as using a mouse, navigating through windows, and surfing the Internet. You have also used paper-based systems to store data that you run calculations on. You now want to migrate that data to an electronic format. In this course, you will use Microsoft® Office Excel 2003 to manage, edit, and print data.
 

Course Objective: You will create and edit basic Microsoft® Office Excel 2003 worksheets and workbooks.

Target Student: This course is designed for persons preparing for certification as a Microsoft® Office Specialist in Excel, who already have knowledge of the Microsoft® Office Windows 98 (or above) operating system, and who desire to gain the skills necessary to create, edit, format, and print basic Microsoft® Excel 2003 worksheets.
 

Course Content

Lesson 1: Getting Started with Excel

Learn: An Overview of Excel, to Navigate in Excel, Select Data, Enter Data, Save a Workbook, Obtain Help


Lesson 2: Modifying a Worksheet

Learn to: Move and Copy Data Between Cells, Fill Cells with Series of Data, Edit Cell Data, Insert and Delete Cells, Columns, and Rows, Find, Replace, and Go To Cell Data, Spell Check a Worksheet


Lesson 3: Performing Calculations

Learn to: Create Basic Formulas, Calculate with Functions, Copy Formulas and Functions, Create an Absolute Reference
 

Lesson 4: Formatting a Worksheet

Learn to: Change Font Size and Type, Add Borders and Color to Cells, Change Column Width and Row Height, Merge Cells, Apply Number Formats, Create a Custom Number Format, Align Cell Contents, Find and Replace Formats, Apply an AutoFormat, Apply Styles
 

Lesson 5: Developing a Workbook

Learn to: Format Worksheet Tabs, Reposition Worksheets in a Workbook, Insert and Delete Worksheets, Copy and Paste Worksheets, Copy a Workbook

 
Lesson 6: Printing Workbook Contents
Learn to: Set a Print Title, Create a Header and a Footer, Set Page Margins, Change Page Orientation, Insert and Remove Page Breaks, Print a Range

Lesson 7: Customizing Layout
Learn to: Split a Worksheet, Arrange Worksheets, Freeze and Unfreeze Rows and Columns, Hide and Unhide Worksheets

Course Length: 1day
Price: £150 plus VAT

Excel 2003 Level2
Excel Level1In Microsoft® Office Excel 2003: Level 1, you created, edited, formatted, and printed basic spreadsheets. You now have a need to streamline repetitive tasks and display spreadsheet data in more visually effective ways. In this course, you will use Microsoft® Excel 2003 to streamline and enhance your spreadsheets with templates, charts, graphics, and formulas.
 

Course Objective: You will apply visual elements and advanced formulas to a worksheet to display data in various formats.

Target Student: The target students for this course are students who desire to gain the skills necessary to create templates, sort and filter data, import and export data, analyze data, and work with Excel on the Web. In addition, this course helps prepare students who desire to prepare for the Microsoft Office Specialist exam in Excel or Module 2 and who already have knowledge of the basics of Excel, including how to create, edit, format, and print basic worksheets.
 

Course Content

Lesson 1: Creating and Applying Templates

Learn to: Create a Workbook from a Template, Create a Custom Template, Working with Comments, Create a Hyperlink, Use Web-based Research Tools
 

Lesson 2: Creating and Modifying Charts

Learn to: Create a Chart, Format Chart Items, Change the Chart Type, Create a Diagram
 

Lesson 3: Working with Graphic Objects

Learn to: Insert Graphics, Create AutoShapes, Format Graphic Objects, Change the Order of Graphic Objects, Group Graphic Objects, Move, Copy, and Resize Graphic Objects
 

Lesson 4: Calculating with Advanced Formulas

Learn to: Create and Apply a Name for a Range of Cells, Calculate Across Worksheets, Calculate with Date and Time Functions, Calculate with Financial Functions, Calculate with Statistical Functions, Calculate with Lookup and Reference Functions, Calculate with Logical Functions
 

Lesson 5: Sorting and Filtering Data

Learn to: Sort Data Lists, Filter Data Lists, Create and Apply Advanced Filters, Calculate with Database Functions, Add Subtotals to a Worksheet
 

Lesson 6: Using Excel with the Web

Learn to: Export Excel Data, Publish a Worksheet to the Web, Import Data from the Web, Create a Web Query

 

Course Length: 1day
Price: £150 plus VAT

Excel 2003 Level3

Excel Level1You have used Microsoft® Office Excel 2003 to perform tasks such as running calculations on data and sorting and filtering numeric data. You would now like to automate some common tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and share Excel data with other applications. In this course, you will do all of these things.

 

Course Objective: You will automate some common Excel tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and share Excel data with other applications.

Target Student: This course was designed for students desiring to gain the skills necessary to create macros, collaborate with others, audit and analyze worksheet data, create PivotTables and PivotCharts, incorporate multiple data sources, and import and export data. In addition, the course is also for students desiring to prepare for the Microsoft Office Specialist exam in Excel 2003 or Module 2-Key Applications of the Internet and Computing Core Certification (IC3) exam, and who already have knowledge of the basics of Excel, including how to create, edit, format, and print worksheets that include charts and sorted and filtered data.
 

Course Content

Lesson 1: Streamlining Workflow

Learn to: Create a Macro, Edit a Macro, Customize Access to Excel Commands, Apply Conditional Formatting, Add Data Validation Criteria, Update a Workbook's Properties, Modify Excel's Default Settings
 

Lesson 2: Collaborating with Others

Learn to: Protect Files, Share a Workbook, Set Revision Tracking, Review Tracked Revisions, Merge Workbooks, Adjust Macro Settings, Administer Digital Signatures
 

Lesson 3: Auditing Worksheets

Learn to: Trace Cell Precedents, Trace Cell Dependents, Locate Errors in Formulas, Locate Invalid Data and Formulas, Watch and Evaluate Formulas, Group and Outline Data
 

Lesson 4: Analyzing Data

Learn to: Create a Trendline, Create Scenarios, Perform What-If Analysis, Develop a PivotTable© Report, Develop a PivotChart© Report, Perform Statistical Analysis with the Analysis ToolPak
 

Lesson 5: Working with Multiple Workbooks

Learn to: Create a Workspace, Consolidate Data, Link Cells in Different Workbooks, Edit Links

 

Lesson 6: Importing and Exporting Data

Learn to: Export to Microsoft Word, Import a Word Table, Import Text Files

 

Lesson 7: Structuring XML Workbooks

Learn to: Develop XML Maps, Import, Add, and Export XML Data, Manage XML Workbooks, Apply XML View Options

 

 

Course Length: 1day
Price: £150 plus VAT

Excel Level1

Delivery Method - Tutor Led

Excel Level1 Learn how to use spreadsheets for storage and manipulation of data and report creation.

Prerequisites:
Windows 98: Introduction, or equivalent knowledge.

Performance-based objectives
Upon successful completion of this course, students will be able to:

 

  1. Identify the disadvantages of paper spreadsheets and the advantages of electronic spreadsheets by exploring both.

  2. Create a basic worksheet by entering text, values, and formulas.

  3. Create formulas by using Excel’s built-in functions.

  4. Move and copy data by using shortcut menus, drag-and-drop editing, and toolbar buttons.

  5. Change the appearance of worksheet data by using a variety of formatting techniques.

  6. Prepare a document for printing by using the spell checking feature and a variety of printing options.

  7. Use the three-dimensional aspect of the Excel workbook environment by creating formulas that refer to cells on multiple worksheets.

  8. Save an Excel workbook as a Web page.


    9. Course Length: 1day
    Price: £150 plus VAT

Excel Level2

Delivery Method - Tutor Led

Excel Level2 - 28 July Students will probably get the most out of this course if they want to learn the skills and concepts necessary to work with advanced features of Excel 2000. Students should have a basic knowledge of the concepts involved in using Excel 2000. For example, they should be familiar with data types (text and values), copying data, basic formulas and functions, and opening and saving files.

Prerequisites:
To ensure students’ success with this course, we recommend that they first take the following courses or have equivalent knowledge:
Excel 2000: Level1

Performance-Based Objectives

  1. Customize toolbars and create styles and templates.

  2. Create decision-making functions.

  3. Analyze worksheet data by creating PivotTables.

  4. Compare and contrast workbook files and file links.

  5. Outline and consolidate worksheets and analyze worksheet data by using the Scenario Manager.

  6. Display and protect worksheet data by locking cells.

  7. Record and modify macros by using the Visual Basic Editor.

  8. Create and work with interactive Web documents.



    9. Course Length: 1day
    Price: £150 plus VAT