100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached
logo-home
Previously searched by you
Previously searched by you
logo
BTEC LEVEL 3 - Unit 42- Spreadsheet Modelling A3 £2.99   Add to cart
Quickly navigate to
Preview
  2.  
  3. PEARSON
  4.  
  5. Information Technology 2010 QCF
  6.  
  7. Unit 42 - Spreadsheet Modelling

Essay

BTEC LEVEL 3 - Unit 42- Spreadsheet Modelling A3

1 review
 157 views  0 purchase

Essay study book BTEC Level 3 National IT Student Book 1 of Karen Anderson, Alan Jarvis - ISBN: 9781846909283, Edition: 1, Year of publication: - (Assignment 3- P1 D1)

Preview 1 out of 4  pages

  View example

Getting your document ready...

mobile-preview

Document information

  • July 6, 2018
  • 4
  • 2017/2018
  • Essay
  • Unknown
  • Unknown

Subjects

Connected book

book image

Book Title:

Author(s):

  • Edition:
  • ISBN:
  • Edition:

Written for

All documents for this subject (12)

1  review

review-writer-avatar

By: Opuntia_Variola.louti • 6 year ago

Seller

avatar-seller
Stuartia_Balistapus.undulatus

Reviews received

Content preview

How Spreadsheets Can Be Used To Solve Complex Problems- P1

Spreadsheet models give the user a large amount of tools and functions which can be used
to solve a number of problems, such as cash flow forecasting, budget control, sales
forecasting, payroll projections, statistical analysis and trend analysis.

Supporting Decision Making

Spreadsheet software offers functions that can be used to support decision making,
providing timely and accurate information in a variety of situations.

Analysis of data: This is more easily achieved when data is summarised in some way or is
presented graphically. This is especially true for large amounts of data when it is necessary
to rely on representative values as there is too much data to spot a trend among thousands
of individual data results.

Goal seeking: If you know the result that you want from a formula, but are not sure what
input value the formula needs to get that result, using the “Goal Seek” feature does the job
for you.

Scenarios: If you create and save different groups of values as scenarios on a worksheet,
you will then be able to switch between these scenarios to view the different results.

Regression: This is a form of statistical analysis used for forecasting. It is time consuming to
perform manually but easier if you use a spreadsheet to do all the calculations for you.

Data mining tools: These help the user to derive patterns and trends that exist in complex
data. For example, all credit card transactions are stored by the various credit card agencies
and the data is analysed to spot possible fraudulent activity.

Cash Flow Forecasting

If you have sufficient information about how things have worked out in the past, and you
have the tools to process this data. You can take measurements today and, if you have a
formula that you think will work, you can calculate the values for tomorrow, the day after and
so on. Then, as time passes, you can check the accuracy of your forecasts and amend your
model - the formulae that you used - until they more accurately forecast the future. A
spreadsheet is particularly useful for forecasting because it will do all the calculations for
you. Each new row (or column) can be used to represent the next day (or whatever time
interval you choose for your model).

Accounts departments need cash flow forecasting data so that they can chase payments to
avoid problems, and they may use this data to forestall outgoing payments if they know there
is not enough money to honour a payment.

Budget Control

Spending can't just happen; there ought to be plans made so that the expected revenue for

The benefits of buying summaries with Stuvia:

Guaranteed quality through customer reviews

Guaranteed quality through customer reviews

Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.

Quick and easy check-out

Quick and easy check-out

You can quickly pay through credit card for the summaries. There is no membership needed.

Focus on what matters

Focus on what matters

Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!

Frequently asked questions

What do I get when I buy this document?

You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.

Satisfaction guarantee: how does it work?

Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.

Who am I buying these notes from?

Stuvia is a marketplace, so you are not buying this document from us, but from seller Stuartia_Balistapus.undulatus. Stuvia facilitates payment to the seller.

Will I be stuck with a subscription?

No, you only buy these notes for £2.99. You're not tied to anything after your purchase.

Can Stuvia be trusted?

4.6 stars on Google & Trustpilot (+1000 reviews)

13 documents were sold in the last 30 days

Founded in 2010, the go-to place to buy revision notes and other study material for 15 years now

Start selling

Recently viewed by you

Other ·

(0)

BTEC LEVEL 3 - Unit 42- Spreadsheet Modelling- Finished Spreadsheet

Lecture notes ·

(0)

Chapter 6 Notes - Project Networks

Lecture notes ·

(0)

Chapter 2 Notes - Strategy and Project Selection

Summary ·

(1)

AQA A-Level Sociology Theory and Methods (Paper 1 and 3)

Summary ·

(0)

1. Introduction

Essay ·

(1)

Unit 3 Information Systems - P3, P4 and M2

Summary ·

(0)

Introduction to Research Methodology - Summary

Summary ·

(0)

5. Inheritance

Other ·

(1)

Writing Exercises English 2.1
£2.99
  • (1)
  Add to cart