Intermediate Excel

Intermediate Excel

13th March 2019
9:30 am

Location:
IRD Duhallow
Newmarket
Places remaining: 6
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.

Intermediate Excel

Start Date: 12th March

Day of the Week: Wednesday

Time: 9.30am – 5.30pm

Time: Duration: 1 Day

Venue: IRD Duhallow, James O’Keeffe Institute, Newmarket

Tuition Fee: €100

Accreditation: Certificate of Attendance.

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

 

Bookings no longer allowed on this date.