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