Course: Up-skilling SPF123 | Grŵp NPTC Group Moodle

  • General


  • Open all

    Close all

  • Instructions: Clicking on the section name will show / hide the section.

  • 2

    Overview

    The UK Shared Prosperity Fund (UKSPF) is a central pillar of the UK Government’s Levelling Up agenda and will provide £2.6 billion of funding for local investment by March 2025.

    The overarching objective of the Fund is building pride in place and increasing life chances.

    The UKSPF aims to achieve this through three investment priorities:

    • Community & Place;
    • Supporting Local Business; and
    • People & Skills (including the 'Multiply' initiative to improve adult numeracy)

    The UK Shared Prosperity Fund Prospectus provides a comprehensive overview of the fund.


  • 3

    SPF Training Courses   To apply:  
      eMail Business at:  
                Business@NPTCgroup.ac.uk
                with the following :
    Date, Time, Venue, and Subject. 
                Name, Date, Time, Venue, and Subject. 
                For more details click here 
     
    Venue Date Day Month AM Subject  PM  Subject 
    Online 01/02/2024 Thursday February 09:00 - 13:00 Intermediate Word  14:00 - 16:00  Introduction to One Drive 
    Online 02/02/2024 Friday February 09:00 - 13:00 Advanced Excel  14:00 - 16:00  Using Windows PC & the Internet 
    Online 05/02/2024 Monday February 09:00 - 13:00 Beginners Excel  14:00 - 16:00  Intermediate Outlook Email and Calendar 
    Online 06/02/2024 Tuesday February 09:00 - 13:00 Intermediate Excel  14:00 - 16:00  Introduction to Teams 
    Online 07/02/2024 Wednesday February 09:00 - 13:00 Beginners Word  14:00 - 16:00  Introduction to Office 365 
    Online 08/02/2024 Thursday February 09:00 - 13:00 Intermediate Word  14:00 - 16:00  Introduction to One Drive 
    Online 09/02/2024 Friday February 09:00 - 13:00 Advanced Word  14:00 - 16:00  Make the Best of Mobile Devices 
    Online 19/02/2024 Monday February 09:00 - 13:00 Beginners Excel  14:00 - 16:00  Intermediate Outlook Email and Calendar 
    Online 20/02/2024 Tuesday February 09:00 - 13:00 Intermediate Excel  14:00 - 16:00  Introduction to Teams 
    Online 21/02/2024 Wednesday February 09:00 - 13:00 Beginners Word  14:00 - 16:00  Introduction to Office 365 
    Online 22/02/2024 Thursday February 09:00 - 13:00 Intermediate Word  14:00 - 16:00  Introduction to One Drive 
    Online 23/02/2024 Friday February 09:00 - 13:00 Advanced Excel  14:00 - 16:00  Make the Best of Mobile Devices 
    Online 26/02/2024 Monday February 09:00 - 13:00 Beginners Excel  14:00 - 16:00  Intermediate Outlook Email and Calendar 
    Online 27/02/2024 Tuesday February 09:00 - 13:00 Intermediate Excel  14:00 - 16:00  Introduction to Teams 
    Online 28/02/2024 Wednesday February 09:00 - 13:00 Beginners Word  14:00 - 16:00  Introduction to Office 365 
    Online 29/02/2024 Thursday February 09:00 - 13:00 Intermediate Word  14:00 - 16:00  Introduction to One Drive 
    Online 01/03/2024 Friday March 09:00 - 13:00 Advanced Word  14:00 - 16:00  Using Windows PC & the Internet 
    Newtown 04/03/2024 Monday March 09:00 - 13:00 Beginners Excel  14:00 - 16:00  Intermediate Outlook Email and Calendar 
    Newtown 05/03/2024 Tuesday March 09:00 - 13:00 Intermediate Excel  14:00 - 16:00  Introduction to Teams 
    Newtown 06/03/2024 Wednesday March 09:00 - 13:00 Beginners Word  14:00 - 16:00  Introduction to Office 365 
    Newtown 07/03/2024 Thursday March 09:00 - 13:00 Intermediate Word  14:00 - 16:00  Introduction to One Drive 
    Newtown 08/03/2024 Friday March 09:00 - 13:00 Advanced Excel  14:00 - 16:00  Make the Best of Mobile Devices 
    Newtown 11/03/2024 Monday March 09:00 - 13:00 Beginners Excel  14:00 - 16:00  Intermediate Outlook Email and Calendar 
    Newtown 12/03/2024 Tuesday March 09:00 - 13:00 Intermediate Excel  14:00 - 16:00  Introduction to Teams 
    Newtown 13/03/2024 Wednesday March 09:00 - 13:00 Beginners Word  14:00 - 16:00  Introduction to Office 365 
    Newtown 14/03/2024 Thursday March 09:00 - 13:00 Intermediate Word  14:00 - 16:00  Introduction to One Drive 
    Newtown 15/03/2024 Friday March 09:00 - 13:00 Advanced Word  14:00 - 16:00  Using Windows PC & the Internet 
    Newtown 18/03/2024 Monday March 09:00 - 13:00 Beginners Excel  14:00 - 16:00  Intermediate Outlook Email and Calendar 
    Newtown 19/03/2024 Tuesday March 09:00 - 13:00 Intermediate Excel  14:00 - 16:00  Introduction to Teams 
    Newtown 20/03/2024 Wednesday March 09:00 - 13:00 Beginners Word  14:00 - 16:00  Introduction to Office 365 
    Newtown 21/03/2024 Thursday March 09:00 - 13:00 Intermediate Word  14:00 - 16:00  Introduction to One Drive 
    Newtown 22/03/2024 Friday March 09:00 - 13:00 Advanced Excel  14:00 - 16:00  Make the Best of Mobile Devices 
    Brecon 08/04/2024 Monday April 09:00 - 13:00 Beginners Excel  14:00 - 16:00  Intermediate Outlook Email and Calendar 
    Brecon 09/04/2024 Tuesday April 09:00 - 13:00 Intermediate Excel  14:00 - 16:00  Introduction to Teams 
    Brecon 10/04/2024 Wednesday April 09:00 - 13:00 Beginners Word  14:00 - 16:00  Introduction to Office 365 
    Brecon 11/04/2024 Thursday April 09:00 - 13:00 Intermediate Word  14:00 - 16:00  Introduction to One Drive 
    Brecon 12/04/2024 Friday April 09:00 - 13:00 Advanced Word  14:00 - 16:00  Using Windows PC & the Internet 
    Brecon 15/04/2024 Monday April 09:00 - 13:00 Beginners Excel  14:00 - 16:00  Intermediate Outlook Email and Calendar 
    Brecon 16/04/2024 Tuesday April 09:00 - 13:00 Intermediate Excel  14:00 - 16:00  Introduction to Teams 
    Brecon 17/04/2024 Wednesday April 09:00 - 13:00 Beginners Word  14:00 - 16:00  Introduction to Office 365 
    Brecon 18/04/2024 Thursday April 09:00 - 13:00 Intermediate Word  14:00 - 16:00  Introduction to One Drive 
    Brecon 19/04/2024 Friday April 09:00 - 13:00 Advanced Excel  14:00 - 16:00  Make the Best of Mobile Devices 
    Brecon 22/04/2024 Monday April 09:00 - 13:00 Beginners Excel  14:00 - 16:00  Intermediate Outlook Email and Calendar 
    Brecon 23/04/2024 Tuesday April 09:00 - 13:00 Intermediate Excel  14:00 - 16:00  Introduction to Teams 
    Brecon 24/04/2024 Wednesday April 09:00 - 13:00 Beginners Word  14:00 - 16:00  Introduction to Office 365 
    Brecon 25/04/2024 Thursday April 09:00 - 13:00 Intermediate Word  14:00 - 16:00  Introduction to One Drive 
    Brecon 26/04/2024 Friday April 09:00 - 13:00 Advanced Word  14:00 - 16:00  Using Windows PC & the Internet 
    Brecon 29/04/2024 Monday April 09:00 - 13:00 Beginners Excel  14:00 - 16:00  Intermediate Outlook Email and Calendar 
    Brecon 30/04/2024 Tuesday April 09:00 - 13:00 Intermediate Excel  14:00 - 16:00  Introduction to Teams 
                   

  • 4

    Beginners Word

    Course Content:

    • Paragraphs, alignment, and justification
    • Line spacing
    • Tables
    • Borders and shading
    • Tabs, stops and indents
    • Page numbers, headers, and footers
    • Bullets and numbered lists
    • Adding Pictures
    • Dictionary and Thesaurus

    To apply:            

    Please email Business at Business@NPTCgroup.ac.uk  with the following information: Date, Time, Venue, and Subject when applying.

  • 5

    Advanced Word

    Course Content:

    • Create and modify templates
    • Using and merging different documents
    • Use tables, forms, and columns to organise information
    • Create and use contents pages
    • Create and use Marcos
    • Advanced document formatting

    Please email Business at Business@NPTCgroup.ac.uk  with the following information: Date, Time, Venue, and Subject when applying.

  • 6

    Beginners Excel

    Course Content:

    • Creating, opening, and saving a workbook
    • Learn to set up spreadsheets from new
    • Understanding the Excel screen (Quick Access Toolbar, Ribbon)
    • Learn how to enter data
    • Learn how to do basic maths functions (addition, subtraction, multiplication, and division)


  • 7

    Intermediate Excel

    Course Content:

    • Learn how to use formulae and functions
    • Explore the various user interface elements
    • Use the Excel galleries
    • Customise the interface
    • Creating forms with Excel
    • Replicate formulae and functions
    • Create an absolute reference
    • Range names and how they are applied
    • Using Freeze Panes
    • Recording the current date and time on the printed spreadsheet
    • Turning your figures into charts
    • Formatting charts

    Please email Business at Business@NPTCgroup.ac.uk  with the following information: Date, Time, Venue, and Subject when applying.

  • 8

    Advanced Excel

    Course Content:

    • Absolute cell references
    • Naming cells and ranges
    • Referring to named cells and ranges in formulae
    • Editing named cells and ranges
    • Setting up entire workbooks with group editing
    • Using VLOOKUP and HLOOKUP statements to retrieve date
    • Editing lookups and ensuring accuracy in returned data
    • Linking spreadsheets and workbooks together with formulas and functions
    • Utilising IF statements to assist decision making
    • IF statements and calculations
    • Analysing data with the all new conditional formatting features
    • Sorting data numerically and alphabetically
    • Filtering data for range and precision analysis
    • Setting up data validation to ensure integrity of the data
    • Attaching security to a spreadsheet
    • Selective protection i.e., protecting formulas whilst allowing data entry
    • Setting up and utilising templates
    • Creating and formatting charts
    • Adding trend lines to the chart
    • Utilising custom chart types


  • 9

    Intermediate Outlook Email and Calendar

    Course Content:

    • Tabs
    • Creating and replying to emails
    • Forwarding emails
    • Attaching files to emails
    • The Outlook calendar



  • 10

    Introduction to Teams

    Course Content:

    • Overview
    • Channels
    • Meetings
    • Collaboration


  • 11

    Introduction to Office 365

    Course Content:

    • Overview
    • Apps
    • Collaboration
    • Sharing


  • 12

    Introduction to One Drive

    Course Content:

    • Overview
    • Storage
    • Collaboration
    • Sharing
    • Tools (basic)


  • 13

    Using Windows PC & the Internet

    Course Content:

    • Access PC / Startup
    • Desktop
    • Documents
    • Accessing the internet


  • 14

    Make the Best of Mobile Devices

    Course Content:

    • Accessing your device
    • Setting up your device
    • Customising your device