program factsheet
Forecasting and Trend Analysis Using Microsoft Office Excel 2003
Forecasting and Trend Analysis Using Microsoft Office Excel 2003 course details Duration: you will learn to 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 the next step Eager to learn more? We recommend: Excel Pivot Tables Excle VBA Introduction course dates Visit www.pollak.com.au for our latest course schedule or call us on 1300 658 388. 1/2 Day
This course will provide experienced Excel users with a practical, hands-on understanding of advanced data forecasting and charting techniques. It examines the risks and benefits of forecasting, teaches different forecasting and trending methods and explores ways to maximise profit potential.
the learning process
Before the course
We recommend that you have experience with analysing business data, creating formulas, named ranges and inline graphs in Excel. Also the ability to make decisions about products, projects and strategic direction is desirable. Our Training Needs Analysis survey is available to help you determine which level of training is most suitable for your level of experience with this application. To access this contact us on 1300 658 388. Prior to commencing the training, we provide pre-course material to reflect on and align your learning outcomes to the course content.
During the course
This Business Skills Series course will benefit you if you are a financial analyst, project manager, accountant, business owner and regularly use Microsoft Office Excel.
After the course
This course includes an associated eLearning course, containing similar content to the course delivered in the classroom. After completing the course, you will now be able to refresh your knowledge by logging on to the relevant eLearning course. We also provide post-course telephone support whenever you require it.
"Instructor gave examples which were easy to grasp and educational for the purpose of the course. The instructor effectively linked how course content applied to workplace concepts."
"I learnt some useful functions and tips and really enjoyed the main content of the course."
1300 658 388
www.pollak.com.au
program factsheet
Forecasting and Trend Analysis Using Microsoft Office Excel 2003 course content
The Risks and Benefits of Forecasting Data
What Is Data Forecasting? The Business Needs for Data Forecasting Summary of the Risks and Benefits of Data Forecasting
Maximising Profit Potential
Net Present Value and Internal Rate of Return Calculating Net Present Value Calculating Internal Rate of Return Introduction to Solver Determining Optimal Project Mixes Best Practices for Defining Problems in Solver Summarising Data Forecasting Benefits Next Steps
Creating Formula-Based Forecasts
Three Formula-Based Forecasting Resources Creating Forecasts from Existing Data Analysing Data by Using Goal Seek Establishing Targets by Using Goal Seek Tips and Tricks for Formula-Based Forecasts
Forecasting Using Moving Averages
What Is a Moving Average? What Decisions Do Moving Averages Help Me Make? Calculating and Charting a Moving Average Creating an Interactive Chart Tips and Tricks - Refining Moving Average Analysis
customising this course for your business
Pollak Learning Alliance can provide a range of consulting services to better meet your business needs, including closed courses for your organisation, customised course material relevant to your industry and requirements, and blended learning solutions.
training needs analysis
To ensure participants are booked onto the correct Desktop programs, we offer a survey tool that will align participants to the correct course for their needs, based on their experience using an application. Your client manager will work closely with you to ensure that all staff are booked onto the right programs and offer you the most suitable solution each time - whether this be public course training, group sessions, and any other alternate methods of delivery that could also work for you at the time - such as online learning or one-on-one coaching.
prepare-learn-apply-measure
Pollak Learning Alliance has led the way in measuring return on investment for end-user applications training. We have developed and implemented our in-house Prepare-Learn-Apply-Measure (PLAM) system to provide our clients with return on investment information to assist them in gauging the success of our learning and development initiatives. Prepare: Pre-work Reflecting on and aligning learning outcomes. Learn: During the course Focusing on relevance to on-the-job outcomes. Apply: Post-work Action plans and post-work encourage follow up. Measure: ROI Calculate and report on some aspect of return on investment.
CPD points
Many professional institutions, industry bodies and associations require their members to undertake continuing professional development (CPD). course may be recognised as contributing to your CPD. Please contact your professional institution to find out more.
For more information on this course, or to view the latest course schedule, visit our website www.pollak.com.au or call us on 1300 658 388.
1300 658 388
www.pollak.com.au
program factsheet
1300 658 388
www.pollak.com.au