For business IT peace of mind call
01553 609969

Analysing your data in Microsoft Excel Analysing your data in Microsoft Excel

This one day course is designed for users who want to use the software more efficiently to analyse and visualise data

Pre-requisites

Delegates must already be using Microsoft Excel to a relatively high standard as this course is designed for the more advanced user.

Course details

Consolidating your information by linking and Data Consolidate

Using PivotTables and PivotCharts

Data validation

Protecting cells, sheets and workbooks

Using Lookup and Error functions

Using conditional formatting

Creating simple macros (using record macro not writing VBA code)

Using and creating keyboard shortcuts

* There may be some flexibility in content according to the audience on the day

Reserve Your Place(s)

Investment

£175 per person (+vat)


Venue

Yours Business Network
Bishops Lynn House
18 Tuesday Market Place
King's Lynn
PE30 1JW


This course can also be held at your own premises or at a venue of your choice, please contact us for details.

Our Blog

How to Keep Your Data Safe Online

For both individuals and business, keeping data secure is crucial - whether it is passwords, financial information and any other personal data. Cyber attacks have... Read More »

Windows 7 end of life, what does it mean for my business?

On the 14th of January 2020 Windows 7 will be entering its end of life, the implications for machines running this are far reaching as... Read More »

Is your phone recording your conversations?

We are always on guard when talking -- whether on the phone or in public -- we obviously do not want any stranger to listen... Read More »

Call today if you would like to learn more about how you can protect and streamline your IT and data with Anglia IT Solutions.

King's Lynn Office01553 609969

Norwich Office01603 959000