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

Convert PDF to Excel, PowerPoint & Word

Written by Aaron Charlie – Mon 21 Jul 2014

If you've ever tried to copy and paste from a PDF into Office software, you'll know how frustrating it can be. 

Luckily, with Acrobat XI you can easily export information to any Office program - you can even just export snippets of information.

In my example, I've been sent a report and I want to do three things:

  • Import the data into Excel to perform my own analysis
  • Use the key points in a PowerPoint presentation
  • Use insights in my own Word report

Here's how to do each task using Acrobat XI:

Convert PDF to Excel, PowerPoint & Word

This process works great for exporting data, text and graphics from PDF files and even allows you to keep your formatting.

Read More


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


The Best Microsoft Office 2013 Guides

Written by Andy Trainer – Tue 09 Jul 2013

The decision to upgrade to a new version of Office doesn't come lightly. It's not just the monetary cost to consider it's also the time spent training staff on the new software, compatibility issues and potential bugs if you're an early adopter.

We run most of our Office courses on Office 2010 because very few businesses have taken the leap of faith and upgraded to Office 13. A lot of them actually can't; Office 2013 is incompatible with XP, Vista and early versions of Windows - making it unavailable for more than half of Windows users.

However, we know that some businesses are thinking about making the switch so we've put together this list of Office 2013 guides to help you decide whether it's worth upgrading and what you need to know if you decide to.

If you would like more in depth training then contact us about a bespoke Office 2013 upgrade course - including Excel, Access and MS Project.

microsoft-office-2013-guides

 

Read More


6 Reasons to Switch from Word to InDesign

Written by Aaron Charlie – Thu 30 May 2013

There's no doubt that Word will around for a long time. It's taught in all schools and is the de facto software for Word Processing and document creation worldwide. However, InDesign has become more and more popular in businesses due to the desire to create more consistent and professional internal and external documents.

word-vs-indesign

If you have ever tried to persuade your employees/co-workers/boss to switch to InDesign then you've probably been met with one or all the following:

I don't want to learn new software!

It's too complicated!

There's nothing wrong with Word!

I'm going to try and dispel these myths with 6 reasons why now is the right time to switch from Word to InDesign:

Read More


Creative Uses of Excel: From Nyan Cat to Pac-Man

Written by Aaron Charlie – Sun 19 May 2013

Excel-2013-IconWhen people think of Microsoft Excel, they often picture dull figures and charts and just generally lots and lots of data. All very useful stuff but not the most enthralling outside of a work environment.

Some people however, take a different approach. To them Excel can be anything and everything. It's not just for business and numbers. It can be used to create innovative and original concepts, in all sorts of different ways.

Whatever you want to use Excel for, our Excel Training will give you all the knowledge you need to make the most of this powerful tool and it's also worth reading this blog post on some hidden Excel tips and tricks.

So let's take a look at some of the less traditional uses of Excel to give you an idea of what this software can really do.

Art in Excel

Excel can and has been used by artists as a platform to express their ideas and creativity. It may sound like an odd choice of medium but the flexibility and functionality Excel provides is surprisingly suited to artistic endeavour.

Take a look at these magnificent pieces by Japanese artist Tatsuo Horiuchi:

excel-art

art in excel

And these Star Wars-themed works by Shukei are out of this world (excuse the pun):

excel-darth-vader

excel x-wing

Read More