What You Learn On: The 'Forecasting, Planning and Budgeting Techniques - with Excel' CIMA Mastercourse

Financial Management (UK), June 2014 | Go to article overview

What You Learn On: The 'Forecasting, Planning and Budgeting Techniques - with Excel' CIMA Mastercourse


The course speaker, Pratish Sharma, is an IT tutor and systems consultant at BPP Professional Education.

A highly experienced presenter and designer of courses, including an IT programme for the hospitality industry, he has also managed projects to combat the millennium bug and served as a one-to-one coach and mentor.

This intermediate-level one-day course is aimed at accountants, business analysts, budget-holders, people running their own businesses and spreadsheet authors who want to know what end-users are doing on Excel. It should also be of value to people from any functional area who need to improve their skills in developing departmental forecasts, plans and budgets using the ubiquitous Microsoft application. In fact, the programme is appropriate for anyone wishing to gain more practical experience in Excel reporting and using statistical data.

[ILLUSTRATION OMITTED]

We start the day by opening a model file in Excel and performing exercises such as forecasting activity for a simple business process. I will explain the mathematical equation Y = MX + B, creating a linear regression on a chart to give a visual impression using historical data. I'll also show how to examine a year's worth of data on a couple of business processes to comprehend the activity of the next three months.

The course provides the following three solutions to forecasting techniques:

* The Y = MX + B equation.

* The Forecast function.

* The Trend (array) function.

Next I will cover correlation and regression analysis - an example of which would be the relationship between historical data and any factors that influence an increase in sales. …

The rest of this article is only available to active members of Questia

Already a member? Log in now.

Notes for this article

Add a new note
If you are trying to select text to create highlights or citations, remember that you must now click or tap on the first word, and then click or tap on the last word.
One moment ...
Default project is now your active project.
Project items

Items saved from this article

This article has been saved
Highlights (0)
Some of your highlights are legacy items.

Highlights saved before July 30, 2012 will not be displayed on their respective source pages.

You can easily re-create the highlights by opening the book page or article, selecting the text, and clicking “Highlight.”

Citations (0)
Some of your citations are legacy items.

Any citation created before July 30, 2012 will labeled as a “Cited page.” New citations will be saved as cited passages, pages or articles.

We also added the ability to view new citations from your projects or the book or article where you created them.

Notes (0)
Bookmarks (0)

You have no saved items from this article

Project items include:
  • Saved book/article
  • Highlights
  • Quotes/citations
  • Notes
  • Bookmarks
Notes
Cite this article

Cited article

Style
Citations are available only to our active members.
Buy instant access to cite pages or passages in MLA, APA and Chicago citation styles.

(Einhorn, 1992, p. 25)

(Einhorn 25)

1. Lois J. Einhorn, Abraham Lincoln, the Orator: Penetrating the Lincoln Legend (Westport, CT: Greenwood Press, 1992), 25, http://www.questia.com/read/27419298.

Cited article

What You Learn On: The 'Forecasting, Planning and Budgeting Techniques - with Excel' CIMA Mastercourse
Settings

Settings

Typeface
Text size Smaller Larger Reset View mode
Search within

Search within this article

Look up

Look up a word

  • Dictionary
  • Thesaurus
Please submit a word or phrase above.
Print this page

Print this page

Why can't I print more than one page at a time?

Help
Full screen

matching results for page

    Questia reader help

    How to highlight and cite specific passages

    1. Click or tap the first word you want to select.
    2. Click or tap the last word you want to select, and you’ll see everything in between get selected.
    3. You’ll then get a menu of options like creating a highlight or a citation from that passage of text.

    OK, got it!

    Cited passage

    Style
    Citations are available only to our active members.
    Buy instant access to cite pages or passages in MLA, APA and Chicago citation styles.

    "Portraying himself as an honest, ordinary person helped Lincoln identify with his audiences." (Einhorn, 1992, p. 25).

    "Portraying himself as an honest, ordinary person helped Lincoln identify with his audiences." (Einhorn 25)

    "Portraying himself as an honest, ordinary person helped Lincoln identify with his audiences."1

    1. Lois J. Einhorn, Abraham Lincoln, the Orator: Penetrating the Lincoln Legend (Westport, CT: Greenwood Press, 1992), 25, http://www.questia.com/read/27419298.

    Cited passage

    Thanks for trying Questia!

    Please continue trying out our research tools, but please note, full functionality is available only to our active members.

    Your work will be lost once you leave this Web page.

    Buy instant access to save your work.

    Already a member? Log in now.

    Author Advanced search

    Oops!

    An unknown error has occurred. Please click the button below to reload the page. If the problem persists, please try again in a little while.