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:

  • Wed
    19
    Jun
    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
  • Fri
    28
    Jun
    2019
    Leeds

    Course Content:

    • Creating Memorable Presentations through structure, key points & visual aids
    • Formatting images, screenshots and clipping
    • Creating and using slide templates and backgrounds
    • Setting up master slides, layouts & custom themes
    • Creating, editing and using shapes
    • How to create and design charts
    • Building diagrams with Smart Art
    • Animations and transitions
    • Inserting audio and video
    • Creating menus
    • Presentation tips
    Show Course Details
  • Sat
    29
    Jun
    2019
    Manchester

    Course Content:

    • Creating Memorable Presentations through structure, key points & visual aids
    • Formatting images, screenshots and clipping
    • Creating and using slide templates and backgrounds
    • Setting up master slides, layouts & custom themes
    • Creating, editing and using shapes
    • How to create and design charts
    • Building diagrams with Smart Art
    • Animations and transitions
    • Inserting audio and video
    • Creating menus
    • Presentation tips
    Show Course Details
  • Mon
    08
    Jul
    2019
    Liverpool

    Course Content:

    • Creating Memorable Presentations through structure, key points & visual aids
    • Formatting images, screenshots and clipping
    • Creating and using slide templates and backgrounds
    • Setting up master slides, layouts & custom themes
    • Creating, editing and using shapes
    • How to create and design charts
    • Building diagrams with Smart Art
    • Animations and transitions
    • Inserting audio and video
    • Creating menus
    • Presentation tips
    Show Course Details
  • Wed
    10
    Jul
    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
  • Thu
    11
    Jul
    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 that 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.

    Entering and editing data with shortcuts
    Entering data, adding rows / column, moving data around quickly and keyboard shortcuts.

    Spreadsheet maths
    Performing calculations like qty x price and giving you an understanding of how maths works within Excel including use of the $ symbol in a calculation.

    Working with multiple workbooks
    You will work with more than one file on the screen at the same time and see tips to make this easier and also how to link them together with maths.

    Working with large worksheets
    Working within printing and viewing options for a large workbook, you will learn how to get things on the screen and a print out better.

    Working with lists
    You will see how to sort and filter a list within Excel allowing you to create reports very quickly.

    Modifying Graphs and Sparklines
    You will get an understanding of how to manipulate graphs and create sparklines which are tiny graphs in a cell that show trends (Sparklines are Excel 2010 onwards)

    Show Course Details
  • Wed
    17
    Jul
    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
    23
    Jul
    2019
    Manchester

    Course Topics:

    • LinkedIn – How it works
    • How it can work for you
    • Creating the perfect profile page
    • Creating an effective company page
    • Key Dos and Don’ts of LinkedIn
    • Building a strategy for lead generation through LinkedIn
    • Making the most of business pages
    • How to make the most of the search function.
    • Creating great content for LinkedIn
    • LinkedIn Groups and other features
    • Creating Effective LinkedIn advertising campaigns
    • Managing LinkedIn advertising campaigns
    • Optimising LinkedIn ad campaigns
    Show Course Details
  • Wed
    14
    Aug
    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
    15
    Aug
    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
  • Thu
    15
    Aug
    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 that 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.

    Entering and editing data with shortcuts
    Entering data, adding rows / column, moving data around quickly and keyboard shortcuts.

    Spreadsheet maths
    Performing calculations like qty x price and giving you an understanding of how maths works within Excel including use of the $ symbol in a calculation.

    Working with multiple workbooks
    You will work with more than one file on the screen at the same time and see tips to make this easier and also how to link them together with maths.

    Working with large worksheets
    Working within printing and viewing options for a large workbook, you will learn how to get things on the screen and a print out better.

    Working with lists
    You will see how to sort and filter a list within Excel allowing you to create reports very quickly.

    Modifying Graphs and Sparklines
    You will get an understanding of how to manipulate graphs and create sparklines which are tiny graphs in a cell that show trends (Sparklines are Excel 2010 onwards)

    Show Course Details
  • 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.
Performing arts school database Video

No flash installed

×
IFA Practice Manager

No flash installed

×
Production Scheduling Tool

No flash installed

×
Format As Table Part 1

No flash installed

×
Format as a table part 2

No flash installed

×
Subtotalling a list

No flash installed

×
Sorting basics

No flash installed

×
Cell Styles

No flash installed

×
Remove Duplicates In List

No flash installed

×