This 1 day course is designed for the end user who is using or will use Office 365. This course will provide delegates with the knowledge and skills to efficiently use Office 365 on a day-to-day basis. The course is designed with real world scenarios in mind. Delegates will learn how to use Outlook Online, Skype for Business, OneDrive for Business, SharePoint Online, and OneNote. At the end of this course delegates will be able to effectively navigate Office 365 and make use of all of the features of Office 365
Office 365 Overview
Introducing Cloud Computing
Identify and Outline the Component Products in Office 365 including Outlook Web App, Office Online Apps, OneDrive and Skype for Business
Navigating around Office 365
Customising the Office 365 Nav Bar
Updating your Profile in Office 365
Using the Outlook Online Application
Overview of Outlook Online
Working with Email and Folders
Outlook People and IM Contacts
Using the Calendar
Shared Calendars
Outlook Tasks in the Web App
Setting Outlook Options, Signatures, Automatic Replies and Rules
Using Skype for Business
Overview of Skype for Business
Viewing and Setting Presence Status
Using Instant Messages in Business
Understanding the Interactive Contact Card in Microsoft Office Applications
Integration with Outlook
Using Skype for Business for Online Presentations including Content Sharing, Polls and a Virtual Whiteboard
Working with OneDrive for Business
What is OneDrive for Business?
Navigating around OneDrive
Accessing Content in OneDrive
Using the Office Online Apps
Sharing Documents and Collaborating
Connecting Microsoft Office to OneDrive
Creating Office Documents and Saving Directly to OneDrive
Using Groups and Delve
Introduction to Groups
Collaborating using Groups
Getting to Content using Delve
Requirements Requirements
Before attending this course, students must have:
Basic understanding of Microsoft Office
Basic understanding of Microsoft Windows Operating systems
Delivered in London or UK Wide or OnlineLondon or UK WideorOnlineFlexible Dates
£750
Microsoft Word Advanced - In-company (now with live online classes)
Course Objectives
At the end of this course you will be able to:
Collaborate on documents
Add reference marks and notes
Make long documents easier to use
Secure a document
Work with forms
'1 year email support service
Take a closer look at the consistent excellent feedback from our growing corporate clients visiting our site ms-officetraining co uk
With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level.
Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses.
Our competitive rates start from £550.00 per day of training
Tailored training courses:
You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs.
Collaborating on Documents
Modify User Information
Share a Document
Compare Document Changes
Review a Document
Merge Document Changes
Review Tracked Changes
Coauthor Documents
Adding Reference Marks and Notes
Add Captions
Add Cross-References
Add Bookmarks
Add Hyperlinks
Insert Footnotes and Endnotes
Add Citations and a Bibliography
Simplifying and Managing Long Documents
Insert Blank and Cover Pages
Insert an Index
Insert a Table of Contents
Insert an Ancillary Table
Manage Outlines
Create a Master Document
Securing a Document
Suppress Information
Set Formatting and Editing Restrictions
Add a Digital Signature to a Document
Restrict Document Access
Forms
Create Forms
Manipulate Forms
Who is this course for? Who is this course for?
This course is designed for users who would like to create and work with lengthy and well structured documents, collaborate with others on documents, and create forms in Microsoft Word
Requirements Requirements
Preferably, delegates should have attended the Word Intermediate course.
Career path Career path
Microsoft Office know-how can instantly increase your job prospects as well as your salary.
80 percent of job openings require spreadsheet and word-processing software skills
Certificates Certificates
Certificate of completion
Digital certificate - Included
Delivered in London or UK Wide or OnlineLondon or UK WideorOnlineFlexible Dates
£550
Microsoft Word Intermediate - In-company (now with live online classes)
Course Objectives
At the end of this course you will be able to:
Customise tables and charts
Customise formatting with styles and themes
Modify pictures in a document
Create customised graphic elements
Insert content using Quick Parts
Control text flow
Use templates to automate document creation
Perform mail merges
Use macros to automate common tasks
'1 year email support service
Take a look at the consistent excellent feedback from our corporate clients visiting our site ms-officetraining co uk
Customer Feedback
Excelent enviroment for training. Tahnk you.
Jenny Price - ACER
'
With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level.
Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses.
Our competitive rates start from £550.00 per day of training
Tailored training courses:
You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs.
Working with Tables and Charts
Sort Table Data
Control Cell Layout
Perform Calculations in a Table
Create a Chart
Customising Formats Using Styles and Themes
Create and Modify Text Styles
Create Custom List or Table Styles
Apply Document Themes
Using Images in a Document
Resize an Image
Adjust Image Appearance
Integrate Pictures and Text
Insert and Format Screenshots
Use the Snipping tool
Creating Custom Graphic Elements
Create Text Boxes and Pull Quotes
Draw Shapes
Add WordArt and Other Text Effects
Create Complex Illustrations with SmartArt
Inserting Content Using Quick Parts
Insert Building Blocks
Create and Modify Building Blocks
Insert Fields Using Quick Parts
Controlling Text Flow
Control Paragraph Flow
Insert Section Breaks
Insert Columns
Link Text Boxes to Control Text Flow
Using Templates
Create a Document Using a Template
Create a Template
Using Mail Merge
The Mail Merge Features
Merge Envelopes and Labels
Create a Data Source Using Word
Using Macros
Automate Tasks Using Macros
Create a Macro
Who is this course for? Who is this course for?
This course is designed for users who to create or modify complex business documents as well as customised Word efficiency tools
Requirements Requirements
Preferably, delegates should have attended the Word Introduction course.
Career path Career path
Microsoft Office know-how can instantly increase your job prospects as well as your salary.
80 percent of job openings require spreadsheet and word-processing software skills
Certificates Certificates
Certificate of completion
Digital certificate - Included
Delivered in London or UK Wide or OnlineLondon or UK WideorOnlineFlexible Dates
£650
Microsoft Powerpoint Advanced - In-company (now with live online classes)
Course Objectives
At the end of this course you will be able to:
Modify the PowerPoint environment
Using Master View in order to customise a design template
Add and customize SmartArt graphics
Add animations and change its effect options
Add action buttons to control the flow of the presentation
Use various options to customise slide shows
Use different PowerPoint file types to distribute presentations
' 1 year email support service
Take a closer look at the consistent excellent feedback from our growing corporate clients visiting our site ms-officetraining co uk
Customer Feedback
Very clearly explained
Good pace.
Lucy Tailor - ACER
'
With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level.
Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses.
Our competitive rates start from £550.00 per day of training
Tailored training courses:
You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs.
Customising the PowerPoint Environment
Customise the User Interface
Set PowerPoint Options
Customising Design Templates
Modify Slide Masters and Slide Layouts
Add Headers and Footers
Modify the Notes Master and the Handout Master
Adding SmartArt to a Presentation
Create SmartArt
Modify SmartArt
Working with Media
Add Audio to a Presentation
Add Video to a Presentation
Working with Animations
Entrance, Emphasis and Exit Animations
Animate Charts by Category and Series
Customise Animations and Transitions
Collaborating on a Presentation
Review a Presentation
Store and Share Presentations on the Web
Customising a Slide Show
Annotate a Presentation
Set Up a Slide Show
Create a Custom Slide Show
Add Hyperlinks
Add Action Buttons
Record a Presentation
Securing and Distributing a Presentation
Secure a Presentation
Create a Video or a CD
Distribute the Presentation in different File Formats
Who is this course for? Who is this course for?
This course is designed for delegates who want to gain the skills necessary to work with design templates, various types of diagrams, special effects, custom slide shows, collaboration functionality, and advanced presentation delivery.
Requirements Requirements
Preferably, delegates should have attended the Powerpoint Introduction course.
Career path Career path
Microsoft Office know-how can instantly increase your job prospects as well as your salary.
80 percent of job openings require spreadsheet and word-processing software skills
Certificates Certificates
Certificate of completion
Digital certificate - Included
Delivered in London or UK Wide or OnlineLondon or UK WideorOnlineFlexible Dates
Course Objectives
This course aims to provide delegates with a foundation for Excel knowledge and skills.
'
Customer Feedback
Very professional and well mannered, fun and pleasant at the same time. I learnt a lot
Carolina Foster - CNN
Very helpful course. Would definitely take another one. Pedro was very patient and made it fun and engaged with us all.
Laura Smith - James Grant
Great course and excellent trainer. Thanks
Tracy Preston - Western Power Distribution
1 year email support service
Take a look at the consistent excellent feedback from our corporate clients visiting our site ms-officetraining co uk
With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level.
Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses.
Our competitive rates start from £550.00 per day of training
Tailored training courses:
You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs.
What is Excel?
The Excel Interface
Ribbon, Tabs and Groups
Microsoft Office Backstage view
Working with Workbooks
Create a blank Workbook
Create a Workbook using a Template
Opening and saving Files
Working with worksheets
Worksheet navigation
Select one or multiple Worksheets
Insert, Move, Copy or Delete a Worksheet
Working with Cells, Rows & Columns
Cell References
How to select cells or ranges
Different types of data
Move, Copy and Delete cells
Pasting Options
Find and Replace
Working with Rows and Columns
Overview of formulas in Excel
Autocalculation
The parts of an Excel formula
Using calculation operators in Excel formulas
The difference between Absolute, Relative and Mixed references
Using Excel functions; Sum, Average, Max and Min
Cell Formatting
Font Format options
Number Format options
Change the Fill and Borders
Cell Alignment
An Introduction to Charts
Create a simple Chart
Format your chart
Page Layout and Print
Page Layout and Page Break View
Change the Page Orientation
Set Page Margins
Headers and Footers in a worksheet
Print a worksheet or workbook
Who is this course for? Who is this course for?
All users who want to master the main features of Microsoft Excel
Requirements Requirements
General knowledge of the Windows OS
Certificates Certificates
Certificate of completion
Digital certificate - Included
Delivered in London or UK Wide or OnlineLondon or UK WideorOnlineFlexible Dates
£650
Microsoft Powerpoint Introduction - In-company (now with live online classes)
Course Objectives
At the end of this course you will be able to:
Identify the components of the PowerPoint interface
Create slides
Format text on slides
Add and modify graphical objects to a presentation
Work with tables in a presentation
Add charts to a presentation
Prepare the SlideShow
'1 year email support service
Take a look at the consistent excellent feedback from our corporate clients visiting our site ms-officetraining co uk
Customer Feedback
Very patient Trainer. Happy to adapt course + help with problems on existing presentations.
Andrea Lethbridge - CNN
'
With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level.
Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses.
Our competitive rates start from £550.00 per day of training
Tailored training courses:
You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs.
Getting Started with PowerPoint
Identify the Components of the PowerPoint Interface
Create a PowerPoint Presentation
Accessing Help
Choose the right view for the task in PowerPoint
Normal view
Slide Sorter view
Notes Page view
Outline view
Add, rearrange, and delete slides in PowerPoint
Working with Themes
Add colour and design to my slides with themes
Remove the current slide design (theme)
Slide Layout
What is a slide layout?
Apply or change a slide layout
Working with text
Add text to a slide
Create a new text box
Format text
Tables
Add a table to a slide
Format a Table
Copy and paste a table from Word
Insert an Excel spreadsheet within PowerPoint
Edit Cells, Rows and Columns
Delete a table
Graphics
Working with Clipart, and Shapes
Selecting objects, shapes, pictures or text boxes
Arrange a picture, shape or other object
Adding Charts to Your Presentation
Create a Chart
Format a Chart
Insert a Chart from Microsoft Excel
Inserting date and slide numbers
Add slide numbers to your presentation
Hide slide numbers on the title slide
Change where the page numbers appear on your slides
Start your slide numbering with a specific number
Print slides, notes, or handouts
Create the Slide Show
Record your slide show
Preview the recorded slide show
Turn slide timings off
Set the slide timings manually
Add or remove transitions between slides
Add Animations to Text and Objects
Deliver the Presentation
Speakers notes
Add speaker notes to your slides
View your speaker notes as you deliver your slide show
Who is this course for? Who is this course for?
This course is designed for end users who are interested in learning the fundamentals needed to create and modify engaging presentations.
Requirements Requirements
General knowledge of the Windows OS
Career path Career path
Microsoft Office know-how can instantly increase your job prospects as well as your salary.
80 percent of job openings require spreadsheet and word-processing software skills
Certificates Certificates
Certificate of completion
Digital certificate - Included
Delivered in London or UK Wide or OnlineLondon or UK WideorOnlineFlexible Dates
Course Objectives
At the end of this course you will be able to:
Do advance Table design
Do advance Query design and Action Querys
Do advance Form design with the use of macros and buttons
Export and import data to and from different sources.
1 year email support service
Take a look at the consistent excellent feedback from our corporate clients visiting our site ms-officetraining co uk
With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level.
Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses.
Our competitive rates start from £550.00 per day of training
Tailored training courses:
You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs.
Advanced Table Design
Advanced Field Properties
Table Properties
Advanced Query Design
Advanced Naming Conventions
Join Tables in Queries
Manage Query Joins
Use Self-Joins in Queries
Summarise Data in Queries
Parameter Queries
Action Queries
Crosstab Queries
Advanced Form Design
Create Subforms and Linked Forms
Form Controls
Command Buttons
Form Properties
Interface, Start-Up and Navigations Forms
Working with Macros
Create Single Macros
Run Macros
Work with Sub Macros
Use Conditional Macros
Run Macros from Buttons
Assign Macros to Events
Extending Data Reach
Import Data
Export Data
Work with Linked Tables
Managing Databases
Object Dependencies
Database Documenter
Performance Analyzers
Regular Management of a Database
Access Database Security
Who is this course for? Who is this course for?
The course is aimed at all users who would like to obtain the necessary skills to create advanced table, query, form and reports as well as to automate tasks with the use of macros.
Career path Career path
Microsoft Office know-how can instantly increase your job prospects as well as your salary.
80 percent of job openings require spreadsheet and word-processing software skills
Delivered in London or UK Wide or OnlineLondon or UK WideorOnlineFlexible Dates
£550
Microsoft Outlook Introduction - In-company (now with live online classes)
Course Objectives
At the end of this course you will be able to:
Understand the Outlook interface
Send and receive email messages
Organise email messages
Manage their calendar
Manage their contacts
Work with tasks and notes
Customise Outlook
' 1 year email support service
Take a look at the consistent excellent feedback from our corporate clients visiting our site ms-officetraining co uk
With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level.
Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses.
Our competitive rates start from £550.00 per day of training
Tailored training courses:
You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs.
Getting Started With Outlook
Navigate the Outlook Interface
Perform Basic Email Functions
Use Outlook Help
Composing Messages
Create an Email Message
Check Spelling and Grammar
Format Message Content
Attach Files and Items
Enhance an Email Message
Manage Automatic Message Content
Reading and Responding to Messages
Customise Reading Options
Work with Attachments
Manage Your Message Responses
Managing Your Messages
Manage Messages Using Tags, Flags, and Commands
Organise Messages Using Folders
Managing Your Calendar
View the Calendar
Manage Appointments
Manage Meetings
Print Your Calendar
Managing Your Contacts
Create and Update Contacts
View and Organise Contacts
Working With Tasks and Notes
Create and manage Tasks
Create and manage Notes
Customising the Outlook Environment
Customise the Outlook Interface
Create and Manage Quick Steps
Who is this course for? Who is this course for?
This course is intended for the user who needs to learn how to use Microsoft Outlook to compose and send email, schedule appointments and manage contact information.
Requirements Requirements
General knowledge of the Windows OS
Delivered in London or UK Wide or OnlineLondon or UK WideorOnlineFlexible Dates
£550
Microsoft Access Introduction - In-company (now with live online classes)
Course Objectives
At the end of this course you will be able to:
Identify the common objects of an Access database
Design and build the structure of a database
Input and maintain data
Design user-friendly data entry forms
Search the database using queries
Generate reports from your data
1 year email support service
Take a look at the consistent excellent feedback from our corporate clients visiting our site ms-officetraining co uk
With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level.
Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses.
Our competitive rates start from £550.00 per day of training
Tailored training courses:
You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs.
Introducing Microsoft Access
The Access interface
Database terminology
Access database objects
Fields and records
Properties
Designing a database
Planning and designing a table
Creating fields
Setting common field properties
Defining key fields
Working with table data
Entering and editing data
Sorting and filtering table records
Deleting records
Relationships
Why use table relationships?
Relationship types
Referential Integrity
Working with table subdatasheets
Querying a database
Creating simple Select Queries
Specifying query criteria
Sorting query results
Adding calculated fields
Designing Forms
Creating simple forms for data entry
Designing custom forms
Working with form sections
Creating sub forms
Designing Reports
Creating basic list reports
Working with grouping and sorting in a report
Adding totals to a report
Who is this course for? Who is this course for?
This course is intended for the user that wants to explore the creation of a relational database. It will focus on the structuring of the database itself and the creation of the basic functional elements of a database in order to manage data.
Certificates Certificates
Certificate of completion
Digital certificate - Included
Delivered in London or UK Wide or OnlineLondon or UK WideorOnlineFlexible Dates