Intermediate Excel
1st November 2023
9:00 am
Location:
Online
Places remaining: 6
Cost: €45.00 (Plus booking fee)
Terms & Conditions - Click Here 
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
Bookings no longer allowed on this date.
