qualification and course catalogue - watson martin · this excel course is also applicable to...
TRANSCRIPT
QUALIFICATION AND COURSE CATALOGUEMICROSOFT OFFICE (EXCEL, POWERPOINT, WORD)
MICROSOFT OFFICE
EXCEL
Advanced Microsoft Excel 2007 / 2010
Advanced Microsoft Excel 2013
Intermediate Microsoft Excel 2007 / 2010
Intermediate Microsoft Excel 2013
Introduction to Microsoft Excel 2007 / 2010
Introduction to Microsoft Excel 2013
Introduction to Visual Basic For Excel
Pivot Tables and Dashboards Made Easy
POWERPOINT
Advanced Microsoft PowerPoint 2007 / 2010
Advanced Microsoft PowerPoint 2013
Intermediate Microsoft Powerpoint 2007 / 2010
Intermediate Microsoft PowerPoint 2013
Introduction to Microsoft Powerpoint 2007 / 2010
Introduction to Microsoft PowerPoint 2013
WORD
Advanced Microsoft Word 2007 / 2010
Advanced Microsoft Word 2013
Introduction to Microsoft Word 2007 / 2010
Introduction to Microsoft Word 2013
“I really liked John, he has a great
style of teaching and understands that
students need to hear things three times
for them to sink in”
Delegate, Intermediate Microsoft Excel 2007 / 2010
Who is it for?
This advanced course is aimed at learners who have a good grounding in Excel (any version, but Excel 2007 or 2010 are preferable) either from experience or attending our Intermediate Microsoft Excel training course.
If your job involves manipulating and analysing data in Excel, you will find this course very useful. You will also find it helpful if you spend most of your working day using Excel and would like to fill in gaps in your knowledge.
What is it about?
This advanced Microsoft Excel course focuses on the vast array of functionality and will allow delegates to enhance their skills. It offers a focused approach that looks at manipulating and analysing data. This course goes into detail on how to normalise data and analyse it with Pivot Tables.
It also covers importing data using queries, preparing and analysing data with What If functions and Scenario building. You will also discover how to record and run your own macros.
The course is taught by expert Microsoft Certified Trainers with extensive training experience. You will be provided with a comprehensive manual which covers all the features covered during the course. This doubles up as a reference manual for use after the course.
What topics does this course cover?
o The skills to import data into Excel, prepare it and set up pivot tables to analyse it
o The knowledge to record macros and create icons on the toolbars to run them
o An understanding of how to locate errors in formulas and evaluate them
o The ability to use analysis tools to forecast figures based on a range of scenarios
o Ensure important data is highlighted by summarising large workbooks and sorting data into key elements
ADVANCED MICROSOFT EXCEL 2007 / 2010
Get a complete overview of Excel 2007/2010's most powerful features with this advanced excel course.
12 CPD Points
Duration: 2 days | Cost: £400 (+VAT)Excel
What topics does this course cover?
o Text functions in Excel
o Count functions
o Advanced ‘If’ statements
o Create a pivot table reports from new
o Analysing data with pivot tables
o Manipulating pivot tables
o Formatting pivot tables
o Creating pivot charts
o Grouping data in pivot tables
o Adding Slicers (2010)
o Auditing Worksheets
o Trace cell precedents and cell dependents
o Locate errors in formulas
o Locate invalid data and formulas
o Watch and evaluate formulas
o Goal seek to reverse calculate a formula
o Creating single input data tables
o Dual input data tables
o Setting up and manipulating scenarios for ‘What-If?’ analysis
o Consolidating data by position
o Consolidate by label
o Group and outline features
o Importing text files
o Setting up database queries
o Connecting Excel to the web to import data
o Recording macros
o Editing macros
o Creating buttons to run macros
o Customising access to Excel commands
o Adding icons to the toolbars
o Creating your own tab (2010)
o Editing menus
o Adding options to menus to run macros
Courses are delivered in training centres in central London. We can also run courses in-company at a venue of your choice.
Click here to find out more.
To speak to a member of our learning team: Tel: 020 7932 2760 | In-company Tel: 020 7520 6950
Email: [email protected] Web: www.watsonmartin.com/contact-us
ADVANCED MICROSOFT EXCEL 2007 / 2010 cont.
12 CPD Points
Duration: 2 days | Cost: £400 (+VAT)Excel
Who is it for?
This Advanced Microsoft Excel 2013 course is aimed at learners who have a good grounding in Excel (any version, but Excel 2013 are preferable) either from experience or attending our Intermediate Microsoft Excel training course.
If your job involves manipulating and analysing data in Excel, this course is for you. You’ll also find it helpful if you spend most of your working day using Excel and would like to fill in gaps in your knowledge.
What is it about?
This course shows you how to use the vast array of advanced functionality in Microsoft Excel 2013, developing your skills to work more efficiently and effectively. It focuses particularly on manipulating and analysing data. This course goes into detail on how to normalise data and analyse it with Pivot Tables.
It also covers importing data using queries, preparing and analysing data with What If functions and Scenario building. You will also discover how to record and run your own macros.
The course is taught by expert Microsoft Certified Trainers with extensive training experience. You will be provided with a comprehensive manual which covers all the features covered during the course. This doubles up as a reference manual for use after the course.
By attending this course you will gain:
o The skills to import data into Excel, prepare it and set up pivot tables to analyse it
o The knowledge to record macros and create icons on the toolbars to run them
o An understanding of how to locate errors in formulas and evaluate them
o The ability to use analysis tools to forecast figures based on a range of scenarios
o Ensure important data is highlighted by summarising large workbooks and sorting data into key elements
o Hands on exercises, putting Excel 2013’s advanced feature set into practice
ADVANCED MICROSOFT EXCEL 2013
Become an expert in using Microsoft Excel 2013's most powerful functions and applications.
12 CPD Points
Duration: 2 days | Cost: £400 (+VAT)Excel
What topics does this course cover?
o Text functions in Excel
o Count functions
o Advanced ‘If’ statements
o Create a pivot table reports from new
o Analysing data with pivot tables
o Manipulating pivot tables
o Formatting pivot tables
o Creating pivot charts
o Grouping data in pivot tables
o Adding Slicers
o Auditing Worksheets
o Trace cell precedents and cell dependents
o Locate errors in formulas
o Locate invalid data and formulas
o Watch and evaluate formulas
o Goal seek to reverse calculate a formula
o Creating single input data tables
o Dual input data tables
o Setting up and manipulating scenarios for ‘what-if’ analysis
o Consolidating data by position
o Consolidate by label
o Group and outline features
o Importing text files
o Setting up database queries
o Connecting Excel to the web to import data
o Recording macros
o Editing macros
o Creating buttons to run macros
o Customising access to Excel commands
o Adding icons to the toolbars
o Creating your own tab
Courses are delivered in training centres in central London. We can also run courses in-company at a venue of your choice.
Click here to find out more.
To speak to a member of our learning team: Tel: 020 7932 2760 | In-company Tel: 020 7520 6950
Email: [email protected] Web: www.watsonmartin.com/contact-us
ADVANCED MICROSOFT EXCEL 2013 cont.
12 CPD Points
Duration: 2 days | Cost: £400 (+VAT)Excel
Who is it for?
This intermediate excel course is designed for users who have attended an introductory level course or are already confident with the basic features offered in either Microsoft Excel 2007 or 2010.
If you are proficient with a previous version of Microsoft Excel, such as 2003, this course will also be applicable, but knowledge of Office 2007/2010 is preferred to receive the largest benefit.
This Excel course is also applicable to people who are looking to renew their confidence and are looking to treat this as an Excel refresher course.
What is it about?
This course follows on from our Introduction to Excel course and will guide you through all the new features.
It covers more complex formulas and functions, such as the improved conditional formatting features, look-up functions and new filtering options. This means that by the end of the training, you will be much more proficient and ready to tackle the Advanced Excel course.
The course is taught by expert Microsoft Certified Trainers with extensive training experience. You will be provided with a comprehensive manual which covers all the features covered during the course. This doubles up as a reference manual for use after the course.
By attending this course you will gain:
o the skills to utilise database functionality
o how to create look-ups to obtain range and precise data
o how to add ‘IF’ statements and using validation to restrict access to cells, rows and columns
o how to use the new an improved conditional formatting
INTERMEDIATE MICROSOFT EXCEL 2007 / 2010
Learn how to make the most of Excel 2007 and Excel 2010 features with this intermediate excel course.
6 CPD Points
Duration: 1 day | Cost: £250 (+VAT)Excel
What topics does this course cover?
o Recap on user interface, environment and shortcuts
o Absolute references
o Naming cells and ranges
o Referring to named cells and ranges in formulae
o Editing named cells and ranges
o Setting up entire workbooks with group editing
o Using vlookup & hlookup statements to retrieve data
o Editing lookups and ensuring accuracy in returned data
o Linking spreadsheets and workbooks together with formulas and functions
o Utilising If statements to assist decision making
o If statements and calculations
o Analysing data with the conditional formatting features
o Databases in Excel - understanding fields and records
o Sorting data numerically and alphabetically
o Filtering data for range and precision analysis
o Setting up data validation to ensure integrity of the data
o Attaching security to a spreadsheet
o Selective protection i.e. protecting formulas while allowing data entry
o Setting up and utilising templates
o Creating and formatting charts
o Adding trend lines to the chart
o Utilising custom chart types
o Adding Sparklines to view trends in the data (2010)
Courses are delivered in training centres in central London. We can also run courses in-company at a venue of your choice.
Click here to find out more.
To speak to a member of our learning team: Tel: 020 7932 2760 | In-company Tel: 020 7520 6950
Email: [email protected] Web: www.watsonmartin.com/contact-us
INTERMEDIATE MICROSOFT EXCEL 2007 / 2010 cont.
6 CPD Points
Duration: 1 day | Cost: £250 (+VAT)Excel
Who is it for?
This Intermediate Microsoft Excel 2013 course is designed for users who have attended an introductory level course or are already confident with the basic features offered in Microsoft Excel 2013.
If you are proficient with a previous version of Microsoft Excel, such as 2007 or 2010, this course will also be applicable, but knowledge of Office 365 is preferred to receive the largest benefit.
This Excel course is also applicable to people who are looking to renew their confidence and are looking to treat this as an Excel refresher course.
What is it about?
Excel 2013 is packed with useful upgrades, improvements and features, designed to make it even more powerful, intuitive and user friendly. This course follows on from our Introduction to Excel course and will guide you through all the new features.
It covers more complex formulas and functions, such as the improved conditional formatting features, look-up functions and new filtering options. This means that by the end of the training, you will be much more proficient and ready to tackle the Advanced Excel course.
The course is taught by expert Microsoft Certified Trainers with extensive training experience. You will be provided with a comprehensive manual which covers all the features covered during the course. This doubles up as a reference manual for use after the course.
By attending this course you will learn:
o the skills to utilise database functionality
o how to create look-ups to obtain range and precise data
o how to add ‘IF’ statements and use validation to restrict access to cells, rows and columns
o how to use the new and improved conditional formatting
INTERMEDIATE MICROSOFT EXCEL 2013
This intermediate course will develop your skills and enable you to produce clear, precise and relevant spreadsheets.
6 CPD Points
Duration: 1 day | Cost: £250 (+VAT)Excel
What topics does this course cover?
o Recap on user interface, environment and shortcuts
o Absolute references
o Naming cells and ranges
o Referring to named cells and ranges in formulae
o Editing named cells and ranges
o Setting up entire workbooks with group editing
o Using vlookup and hlookup statements to retrieve data
o Editing lookups and ensuring accuracy in returned data
o Linking spreadsheets and workbooks together with formulas and functions
o Utilising If statements to assist decision making
o If statements and calculations
o Analysing data with the ‘quick analysis’ feature and conditional formatting
o Databases in Excel - understanding fields and records
o Sorting data numerically and alphabetically
o Filtering data for range and precision analysis
o Setting up data validation to ensure integrity of the data
o Attaching security to a spreadsheet
o Selective protection i.e. protecting formulas while allowing data entry
o Setting up and utilising templates
o Creating and formatting charts
o Adding trend lines to the chart
o Utilising custom chart types
o Adding Sparklines to view trends in the data
Courses are delivered in training centres in central London. We can also run courses in-company at a venue of your choice.
Click here to find out more.
To speak to a member of our learning team: Tel: 020 7932 2760 | In-company Tel: 020 7520 6950
Email: [email protected] Web: www.watsonmartin.com/contact-us
INTERMEDIATE MICROSOFT EXCEL 2013 cont.
6 CPD Points
Duration: 1 day | Cost: £250 (+VAT)Excel
Who is it for?
This introductory Excel course is for anyone who needs to understand the way Excel works. It’s suitable for complete beginners or those who have a little self-taught knowledge. This training course is also applicable for individuals who want to know how to use Excel more efficiently for day-to-day tasks.
What is it about?
Excel 2007/2010 is a powerful piece of software, and this introductory course will show you how to get the most out of it.
The course will teach you how to navigate the ribbon and tab interface and it also covers the difference between text data, numerical data, and formulas and functions. Beginners will also learn how to set-up their own spreadsheets without relying on anyone else and develop skills to present their work clearly by making the most of Excel’s features.
The course is taught by expert Microsoft Certified Trainers with extensive training experience. You will be provided with a comprehensive manual which covers all the features covered during the course. This doubles up as a reference manual for use after the course.
By attending this course you will:
o learn how to set up your own spreadsheets from new
o develop the skills to present your work clearly
o learn how to create purchase orders, bank statements and compile sales figures
o learn how to enter data, basic formulas and functions
o gain the knowledge to manipulate data by inserting rows, columns and sheets as well as how to move, copy and delete data
o set-up printing and spreadsheet layouts
INTRODUCTION TO MICROSOFT EXCEL 2007 / 2010
Build your confidence with Microsoft Excel 2007/2010 and learn to use its key features with our introduction training course.
6 CPD Points
Duration: 1 day | Cost: £250 (+VAT)Excel
What topics does this course cover?
o Explore the various user interface elements
o How to master the ribbon
o Getting going with formulas and functions
o Learn the keyboard shortcuts
o Working with contextual tabs
o Using the Excel galleries
o Customising the interface
o Creating, opening and saving a workbook
o Creating forms with Excel
o Utilising Excel help
o Replicating formulas and functions
o Creating an absolute reference
o Range names and how they are applied
o Setting up data for printing
o Adding headers & footers
o Recording the current date and time on the printed spreadsheet
o Turning your figures in to charts
o Formatting charts
Courses are delivered in training centres in central London. We can also run courses in-company at a venue of your choice.
Click here to find out more.
To speak to a member of our learning team: Tel: 020 7932 2760 | In-company Tel: 020 7520 6950
Email: [email protected] Web: www.watsonmartin.com/contact-us
INTRODUCTION TO MICROSOFT EXCEL 2007 / 2010 cont.
6 CPD Points
Duration: 1 day | Cost: £250 (+VAT)Excel
Who is it for?
This introductory Microsoft Excel 2013 course is for anyone who needs to understand the way Excel works. It’s suitable for complete beginners or those who have a little self-taught knowledge.
This training course is also applicable for individuals who want to know how to use Excel more efficiently for day-to-day tasks.
What is it about?
Excel 2013 is a powerful piece of software, introducing a number of new features designed to make the process of creating, modifying and formatting spreadsheets as simple and straightforward as possible. This introductory course will show you how to get the most out of it.
The course will teach you how to navigate the ribbon and tab interface and it also covers the difference between text data, numerical data, and formulas and functions. Beginners will also learn how to set-up their own spreadsheets without relying on anyone else and develop skills to present work clearly by making the most of Excel’s features.
The course is taught by expert Microsoft Certified Trainers with extensive training experience. You will be provided with a comprehensive manual which covers all the features covered during the course. This doubles up as a reference manual for use after the course.
By attending this course you will:
o learn to set up your own spreadsheets from new
o develop your skills to present your work clearly
o learn how to create purchase orders, bank statements and compile sales figures
o learn how to enter data, basic formulas and functions
o gain the knowledge to manipulate data by inserting rows, columns and sheets as well as how to move, copy and delete data
o be able to manage printing and spreadsheet layouts
INTRODUCTION TO MICROSOFT EXCEL 2013
Get a complete overview of Excel 2013's most powerful features with this introductory course.
6 CPD Points
Duration: 1 day | Cost: £250 (+VAT)Excel
What topics does this course cover?
o Explore the various user interface elements
o How to master the ribbon
o Getting going with formulas and functions
o Learn the keyboard shortcuts
o Working with contextual tabs
o Using the Excel galleries
o Customising the interface
o Creating, opening and saving a workbook
o Creating forms with Excel
o Utilising Excel help
o Replicating formulas and functions
o Creating an absolute reference
o Range names and how they are applied
o Setting up data for printing
o Adding headers and footers
o Recording the current date and time on the printed spreadsheet
o Turning your figures into charts
o Formatting charts
Courses are delivered in training centres in central London. We can also run courses in-company at a venue of your choice.
Click here to find out more.
To speak to a member of our learning team: Tel: 020 7932 2760 | In-company Tel: 020 7520 6950
Email: [email protected] Web: www.watsonmartin.com/contact-us
INTRODUCTION TO MICROSOFT EXCEL 2013 cont.
6 CPD Points
Duration: 1 day | Cost: £250 (+VAT)Excel
Who is it for?
This course is suitable for people who would like to use VBA (Visual Basic for Applications) to enhance their usage of Excel for a more professional result.
A thorough understanding of Excel formulas and functions is required. A prior knowledge of Visual Basic is not required.
What is it about?
For advanced users of Excel, coding functionality using Visual Basic (VB) can be used to create extremely powerful and complex spreadsheets. Guided by an expert facilitator, you’ll learn how to incorporate VB programming to achieve results outside the scope of Excel’s in-built functions.
By attending this course you will learn how to:
o maximise existing Excel functionality by learning how to write programmes
o automate repetitive, tedious and complex tasks by using advanced ‘If’ statements and macros
o update VBA programmes by learning how to edit and amend them
What topics does this course cover?
o Writing and editing macros
o Assigning macros to a button in the toolbar
o Understanding the Visual Basic Integrated Development Environment and its Components
o Creating and Editing Modules, Objects and Procedures
o Adding Input and Output Message boxes
o Procedures and Conditions
o Writing Private and Public and Sub-routines
o Creating new functions for use in Excel
o Declaring Constants and Variables
o Variable Types - Dim, Static and Const
o Writing and Understanding Loops and Arrays, Do while and Do Until loops Static and Dynamic Arrays
o Using Advanced “If”, “Elseif” and the “Case Selection” alternative
INTRODUCTION TO VISUAL BASIC FOR EXCEL
Create powerful new Excel functions using Visual Basic programming.
12 CPD Points
Duration: 2 days | Cost: £400 (+VAT)Excel
Courses are delivered in training centres in central London. We can also run courses in-company at a venue of your choice.
Click here to find out more.
To speak to a member of our learning team: Tel: 020 7932 2760 | In-company Tel: 020 7520 6950
Email: [email protected] Web: www.watsonmartin.com/contact-us
Who is it for?
Anyone who wants to analyse and present Excel data quickly, efficiently and beautifully.
What is it about?
Recent versions of Excel have great data visualisation features, which make interpreting and presenting data better than ever before. This course will show you how to use these features to full effect to create stunning dashboards with Pivot Charts, Sparklines and Tables.
By attending this course you will:
o learn how to setup a Dashboard from scratch by adding charts and tables
o best practice for workbook construction
o visualisation techniques to display trends, and performance against target
o gain confidence in creating Pivot Tables and Pivot Charts
What topics does this course cover?
o Where to start with dashboards
o Structuring your work
o The anatomy of a chart
o Creating and editing various chart types to effectively present the data
o Other visualisation techniques beyond charts
o Adding linked tables to your dashboard
o Effective use of conditional formatting
o Creating and updating Pivot Table
o Master conditional formatting features to highlight trends
o Adding interactive controls and create a user interface so others can perform analysis
o How to use the latest COUNT functions introduced in Excel 2007 and 2010 to maximum effect
PIVOT TABLES AND DASHBOARDS MADE EASY
Learn how to use of Excel’s visualisation features to present your data beautifully.
6 CPD Points
Duration: 1 day | Cost: £475 (+VAT)Excel
Courses are delivered in training centres in central London. We can also run courses in-company at a venue of your choice.
Click here to find out more.
To speak to a member of our learning team: Tel: 020 7932 2760 | In-company Tel: 020 7520 6950
Email: [email protected] Web: www.watsonmartin.com/contact-us
Who is it for?
This Advanced Microsoft Word training course will help anyone who uses Microsoft Word to create long or complex documents such as reports, manuals or client-facing documents. It is aimed at learners who have a good grounding in Word either from experience or attending our Introduction Microsoft Word training course.
What is it about?
Microsoft Word 2007 and 2010 offer many features to automate long documents, reports and contracts. Adding captions to graphics and cross references and paragraph numbering in the text are very useful but the most popular feature is the automatic table of contents. This course focuses on those features and many many more which allow you to control your document and make future editing really easy.
You will be provided with a comprehensive manual which covers all the features covered during the course. This doubles up as a reference manual for use after the course.
By attending this course you will learn how to:
o add fields to documents so you can edit and update key information at the touch of a button
o create macros to automate manual processes
o protect confidential documents with security
o format longer documents consistently and easily using style sheets
What topics does this course cover?
o Document version management o Creating an automatic table of contents o Using document styles to automate formatting o Creating new styles o Advanced editing of style sheets o Managing large documents with page and section breaks o Handling different page layouts in the same document o Starting and stopping headers and footers o Controlling page numbering o Newspaper columns and newsletter o Inserting graphics and controlling positions on page o Inserting charts and managing surrounding text o Adding captions and cross references o Working with multiple versions of a document o Revision markers
o Using OLE to link with other applications
o Creating macros to automate task
ADVANCED MICROSOFT WORD 2007 / 2010
Become an expert user of Microsoft Word 2007/10 and master all the latest features and techniques the software has to offer.
6 CPD Points
Duration: 1 day | Cost: £250 (+VAT)Word
Courses are delivered in training centres in central London. We can also run courses in-company at a venue of your choice.
Click here to find out more.
To speak to a member of our learning team: Tel: 020 7932 2760 | In-company Tel: 020 7520 6950
Email: [email protected] Web: www.watsonmartin.com/contact-us
Who is it for?This training course is suitable for complete beginners with little or no experience of Microsoft Word. It’s also suitable for anyone who has some experience using Word, but no formal training and who would like to learn best practice.
What is it about?Microsoft Word 2007 and 2010 is a key tool that people use every day in the workplace and employers will expect you to have a good working knowledge of it. Taught by expert Microsoft Certified Trainers with extensive experience, this practical course will give you the skills and confidence you need, with a complete overview of Word 2007/2010’s core features.
You will be provided with a comprehensive manual which covers all the features covered during the course. This doubles up as a reference manual for use after the course.
What will I get out of this training course? o The skills to navigate the Word environment utilising the ribbon and
new keyboard shortcuts
o The knowledge of how to create professional looking documents with ease and speed
o The understanding of how to fully utilise the mailmerge features
INTRODUCTION TO MICROSOFT WORD 2007 / 2010
a step by step guide to the fundamentals of Microsoft Word 2007/2010, giving you the confidence to create professional reports and other client-facing documents.
6 CPD Points
Duration: 1 day | Cost: £250 (+VAT)Word
What topics does this course cover?
o Explore the various user interface elements
o How to master the ribbon and keyboard shortcuts
o See how contextual tabs work to manipulate, edit, and format a document
o Use Word galleries to apply design features
o Customise the Word environment
o Apply quick styles to format documents
o Control a document’s page setup and its overall appearance
o Adding and removing page breaks
o Quickly apply document themes to ensure a professional and consistent document design
o Use SmartArt for flow charts, illustrations and much more
o Utilising new template features
o Add tables to a document
o Modifying table structures
o Formatting tables
o Set-up header and footers
o Saving & opening files
o Proofing the document with spelling and grammar
o Utilising the thesaurus
o Setting up a mail merge
o Merging to lists
o Creating a selective mail merge
INTRODUCTION TO MICROSOFT WORD 2007 / 2010 cont.
6 CPD Points
Duration: 1 day | Cost: £250 (+VAT)Word
Courses are delivered in training centres in central London. We can also run courses in-company at a venue of your choice.
Click here to find out more.
To speak to a member of our learning team: Tel: 020 7932 2760 | In-company Tel: 020 7520 6950
Email: [email protected] Web: www.watsonmartin.com/contact-us
Who is it for?
This Advanced Microsoft Word training course is suitable for anyone who is responsible for producing long or complex documents such as reports, manuals or client-facing documents. It is aimed at learners who have a good grounding in Word either from experience or attending our Introduction Microsoft Word training course.
What is it about?
Microsoft Word 2013 offers offers many features to automate long documents, reports and contracts. Adding captions to graphics and cross references and paragraph numbering in the text are very useful, but the most popular feature is the automatic table of contents. This Advanced Word training course focuses on those features which allow you to control your document, making future editing much easier.
The course is taught by expert Microsoft Certified Trainers with extensive experience. You will be provided with a comprehensive manual which covers all the features covered during the course. This doubles up as a reference manual for use after the course.
By attending this course you will learn how to:
o add fields to documents so you can edit and update key information at the touch of a button
o create macros to automate manual processes o protect confidential documents with security o format longer documents consistently and easily using style sheets
What topics does this course cover?
o Document version management o Creating an automatic table of contents o Using document styles to automate formatting o Creating new styles o Advanced editing of style sheets o Managing large documents with page and section breaks o Handling different page layouts in the same document o Starting and stopping headers and footers o Controlling page numbering o Newspaper columns and newsletter o Inserting graphics and controlling positions on page o Inserting charts and managing surrounding text o Adding captions and cross references o Working with multiple versions of a document o Revision markers o Using OLE to link with other applications o Creating macros to automate task
ADVANCED MICROSOFT WORD 2013
Master all the latest features and techniques the software has to offer and become an expert user of Microsoft Word 2013.
6 CPD Points
Duration: 1 day | Cost: £250 (+VAT)Word
Courses are delivered in training centres in central London. We can also run courses in-company at a venue of your choice.
Click here to find out more.
To speak to a member of our learning team: Tel: 020 7932 2760 | In-company Tel: 020 7520 6950
Email: [email protected] Web: www.watsonmartin.com/contact-us
Who is it for?This training course is suitable for complete beginners with little or no experience of Microsoft Word. It’s also suitable for anyone who has some experience using Word, but no formal training and who would like to learn best practice.
What is it about?Microsoft Word is a key tool that people use every day in the workplace and employers will expect you to have a good working knowledge of it. This practical course will give you the skills and confidence you need, with a complete overview of Word 2013 core features.
This course is taught by expert Microsoft Certified Trainers with extensive experience. You will be provided with a comprehensive manual which covers all the features covered during the course. This doubles up as a reference manual for use after the course.
What will I get out of this training course? o The skills to navigate the Word environment utilising the ribbon and
new keyboard shortcuts
o The knowledge of how to create professional looking documents with ease and speed
o The understanding of how to fully utilise the mailmerge features
What topics does this course cover? o The Microsoft Word 2013 screen o Starting to use Microsoft Word 2013 o Using templates to create documents
o Manipulating Text o Microsoft Word 2013 Text Formatting o Microsoft Word 2013 Paragraph Formatting o Applying bullets to a list o Borders and shading o Tabs o Using Design Themes o Microsoft Word 2013 Page Formatting o Headers and Footers o Cover pages o Views and Document Navigation o Navigating through documents o Tables o Using graphics o Finding and replacing text within a Microsoft Word 2013 document o Mail Merge
INTRODUCTION TO MICROSOFT WORD 2013
a step by step guide to the fundamentals of Microsoft Word 2013, giving you the confidence to create professional reports and other client-facing documents.
6 CPD Points
Duration: 1 day | Cost: £250 (+VAT)Word
Courses are delivered in training centres in central London. We can also run courses in-company at a venue of your choice.
Click here to find out more.
To speak to a member of our learning team: Tel: 020 7932 2760 | In-company Tel: 020 7520 6950
Email: [email protected] Web: www.watsonmartin.com/contact-us
Who is it for?
This course is suitable for delegates who have attended the Intermediate Microsoft PowerPoint training course or have good knowledge and understanding of PowerPoint 2007/2010.
When attending the Advanced Microsoft PowerPoint 2007/2010 course, you should feel comfortable creating presentations that include title slides, text and bullet slides, drawing objects, ClipArt, and pictures.
What is it about?
This course will show you how to use the advanced features to deliver truly memorable presentations. It will focus on features such as adding buttons for interactivity and using media content like audio and video.
It also covers how to work with advanced graphic manipulation features, advanced slide show features, and exporting data out of PowerPoint.
The course is taught by expert Microsoft Certified Trainers with extensive training experience. You will be provided with a comprehensive manual which covers all the features covered during the course. This doubles up as a reference manual for use after the course.
By attending this course you will learn:
o how to create rich slides that have more impact on your audience
o animation best practice and how to use it to enhance rather than undermine your presentation
o how to share and edit your presentations by using appropriate file formats
o how to insert professional-looking diagrams through expert use of SmartArt
What topics does this course cover?
Saving your files
o Using file formats
o Exporting a file to PDF
o Save as HTML
o Using file properties
o Using auto-recover
Navigating the slideshow with Custom Buttons
o Using the navigation buttons
o Adding Custom Buttons
o Adding hyperlinks
ADVANCED MICROSOFT POWERPOINT 2007 / 2010
Use PowerPoint 2007/2010's advanced features to deliver truly memorable presentations to colleagues and clients.
6 CPD Points
Duration: 1 day | Cost: £250 (+VAT)PowerPoint
Advanced tables and charts
o Creating and working with tables
o Drawing a table
o Using the table tools ribbon
o Inserting an Excel table
o The insert Excel table ribbons
o Setting style options
o Setting table styles
o Changing the shape of a fill
o Applying borders
o Adding effects
Working with charts and graphs
o Creating and linking worksheet charts and graphs
o Chart tools ribbon
o Incorporating titles and data
o Adding chart specific animations
Working with SmartArt
o Creating SmartArt
o SmartArt tools
o Resizing diagrams
o Inserting SmartArt from a slide
Adding graphics
o Inserting a symbol or special character
o Adding and editing shapes
o Changing diagram types and design schemes
o Incorporating text
o Using ClipArt
Adding audio/visual effects
o Adding a movie
o Insert movie from the clip organiser or file
o Movie tools
o Deleting a movie
o Video tools in Office 2010
o Inserting a sound clip from sound organiser or file
o Sound tools
o Recording audio
o Playing a CD
o Deleting audio
Using animation
o Entrance, emphasis and exit effects
o Adding and drawing motion paths
o Speeds and timing options
o Using slide transitions
o Creating custom animation
Delivery methods
o Broadcasting your presentation (Office 2010)
o Turning your presentation into a Movie (Office 2010)
Courses are delivered in training centres in central London. We can also run courses in-company at a venue of your choice.
Click here to find out more.
To speak to a member of our learning team: Tel: 020 7932 2760 | In-company Tel: 020 7520 6950
Email: [email protected] Web: www.watsonmartin.com/contact-us
ADVANCED MICROSOFT POWERPOINT 2007 / 2010 cont.
6 CPD Points
Duration: 1 day | Cost: £250 (+VAT)PowerPoint
Who is it for?
This course is suitable for delegates who have attended the Intermediate Microsoft PowerPoint training course or have good knowledge and understanding of PowerPoint 2013.
When attending the Advanced Microsoft PowerPoint 2013 course, you should feel comfortable creating presentations that include title slides, text and bullet slides, drawing objects, ClipArt, and pictures.
What is it about?
This course shows you how to use the vast array of advanced functionality in Microsoft PowerPoint 2013, developing your skills and confidence so you can work more efficiently and effectively. It focuses particularly on tables and charts, animations and SmartArt.
The course is taught by expert Microsoft Certified Trainers with extensive training experience. You will be provided with a comprehensive manual which covers all the features covered during the course. This doubles up as a reference manual for use after the course.
By attending this course you will learn:
o how to create rich slides that have more impact on your audience
o animation best practice, and how to use it to enhance your presentation
o how to share and edit your presentations by using appropriate file formats
o how to create professional-looking diagrams through expert use of
What topics does this course cover?
o Choosing the best file formats o Navigating the slideshow with action buttons o Using the navigation buttons o Adding custom buttons o Adding hyperlinks o Advanced tables and charts o Creating and working with tables o Creating and linking worksheet charts and graphs o Adding chart specific animations o Creating SmartArt o SmartArt tools o Adding a movie o Insert movie from the clip organiser or file o New video tools in Office 2013 o Using animation o Entrance, emphasis and exit effects o Using slide transitions o Creating custom animation
ADVANCED MICROSOFT POWERPOINT 2013
Find out how to deliver truly memorable presentations using Microsoft PowerPoint 2013's advanced features.
6 CPD Points
Duration: 1 day | Cost: £250 (+VAT)PowerPoint
Courses are delivered in training centres in central London. We can also run courses in-company at a venue of your choice.
Click here to find out more.
To speak to a member of our learning team: Tel: 020 7932 2760 | In-company Tel: 020 7520 6950
Email: [email protected] Web: www.watsonmartin.com/contact-us
Who is this training it for?
Reed Learning’s Intermediate Microsoft PowerPoint 2007 / 2010 training course is for anyone who has attended an Introduction to PowerPoint course or for self-taught individuals with equivalent basic knowledge. Participants should ideally be at the stage where they feel comfortable creating basic presentations that include title slides, text and bullet slides, drawing objects, ClipArt, and pictures.
What is it about?
This Intermediate PowerPoint course will focus on working beyond bullet points to create presentations that have real impact and communicate your ideas clearly. You will discover how to insert and manipulate Word tables, Excel spreadsheets and other graphic elements in a PowerPoint presentation. The PowerPoint training course will also cover advanced graphic manipulation features, getting the best out of Slide Masters and working with animations and transitions.
The course is taught by expert Microsoft Certified Trainers with extensive training experience. You will be provided with a comprehensive manual which covers all the features covered during the course. This doubles up as a reference manual for use after the course.
What will I get out of this training course?
o Increased visual impact of your presentations by adding objects to slides
o More sophisticated and impressive slide shows
o Enhanced visual impact through the use of appropriate, engaging styles and layouts when preparing your presentations
What topics does this course cover?
Adding tables and charts
o Creating and Working with Tables
o Inserting a Table
o Drawing a Table
o Using the Table Tools Ribbon
o Working with Cells
o Inserting an Excel Table
o The Insert Excel Table Ribbons
o Setting Style Options
Working with charts and graphs
o Creating and linking worksheet Charts and Graphs
o Chart Tools Ribbon
o Incorporating Titles and Data
o Legends and Labels
INTERMEDIATE MICROSOFT POWERPOINT 2007 / 2010
This course will help you create sophisticated and powerful presentations that look professional.
6 CPD Points
Duration: 1 day | Cost: £250 (+VAT)PowerPoint
Working with SmartArt
o Creating SmartArt
o SmartArt Tools
o Resizing Diagrams
o Inserting SmartArt from a Slide
Adding graphics
o Inserting a Symbol or Special Character
o Adding and editing Shapes
o Changing Diagram Types and Design Schemes
o Incorporating Text
Working with text boxes
o Adding, selecting, deleting a Text Box
o Moving, resizing, rotating a Text Box
o Formatting a Text Box
o The Drawing Tools Ribbon
ClipArt
o Searching for ClipArt
o Inserting ClipArt
o Formatting ClipArt
o Skill Sharpener
o Other Illustrations
o Inserting a Photo from a File
o Inserting a Photo from a Scanner or Camera
o Slide Masters and Templates
o Viewing Masters
o Modifying Masters
o Inserting date, time and page numbers
o Applying and creating design templates
Slide masters and themes
o Viewing Masters
o Modifying Masters
o Inserting date, time and page numbers
o Applying and creating design templates
Using animation
o Entrance, Emphasis and Exit Effects
o Add and draw Motion Paths
o Speeds and timing options
o Using Slide Transitions
o Creating a Custom Animation
Courses are delivered in training centres in central London. We can also run courses in-company at a venue of your choice.
Click here to find out more.
To speak to a member of our learning team: Tel: 020 7932 2760 | In-company Tel: 020 7520 6950
Email: [email protected] Web: www.watsonmartin.com/contact-us
INTERMEDIATE MICROSOFT POWERPOINT 2007 / 2010 cont.
6 CPD Points
Duration: 1 day | Cost: £250 (+VAT)PowerPoint
Who is this training course for?
Reed Learning’s Intermediate Microsoft PowerPoint 2013 training course is for anyone who has attended an Introduction to PowerPoint course or for self-taught individuals with equivalent basic knowledge. Participants should ideally be at the stage where they feel comfortable creating basic presentations that include title slides, text and bullet slides, drawing objects, ClipArt, and pictures.
What is it about?
This Intermediate PowerPoint 2013 course will help you learn how to use the more complex features in PowerPoint such as text boxes, charts and tables. You will discover how to insert and manipulate Word tables, Excel spreadsheets and other graphic elements in a PowerPoint presentation. The PowerPoint training course will also cover advanced graphic manipulation features, getting the best out of Slide Masters and working with animations and transitions.
The course is taught by expert Microsoft Certified Trainers with extensive training experience. You will be provided with a comprehensive manual which covers all the features covered during the course. This doubles up as a reference manual for use after the course.
What will I get out of attending this training course?
o Increased visual impact of your presentations by adding objects to slides
o More sophisticated and impressive slide shows
o Enhanced visual impact through the use of appropriate, engaging styles
and layouts when preparing your presentations.
INTERMEDIATE MICROSOFT POWERPOINT 2013
learn all the PowerPoint shortcuts that will save you time.
6 CPD Points
Duration: 1 day | Cost: £250 (+VAT)PowerPoint
What topics does this course cover?
o Recap on the basics of PowerPoint 2013 / 365
o Working with Tables
o Adding / Deleting Rows and Columns
o Creating and Formatting Charts and Graphs
o Creating and editing SmartArt
o SmartArt Tools
o Adding and editing Shapes
o Changing Diagram Types and Design Schemes
o Working with Text Boxes
o Adding, selecting, deleting a Text Box
o Moving, resizing., rotating a Text Box
o Formatting a Text Box
o The Drawing Tools Ribbon
o Inserting ClipArt
o Inserting a photo from a file
o Photo editing features explained
o Inserting date, time and page numbers
o Applying and creating design templates
o Viewing Masters
o Modifying Masters
o Using Animation
o Entrance, Emphasis and Exit Effects
o Using Slide Transitions
Courses are delivered in training centres in central London. We can also run courses in-company at a venue of your choice.
Click here to find out more.
To speak to a member of our learning team: Tel: 020 7932 2760 | In-company Tel: 020 7520 6950
Email: [email protected] Web: www.watsonmartin.com/contact-us
INTERMEDIATE MICROSOFT POWERPOINT 2013 cont.
6 CPD Points
Duration: 1 day | Cost: £250 (+VAT)PowerPoint
Who is it for?
Suitable for complete beginners or those with little self-taught knowledge, this Microsoft PowerPoint 2007/2010 course is will help prepare, deliver or oversee the preparation of effective presentations.
What is it about?
This training course is designed to give delegates a thorough introduction to the fundamentals of Microsoft PowerPoint 2007/2010, enabling them to create and edit presentations that look professional and attractive. Everyone attending this course will learn how to create presentations that support the key messages from their presentation, rather than distract from them.
This is a one day practical course that is taught by expert Microsoft Certified Trainers with extensive experience. Delegates will be provided with a comprehensive manual which covers all the features covered during the course. This doubles up as a reference manual for use after the course.
By attending this course you will gain:
o a full understanding of features, shortcuts and tips for the 2007/2010 versions of MS PowerPoint
o total confidence in setting up, writing and editing your own presentations
o an understanding of how to use different slide types to hold your audience’s attention
o added value for your presentation through the ability to produce notes and handouts for your audience
What topics are covered?
o The ribbon
o Getting started with PowerPoint
o Command and contextual tabs
o Quick access toolbar
o Status bar and mini toolbar
o Moving around a presentation
o Working in different views
o Creating speaker notes
o Opening and closing presentations
o Creating a new presentation
o Saving presentations
o Applying slide layouts
INTRODUCTION TO MICROSOFT POWERPOINT 2007/2010
a step by step guide to the fundamentals of Microsoft PowerPoint 2007/10, giving you the confidence to create professional presentations.
6 CPD Points
Duration: 1 day | Cost: £250 (+VAT)PowerPoint
What topics does this course cover?
o Moving and deleting slides
o Working with text
o Inserting and formatting text
o Live preview
o Bulleted and numbered lists
o Spell checking
o Finding and replacing text
o Creating tables
o Creating text boxes and rotating text
o Inserting columns into text boxes
o Clipart
o Inserting and resizing pictures
o Ungrouping and grouping
o Re-colouring
o Drawing objects
o Using drawing tools
o Drawing shapes
o Adding text to shapes
o Flipping and rotating objects
o Aligning and ordering objects
o Selecting objects using the selection and visibility task pane
o Using other visual tools
o Creating graphs
o Creating diagrams and organisational charts using SmartArt tools
o WordArt
o Slide masters and themes
o Viewing masters
o Modifying masters
o Inserting date, time and page numbers
o Applying and creating design templates
o Presentation techniques
o Printing notes, slides and handouts
o Creating slide shows using transitions and text animation
o Using presenter view
Courses are delivered in training centres in central London. We can also run courses in-company at a venue of your choice.
Click here to find out more.
To speak to a member of our learning team: Tel: 020 7932 2760 | In-company Tel: 020 7520 6950
Email: [email protected] Web: www.watsonmartin.com/contact-us
INTRODUCTION TO MICROSOFT POWERPOINT 2007/2010 cont.
6 CPD Points
Duration: 1 day | Cost: £250 (+VAT)PowerPoint
Who is it for?
This course is suitable for complete beginners or those with little self-taught knowledge.
What is it about?
This training course is designed to give delegates a thorough introduction to the fundamentals of Microsoft PowerPoint 2013, enabling them to create and edit presentations that look professional and attractive. Everyone attending this course will learn how to create presentations that support the key messages from their presentation.
This is a one day practical course that is taught by expert Microsoft Certified Trainers with extensive experience. Delegates will be provided with a comprehensive manual which covers all the features covered during the course. This doubles up as a reference manual for use after the course.
By attending this training course you will gain:
o a full understanding of features, shortcuts and tips for the 2007/2010 versions of MS PowerPoint
o total confidence in setting up, writing and editing your own presentations
o an understanding of how to use different slide types to hold your audience’s attention
o added value for your presentation through the ability to produce notes and handouts for your audience
INTRODUCTION TO MICROSOFT POWERPOINT 2013
Get the skills and confidence to create professional presentations with our Introduction to Microsoft Powerpoint 2013 course.
6 CPD Points
Duration: 1 day | Cost: £250 (+VAT)PowerPoint
What topics are covered?
o Getting started with PowerPoint
o Moving around a presentation
o Working in different views
o Creating speaker notes
o Opening and closing presentations
o Creating new presentations
o Saving presentations
o Applying slide layouts
o Moving and deleting slides
o Working with text
o Inserting and formatting text
o Spell checking
o Creating tables
o Creating text boxes and rotating text
o Clipart
o Inserting and resizing pictures
o Drawing Illustrations
o Using drawing tools
o Drawing Shapes
o Adding text to Shapes
o Flipping and rotating objects
o Selecting objects using the selection and visibility task pane
o Using other visual tools
o Creating graphs
o Creating Diagrams and Organisational Charts using SmartArt tools
o Slide masters and themes
o Viewing masters
o Modifying masters
o Inserting date, time and page numbers
o Printing notes, slides and handouts
o Creating slide shows using transitions and text animation
Courses are delivered in training centres in central London. We can also run courses in-company at a venue of your choice.
Click here to find out more.
To speak to a member of our learning team: Tel: 020 7932 2760 | In-company Tel: 020 7520 6950
Email: [email protected] Web: www.watsonmartin.com/contact-us
INTRODUCTION TO MICROSOFT POWERPOINT 2013 cont.
6 CPD Points
Duration: 1 day | Cost: £250 (+VAT)PowerPoint