- Duration: 2 days
Course overview
The skills and knowledge acquired in Microsoft Excel 2016 Intermediate – Level 2 (with Challenge Exercises) enable users to expand their knowledge and learn how to create more productive workbooks. It covers formulas and function techniques, advanced formatting and charting features and data manipulation tools like goal seeking.
Course Learning Outcomes
At the end of this course the participants will be able to:
• Use the fill operations available to fill a data series
• Use common worksheet functions
• Create more complex formulas and functions
• Create and use defined names in a workbook
• Use goal seeking to determine the values required to reach a desired result
• Use a range of techniques to work with worksheets
• Apply a variety of page setup techniques
• Apply borders to cells and ranges in a worksheet
• Apply a range of number formatting techniques to worksheet cells
• Apply conditional formatting to ranges in a worksheet
• Understand and use Excel’s Quick Analysis tools
• Create and work with tables
• Use a range of elements and features to enhance charts
• Select and change the format of objects in a chart
Target audience
This training courses is suitable for those individuals who want to learn Microsoft Excel.
Training Methodology
State-of-the-art business facilitation methods are transferred by means of short, focused presentations which are followed by experiential learning workshop sessions. In these sessions, the knowledge gained is applied to real-world examples and case studies. Rapid learning of the methods and techniques is achieved by means of group work, individual work, participant discussion, facilitator interaction and constructive feedback.
WHY STUDY WITH US?
Diamond Training Institute give you the opportunity to further your education and acquire the knowledge and skills that are relevant in the workplace.
ON-TRACK FOR GROWTH
The individual leaves this course with a Personal Action Plan to encourage immediate transfer of training to the job.
EVALUATION TO ENSURE CONSISTENT QUALITY
All our courses are evaluated at Kirkpatrick’s Reaction and Learning levels as part of our quality control process.
Download Course Outline Here
