About this Course

Tech Type Performance
Code VCPAM16
Duration 1 Day

Introduce your staff to new, time-saving and productivity-boosting features in Microsoft Office using our Virtual Class 90 minute Sessions.

Just choose 3 sessions (delivered over 1 day) from the extensive list of Microsoft Office end user applications topics listed below.

Further training courses are available on all Office applications and we offer most Classroom Courses as Virtual Courses.

Prerequisites

Before attending this course, delegates should be existing Microsoft Office users.

Delivery Method

Virtual Training using WebEx Meeting Software accessible from your desktop or laptop using a headset with microphone.

Sessions are fully interactive and will require each delegate to have their own PC or Laptop with appropriate Microsoft Application available and a headset (with a microphone if possible).

Session Topics Available

 

Microsoft Office Pick and Mix

 

Microsoft Excel

 

1. Introduction to Excel (The Basics)

New to Excel? This session will show you some basic features to get started on the creation, formatting and printing of an Excel Workbook.

  • Create and edit a worksheet (New, Open, Save, Save As)
  • Format a worksheet (Font, Alignment, Format Painter, Cut/Copy/Paste)
  • Print a worksheet (Page Setup and Printing)

 

2. Basic Formulas

Using Excel, but don’t know how to create basic formulas? This session is for you, showing you how to get started on the creation of basic Excel Formulas and Functions.

  • Create basic formulas
  • Insert functions
  • AutoSum / AutoCalc

 

3. Pivot Tables and Pivot Charts

Analysing Data Lists can be much simpler with the use of Pivot Tables as they allow you to summarise, filter and chart large amounts of data quickly.

  • Create and modify a Pivot Table
  • Add Calculated Fields
  • Group Data
  • Pivot Charts
  • Filter with Slicers and Timelines

 

4. Date and Text Functions

This session will show you some of the Text Functions within Excel to allow you to extract data from a cell, add cells together and use functions and shortcuts for dates.

  • DATE Functions
  • TEXT Functions
  • Text to Columns
  • Flash Fill

 

5. If and VLookup Functions

Use some of Excel’s Logical Functions to test conditions within cells and how to use VLOOKUPs to help you extract data within a data list.

  • IF, COUNTIF and SUMIF
  • IFERROR
  • VLOOKUP

 

6. Using Visual Tools

How can you make your Excel Workbook look professional? In this session you will insert various Charts, use Sparklines to show trends and apply Conditional Formatting to highlight cells under various conditions.

  • Insert Charts
  • Insert Sparklines
  • Quick Analysis Tool
  • Conditional Formatting

 

7. Excel Tables and Data List Management

Currently using Basic Sort and Filter for Data Lists? This session will show you how to use Excel Tables for Data Lists which will allow you to add calculations quickly to the list and also how to manage lists with Freeze Panes.

  • Introducing Excel Tables
  • Format a Table
  • Create a calculated row
  • Freeze Panes
  • Subtotals

 

8. Creating and Running Macros

Repetitive tasks can be time-consuming; recording a Macro to automate those tasks and running the Macro as many times as you like could be time-saving!

  • Create, run, edit and delete Macros
  • Create a Macro Ribbon Tab

 

9. Collaborating with Others

Making sharing workbooks easier to control, this session will show you how to password protect cells and worksheets and track all changes made to a shared workbook.

  • Cell, Worksheet and Workbook Protection
  • Share a Workbook
  • Set Revision Tracking
  • Review Tracked Changes

 

Microsoft Word

 

1. Introduction to Word (The Basics)

New to Word? This session will show you some basic features to get started on the creation, formatting and printing of a Word Document.

  • Create and edit a document (New, Open, Save, Save As)
  • Format a document (Font, Alignment, Format Painter, Cut/Copy/Paste)
  • Print a document (Page Setup for Printing)

 

2. Word Mail Merge

In this session find out how to send out multiple letters or emails. Mail merge is used to create identical bulk labels, letters and emails – easy when you know how!

  • Create a Mail Merge Letter
  • Data Source using Word and Excel
  • Filter and Sort the Data Source
  • Create Mailing Labels
  • Email Merge

 

3. Collaborating on Documents

Collaborating with others can be difficult, however in this session you will find out how to Track Changes made by others and add comments, making it easier to review documents.

  • Modify User Information
  • Insert Comments
  • Use Track Changes
  • Track Changes Options
  • Review Tracked Changes
  • Document Inspector

 

4. Working with Word Tables and Illustrations

