Excel Intermediate
Need course dates or locations to suit you? CLICK HERE TO SEND ENQUIRY...  
Excel Intermediate.

Target Audience:
Existing users who want to unlock the power of their spreadsheets and develop their skills and confidence further. This is a hands-on course with plenty of opportunity for discussion and practice.

What’s Covered?
- review of good spreadsheet design concepts and techniques
- applying formula to textural data, (e.g. to convert to uppercase)
- using logical functions and nested IF's to carry out complex tests
- using SUMIF and COUNTIF to selectively sum and count
- using dates within formula, (e.g. to calculate due date on an invoice)
- working with named ranges and multiple worksheets
- when to use absolute, relative and mixed cell addressing
- hiding and protecting data, (including security considerations)
- creating hierarchical data structures with Outlines
- overview of list handling, (including sorting and use of AutoFilters)
- using data validation to control user input, (including drop-down lists)
- using Lookup functions to find data values in a table
- customising the Toolbars

Please Note:
There will be a maximum group size of 6 attendees allowing for individual attention from the tutor and the opportunity to practise your skills during the day. Feel free to bring along a spreadsheet of your own to work on.

 
Need course dates or locations to suit you? CLICK HERE TO SEND ENQUIRY...  
My Location
Results for location are highlighted in the table below. Click here to remove highlight
The course either has new dates in data loading, or is only run as a dedicated or In Company course.
Tools
 
Key Details
Duration1 day
 
£145
per delegate
 
 
Bookings Helpline: 01933 233884 (Monday to Thursday - 8:00am to 5:30pm and Friday 8:00am to 5:00pm).