Aviation Finance Finuas Logo

CLICK HERE TO BOOK NOW

DATES: Monday 23rd February 

LOCATION: Training Point Raheen Limerick

COST: €€100.00 per participant….. funding applied

 

Overview
This Microsoft Excel Intermediate training course is a 1 Day public 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.
Target Audience
This Microsoft Excel Intermediate training programme may be of interest to personnel who wish to gain a comprehensive overview of the basic features of Microsoft Word. No prior knowledge of Microsoft Word is required; however an experience of basic computer and keyboard skills would be an advantage.

 

Agenda
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. • HLOOKUP.
Statistical Functions • COUNT. • COUNTA. • COUNTIF. • CONCATENATE.
Text to columns Named Ranges • Naming Cell Ranges. • Removing a Named Range. • Named Cell Ranges and Functions. Cell Formatting • Applying Styles to a Range. • Conditional Formatting. • Custom Number Formats.
Manipulating Worksheets • Copying or Moving Worksheets • Splitting a Window. • Hiding Rows, Columns & Worksheets. Templates • 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 • Custom Sorts • Customized List • AutoFilter
Subtotalling
Charts • 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.

 

Trainer

Phone:061 498919
Email:B.Egan@TrainingPoint.ie

Skillnets funded from the National Training Fund through the Department of Education and Skills

The Aviation Finance Finuas Network is funded by member companies and the Finuas Networks Programme, an initiative of Skillnets funded from the National Training Fund through the Department of Education and Skills.

Click here for Finuas Network website www.finuas.ie

 


 

Enquire about this course:

Full Name (required)

Your Email (required)

Your Message

Anti-Spam Check:
Please enter the text & numbers as they appear in this image
captcha