« Terug naar Automatisering & ICT/IT
Forecasting and Trend Analysis Using Microsoft® Office Excel® 2003 (MOC54002)
Microsoft® Excel® is the spreadsheet program most commonly used by financial analysts, project managers, academics, and small business owners around the world to track and analyze business and personal data. Because of the increasing demands on their time, business professionals need to learn efficient and effective data forecasting methods that give them the answers they need. This course, formerly course number 4002, will provide experienced Excel users with a practical, hands-on understanding of advanced Excel data forecasting and charting techniques. It examines the risks and benefits of forecasting, teaches different forecasting and trending methods, and explores ways to maximize prof...
Lees de complete beschrijving
Ervaring met deze cursus?
Heeft u de cursus Forecasting and Trend Analysis Using Microsoft® Office Excel® 2003 (MOC54002) gevolgd bij Twice? Help dan anderen door uw ervaring op Eduhub te plaatsen!
Wij doneren als dank voor elke ervaring €10,- aan Stichting Edukans, of u ontvangt een kadobon.
Deel uw ervaring
Uitgebreide gegevens
- Doorlooptijd:
- CertificaatAfronding:
-
Op het instituut, Hotelaccommodatie.
Soort locatie:
-
Klassikaal onderwijs.
Lesvorm:
U kunt deze pagina ook overzichtelijk printen of .
Microsoft® Excel® is the spreadsheet program most commonly used by financial analysts, project managers, academics, and small business owners around the world to track and analyze business and personal data. Because of the increasing demands on their time, business professionals need to learn efficient and effective data forecasting methods that give them the answers they need. This course, formerly course number 4002, will provide experienced Excel users with a practical, hands-on understanding of advanced Excel data forecasting and charting techniques. It examines the risks and benefits of forecasting, teaches different forecasting and trending methods, and explores ways to maximize profit potential. After completing this course, students will be able to:
Describe the role data forecasting plays in organizational planning. Identify the positive and negative aspects of data forecasting. Create formula-based data forecasts. Define best, middle, and worst case scenario data. Establish target values using Goal Seek. Calculate moving averages. Chart moving averages interactively. Calculate Net Present Value and Internal Rate of Return. Define and solve problems in Solver.
