Blog Main Categories
- Project Management 81
- Business Skills 157
- Creative Design 94
- Business Processes 88
- IT and Web Development 81
- Digital Marketing 160
You are viewing posts by Andy Trainer. Click to view all posts
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.
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.
To work through our PRINCE2 quiz, use the links below:
- PRINCE2 Quiz Part 1: PRINCE2 Principles
- PRINCE2 Quiz Part 2: Business Case Theme
- PRINCE2 Quiz Part 3: Organisation Theme
- PRINCE2 Quiz Part 4: Quality Theme
- PRINCE2 Quiz Part 5: Plans Theme
- PRINCE2 Quiz Part 6: Risk Theme
- PRINCE2 Quiz Part 7: Change Theme
- PRINCE2 Quiz Part 8: Progress Theme
- PRINCE2 Quiz Part 9: Starting up and Initiating a Project
- PRINCE2 Quiz Part 10: Directing a Project , Controlling a Stage and Managing Product Delivery
- PRINCE2 Quiz Part 11: Managing a Stage Boundary and Closing a Project
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.
Welcome to the first part of our PRINCE2® Quiz, which will test your knowledge of PRINCE2 Processes & Themes.
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.
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.
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...
- Pavilion Entertainment
- Precision Paraplanning
- SNAP Solutions
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 "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!
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.
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.
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.
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.
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!
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."