• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
Free ACCA & CIMA online courses from OpenTuition

Free ACCA & CIMA online courses from OpenTuition

Free Notes, Lectures, Tests and Forums for ACCA and CIMA exams

  • ACCA
  • CIMA
  • FIA
  • OBU
  • Books
  • Forums
  • Ask AI
  • Search
  • Register
  • Login
  • ACCA Forums
  • Ask ACCA Tutor
  • FIA Forums
  • CIMA Forums
  • OBU Forums
  • Qualified Members forum
  • Buy/Sell Books
  • All Forums
  • Latest Topics

Save 20% on ACCA & CIMA Books

Interactive BPP books for June 2026 exams, recommended by OpenTuition.
Get discount code >>

Formulas to learn for spreadsheet

Forums › Ask ACCA Tutor Forums › Ask the Tutor ACCA PM Exams › Formulas to learn for spreadsheet

  • This topic has 3 replies, 2 voices, and was last updated 5 years ago by AvatarJohn Moffat.
Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
    Posts
  • January 18, 2021 at 11:47 am #606796
    Avatarfarhaanm
    Participant
    • Topics: 169
    • Replies: 74
    • ☆☆☆

    hello, i want to know if there is a certain formulas to use when using spreadsheet. I use certain formulas that i learn online because it allows me to do the work quieter.

    January 18, 2021 at 3:42 pm #606922
    AvatarJohn Moffat
    Keymaster
    • Topics: 57
    • Replies: 54846
    • ☆☆☆☆☆

    Spreadsheet formulae for calculating the NPV and the IRR are available for Section C questions.

    You can practice using these in the specimen exam on the ACCA website.

    January 18, 2021 at 4:28 pm #606953
    Avatarfarhaanm
    Participant
    • Topics: 169
    • Replies: 74
    • ☆☆☆

    i meant like for example, i use the formula =cell B4*(1+B7) to calculate the number increased by the new percentage. Do i have to learn more of these?

    January 19, 2021 at 6:06 am #607080
    AvatarJohn Moffat
    Keymaster
    • Topics: 57
    • Replies: 54846
    • ☆☆☆☆☆

    You do not have to specifically learn any formula – you can use a calculator as normal.
    It is just that using spreadsheet formulae can speed things up a bit 🙂

  • Author
    Posts
Viewing 4 posts - 1 through 4 (of 4 total)
  • You must be logged in to reply to this topic.
Log In

Primary Sidebar

ACCA News:

ACCA My Exam Performance for non-variant

Applied Skills exams is available NOW

ACCA Options:  “Read the Mind of the Marker” articles

Subscribe to ACCA’s Student Accountant Direct

ACCA CBE Exams – Instant Poll

How was your exam, and what was the exam result?

BT CBE exam was.. | MA CBE exam was..
FA CBE exam was.. | LW CBE exam was..

Donate

If you have benefited from OpenTuition please donate.

PQ Magazine

Latest Comments

  • harsh9 on Regulatory framework – ACCA Financial Reporting (FR)
  • LiliaDvornikova on ACCA TX-UK FA2025 Chapter 20 Trading and other losses – Companies
  • Zidanda on The valuation of debt finance, and duration (part 1) – ACCA (AFM) lectures
  • Davud on FA Chapter 21 Questions IAS 38 – Intangible Assets: Goodwill, Research and Development
  • Kim Smith on AA Chapter 12 Questions

Copyright © 2026 · Contact · Advertising · OpenLicense · About · Sitemap · Privacy Policy · Cookie settings · Comments · Log in