Course description
This course is ideal for individuals who wish to enhance their current knowledge of Excel by understanding how to use the applications more complex features. Delegates will learn how to perform calculations and functions within a workbook, manipulate data lists and create custom charts which will enable the user to maintain and present data in a professional looking format.
Upcoming start dates
Choose between 2 start dates
Suitability - Who should attend?
Outcome / Qualification etc.
- work with functions within Excel
- format within worksheets
- manage cells and ranges
- interrogate lists and worksheets
- create more sophisticated tables and charts
Training Course Content
Module 1 – More Functions
- IF
- AND/OR
- Nested IF
- SUMIF/COUNTIF
- Text Functions
- Sorts & Filters
- Basic Sorts
- Multiple Sorts
- Custom Sorts
- AutoFilter
- Advanced Filter
- Protection/Security
- Data Validation
- Protected Sheets/workbooks
- Linking Sheets
- Linking Files
- Managing
- Chart Types
- Chart Elements
- Modifying Chart Elements
- Combo Charts
Course delivery details
Continuing Studies
Request info
Cosensa Learning and Development
Innovation Factory
385 Springfield Road
BT12 7DG Belfast
Cosensa Learning and Development Training Courses
Cosensa Learning & Development offers training courses for professionals and organisations throughout the public, private and third sectors. All Cosensa trainers are highly qualified, with extensive experience in training and coaching. Cosensa's wide range of open courses are delivered throughout...
Ads