Intermediate Excel

Intermediate Excel

13th March 2019
9:30 am - 5:30 pm

Location:
IRD Duhallow
Newmarket
Places remaining: 10
Cost: €€100.00 (Plus booking fee)

Terms & Conditions - Click Here

The aim of this training course is to provide clients with the necessary skills required to produce reports using spreadsheets incorporating various calculations, professional formatting & graphical charts.

Duration: 1 day

Time: 9.30am- 5.30pm

The aim of this training course is to provide clients with the necessary skills required to produce reports using
spreadsheets incorporating various calculations, professional formatting & graphical charts.

Client Profile
It is important that each client has previous experience and a basic working knowledge of Microsoft word or any
application. Ideally each client would have access to a computer system where Microsoft Excel is available to
maximum learning post training

Basic Working knowledge – Open Close Save files, understand the formatting menu i.e. Font, Font size, Text
colour and importantly to be able to navigate within a spreadsheet.

Course Outline
Microsoft Excel 2010 / 2013 / 2015
 Intermediate MS Excel Command & Functions
 Open Close, Save File Formats
 Font Type, Font Size, Bold Italics, Underline
 Font Colour, Page Setup & Margins
 Worksheets, Columns & Rows,
 Borders
 Editing Cells, Text Orientation, Comments
 Headers & Footers
 Spreadsheet layout, Freezing Panes etc
 Grouping Cells, Audit functions
 Conditional Formatting
 Data Filters & Sorting
 Formulas, Addition Substraction, Count, Min, Max
 Percentages
 IF Statments
 Linking Worksheets
 Adjusting sheets for Printing, Row Column Headers
 Page Styles
 Graphs
 Templates
 Embedded Objects within Excel & MS Word

***A limited number of FREE places are available on this course for those in receipt of a welfare payment. For further details contact Louise on 029-60633 / [email protected]***

Keep this field blank:

Registration Form

First name *
Required field
Last name *
Required field
E-Mail *
Required field
Phone number *
Required field
Date of birth
Address
What target group do you fall under?
Seats *
Comments / Special Requirements