Module 1 – More Functions
- IF
- AND/OR
- Nested IF
- SUMIF/COUNTIF
- Text Functions
Module 2 – Sorts, Filter and Security- Sorts & Filters
- Basic Sorts
- Multiple Sorts
- Custom Sorts
- AutoFilter
- Advanced Filter
- Protection/Security
- Data Validation
- Protected Sheets/workbooks
Module 3 – Linking- Linking Sheets
- Linking Files
- Managing
Module 4 - Charts- Chart Types
- Chart Elements
- Modifying Chart Elements
- Combo Charts
On completion, delegates will have the knowledge how to:
- work with functions within Excel
- format within worksheets
- manage cells and ranges
- interrogate lists and worksheets
- create more sophisticated tables and charts
- demonstrate intermediate Excel skills
This intermediate Excel training course is ideally suited for individuals who are either self-taught and have a basic knowledge of Excel or have already completed the Introduction level programme.
This course helps delegates gain the
skills necessary to create sort and filter data, import, export and analyse data. In addition,
this course helps prepare students who desire to take the Microsoft
Certified Application Specialist exam in Excel and who already have
knowledge of the basics of Excel, including how to create, edit, format,
and print basic worksheets.
No pre-course work required.
