Intermediate Excel

Intermediate Excel

27th March 2018
9:30 am

Location:
James O'Keeffe Institute, Newmarket, Co. Cork

Places remaining: 0
Cost: €100.00 (Plus booking fee)

Start Date: 27th March
Day of the Week: Monday
Time: 9:30am – 5.30pm
Duration: 1 Day
Venue: James O’Keeffe Institute, Newmarket, Co. Cork.
Tuition Fee: €100
Accreditation: Cert of Attendence

Aim of Course: 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.
Course Outline:
• Intermediate MS Excel Commands & 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 Function,
• Conditional Formatting,
• Data Filters & Sorting,
• Formulas, Addition Subtraction, Count, Min, Max
• Percentages
• IF Statements
• Linking Worksheets
• Adjusting sheets for Printing, Row Column Headers
• Page Styles
• Graphs
• Templates
• Embedded Objects within Excel & MS Word
This course is suitable for anyone who would like to be produce and run professional looking
slide shows. No previous experience of MS PowerPoint is required; however, it is important that
those attending have a good working knowledge of other Microsoft applications e.g. MS Word
or Excel.

We will look at the basics of slide content from text based slides through to inserting SmartArt,
pictures, charts etc. We will also look at formatting the slide show in a number of different ways
including applying PowerPoint Design Themes.

Once the content is complete, we will then look at adding the finishing touches to your
slide show by adding Custom Animation. Learn then how to run the slide show in the most
professional way possible through the use of some simple keys.