Using built in Features Subtotals and Grouping Intro to Macros & VBA Data Validation What If Analyses Working with Scenarios PivotTables
1: Who is the Course for? This course is designed for users who have a good knowledge and understanding of spreadsheets and wish to use more advanced features of the programme.
2: The Course Courses delivered by InIT Learning are tutor led. The tutor will use demonstration and discussion along with hands-on practical tasks and assignments to ensure each user has gained an understanding of each topic. Questions are encouraged throughout the session. During each task and assignment the tutor will give one to one support as required.
3: Certificates Each delegate will receive a manual and a certificate of attendance
Excel Level 3
Naming Cells & Ranges V & H Lookup Index & Match Logic – AND OR NOT Excel Forms Scenario Manager Goal Seek Installing Solver Solver Data Validation Subtotals Grouping & Outlining Index & Match Toolbars Pivot Tables Pivot Charts Excel Macros Macro Security Saving a Macro Workbook Recording & Running a Macro Relative Cell References (Macros) Viewing & Editing a Macro Assigning Macros Global Macros Object to run Macros
Areas Covered - Milton Keynes, Buckinghamshire - Northampton, Northamptonshire - Rugby, Warwickshire - Oxford, Oxfordshire - Bedford, Bedfordshire - All surrounding towns and counties
The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.