Microsoft Excel: Data Analysis Decision Making/Solve Business Problems (1 day)

Course Overview

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

CourseMonster only uses quality Microsoft training suppliers who have been through our rigorous standards to ensure that you receive the best quality training available.

Related Courses

• Microsoft Excel: Introduction for Beginners (1 day)
• Microsoft Excel: Visual Basic For Applications (VBA) Programming (2 day)
• Microsoft Excel: Financial Modelling using Excel
• Microsoft Excel: Formulae & Functions (1 day)
• Microsoft Office: Word, Excel & PowerPoint: Introduction for Beginners (1 day)
• Microsoft Excel: Data Analysis Decision Making/Solve Business Problems (2 day)
• Microsoft Excel: Visual Basic for Applications (VBA) Programming (4 day)
• Microsoft Excel: Charts, Pivot Tables & Macros (1 day)
• Microsoft Excel: Financial Modelling (2 day)
• Microsoft Excel: Business Modelling for Telecoms (2 day)

Audience

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

Skills Gained

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.

Course Outline

• 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 and outline OLE

 

Microsoft Excel: Data Analysis Decision Making/Solve Business Problems (1 day) / MEX-MA

Request availability or enquire by clicking a date: