Business Computing for Executives - Advanced

Introduction

This course is intended to develop the knowledge base for busy Executives who require a more detailed understanding of Excel and Word. In Excel the course covers the manipulation of data, develops the use of formulae and shows how to create Charts. In Word the course shows how to develop a business document with the relevant processes being covered. Also covered within the programme is the linking of data within Excel spreadsheets and the creation of active linking between Word and Excel documents.

Course Aims

To develop the knowledge of senior managers and executives in a range of Microsoft applications allowing them to have an understanding of functionality up to Intermediate/Advanced user level.

Course Objectives

• By the end of the course, delegates will be able to:
• Manipulate data and developing formulae in Excel
• Create business documents in Word
• Link data between Excel and Word
• Create Templates, protect documents and create Charts

Pre-requisites

We recommend that all those who attend have:

• A working knowledge of the PC, Excel and Word or have been on the Introduction course

Course Content

(If requested courses can be tailored to cover specific work requirements)

Excel

• Use of data Sort and Filter
• Use of Subtotals
• Using the Autosum function
• Creating formulae and the use of Special Functions
• Saving and using a Template
• Creating and amending a Chart

Word

• Use of Tables and Tabs
• Advanced Formatting
• Creating a common look for documents
• Importing Graphics
• Saving and using a Template

Data Links

• Creating a Link between Spreadsheets in Excel
• Creating an active Link
• Linking Excel and Word

Document protection

• Protecting an Excel document while allowing access to individual cells
• Protecting a Word document
• Use of Passwords

Back to previous page