Business Excellence Skillnet
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
DATES: Tuesday, October 25th 2016
TIMES: Registration 9.15 Training starts at 9.30 am 4.30 pm
LOCATION: Optima Training & Consulting, Portal House, Raheen, Limerick
COST: €100 per member; €125 non member (funding applied/regular cost is €180.50 per person)
Courseware Manual / Certificate and Lunch & Light Refreshments Included in price
This Microsoft Excel Intermediate training course is a 1 Day programme designed for anyone who wants to improve his or her knowledge of Microsoft Excel. Participants will learn topics, which will improve their efficiency and productivity in the work place.
On completion of this course participants will be able to use much of the functionality with MS Excel including:
- Competent use of Shortcut Keys
- Use formatting tools such as the format painter
- Write and copy formulas Relative / Absolute
- Work with multiple worksheets and write formulas across sheets / Link Sheets.
- Create professional looking charts and use drawing tools to enhance these.
- Use the database functionality of MS Excel Sorting & Auto Filter
Setup & Printing Issues
Worksheet Page Size
Headers and Footers
Header and Footer Fields
Scaling Your Worksheet to Fit a Page(s)
Printing Titles On Every Page
Printing the Row and Column Headings
Previewing a Worksheet
Viewing Workbooks Side By Side
Functions and Formulas
Getting Help With Functions.
Consolidating Data using a 3-D Reference Sum Function.
Mixed References within Formulas.
Time & Date Functions
Naming Cell Ranges.
Removing a Named Range.
Named Cell Ranges and Functions.
Applying Styles to a Range.
Custom Number Formats.
Copying or Moving Worksheets
Splitting a Window.
Hiding Rows, Columns & Worksheets.
Creating Excel Templates.
Editing Excel Templates
Paste Special Options
Using Paste Special to Add, Subtract, Multiply & Divide.
Using Paste Special Values.
Using Paste Special Transpose Option.
Database & List Management – Sorting and Filtering Data
Sorting Data by Multiple Columns
Combined Line and Column Chart.
Adding a Secondary Axis.
Changing the Chart Type For a Data Series.
Adding a Data Series to a Chart.
Removing a Data Series from a Chart.
Modifying the Chart Title, Legend & Data Labels.
Chart Axis Scales.
Inserting Images Into Chart Columns.
Formatting the Chart Area
This Microsoft Excel Intermediate training programme will be of interest to Microsoft Excel users that understand basic Excel skills (typing in cells, used a formula before, opened a workbook…)and also users who have had no formal training in excel but who understand the basic features of the programme.
Training Company – Optima Training & Consulting