Microsoft Excel: Rounding Functions

Wishlist Share

About Course

Learn the difference between how a number looks and the value Excel actually stores, and how to round properly. The course covers ROUND, ROUNDUP, ROUNDDOWN, MROUND, CEILING.MATH, FLOOR.MATH, INT and TRUNC with practical examples such as pricing, packaging and time.

Tutwoo is an independent learning provider and is not affiliated with or endorsed by Microsoft. Menu names and features can vary between versions and platforms and change with updates. This course is general skills training and is not an accredited qualification.

What Will You Learn?

  • Understand why displayed totals sometimes do not add up Choose the right rounding function for each task Round to decimal places, to tens or thousands, or to a multiple such as 5p or 15 minutes Avoid common rounding mistakes in invoices and reports

Course Content

Course Lessons

  • Formatting is not rounding
  • ROUND, ROUNDUP and ROUNDDOWN
  • Rounding to a multiple: MROUND, CEILING.MATH and FLOOR.MATH
  • INT, TRUNC and putting it together

Sources & Further Reading
The official guidance this course is based on.

Final Assessment

Student Ratings & Reviews

No Review Yet
No Review Yet

Want to receive push notifications for all major on-site activities?

✕