
- This event has passed.
Advanced Excel 2010
31st October 2017 @ 9:00 am - 4:00 pm
£160Objectives: | This course is designed to show delegates tools and techniques at the higher end of Excel’s capabilities. It should provide them with new skills and an in-depth awareness of the advanced formulas and features that Excel has to offer, helping to maximise its full potential. |
Style: | A structured, hands-on, tutor-led session using practical examples and exercises. |
Prerequisites: | Delegates attending this course must have good practical experience using most of Excel’s popular formulas and formatting tools (or have previously attended an intermediate course). |
Content: |
Quick review of essentials
Formulae – quickest & best practice methods Formula Auditing Trace Dependants / Trace Precedents Show / Hide formulas – [F2] key to edit Goals Seeking Using Goal Seek to find a required value More Statistical Functions COUNTIF & SUMIF (multiple ranges) Logical Functions IF Functions (using Absolute cell references) Named Ranges Creating & managing Named ranges Lookup Functions H & VLOOKUP (using Named ranges) |
Text Functions
UPPER / LOWER / PROPER Manipulating Data Navigation shortcuts for databases Macros Recording a Macro Data Consolidation Grouping / ungrouping worksheets Protection Protecting workbooks & worksheets Rounding Functions ROUND / ROUNDUP / ROUNDDOWN / INT |
Benefits to the organisation
|
NB: This course is also available as in house course tailored to the needs of your organisation if you have a minimum of 5 delegates (Please enquire for details)