Individual courses – how can Excel help you?

Excel is a Microsoft Office package that a lot people need to know about but dread looking in to learning about as they don’t know where to look! Here at JPL we offer a wide range of levels of courses that you can learn about Excel and how it can be used in your work place!

We also offer a range of hints and tips on our website, which you can see a few of below from our more Advanced Excel courses.

Charting in Excel

Charting in Excel is probably the single most function that has changed through the releases we’ve seen since 2003. It is now incredibly simple to create a chart from a set of data – just make sure you’ve got your Series and Category headings set up correctly and then you can use either the QA button (in 2013) or the legendary F11 button in any release. It’s so easy in 2013 to add titles, data labels and new axes.

Nested Functions in Excel

On our Advanced and Master Class courses in Excel we cover nested functions especially IF, VLOOKUP and ISEROR.

These can be tricky to follow but the golden rule is when building one is firstly to break down the more complicated nested statement into two or three separate cells and get that working before moving on to the nested function.

Examples are below:

=IF(and(b1>c1),”Over budget”,”on budget”) This would say if the value in b1 (Actual spend) is greater than c1 the budget spend then you are over your budget else you are on target.

=vlookup(vlookup(a10,table1,2,false),table2,3,false) This would look up a value in table1 starting with the value in a10 and pick up column 2 exactly and then use this new value as the lookup value to table2 and pick up the 3rd columns value exactly

If you would like to know about individual courses or even courses for groups, then do email us on johnlegge@jplcomputer.co.uk

Cookie Control

Cookie control

We have placed cookies on your device to help make this website better.

I'm fine with this

We have placed cookies on your device to help make this website better.

You can use this tool to change your cookie settings. Otherwise, we’ll assume you’re OK to continue.

Some of the cookies we use are essential for the site to work.

We also use some non-essential cookies to collect information for making reports and to help us improve the site. The cookies collect information in an anonymous form.

To control third party cookies, you can also adjust your browser settings.

I'm fine with this
(One cookie will be set to store your preference)
(Ticking this sets a cookie to hide this popup if you then hit close. This will not store any personal information)
Information and Settings Cookie policy