In this session, you will learn how to create and edit Word Tables, Insert Pictures and use SmartArt for diagrams to enhance your documents.

  • Create, modify and format Word Tables
  • Insert Pictures
  • Insert a Screenshot / Screen Clipping
  • Add SmartArt Diagrams
  • Insert an Excel Chart

 

5. Managing Reference Marks

In this session, you will learn how to add quick references for navigation, site sources of your content and add captions after pictures and word tables.

  • Insert Bookmarks
  • Add Footnotes and Endnotes
  • Add Captions
  • Add Hyperlinks
  • Add Cross References
  • Insert Captions

 

6. Managing Long Documents

In this session, you will learn how to use Styles to enhance the appearance of your document quickly, save text to re-use in other documents and insert Section Breaks to change the layout within the document.

  • Heading Styles
  • Expand/Collapse Paragraphs
  • Navigation Pane
  • Use Quick Parts
  • Use Section Breaks
  • Add Headers and Footers
  • Insert Table of Contents

 

Microsoft PowerPoint

 

1. Introduction to PowerPoint (The Basics)

New to PowerPoint? This session will show you how to get started with the creation of PowerPoint Slides for your Presentation.

  • Create and edit a Presentation
  • Add and format Slides with Text, Bullets and Pictures
  • Add Speaker Notes
  • Create Handouts
  • Run a Presentation

 

2. Managing Slide Masters

Slide Masters are layouts of slides containing the same font, images and/or colours and can then be applied to your blank slides to keep your presentation consistent.

  • Set up a Slide Master
  • Customise Slide Layouts
  • Custom Themes
  • Headers and Footers
  • Modify Notes and Handout Masters

 

3. Adding Special Effects

Find your presentations a bit boring? In this session you will enhance your presentations by adding videos, sound and animation to text or pictures.

  • Insert Audio and Video Files
  • Add Slide Transitions
  • Add Animation
  • Use the Animation Painter
  • Advanced Animation Features

 

4. Customising a Slide Show

Running a presentation can be difficult to manage sometimes, in this session you will use some features to help you run a more professional presentation and manage the slides more effectively.

  • Create Custom shows
  • Insert Hyperlinks and Action Buttons
  • Setup a Slide Show
  • Slide Annotations
  • Slide Sections

 

5. Working with Images and Illustrations

In this session, you will add various types of Illustrations to enhance your presentation and make it look more professional.

  • Insert Pictures
  • Use Smart Guides
  • Insert a Screenshot / Screen Clipping
  • Add SmartArt Diagrams
  • Insert Excel Charts
  • Insert Word Tables

 

Microsoft Outlook

 

1. Mailbox Management

Manage your emails effectively by learning how to flag for follow up, organise into folders and use quick searches and filtering to find emails easily.

  • Different Views / Task Panes
  • Create Search Folders
  • Sort and Filter Emails
  • Use Flags
  • Set up Email Rules
  • Use Quick Steps
  • Out of Office Notification
  • Create Email Signatures
  • Access Another User’s Folder

 

2. Calendar Management

Not using your Calendar to its full potential? This session will show you how to manage appointments and use features to help you organise your schedule.

  • Calendar Views
  • Create an appointment
  • Create a Recurring Appointment
  • Set Calendar Options
  • Schedule Meetings
  • Colour Categories
  • Email a Calendar
  • Share Calendars
  • Calendar Overlay Mode

 

Microsoft Visio

 

1. Introduction

Visio is used to create process flowcharts, organisation charts and many more diagrams. This short introduction will allow you to explore the Visio interface and create a basic flowchart and organisation chart.

  • Explore the Visio interface
  • Create, edit and format a basic flowchart
  • Create, edit and format a basic organisation chart

 

Microsoft OneNote

 

1. Introduction

OneNote is used to manage and gather users’ notes (i.e. from Word, Excel, typed or website links) and keep them in one place: a OneNote Notebook. This session will show you how to create a notebook and add content to get you started.

  • Explore the OneNote interface
  • Create a Notebook, add Sections and Pages
  • Link content from the Web, Excel, Word

 

Performance

1 Day

Duration
Microsoft Office

Find dates and prices

Sorry, we don't have any public dates scheduled for this course, but it can be run as a closed event for your company.
Please contact us for details on alternative ways we can help you 0113 220 7150 or email us at info@qa.com.

Trusted, awarded and accredited

Fully accredited to ensure we provide the highest possible standards in learning

All third party trademark rights acknowledged.