We are pleased to be able to offer a limited number of free places for jobseekers on our network programmes subject to funding being available. Please click on the following link to check if you meet Jobseekers eligibility criteria
DATES: Friday 2nd December 2016
TIMES: 9.30am – 5.00pm (Registration at 9.15)
LOCATION: Optima Training, Raheen, Limerick
COST: €100 per member €120 non member (funding applied/regular cost is €180.50 per person)
(Courseware Manual / Certificate and Lunch & Light Refreshments Included in price)
This Microsoft Excel Advanced training course is a 1 Day programme, designed for candidates who would like to enhance their understanding and knowledge of Excel to an advanced level. It takes participants through the items listed in the course contents to a point where participants can use Microsoft Excel to advanced levels to increase efficiency in their everyday work.
Creating Excel templates.
Displaying hidden template folders on a Windows 7 computer.
Editing Excel templates on a Windows 7 computer.
Displaying hidden template folders on a Windows Vista computer.
Editing Excel templates on a Windows Vista computer.
Displaying hidden template folders on a Windows XP computer.
Editing Excel templates on a Windows XP computer.
Paste Special Options
Using Paste Special to add, subtract, multiply & divide.
Using Paste Special values.
Using Paste Special transpose option.
Using a Pivot Table.
Filtering and Sorting Data
Creating and using a pivot table.
Filtering and sorting data within a pivot table.
Automatically grouping data in a pivot table and renaming groups.
Manually grouping data in a pivot table and renaming groups.
One-input data tables.
Two-input data tables.
Combined line and column charts.
Adding a secondary axis to a chart.
Adding a data series to a chart.
Removing a data series from a chart.
Re-positioning chart title.
Re-positioning the chart legend.
Moving and formatting chart data labels.
Modifying chart axis scales.
Formatting an axis to display using commas.
Inserting images into chart columns.
Inserting images to chart bars.
Formatting the chart plot area using a picture.
Formatting the chart area using a picture.
Linking & Embedding
Linking data within a worksheet.
Linking cells between worksheets
Linking data between workbooks.
Linking data from Excel to Word.
Linking an Excel chart to Word.
Updating, locking and breaking links.
Tracking and Reviewing Changes
Enabling or disabling the ‘track changes’ feature.
Sharing, comparing and merging worksheets.
Scenario summary reports.
Data validation – Whole number.
Data validation – Decimal number.
Data validation – List.
Data validation – Date.
Data validation – Time.
Data validation – Text Length.
Customising a validation input message and error alert.
Removing data validation.
Tracing precedent cells.
Tracing dependent cells.
Identifying cells with missing dependents.
Showing all formulas in a worksheet, rather than the resulting values.
Inserting and viewing comments.
Editing and deleting comments.
Showing and hiding comments.
Assigning a Macro to a Button on the Quick Access Toolbar.
Macro to change the page set-up.
Macro to apply a custom number format.
Macro to format a cell range.
Macro to insert fields into the header or footer.
Assigning a macro to a button on the Quick Access toolbar.
Modifying Excel Options
Minimising the Ribbon
Passwords & Security Issues
Adding password protection to a workbook.
Removing password protection
Password protecting cells and worksheets.
Hiding and un-hiding formulas.
Anyone who wants to gain a comprehensive overview of the advanced features of Microsoft Excel.
Anyone with a good knowledge of Excel or who has completed Intermediate Excel training.
Optima Training http://www.trainingpoint.ie/Home.aspx#.WDWELGdvgdU