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


Silicon Beach Startup Stories - Part 4

Written by Aaron Charlie – Mon 24 Mar 2014

In Part 4 of our Startup Stories feature, we have three interesting new commerce businesses that have all spotted a gap in the market.

We will announce the final 3 from our shortlist on Wednesday and then the Top 5 chosen by our judging panel next week.

Don't forget to read about our other shortlisted startups in Part 1, Part 2Part 3.

Sweet Hangovers Bakery

Sweet Hangovers Bakery

What is the Sweet Hangovers Bakery?

"Sweet Hangovers Bakery is a bakery specialising in alcohol-infused sweet treats. We produce cakes, cupcakes, cake pops, bread, biscuits, tarts, pies and many more treats.

"All our goods are infused with premium alcohols from spirits, liquors to champagnes. Sweet Hangovers is currently run from a private home-based kitchen."

Read More


Silicon Beach Startup Stories - Part 3

Written by Andy Trainer – Mon 17 Mar 2014

We're now halfway through our Startup Shortlist announcement and today we feature 3 community-focused startups with very different ideas.

If you haven't already, don't forget to read Startup Stories Part 1 and Startup Stories Part 2 to find out more about the 6 startups already announced.

The Honeycomb Imaging

We're lucky to be surrounded by some fantastic local craft businesses in the North Laine in Brighton. Adam Bastock has come up with a way to help the craft community by offering affordable product photography.

What is Honeycomb Imaging?

"The Honeycomb Imaging offers affordable and effective product photography services to small and personal businesses locally."

Honeycomb Imaging

Read More


Silicon Beach Startup Stories - Part 2

Written by Aaron Charlie – Fri 14 Mar 2014

Yesterday we announced our first 3 shortlisted startups, this is the second part of our Startup Stories series where we feature 3 of the best entries to our Startup Competition each day.

Today's featured startups are all hoping to revolutionise the travel industry with innovative new ideas.

Goat on a MopedGoat on a Moped

You can't help but remember the name (partly why they chose it!), Goat on a Moped want to create a better experience for finding out about travel destinations. I particularly like the map-based discovery engine - I often use Google Maps to research potential destinations anyway so combining that with personal blogs about areas and experiences would be great.

Find out more from David Matthews...

Read More


Silicon Beach Startup Stories - Part 1

Written by Andy Trainer – Thu 13 Mar 2014

Startup StoriesWe've spent the past week poring over the excellent entries to our Startup Competition to win over £12,000 of services.

The standard has been incredibly high and we look forward to tracking all the entries throughout their development.

Our shortlist of 15 promising startups is now with our judging panel who will decide the final 5 to present at the final.

While we wait for the judges' decision, we are going to feature the shortlist in a series of posts, starting with this one!

A lot of the applicants mentioned online marketing as the main area they need support to grow their business, so we're hoping that our brand new SEO courses and one-of-a-kind Social Media strategy workshops can help them out.

In no particular order, here are the first 3 shortlisted startups...

Read More


New Course: Advanced SEO Training for Managers

Written by Aaron Charlie – Mon 03 Mar 2014

Learn the advanced SEO techniques required for planning strategy and managing clients & teams with our new Advanced SEO Strategy course.

Advanced SEO Training for Managers

We have been running SEO courses for over 10 years and although we update the content before every course to reflect the latest changes, it is time to launch a new course aimed at more senior SEO practitioners & managers.

Advanced SEO Training will give you the skills to actively plan, exectue and improve campaigns in an in-house or agency role.

Building on our Beginner - Intermediate SEO course, this course will teach you how to apply your skills directly to a website and make intelligent, informed decisions.

We believe this is the most up to date SEO course on the market and one of a handful that focuses on strategy.

You might already know what makes Google tick - but are you prepared for future changes? Do you have an agile strategy that is future-proofed against future updates?

Read More