Business IT Courses

 

Making long documents easier to use

·            How to navigate long documents quickly

·            Create a Table of Contents

·            Mark text for indexing

·            Create an Index

 

Creating forms

·            Add form fields to a document

·            Creating forms

·            Form protection

·            Limit form completion

 

Collaborating with others

·            Using comments

·            Send a document for review

·            Compare document changes

·            Accept document changes

·            Reject document changes

·            Merge document changes

·            Review a document

 

Document setup

·            Advanced page numbering

·            Working with templates

·            Standard templates

·            Creating templates

 

Document Security

·            Update document properties

·            Password protect documents

·            Creating read only documents

·            Limit formatting choices within a document

 

Using Word with other applications

·            Link a chart to excel data

·            Send a document outline to PowerPoint

·            Saving documents as different file formats

·            Send a document as an email attachment

 

Working with Macros

·            Creating macros within Word

·            Editing Macros

·            Running Macros

·            Creating and editing toolbars

 

 

This course will build on the skills you have learnt on our Essential Excel course or already posess and teach you the more advanced features of the application.  You will become familiar with lists, and sorting and filtering data.  You will learn how to create hyperlinks, create and modify charts, and look at the more advanced functions and formula.

 

Working with Graphs & Charts

·            Create Column, Line and Pie Charts

·            Edit & Format charts

·            Change the chart type

·            Update charts

·            Link charts to other worksheets

 

Advanced Formulae & Functions

·            Working with %

·            Absolute & Mixed Cell Referencing

·            Named Ranges

·            Conditional Formulae

·            IF statements

·            Sum IF, Count IF

 

Working with Lists

·            Sort Data Lists

·            Filtering Data

·            Create and Apply Advanced Filters

·            Creating custom lists

·            Introducing V Look Up

 

Linking Worksheets and Workbooks

·            Working with Hyperlinks

·            Link data from worksheets

·            Link data from workbooks

·            Export to Microsoft Word

 

Summarising Data

·            Pivot Tables

·            Pivot Charts

·            Data Consolidation

 

 

Data Worksheet Protection

·            Protect Cell Contents

·            Protect Workbook

·            Share workbooks

·            Inserting Comments

·            Revision Tracking

Sorry there are no upcoming dates for this course, please check back later

Sorry there are no upcoming dates for this course, please check back later