Can't find what your looking for?

Call us on +44 (0)1273 622272 or contact us.

Courses

showing {{courseLimit}} of {{(courses | filter:query).length}} results Show All

Hide All

Categories

showing {{courseLimit}} of {{(tags | filter:query).length}} results Show All

Hide All

theBLOG

Excel Tutorial: Using Lookup Formulas

Written by Andy Trainer – Sun 13 Apr 2014

This tutorial is an extract from our popular 1-day Advanced Excel course. Lookup formulas are one of the most asked about topics so we decided to put together a short tutorial.

Lookup tables provide a way of producing numbers or text that cannot be calculated with a formula. For example they could look up a salesman's commission dependent on what has been sold (Example 1), or the amount of discount available to a customer based on the amount of goods ordered (Example 2).

Excel has two Lookup functions; Vertical and Horizontal.

VLOOKUP looks down the vertical column on the left side of the table until the appropriate comparison is found.

HLOOKUP looks across the horizontal row at the top of a column until the appropriate comparison is found.

Function Syntax

LOOKUP(lookup_value,table_array,col_index_num,range_lookup)

HLOOKUP(lookup_value,table_array,row_index_num,range_lookup)

Read More


PRINCE2 Quiz

Written by Andy Trainer – Mon 07 Apr 2014

Now you can test your knowledge of PRINCE2® with our interactive PRINCE2 Quiz!

Split into 11 bite-sized parts, this quiz tests your understanding of PRINCE2 2009 Themes and Processes.

Our PRINCE2 quiz is ideal for revision for your PRINCE2 Foundation and PRINCE2 Practitioner exams or for testing your knowledge before coming on a PRINCE2 course.

PRINCE2 Revision Quiz

To work through our PRINCE2 quiz, use the links below:

For comprehensive instructor-led PRINCE2 training, examination and certification, delegates should attend one of our public PRINCE2 Foundation training or PRINCE2 Practitioner training courses in Brighton, UK.

Head over to our PRINCE2 Resources page for more help with your PRINCE2 revision.

This PRINCE2 quiz is written by Silicon Beach Training and does not represent real PRINCE2 exam content.

Read More


PRINCE2 Quiz Part 1: PRINCE2 Principles

Written by Andy Trainer – Sun 06 Apr 2014

Welcome to the first part of our PRINCE2® Quiz, which will test your knowledge of PRINCE2 Processes & Themes.

PRINCE2 Quiz Part 1

If you are completely new to PRINCE2, we recommend visiting our PRINCE2 Resources page, full of free guides, tips and diagrams to help learn about PRINCE2.

The quiz is made up of 11 Bite-Sized Parts - each with 5 questions.

It should take you no longer than two minutes to complete each part.

Get 5 or more correct answers to pass!

Quiz questions are written by Silicon Beach Training, this content is not supplied by AXELOS.

Passing this quiz does not indicate that you will pass a PRINCE2 Foundation or Practitioner Exam.

For full PRINCE2 training and certification attend a Foundation or Practitioner course at Silicon Beach.

Read More


Silicon Beach Start-up Finalists Announced

Written by Andy Trainer – Wed 02 Apr 2014

We hope that you enjoyed reading about all the startups on our shortlist (check out part 1 if not), but now it's time to announce the Top 5 startups who are through to our grand final.

Startup Finalists Announcement

Our shortlist was sent to our esteemed judging panel - Mike Herd (Sussex Innovation Centre), Caraline Brown (Midnight Communications), Lisa Reynolds (Let Me Do That For You), Darren Fell (Crunch Accounting) and Lee Mansfield (Life Media Group) - who then sent back their individual top 5. We tallied the scores and are delighted to announce that the following startups are through to the final...

  • Localfunded
  • Pavilion Entertainment
  • Precision Paraplanning
  • SNAP Solutions
  • TagPoints

The final will take place at Silicon Beach Training on Tuesday April 22. Each finalist will have five minutes to present their business plan followed by a 10 minute Q & A session with the judges. We've got our fingers crossed for some Apprentice/Dragon's Den style grilling.

The eventual winner will receive over £12,000 of business services from our sponsors, including:

  • £10,000 worth of training at Silicon Beach Training
  • One year subscription to Crunch Accounting worth over £900
  • £1000 of PR consultancy with Midnight Communications
  • £1000 of business strategy consultancy with Clear Business Development

All of the finalists are of a high calibre so we recommend keeping an eye on every business in the future. Here's a bit more about what they do...

Localfunded 

Localfunded "is an innovative, reward-based, crowdfunding platform, focusing on local projects that impact their communities positively throughout the UK." 

They only launched their service last week and already have a number of projects up and running with backers.

We particularly like the Purley Festival project which features some interesting funding options. So far most people have gone for 5 burgers and 5 drinks for £20!

Read more in Startup Stories Part 3.

Pavilion Entertainment

Pavilion Entertainment "is an innovative, reward-based, crowdfunding platform, focusing on local projects that impact their communities positively throughout the UK."

One of the businesses that caught our attention at Silicon Beach and also hooked the judges, Pavilion Entertainment seeks to kickstart the music scene in Brighton with a local radio station, live video, community blog, magazine and live events.

Read more in Startup Stories Part 3.

Precision Paraplanning

Precision Paraplanning "provide high quality outsourced paraplanning solutions to Financial Advisers."

Compared to some of our wackier entries, Precision Paraplanning have a solid, serious business plan with a clear vision moving forward. Their entry really impressed our judges as a potential success story in the future.

Read more in Startup Stories Part 5.

SNAP Solutions

SNAP "is the first ever consumer driven Social Nightlife Mobile solution giving consumers a fun, rewarding and hassle-free experience when visiting a Bar, Pub or Club (BPCs)."

Mobile is still a massively growing industry, and SNAP are hoping to corner a market that hasn't got any main players yet - nightlife. The SNAP app allows users to pay for and order drinks without queuing - an attactive prospect on a busy Friday night! There are played incentive schemes to get new users on board.

Read more in Startup Stories Part 1.

TagPoints

TagPoints "is the most exciting and creative loyalty scheme ever to be designed for a mobile device."

Another mobile app startup, TagPoints want to make physical stores mobile-friendly with their SaaS platform which allows businesses to intelligently target customers.

Read more in Startup Stories Part 1.

Read More


Silicon Beach Startup Stories - Part 5

Written by Andy Trainer – Wed 26 Mar 2014

Welcome to the final post in our Startup Stories series, featuring the last three startups to be announced on our competition shortlist.

We will be announcing the Top 5 next week along with the details of our final event which has everyone at Silicon Beach excited.

Good luck to everyone on our shortlist and we look forward to meeting five of you in a month!

Lighthouse Learning

Lighthouse Learning

What is Lighthouse Learning?

"Lighthouse Learning creates awesome digital learning for kids.

"We are a fast growing in-house development team focused on building cool products that kids and parents love.

"With 2 successful iOS apps completed, we are working on a fun and educational cross-platform product for little learners around the world."

Read More