Excel for Scientists - Training Course

Training course covering principles and techniques used when dealing with scientific data in Microsoft Excel.

This course enables users of Excel to become more aware of what can be done using the software, and gives hands-on experience of some of the more common tasks so that these can be readily applied to a wide range of situations.

The course is taught by experienced scientists whose daily roles involve significant and in-depth use of Excel. This is not an "off-the-shelf" Excel training course, but is much more focused on the tasks and types of data that scientists are likely to encounter in their day-to-day work.

Key Features: 

• Data Entry - file formats, copying, moving, hiding, printing, cell referencing, auditing, validation, formulae and functions.
• Data Manipulation - sorting, filtering, conditional formatting, pivoting and macros.
• Data Interpretation - graphing (including filtered graphing), statistics (Analysis Toolpak add-in) and fitting equations to data (Solver add-in).

Benefits to You and Your Organization: 

Microsoft Excel is part of the standard Office suite and is, therefore, available on most PCs. It has a high degree of flexibility and significant power enabling it to perform most data-based scientific tasks. Quite often the full potential of this software goes unused due to users being unaware of what it can and cannot do. By the end of this course, users will have a clearer understanding of the power of Excel. They will be able to perform a number of more regularly used tasks but will also know how much further they can push the software when the need arises.

The knowledge gained on this course will enable staff to be more productive, achieving more in a shorter time. It may also save capital expenditure by eliminating the purchase of additional, often costly, specialist software when the tasks can actually be achieved in Excel.

Feedback Received: 

• "I thought that the course was pitched at the right level for me. There were some areas that I already knew about but quite a lot that was new to me."
• "I thought that the presentations were very good. It is rare to find computer experts who can talk clearly to other people about their subject and convey this sort of information in a way that can be easily followed and understood."
• "This really was a very good course for us and you will see that the feedback reflects this. I will definitely be interested in holding this course here again in the future."
• "Learnt a lot about things that I though I knew about and learnt many new methods and tools that I expect will improve my abilities at work."
• "Very useful tips and tricks that will help with data analysis in my job."

Future Courses:

Regular courses are held at Intertek, Manchester, UK.

Tailored courses can also be run at your location.

Request more information to see how Intertek can help your organization with Excel for Scientists - Training Course.