Microsoft Office Pick and Mix Training

  • Learn via: Classroom
  • Duration: 1 Day
  • Level: Fundamentals
  • Price: From $845+VAT
We can host this training at your preferred location. Contact us!

Introduce your staff to time-saving and productivity-boosting features in Microsoft Office using our bite-size sessions.

Just choose 3 sessions (delivered over 1 day) from the extensive list of End User Applications on the following pages, these sessions will target specific topics.

More detailed training courses are also available on all Office applications, please contact us for more details.

Delivery Method

Virtual Training accessible from your desktop or laptop, session will be fully interactive and will require everyone to have their own PC or Laptop, headset/speaker to participate in the session and would benefit from having 2 screens. These sessions are also available to run as live face-to-face classroom events.

  • Use of mouse and keyboard
  • Ability to navigate the Windows environments
  • Open and close programs

MICROSOFT EXCEL

90 min sessions

1. Excel (The Basics)

In this session, you will learn how to create a basic spreadsheet.

  • Creating and editing a workbook
  • Creating Basic Formulas including AutoSum
  • Formatting a worksheet (Text formatting and cell alignment)
  • Page layout options / printing a worksheet

2. Excel (Beyond The Basics)

In this session, you will build on Excel (The Basics) and use more features to enhance your spreadsheet

  • Introducing Functions (SUM, AVERAGE, MIN, MAX, COUNT)
  • Understanding Relative and Absolute cell references
  • Further formatting features (Format Painter, Cell Styles)
  • Managing worksheets and workbooks

3. Working with Data Lists

In this session, you will learn how to manage Data Lists using a variety of commands

  • Flash Fill
  • Text to columns
  • Sorting and filtering
  • Creating Custom Views
  • Using Subtotals

4. Mastering Excel Tables

In this session, you will see the benefits of using Excel Tables to further analyse data lists

  • Creating and Formatting Excel Tables
  • Add calculations and totals to a table
  • Using Slicers to filter data
  • Managing tables

5. Visual Tools

In this session, you will insert Charts and use Sparklines to show trends and use Conditional Formatting to format cells based on rules.

  • Creating and managing Charts
  • Analyse data using Sparklines
  • Creating Conditional Formatting
  • Using Quick Analysis

6. Collaborating with Others

In this session, you will use features that allow you to control the entry of data into worksheets that are shared with others

  • Data Validation
  • Conditional Data Validation
  • Protecting Cells, worksheets and workbooks

7. Logical Functions

In this session, you will use some of Excel’s Logical Functions to test conditions within cells

  • IF, COUNTIF, SUMIF, AVERAGEIF
  • COUNTIFS, SUMIFS, AVERAGEIFS (multiple criteria)
  • IF Function with AND / OR
  • IFERROR

8. Lookup and Reference Functions

In this session, you will create different LOOKUP functions to search for values and return value(s) from another location.

  • Office 365 / Office 2016: VLOOKUP Functions
  • Office 365 / Office 2019 Only (XLOOKUP / Dynamic Arrays)

9. Pivot Tables and Pivot Charts

In this session, you will use Pivot Tables to calculate, summarise and analyse data, showing trends and patterns in your data.

  • Create and modify Pivot Tables
  • Manage and configure Pivot Table fields
  • Creating interactive reports using Slicers and Timelines
  • Creating Pivot Charts

10. Text Functions

In this session, you will use some of Excel’s Text Functions to transform, extract and split data.

  • Flash Fill
  • UPPER, LOWER, PROPER
  • CONCAT, TEXTJOIN
  • Get and transform data using Power Query (if time)

MICROSOFT WORD

90 min sessions

1. Word (The Basics)

In this session, you will learn how to create, format and print a Word document.

  • Creating and editing a document
  • Formatting Text and Paragraphs
  • Adding Headers and Footers
  • Printing a document

2. Word (Beyond the Basics)

In this session, you will build on Word (The Basics) and use more features to enhance your document.

  • Font and paragraph formatting
  • Borders, Shading, Format Painter, Indents, Spacing
  • Bullets, Numbering and Multi-level numbering
  • Creating Styles
  • Navigation Pane

3. Working with Graphics, Word Tables and Excel Charts

