San Francisco, California
London, United Kingdom
This one-day course is designed for the experienced Excel user who wishes to examine the more advanced features of this sophisticated spreadsheet package. A good familiarity with spreadsheet design and layout formatting and automation features within Excel.
Macro building is covered but Visual Basic for Applications (VBA) is the subject of a separate course.
Key Learning Themes
- ‘What if’ forecasting using one and two variable data tables and scenarios
- LOOKUP functions, Automatic Outline, using the form tools and scenario manager, excel macros
- Restricting input using protection and data validation
- Goal Seek and Solver analysis
- Importing data into Excel
- Navigation using hyperlinks, command buttons and sheet and range naming.
Benefits of the course
"Great course. An extremely knowledgable trainer. Very relevant to my work"
"Made Excel interesting! Very useful day and the small group was very beneficial"
This course includes advanced worksheet formatting and Excel shortcuts, as well as using named ranges in formulae, formula auditing—tracking changes and formula building.
When & Where
Crisp Professional Development
CRISP PROFESSIONAL DEVELOPMENT
What will you learn today?
Crisp Professional Development exists for one reason – to support and facilitate the learning and development of individuals and teams.
Since 1990 Crisp Professional Development has been delivering exceptional training courses, management development programmes and leadership interventions. We operate in-house training programmes at your premises, run open courses for all and offer blended learning through our online learning platform. As an ILM centre our training enjoys national accreditation.
Our coaching interventions are for c-suite executives and business owners; for leaders and managers in transition; for people in between careers, and for groups seeking greater team cohesion and improved performance.