INTRODUCTION
Excel has powerful tools that enable busy users to set up systems that simplify data analysis and interpretation. Effectively using Excel allows users to devote their time more profitably to making decisions about and acting on results, with more effective outcomes.
Participants actively learn through a series of practical simulations which ensures that they maximize their learning and can use the tools immediately when they return to the office. In addition to the practical component, all participants also receive a manual describing all the techniques learned.
WHO SHOULD ATTEND?
This advanced Microsoft Excel training course is ideal for people wanting to use more complex functions within Excel, including tools for analyzing, linking and exporting data. Participants will need to have attended or be familiar with the basics of Microsoft Excel.
LEARNING OBJECTIVES
• Protect a workbook and save with a backup
• Understand and use advanced functions
• Consolidate data, link and export data
• Use What-If Analysis tools such as Goal Seek, Solver and Scenarios
• Create and modify PivotTables and Pivot Charts
• Create and modify Microsoft Excel Macros
HOW TO PARTICIPATE
Tailor Made Training
Register Individual
Register Group
Become one of Our Partners
View Research, Data Management and Statistical Analysis Institute Course Catalogue
For further inquiries, please contact us on Tel: +254 715 077 817, +254 (020) 211 3814, +254 731240802, +254 735331020.
Email outreach@indepthresearch.org