Duration: 1 Day
Course Overview
Many of us have either learned Excel ourselves or attended Intro/Intermediate/Advanced Excel courses. You have either created workbooks from scratch and later found them part of a critical process to make business decisions, or you have inherited someone else’s workbook that takes you hours or even a day to maintain and update. Very often the data has errors that you discover only after having presented its analysis; the calculations are slow; and every now and then there are numbers errors in a large calculation and you have to fix them.
This 1-Day course looks at how you can make it easy for yourself to reduce calculation errors and the time it takes to maintain a very effective workbook.
How can I attend my course?
COURSE OBJECTIVES
• Implement a workbook design to improve and ease maintenance
• Design datasets to ensure ease of use
• Reduce bad data entries into Excel datasets
• Design calculations to make errors transparent and easy to identify
• Link datasets with each other