Information about the General Data Protection Regulation (GDPR) is available on the Data Protection area of the staff intranet (login required).
If your department or team have a Facebook page, then it is important not to share the administrator password with anyone. You can add additional editors onto your page by following these steps:
Excel Quick Selection Techniques
In Excel to highlight/select data you can "click and drag" around the data to select it, there are in fact several different ways you can highlight/select data a lot faster or more effciently. Esspecially when you have large ammounts of data.
There are several ways to re-size a column or row, each has a specific use and will benefit you in different ways depending on what you wish to accomplish.Click and drag a column or row header's boundary:
To resize an individual column or row you can click...
Freeze Panes can be used to lock specific columns or rows in place so that you may see them where-ever you are within the data.
In the view tab of the ribbon you will find the "freeze panes" drop down menu:
When you input data into Excel it is initially a 'data array' and although it is perfectly fine to leave data in this format it is sometimes easier or better to convert it to Table for the following reasons;
This page will guide you through using Excel to create basic mathematical operations. This is very similar to creating a function or formula except that we are not using the function's operative such as (=Sum) or (=Average) or...
This page will cover the 5 basic functions found in the auto-sum drop-down menu:
Summation, the addition of a...
Cell references are used in almost all functions and they interact differently with the Auto-fill handle depending on what type of reference you have used:
The fill handle is shown when a cell is selected (by left clicking it), you will...