Professional Data Analysis & Report Design with Excel
Course Description
This course will show experienced Excel users how to operate the package at a higher level and explore its more sophisticated analysis tools. It will also demonstrate how to deliver presentations and reports developed in Excel using Multi-Office techniques (Word and Powerpoint).
1 days
Contact us for pricing
Prerequisites
This course is aimed at experienced Excel users.Who will Benefit?
- Anyone who has to analyse data using Excel- Anyone who has to use data which has been analysed in Excel
- Anyone who has to present Excel-based data to an audience
Benefits
- Using Excel features to a higher level of operation- Produce more relevant and succinct reports
- Case Study Based approach
- Translation of theory into practice using interactive and participative examples
- All programme content available on line after the session
Course Content
- Data mining techniques in Excel- Arrays: to boldly go where no function has gone before!
- Advanced Pivot Table operation
- Operating with Data Tables
- Purpose and use of Standard Excel Add-ins
- Reporting tools in Excel and best practice for them
- Linking reports to other Office Media for best effect
- Create an Excel based PowerPoint show
Advanced ExcelExcel 2016Microsoft ExcelMicrosoft Excel 2016MS ExcelExcel 365Excel 2019