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.
Benefits
This course is designed for those users who wish to step up their current knowledge of Excel to take advantage of the more complex features. To be able to create, edit and format large or multiple spreadsheets. Delegates will also be able to perform calculations and functions within a workbook, manipulate data lists and create custom charts which will enable the user to maintain and present data in a professional environment.
Typically our courses are delivered in one day, to groups of upto 8 delegates, at your location. This keeps your costs down, and allows your staff to learn in a familiar environment. If you don't have your own training facility, then we can deliver training at a location to suit you, which you can arrange yourself or we can do that for you.
For more information please contact us at info@inspiresit.ie or call the senior trainer on 085 1055651
Inspire IT has delivered training in Dublin, Waterford, Kilkenny, Sligo, Galway, Donegal, Tipperary, Athlone, Dundalk, Kerry and Wexford.
Charting
- Creating
& Modifying Charts
- Formatting
Charts
- Creating
Line & Pie Charts
- Editing
the Legend
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
Graphic
Objects
- Using
Graphic Objects in a spreadsheet
|
| Back to Main Excel Page>> |
Recommended Course Advanced Excel |
|
