Category: West Sussex

PowerPoint Training CoursesWest Sussex

PowerPoint Training West Sussex | Live Online or Onsite

PowerPoint Training Options During the COVID-19 Pandemic

COVID-19: Whilst the COVID-19, Coronavirus emergency lasts, online, remote PowerPoint training provides a safe way for businesses to train their staff. Whether you are employed, self-employed or an individual looking to update your skills, we are here to help.

Furloughed employees may still take part in training – please see government guidance.

Closed, Private PowerPoint Training for Businesses

If you are a business enquiring about private, tailored PowerPoint training for your staff, please see our Microsoft Office remote training information page which will explain all you need to know about our virtual PowerPoint classroom.

Open, Scheduled PowerPoint Courses for Individuals 

If you are an individual looking to join a remote scheduled PowerPoint course, please see our scheduled PowerPoint training page here.

Established in 2005, Blue Pecan provides tailored / bespoke in house PowerPoint training courses.

Live Online Courses - PowerPoint courses can be delivered online with a live tutor via Zoom, Microsoft Teams or Webex virtual classroom software.

Onsite Courses - PowerPoint courses can be delivered onsite at your business premises.

We deliver in-house PowerPoint training to businesses in West Sussex including Arundel, Billingshurst, Bognor Regis, Burgess Hill Chichester, Crawley, East Grinstead, Gatwick, Haywards Heath, Horsham, Lancing, Littlehampton, Midhurst, Petworth, Pulborough, Shoreham-by-Sea, Worthing.

PowerPoint Course Outline

Creating a Presentation from Scratch

  • Starting a new presentation
  • Adding slides to a presentation
  • Selecting an appropriate slide layout
  • Saving a presentation
  • Breaking up your presentation into sections
  • Creating Custom Shows

Working with Text

  • Entering text as bullet points
  • Shortcut keys for formatting text
  • Controlling Autocorrect
  • Controlling Autosize for placeholders
  • Using the outline view to organise text
  • Converting text to SmartArt

Including Other Content

  • Including and formatting Excel charts
  • Including and formatting SmartArt
  • Including and formatting images
  • Including and formatting videos
    • Trimming video
    • Bookmarking video
  • Including and controlling audio

Working with Slide Masters

  • Designing a Slide Master
  • Designing Layout Masters
  • Creating additional Slide Masters
  • Applying a Slide Master to a slide
  • Applying Layout Masters
  • Importing Slide Masters from other presentations
  • Preserving Slide Masters
  • Headers and Footers

Transitions and Animations

  • Applying transitions to a Slide Master
  • Applying transitions to individual slides
  • Applying animations to slide content
    • The Animation Pane
    • Effect options
    • Start on options

PowerPoint Outputs

  • Presenter shortcuts
  • Annotating a presentation
  • Navigating a presentation
  • Setting up slide timings
  • Set up Slide Show options
  • Printing handouts
  • Printing speaker notes
  • Creating read-only shows
  • Package for CD