In this session, you will enhance your documents by inserting graphics, Word Tables and Excel Charts.

  • Inserting Pictures
  • Adding SmartArt Diagrams
  • Create, Modify and Format Word Tables
  • Inserting an Excel Chart

4. Word Mail Merge

This session will show you how to use Mail Merge to automate document creation.

  • Creating a Mail Merge Letter
  • Data Source linking using Word and Excel
  • Creating Mailing Labels

5. Collaborating on Documents

In this session, you will learn how to use collaboration tools in Word to manage and review document changes.

  • Inserting Comments
  • Using Track Changes
  • Track Changes Options
  • Review Tracked Changes
  • Restrict Editing

6. Managing Long Documents

In this session, you will incorporate various referencing tools into documents to help you manage long documents.

  • Review of Heading Styles and Navigation Pane
  • Insert Table of Contents
  • Using Section Breaks

MICROSOFT POWERPOINT

90 min sessions

1. PowerPoint (The Basics)

In this session, you will learn how to create a basic PowerPoint Presentation.

  • Creating and editing a Presentation
  • Inserting a Slide Background
  • Formatting Slides with Text and Pictures
  • Adding Slide Transitions
  • Running a Presentation

2. PowerPoint (Beyond the Basics)

In this session, you will build on your PowerPoint skills by use more features to enhance your presentation.

  • Working with Sections
  • Inserting and managing Shapes and Screenshots
  • Adding Animation
  • Creating Speaker Notes and Handouts

3. Adding Content

In this session, you will add content to enhance your slides and make your presentation look more professional.

  • Re-use Slide Content
  • Inserting Audio and Video Files
  • Adding SmartArt Diagrams
  • Inserting an Excel Chart
  • Inserting a Word Table

4. Customising a Slide Show

In this session, you will learn quick ways of running your slideshow.

  • Inserting Hyperlinks and Action Buttons
  • Creating Custom shows
  • Setup a Slide Show / slide show controls
  • Slide Annotations
  • Presenter View

MICROSOFT OUTLOOK ONLINE

90 min sessions

1. Mailbox Management

  • Email Basics and working with Attachments
  • Setting up Automatic Replies
  • Creating Search Folders
  • Creating Email Signatures
  • Sorting and Filtering Emails
  • Using Flags
  • Setting up Email Rules
  • Using Quick Steps
  • Access Another User’s Folder

2. Calendar Management

  • Calendar Views
  • Creating an appointment and a Recurring Appointment
  • Creating a Meeting
  • Setting Calendar Options
  • Colour Categories
  • Sharing Calendars

MICROSOFT ONENOTE ONLINE

90 minute session

This will give you a basic introduction to Microsoft OneNote. OneNote is a digital notebook that provides a single place to gather notes and information to use for your own use or to share with a Team.

  • Explore the OneNote Interface
  • Creating a Notebook, Adding Sections and Pages
  • Adding Content from Excel, Word and Webpages

MICROSOFT VISIO ONLINE

90 minute session

This will give you a basic introduction to creating a Process Flowchart in Microsoft Visio. Visio is an application for creating diagrams using pre-installed templates e.g. Process Flowcharts, Organisation Charts, new office layouts and many more diagrams.

  • Explore the Visio Interface
  • Creating and formatting a Process Flowchart
  • Creating an Org Chart


Contact us for more detail about our trainings and for all other enquiries!

Upcoming Trainings

Join our public courses in our Istanbul, London and Ankara facilities. Private class trainings will be organized at the location of your preference, according to your schedule.

Classroom / Virtual Classroom
21 March 2024
Istanbul, Ankara, London
1 Day
Classroom / Virtual Classroom
06 May 2024
Istanbul, Ankara, London
1 Day
Classroom / Virtual Classroom
12 June 2024
Istanbul, Ankara, London
1 Day
Classroom / Virtual Classroom
04 August 2024
Istanbul, Ankara, London
1 Day
Classroom / Virtual Classroom
23 August 2024
Istanbul, Ankara, London
1 Day
Classroom / Virtual Classroom
04 September 2024
Istanbul, Ankara, London
1 Day
Classroom / Virtual Classroom
10 September 2024
Istanbul, Ankara, London
1 Day
Classroom / Virtual Classroom
13 October 2024
Istanbul, Ankara, London
1 Day
By using this website you agree to let us use cookies. For further information about our use of cookies, check out our Cookie Policy.