Description

Course Overview: 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.

Duration: 1 Day (09:30 – 16:30)

 Course Content: 

Named Ranges
• Naming Cell Ranges.
• Removing a Named Range.
• Named Cell Ranges and Functions.

Setup & Printing Issues
• Worksheet Setup
• Headers and Footers
• Scaling Your Worksheet to Fit a Page(s)
• Printing Titles On Every Page
• Printing the Row and Column Headings
• Spell Checking
• Previewing a Worksheet
• Viewing Workbooks Side By Side
• Printing Options

Functions and Formulas
• Getting Help With Functions.
• Nested Functions.
• Mixed References within Formulas.

Time & Date Functions
• TODAY.
• NOW.
• DAY.
• MONTH.
• YEAR.

Functions
• ROUND.
• ROUNDDOWN.
• ROUNDUP.

• SUMIF.

Logical Functions
• IF.
• AND.
• OR.

Lookup Functions
• VLOOKUP.

Statistical Functions
• COUNT.
• COUNTA.
• COUNTIF.
• CONCATENATE.

and more here: Microsoft Excel Intermediate

 Please book online

Member €100

Non-Member €130

For more information email Cillian at cgriffey@shannonchamber.ie or call 061 475 854

Please quote Purchase Order number if required on invoice. Cheques should be made payable to Shannon Chamber Skillnet. 

Training Cancellation Policy: Registrants who cancel over 7 days in advance of scheduled training date shall incur no cancellation fee. Registrants who cancel within 7 days of scheduled training date shall incur a cancellation fee equal to 50% of the cost. Registrants who give less than 24 hours notice or fail to attend training will be charged 100% of the full fee.

Shannon Chamber Skillnet is co-funded by Skillnet Ireland and member companies. Skillnet Ireland is funded from the National Training Fund through the Department of Education and Skills.

For further information please visit www.skillnetireland.ie