Intermediate Excel Training Course Objectives:
Our Intermediate Excel training 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.
Quality Training – Practical Benefits
Microsoft Excel Training has delivered training in Dublin, Waterford, Kilkenny, Sligo, Galway, Donegal, Tipperary, Athlone, Dundalk, Kerry and Wexford. We have delivered training to clients all over Ireland. Our clients range from multinationals, government bodies and SME’s. We will customise any training course to suit your specific requirements.
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.
Course Outline:
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
Functions
- IF
- Count IF
Recommended Course: Advanced Excel