Course Details

By attending this course, you will learn how to apply data analysis techniques to improve your operational and project based work. You will be able to review a range of tools and choose the right ones for the particular application and produce analyses and diagrams that make your reports and business cases easier to read and more effective.

Delegates will learn how to:-

• Develop practical solutions to your business problems through superior spreadsheet design.
• Discover methods to dramatically reduce the time you spend on spreadsheets.
• Use macros more efficiently.
• Consolidate worksheets from different sources into one workbook.
• Develop efficient techniques for using charts

Course Outline   

• Excel Overview
• Conditional Formatting & Sparklines
• Summarising & Consolidating Data
• Pivot Tables & Slicer
• Lookups and Data Table
• Charts & Validation
• Data Mining
• Macros
• Data Security in MS Excel
• Formulas