Scheduled Dates (sort by: location | date) |
Request availability or book by selecting a date: Central London
City
Prices exclude VAT.
Have questions or need a better city/date? Ask now.
On-site/international quote? Ask now.
|
Course Overview You will gain a complete understanding of what Excel is able to achieve in terms of data analysis, organisation and summarisation. 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 & outline OLE
How to make a booking for the MEX-MA course
|
