This one-day course is for the reasonably experienced user of Excel who wishes to develop more complex spreadsheets, use more advanced formulae and develop skills in data analysis techniques.
A proficiency in setting up basic spreadsheets is assumed, as is familiarity with the Windows environment.
Key Learning Themes
- Relative and absolute cell references in formulae
- Building functions using the Insert Function feature
- Using IF, SUMIF, COUNTIF and other logical functions
- Statistical functions and financial functions
- Database management and facilities and creating and formatting charts
- Pivot tablets and useful shortcuts
BENEFITS OF THE COURSE
"An excellent course which brought me up to date on the software. The tutor was very informative and helpful"
"Excellent trainer. Really enjoyed the whole training day. Just wish that I had done this sooner as a lot of the topics covered would have saved me a lot of time in the past with my job!"
"Enjoyed the course and can take some valuable points away"
You will learn how to format worksheets, as well as using multiple worksheets and linking workbooks.
When & Where
EX2 7HU Exeter
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.