- Duration: 1 day
Course overview
The skills and knowledge acquired in Microsoft Excel 2016 Advanced – Level 3 (with Challenge Exercises) are sufficient to be able to protect worksheet data, perform advanced data operations using summarizing, data consolidations, filters and PivotTables, macros, and much more.
Course Learning Outcomes
At the end of this course the participants will be able to:
• Modify Excel options
• Use logical functions to test whether a statement is true or false
• Use a range of lookup and reference functions
• Use data linking to create more efficient workbooks
• Group cells and use outlines to manipulate the worksheet
• Create summaries in your spreadsheets using subtotals
• Use the Data Consolidation feature to combine data from several workbooks into one
• Create, use and modify data tables
• Create and work with scenarios and the Scenario Manager
• Understand and create simple PivotTables
• Construct and operate PivotTables using some of the more advanced techniques
• Create and edit a PivotChart
• Use advanced filters to analyze data in a list
• Use a variety of data validation techniques
• Protect data in worksheets and workbooks
• Import data into Excel and export data from Excel
• Share workbooks with other users
• Create recorded macros in Excel
Target audience
This training courses is suitable for 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
