excel introduction

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

TrustPilot

starstarstarstarstar Excellent

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel Introduction

Excel Introduction

resolvedResolved · Low Priority · Version 2003

Doreen has attended:
Access Introduction course
Excel Introduction course
Excel Intermediate course
Access Intermediate course
Access Advanced course
Excel Advanced course

Excel Introduction

What is Bedmas?

RE: Excel Introduction

Hello Doreen

Thank you for your question and welcome to the forum.

BEDMAS is an acroynm designed to help you remember the order in which Excel will work out the result of a formula for you, if the formula contains more than one kind of operator.

So:

anything in Brackets will be done first; followed by
any Exponents; then
any Division or Multiplication; and finally
any Addition or Subtraction

I hope this helps.
Amanda

RE: Excel Introduction

Hi Doreen

BEDMAS is a way to remember the Hierarchy Of Calculation in Maths. Since all formulas in Excel must follow this system we need to remember the order in which calculations are conducted.

The letters stand for:

Brackets
Exponent
Division
Multiplication
Addition
Subtraction

This is the order of operations of any formula.

Hope this helps

Carlos

Wed 18 Feb 2009: Automatically marked as resolved.


 

Excel tip:

Enter formulae into multiple cells

If a formula is to be used in a series of cells, select the cells first. Now type in your formula and hold the Ctrl key while you press Enter. This enters the formula in each selected cell.

Just be careful with your absolute and relative cell references.

View all Excel hints and tips


Server loaded in 0.08 secs.