Word 2016 Introduction – 1 Day Course

£695.00

At the end of the course the delegate will be able to:
Identify the key Excel components
Manage worksheets and workbooks
Create, edit, format and print spreadsheets
Enter basic calculations and functions
Create charts and graphs

Category:

MOS Certification Path

Attending this course in conjunction with Excel Intermediate will help you prepare for the Microsoft Office Specialist (MOS) exams.

If you wish to book a MOS exam please contact us by email or on 020 7837 2690.

Pre-Requisites
To be familiar with using a mouse, and working in a Windows environment.

Modules

Getting Started
Launching the software
Understanding the operating environment
The Title bar
The formula bar and
name box
The structure of an Excel spreadsheet
Workbooks, Worksheets, Columns, Rows, Cells, the ActiveCell
Help features
Creating and Navigating Workbooks
Creating a new workbook
Navigating the worksheet using the keyboard, the scroll bars and the mouse
Selecting cells, rows and columns with the keyboard and mouse
The mouse pointer
Using Undo
Saving a workbook and using Save As
Closing a workbook
Opening a workbook
Deleting a workbook
Using the File tab
Working with Data
Data types
Entering and editing text, numeric and date values appropriately in cell and via the formula bar
Using Find and Replace
Using GoTo
Moving data with Cut and Paste or drag and drop
Using Copy and Paste
Creating data using AutoFill and Custom Lists
Flash Fill
Inserting rows and columns
Deleting rows and columns
Entering Calculations
Creating simple formula
Using arithmetical operations
Entering relative formulae with the AutoFill tool
Using the AutoSum tool
Simple statistical summaries
Using absolute and relative cell references
Understanding and correcting common error messages and circular references
Formatting Spreadsheets
Basic text and number cell formatting via the toolbar
Borders and shading
Using the Format Cells
dialogue sheet to enhance the display and alignment of numbers, dates and numeric data
Formatting
rows and columns
Using the Format Painter
Managing Worksheets
Adding, removing, renaming and reordering worksheets
Moving worksheets between workbooks
Creating Charts
Recommended Charts
Producing different types of charts
Changing the chart type
Chart Buttons:
Elements, Styles/Colour, Values
Modifying the formatting of a chart
Adding text labels and other drawing objects to a chart
Preparing a Spreadsheet for Use & Output
Spell checking
Protecting formula
Adding Comments
Using Page Break Preview
Using Print Preview
Applying Headers, Footers and other Page Setup options