Excel: Data Analysis / Decision Making

Show more Microsoft Training Courses

About this class

You will gain a complete understanding of what Excel is able to achieve in terms of data analysis, organisation and summarisation.

Who will the lesson benefit?

This course is suitable for people who need to use Excel in decision making. An understanding of Excel formulas and functions is required.

What delegates will learn

Advanced graph building forms a cornerstone for this course, including incorporating trend lines. You will learn how to use Goal Seeking to achieve a target. Create data tables to display a variable range. How to sort and filter large worksheets, use consolidation to bring together key data. You'll learn how to use grouping and outlining to organise data and OLE techniques for transporting from Excel to other applications such as PowerPoint.

Contents of this class

• Using graphs to represent data
• Advanced editing of graphs
• Including trend lines
• Using pivot tables to summarise data
• Goal seeking
• Data tables
• PMT function consolidation
• Scenarios
• Group & outline OLE

Excel: Data Analysis / Decision Making / MEX-MA

(C) AquinasTraining.co.uk - Contact Us