*Bundle and Save
This courseware title is also available in a Bundle
Microsoft Excel 2003 is the Office suite’s spreadsheet program. Whether you’re using Excel 2003 for the first time, or have been using it for years, this three-level course will help you make the most of Excel 2003’s exciting features.
Highlights of the course include a discussion of PivotTables, list functionality, what-if analysis, and the Scenario Manager.
Learn more... Course Outline
Our courseware is primarily purchased by five types of trainer; HR managers, corporate trainers, private training firms, educational institutions, or private consultants. The target audience varies on the instructor and the type of training required by a particular organization.
The students for this course are usually training staff or managers involved in training.
No previous experience or training in Excel is required, though students should possess basic numeracy and literacy and ideally have a basic understanding of using computers and software applications, such as Microsoft Word.
The Courseware Company (established in the early 1990s and part of gtslearning) is the only European authorised reseller of Velsoft courseware materials and print licences. Velsoft offers fully customisable training materials, delivered online and fully supported with instructor resources and student study tools.
To get started, just open this 'Excel 2003' training courseware in your favourite word processor. You can fully customise the materials to suit your exact learning needs and include your own branding. Your own tailor-made course, delivered 'off-the-peg' and saving you thousands of pounds in development time and man-hours. Just press print and the perfect learning experience is yours to deliver.
Getting Started With Excel To begin, participants will learn the basics of Excel: how to open and close it, how to use the interface, how to create a basic workbook, and how to open and save workbooks.
Excel Basics Next, participants will learn about cells, columns, rows, and ranges; how to create worksheet labels; how to use AutoSum, AutoComplete, AutoCorrect, and AutoFill; how to use Excel's basic formulas; how to use Smart Tags; about option buttons; and how to perform basic editing tasks.
Working With Excel This section will focus on modifying cells and data, applying cell and worksheet formatting, using conditional formatting, using the Format Painter, customizing toolbars, and adding charts.
Workbook Management Participants will learn how to manage worksheets; add headers, footers, and page numbers; set up a workbook for printing; print a workbook; and link, consolidate, combine, and protect workbooks.
Working With Functions And Formulas This section will explore many of Excel's formulas and functions, including array formulas and the IF function. We will also look at how to troubleshoot formulas and how to use named ranges.
Managing Lists This section will teach participants how to create and use lists, records, fields, and filters. We will also discuss how to use Excel as a database.
Working With Macros And Controls Participants will learn how to create and use macros and how to develop forms in Excel.
Using Excel With Other Programs Participants will learn how to add Excel spreadsheets to Word, use Outlook to e-mail spreadsheets, and import and export Excel data.
Getting The Most From Your Data This section will explore creating outlines, groups, PivotTables, scenarios, and using what-if analysis.
Excel And The Internet Participants will learn how to add hyperlinks to workbooks, save a workbook as a web page, and use web queries.
Advanced Excel Tasks To conclude the course, we will look at creating and using shared workbooks, coding macros using Visual Basic, backing up workbooks, protecting workbooks, protecting your personal information, adding passwords, customizing Excel, and using Detect and Repair.
Want to deliver the best Business Skills or Computer Training courses to your students? The Courseware Company is the UK’s leading supplier of fully Customisable business skills courseware licences.
Content is available for many business disciplines as well as Microsoft Office, Adobe and many other training products. Essentially, we’ve packaged the classroom prep time into an affordable, effective product.
This course can be purchased individually or as part of the Microsoft Office 2003 Bundle. Also included in this bundle are: