|
|
|
|
|
|
|
 

Intertek ASG Laboratory, Manchester, UK > Informatics > Excel for Scientists Training Course

Excel for Scientists Training Course

Excel for Scientists by Scientists - a training course covering the principles and techniques required when using Microsoft Excel to deal with scientific data.

Regular courses are held at Intertek ASG, Blackley, Manchester, UK

Tailored courses can be run at your location

Next Course
ASG Home
About Intertek ASG
ASG News
Available Services
Computational Chemistry
Measurement and Control
ASG Information Centre
Send Us A Request

 

Email ASG for more information   asg.nwtc@intertek.com

Telephone ASG for more information  +44 (0) 161 721 5247
  Call Us using Skype

Email ASGlab@intertek.com for more information
Overview and Objectives

A training course covering the principles and techniques required when using Microsoft Excel to deal with scientific data. The aim of this course is to provide information to enable users of Excel to become more aware of what can be done using the software, and to give 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 will be 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 purposefully much more focussed to the tasks and types of data that scientists are likely to encounter in their day-to-day work.

 Excel for Scientists by Scientists - e training course covering the principles and techniques required when using Microsoft Excel to deal with scientific data
Key Features
  • Data Entry - how to get your data into Excel in the first place.

Starting with a guided tour of Excel to bring users up to speed with the terminology to be used throughout the course, this block then goes on to cover the various file formats that Excel can deal with and their individual capabilities. Functionality for copying, moving, hiding and displaying data on the page, and extended options for producing hard copy in the print settings are then introduced. Finally, cell referencing, auditing and validation, formulae, and functions are covered.

  • Data Manipulation - how to arrange, format and augment your data.

In this block of the course, various ways of manipulating the data are covered. This includes sorting, filtering using both the autofilter and advanced filter options, conditional formatting, and pivoting to reshape the data. It concludes with a section on macros which are a powerful way of simplifying repetitive tasks.

  • Data Interpretation - how to query your data to derive information and knowledge.

The final block of the course starts with a section covering the graphing functionality including the combination of this with filtering to produce filtered graphs. Also covered is the functionality included in two Excel add-ins: Analysis Toolpak for statistical analysis and Solver for iteratively solving equations.

 Excel for Scientists by Scientists - e training course covering the principles and techniques required when using Microsoft Excel to deal with scientific data
Benefits to You and Your Organisation

Microsoft Excel is part of the standard Office suite and is therefore available on most desktops. 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 money by eliminating the purchase of additional, often costly, specialist software when the task can actually be achieved in Excel.

 Excel for Scientists by Scientists - e training course covering the principles and techniques required when using Microsoft Excel to deal with scientific data
Who Should Attend?

Regular Excel users who:

  • Feel they are not using the software to its full potential
  • Think that there are tasks that Excel can help with but don't know how
 Excel for Scientists by Scientists - e training course covering the principles and techniques required when using Microsoft Excel to deal with scientific data
Course Duration

This is a one-day course split over an afternoon and the following morning.

Email ASGlab@intertek.com for more information
Testimonials
  • 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 complex 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 thought 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.
Excel for Scientists by Scientists - e training course covering the principles and techniques required when using Microsoft Excel to deal with scientific data
 Intertek Group, Plc | Intertek OCA Disclaimer | Terms and Conditions