Intermediate Excel

Intermediate Excel

21st November 2019
9:30 am

IRD Duhallow, James O'Keeffe Institute, Co. Cork
Co. Cork
Places remaining: 10
Cost: €€100.00 (Plus booking fee)

Terms & Conditions - Click Here

Course Name: Intermediate Excel

Start Date: Thursday 21st November

Time: 09:30am – 5.30pm

Duration: 1 Day

Venue: James O’Keeffe Institute, Newmarket, Co. Cork

Tuition Fee: €100

Accreditation: Cert of Attendance

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

Bookings no longer allowed on this date.