Woodthorpe IT Solutions Ltd

course-dates

Upcoming Course Dates

 

meeting_2

Please see below a list of upcoming course dates. These courses are ideally suited for individuals or small groups. For more details of content please click on the course name:

  • Tue
    17
    Sep
    2019
    Manchester

    Course Content:

    • Using the Calendar effectively
    • Managing Contacts
    • Creating and assigning tasks
    • Utilising Email Options
    • Delay sending an email, setting an expiry and redirecting
    • Use Quick Parts
    • Managing incoming mail
    • Using Automatic Replies
    • Creating and using folders
    • Utilising Automated rules to manage mails
    • Creating and Using Search Folders
    • Managing Junk Mail and archiving messages
    • Managing Safe, Unsafe and blocking recipients
    • Creating and Managing Notes
    • Instant Messaging
    Show Course Details
  • Tue
    17
    Sep
    2019
    9:30 amManchester

    This 1 day course combines the best parts from the introduction and intermediate Excel training sessions. Each module below shows a summary for part of the day, time is built in to each section for questions and other bonus topics to be added in based on the needs of the attendees.

    Formatting - Cell styles, Tables and Conditional
    These are the clever pre-set and automated formats within Excel. You will be able to format large sets of data based on pre-sets and also format cells based on what is within them e.g. if value less than 5 make the cell red.

    Protection
    You will be able to lock down a spreadsheet so that only certain people will be able to change parts of the spreadsheet. So allowing you to control how the spreadsheet is used better.

    Templates
    This allows you to protect an original format of an Excel file. Eg if you have a quote form you want people to fill In, saving as a template will mean that each time they use the form it will be blank and ready to fill in. Rather than potentially having the last persons entry in it.

    Validation
    This allows you to control what data can be entered to a spreadsheet. Eg I only want a value between 1 and 5 OR I only people to select from a drop down list of options.

    Vlookup
    This function allows you to link data together between more than one list. So if you have two lists and you want to “mash” the data together Lookups allows you to fetch data from one list in to another.

    Pivot tables
    This is one of the most powerful reporting tools you will have access to. It allows you to get a detailed list and summarise it by any column very quickly. It is very flexible and once you understand a couple of simple rules it is very easy to use.

    Recording Macros
    This allows you to automate repetitive and robotic tasks. Rather than you having to re do these tasks like a robot each time, Excel will perform the tasks for you.

    Show Course Details
  • Tue
    15
    Oct
    2019
    Manchester

    Course Content:

    • Editing text
    • Saving and Printing Documents
    • Utilising Word's spell check and thesaurus features
    • Using shortcuts
    • Applying formatting to documents
    • Cut, Copy & Paste
    • Text Alignment, Margins & Indents
    • Bulleting and Numbering
    • Creating Tables
    • Performing Calculations in tables
    • Applying Themes
    • Using Watermarks
    • Using the headers & footers
    Show Course Details
  • Wed
    16
    Oct
    2019
    9:30 amManchester

    This 1 day course combines the best parts from the introduction and intermediate Excel training sessions. Each module below shows a summary for part of the day, time is built in to each section for questions and other bonus topics to be added in based on the needs of the attendees.

    Formatting - Cell styles, Tables and Conditional
    These are the clever pre-set and automated formats within Excel. You will be able to format large sets of data based on pre-sets and also format cells based on what is within them e.g. if value less than 5 make the cell red.

    Protection
    You will be able to lock down a spreadsheet so that only certain people will be able to change parts of the spreadsheet. So allowing you to control how the spreadsheet is used better.

    Templates
    This allows you to protect an original format of an Excel file. Eg if you have a quote form you want people to fill In, saving as a template will mean that each time they use the form it will be blank and ready to fill in. Rather than potentially having the last persons entry in it.

    Validation
    This allows you to control what data can be entered to a spreadsheet. Eg I only want a value between 1 and 5 OR I only people to select from a drop down list of options.

    Vlookup
    This function allows you to link data together between more than one list. So if you have two lists and you want to “mash” the data together Lookups allows you to fetch data from one list in to another.

    Pivot tables
    This is one of the most powerful reporting tools you will have access to. It allows you to get a detailed list and summarise it by any column very quickly. It is very flexible and once you understand a couple of simple rules it is very easy to use.

    Recording Macros
    This allows you to automate repetitive and robotic tasks. Rather than you having to re do these tasks like a robot each time, Excel will perform the tasks for you.

    Show Course Details
  • Thu
    17
    Oct
    2019
    Manchester

    Course Content:

    • Customising Heading Styles
    • Effective use of Graphics with a document
    • Using Images within a document
    • Automation of Documents
    • Creating and using templates
    • Document Flow
    • Working With Columns
    Show Course Details
  • Wed
    20
    Nov
    2019
    Manchester

    Course Content:

    • Using the Calendar effectively
    • Managing Contacts
    • Creating and assigning tasks
    • Utilising Email Options
    • Delay sending an email, setting an expiry and redirecting
    • Use Quick Parts
    • Managing incoming mail
    • Using Automatic Replies
    • Creating and using folders
    • Utilising Automated rules to manage mails
    • Creating and Using Search Folders
    • Managing Junk Mail and archiving messages
    • Managing Safe, Unsafe and blocking recipients
    • Creating and Managing Notes
    • Instant Messaging
    Show Course Details
  • Thu
    12
    Dec
    2019
    Manchester

    Course Content:

    • Customising Heading Styles
    • Effective use of Graphics with a document
    • Using Images within a document
    • Automation of Documents
    • Creating and using templates
    • Document Flow
    • Working With Columns
    Show Course Details

Why come to one of our dates?

  • Attendees get their own Laptop to use during the day.
  • We do not lecture! Attendees are encouraged to ask questions.
  • We leave time at the end of the day for custom requests or recapping of content.
  • Attendees get an electronic certificate.
  • Attendees get electronic course notes.
  • Attendees take home contact details for the trainer for post course support.
  • Our venues have parking and are also within walking distance of public transport.

You may also want to consider

meeting_1

Onsite Courses

• We come to you
• We bring all the equipment needed
• The outline can be customised

Contact us

meeting_3

Online Courses

• Self paced
• Budget Friendly
• 24/7 Learning

Buy courses online


What our customers say

© Woodthorpe IT Solutions Site by Ben Timney Business vector designed by Freepik
All prices on this site are excluding VAT unless otherwise stated.