 Course Objectives:
Our
Intermediate Excel course will further develop your skills using excel
to assist you in your work environment. You will learn how to create and modify charts, how to use cell comments and how to print them off. How to use hyperlinks in Excel spreadsheets which is of particular use for those of you who work off shared drives. |
Inspire IT has delivered training in Dublin, Waterford, Kilkenny, Sligo, Galway, Donegal, Tipperary, Athlone, Dundalk, Kerry and Wexford.
We will travel onsite anywhere in Ireland
Prior to to course we will discuss your requirements and develop the course content to suit your needs.
- All participants receive handouts and course files of the course content if they want to review the information at a later date.
- 6 months FREE E-mail Support after course.
- Inspire IT are flexible with start and finish times for courses. We have delivered training courses that started at 7am and finished at 2pm due to clients preference.
- Training will be delivered onsite.
For more information please E-mail Alan Joyce at info@inspiresit.ie or contact him at 085 1055651 |
| |
Cell
Comments
- Inserting
Comments
- Displaying
all Comments on sheet
- Modifying
& Moving Comments boxes
- Printing
Comment boxes on sheet.
Formatting
- Merge
Cells
- Wrap
Text in a Cell
- Place
text at an angle in a cell
- Cell
Backgrounds
Conditional
Formatting
- Applying
Conditional Formatting
- Deleting
Conditional Formats
|
Hyperlinks
- Creating
hyperlinks to an Excel file
- Creating
links to specific sheet in file
- Creating
links to specific cells in a particular sheet with a file
- Linking
to named ranges
- Linking
to applications outside Excel
- Removing
hyperlinks
Sorting
& Subtotaling
- Sorting
data on a spreadsheet
- Creating
subtotals on a spreadsheet
- Removing
subtotals
Auto
Filter
- Turning on
the AutoFilter
- Doing a Custom
Filter
Functions
|
|
