Date: Wednesday, 15th April 
Time: 9am to 4pm
Price: £135 +VAT members / £215 +VAT non members
Venue: The Roundthorn Country Hotel, Penrith, CA11 8SJ

The aim of the course is to provide delegates with the skills to use functionality that will make formulae easier to work with, to create formulae using data from multiple worksheets, and to apply more complex formatting.
Delegates must have previously attended the “Introduction to Excel” course or gained similar knowledge in the workplace.

Course Outline
• Saving and File Management
• Converting and Encrypting Files
• File Properties and Digital Signatures
• File Accessibility and Compatibility
• Formulas with Absolute References
• Autosum Functions (SUM & AVERAGE)
• IF and Nested Functions
• Working with Named Ranges
• Array Functions (SUMIF & AVERAGEIF)
• Formula Auditing
• Text Functions
• Creating Excel Tables
• Working with Records and Filters
• Advanced Filters    
• Flash Fill
• Remove Duplicates
• Data Validation
• Consolidate
• Trendlines
• Error Bars
• Working with Axis Options
• Advanced Chart Formatting
• Creating Sparklines
• Editing Sparklines
• Working with Themes
• Creating Custom Styles
• Applying Cell Styles
• Text to Columns

Delegates will be asked to carry out exercises as we progress so will be required to bring a laptop or tablet. Handouts will be provided for reference during the course.