Customised programme
Key Information
Course Level
Level 2
Delivery
Part-Time
Duration
1 Day (9.00am – 4.00pm)
The course covers the following –
- Introduction
- Work Related Spreadsheets
- Working Example
- Quick Access Toolbar
- Formula Auditing
- Named Ranges
- Data Validation (using Named Ranges
- Absolute Values (‘Locking’ the cell reference)
- Data Transfer between Worksheets and Spreadsheets
- Conditional Formatting
- IF Statements and Formulas
- VLOOKUPs
- Inserting Charts
- Pivot Tables
- Paste Options / Clipboard
- Date and Time Functions
- Placing Existing Data into a ‘Table’
- Themes
- Adapting the view of the Spreadsheet
- Inserting ‘Screen-Shots’
- SmartArt Graphics
- What-If Analysis
- Version History
- Show Changes
- Work Related Spreadsheets
There is also an opportunity during the last section of the workshop to work on Excel with specific work related issues.
N/A
N/A
Financial Support
Depending on your situation, you may be able to access a range of financial support available.
Course Fees
UK
We do not currently have fee information available for this course. Please contact us for further information.
Apply or enquire about this course-
Please use the following links to make an enquiry about this course.