Do you have staff who are needing to extend their Excel skills?
Second of a set of 3 courses
About this Event
During this course you will learn the next level of Microsoft Excel.
Understand the terminology, work your way around spreadsheets and make your reports look professional using data tools, charts, formulas and all the latest functionality available in Excel.
£95 for the full day including refreshments and lunch.
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
· Text to Columns
· 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
Event Venue & Nearby Stays
Workington, United Kingdom
GBP 95.00