FAQS [sc_fs_multi_faq headline-0="h4" question-0="Where does Blue Pecan Computer Training Ltd deliver these courses?" answer-0="Private training courses…

Read More
Excel ConsultingWest Sussex

Excel Consulting West Sussex

Excel Consulting for Businesses in West Sussex

Looking for an Excel developer? We can help with custom Excel spreadsheet development, either through redesign of existing spreadsheets or design from scratch. Although our main expertise at Blue Pecan is onsite training, we are often asked to act in a consulting role to develop, design, customise and improve our client's spreadsheets. 

Here are the aspects of Excel's functionality we can help you with.  

Bespoke Spreadsheet Development

  • Automate frequent and repetitive tasks to free up your time
  • Probe deeper into and more effectively analyse your data
  • Create professional looking, automated dashboards
  • VBA development to push the boundaries of Excel’s capabilities
  • Complex formula
  • Interrogate your data with Power Pivot and Power Query.

Need Help from an Excel Specialist?

If we can help, please email us at info@bluepecan.co.uk providing as much information as you can about the project you would like help with and the timescale in which you need it to be done. We can then provide you with a quote.

We are happy to offer our Excel consulting services to you wherever you are based in West Sussex including Arundel, Billingshurst, Bognor Regis, Burgess Hill Chichester, Crawley, East Grinstead, Gatwick, Haywards Heath, Horsham, Lancing, Littlehampton, Midhurst, Petworth, Pulborough, Shoreham-by-Sea, Worthing.

Read More
Microsoft Project Training CoursesWest Sussex

MS Project Training West Sussex | Live Online or Onsite

Training Options During the COVID-19 Pandemic

COVID-19: Whilst the COVID-19, Coronavirus emergency lasts, online, remote training provides a safe way for businesses to train their staff. Whether you are employed, self-employed or just looking to update your skills, we are here to help.

Furloughed employees may still take part in training - please see government guidance.

Business Enquiries - Closed, Private Courses

For closed, private courses suitable for businesses with one or members of staff who need training, please see our Microsoft Office remote training information page which will explain all you need to know about our virtual Microsoft Project classroom.

Individual Enquires - Public, Scheduled Courses

For open, publically scheduled courses, please see our scheduled remote Microsoft Project training courses.

Live Online Courses - MS Project courses can be delivered online with a live tutor via Zoom, Microsoft Teams or Webex virtual classroom software.

Onsite Courses - Ms Project courses can be delivered onsite at your business premises.

Established in 2005, Blue Pecan delivers Microsoft Project training live online (virtual classroom) or at customers' business premises. Our one day Microsoft Project training course will enable delegates to effectively schedule tasks, assign resources and track the progress of project.

We deliver Microsoft Project training to businesses in West Sussex including Arundel, Billingshurst, Bognor Regis, Burgess Hill, Chichester, Crawley, East Grinstead, Gatwick, Haywards Heath, Horsham, Lancing, Littlehampton, Midhurst, Petworth, Pulborough, Shoreham-by-Sea, Worthing.

Our Microsoft Project training course is compatible with Project 2016, 2013, 2010, & 2007.

Pricing

COVID-19: Whilst the COVID-19, coronavirus emergency lasts, online, remote training provides a safe way for businesses to train their staff. Whether you are employed, self-employed or just looking to update your skills, we are here to help.  Please see our pricing for remote training here.

Publicly scheduled courses 

From £150 inc vat – price per person / delegate per day course


In-house training prices

Instructor Led Training via Zoom, Webex etc

One-to-one training
Half-day session – £195 plus vat
Full-day session – £350 plus vat

Group training
Half-day session – £295 plus vat
Full-day session – £550 plus vat

Shorter one-to-one sessions
Charged at £75 plus vat per hour

Onsite Pricing (Per Group) – Day Rates

Full-day session – £595 plus vat.  

Group Size

We recommend group sizes no larger than 5 for online training and 10 for onsite training, but are happy to accommodate your requirement.

Project Course Outline

Our one day Microsoft Project training course gives you a great overview of this popular project management software.  The course aims to give delegates the knowledge needed to set and and link tasks; assign resources to tasks; set baselines and track progress and then create useful reports and outputs based on the values that have been gathered.

Customising the Project Interface

  • Customising the Quick Access Toolbar
  • Customising the Ribbon
  • Exporting/importing your customisations

Configuring Your Project

  • Setting the project start date
  • Setting up working times for the project
  • Adding bank holidays and other shut-down periods
  • Saving customisations to the global template
  • Auto scheduling vs Manual scheduling tasks

Entering Tasks

  • Task durations
  • Setting the default unit for durations
  • Deleting tasks
  • Inserting tasks
  • Moving tasks
  • Creating milestone tasks

Linking Tasks

  • Creating links using the predecessors column
  • Creating links using the Task Information dialogue box
  • Creating links using the “link tasks” button
  • Dragging and dropping links in the Gantt chart
  • Relationship types
    • Finish to start relationships
    • Start to start relationships
    • Finish to finish relationships
    • Start to finish relationships
  • Applying lag and lead to task relationships
  • Task Path Highlighter

Task Constraints

  • Constraint types
  • Understanding the Planning Wizard in relation to constraints

Subtasks

  • Indenting tasks to create subtasks
  • Collapsing and Expanding Summary Tasks
  • Outline numbering
  • Work Breakdown Structure
  • The Project Summary Task

The Critical Path

  • Formatting your Gantt chart to show the critical path
  • Understanding the critical path

Navigation

  • Using the “Go to” dialogue box
  • Scroll to task
  • Zoom options
  • Formatting the Gantt chart timescale

Resources

  • Resource types
    • Work resources
    • Material resources
    • Cost resources
  • Understanding the resource sheet columns – material, max units, rate, accrue at, base calendar
  • Editing resource calendars – adding holidays, customising work times
  • Assigning resources to tasks
  • Understanding the “Work” value
  • Levelling resources
  • Budget resources

Setting a baseline

  • How to set a baseline
  • Viewing the baseline in the Tracking Gantt
  • Viewing baseline values in tables

Tracking Progress on Your Project

  • Marking a task as on track
  • Moving incomplete parts of a task to a new date
  • Updating task start and finish dates as well as percentage complete
  • Setting a Status Date
  • Tracking progress in the Resource Usage view

More on Project

  • Hyperlinking to supporting documents
  • Using text styles format your task list
  • Formatting the Gantt chart with bar styles
  • Formatting Gantt chart gridlines
  • Sorting the task list
  • Filtering data in different Project view
  • Grouping data
  • Creating reports
  • Printing the Gantt chart
  • Sharing resources across multiple projects
  • Combing multiple projects into one Gantt chart

[sc_fs_multi_faq headline-0="h4" question-0="Where in West Sussex does Blue Pecan Computer Training…

Read More