Course Aim:

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 and graphical charts.

Client Profile:

It is important that each client has previous experience and a basic working knowledge of Microsoft Excel. Ideally each client would have access to a computer system where Microsoft Excel is available to maximise learning post training

Basic Working knowledge – Open, Close, Save files, understand the formatting menu i.e. Font, Font size, Text colour and have a knowledge of basic formulas.

Course Outline:

Microsoft Excel Office 365/ 2013 / 2016 / 2019

• Intermediate MS Excel Command & Functions
• Open Close, Save File Formats
• Subtotals
• 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, Subtraction, Count, Min, Max
• Percentages
• IF Statements
• Linking Worksheets
• Adjusting sheets for Printing, Row Column Headers
• Page Styles
• Graphs, use chart features/filters
• Templates
• Embedded Objects within Excel & MS Word

Course Location:

Killarney, Kerry | Macroom | Cork City | Online

Course Available as Daytime Training | Night Classes | One-to-One | Online

Please contact Island Computers & Training for more details