Microsoft Office 365 Training Courses

Microsoft Office – Microsoft Word

The Advanced Microsoft Word aims to provide delegates with skills in integrating text and graphics, producing complex documents with the use of advanced layout and structural and presentation tools, and creating on-line forms.

Who Is The Course Aimed At?

Delegates with a good all-round knowledge of Word who are interested in gaining particular expertise in desktop publishing and handling long documents in Word.

Course Content

• Newspaper-style Columns
• Styles
• Table of Contents Generation
• Automatic Indexing
• Footnotes
• Inserting & Handling Graphics, including Cropping
• Using the Drawing Tools, including Text Boxes & Callouts
• WordArt
• Linked Text boxes or Autoshapes with Running Story
• Creating On-Line Forms with Form Fields, Drop Down
• Lists and Check Boxes

Entry Requirements

Delegates should have a sound knowledge of Word, with mouse use, preferably having previously attended the Intermediate course.

Overview

Many people waste time not understanding the functions of Excel, this course will provide an understanding and the knowledge required to get the best from EXCEL!!!!

This training will give you a good understanding of the functions of Microsoft Excel, and can be delivered either on a 1:1 or group basis.

This course is aimed at any level of personnel within any business who already have a basic understanding of Microsoft Excel and wish to develop their skills further.  By the end of this course, delegates will be able to;

• Demonstrate the main functions of Microsoft Excel
• Successfully implement the use of Excel into their Job Role

Course Content

The course can be tailored to meet your specific requirements and deal with any issues you may wish to address. To give you an idea of the course content, we could cover the following areas for you.

• Working with Large Worksheets
• Navigating Worksheets & Workbooks
• Viewing Options
• Page Break Preview
• Hiding & displaying data
• Printing large Worksheets
• Freeze and Split Panes
• Multiple Worksheets/Workbooks
• Inserting sheets
• Renaming sheets
• Copying sheets
• 3D formulas to link sheets
• Consolidating data
• Linking Workbooks
• Recap Formulas
• Relative & absolute referencing
• Averages, minimum & maximum
• Paste functions
• Conditional Formulas
• Formatting the Worksheet
• Adding Borders & Shading
• AutoFormats
• Copying Formats
• Text Formatting
• Working with dates
• Using Special Number Formats
• Indented lists
• Merge & Centering

Outcomes

You will receive individual feedback and will be asked to complete a personal action plan to identify key changes to implement and skills to practice.