Need to undertake complex number-crunching and analysis? Microsoft Excel’s advanced reporting and data manipulation features can deliver powerful insights in to your business and can lift your competitiveness.
This course is aimed at people who analyse and report on large data lists – usually extracted from in house databases and then imported into Excel.
• Work with data imported into Excel from an external source
• Prepare data so that it’s fit for analysis and reporting
• Extract and match data using Lookup functions
• Create and work with Named ranges
• Analyse and filter data using Advanced Filter commands and the Table feature
• Create powerful reports using Pivot Tables and Pivot Charts