Learnsignal

Search Learnsignal

Search across blog posts, courses, and CPD content

Ms Excel

Microsoft Excel: Formatting Data

Fonts, styles, number formats, currencies, and date display

2 CPD credits on completion
Enrol Now
Certificate on completion
Downloadable resources
Self-paced learning

About This Course

Course Information

This course describes ways of formatting data within a spreadsheet using different fonts and styles. We also cover how to show numeric data including currencies and dates.

Certificate on Completion

This course is made up of videos, questions and additional reading materials and accounts for 2 units of CPD . One unit is the equivalent of one hour of learning. A certificate will be issued once you have completed all 2 units.

Course Sections

This track is made up of the following sections:

  • Formatting Data (Video)
  • Formatting Data (Notes)
  • Formatting Data (Quiz)

What You Will Learn

  • Apply different fonts, styles, and text formatting to improve spreadsheet readability
  • Describe how number formatting changes the display of values without altering the underlying data
  • Identify the correct format for displaying currencies, percentages, and dates in Excel
  • Explain the purpose of adding notes and comments to cells for collaborative work
  • Distinguish between formatting for appearance and data entry for values

Who This Course Is For

  • Excel beginners who want to present data clearly and professionally
  • Accountants who prepare financial reports and need consistent formatting for numbers and currencies
  • Office professionals who share spreadsheets with colleagues and need readable, well-organised data

Prerequisites

  • Ability to open Excel and enter data into cells
  • No prior formatting knowledge is required

Frequently Asked Questions

Course Details

CPD Credits2
CertificateYes

Need Help?

Our team is here to help you choose the right course for your CPD needs.

Contact Us
Pricing

Pricing

Invest in your professional development with flexible payment options.

Everything included in your subscription:

CPD certificate on completion
Downloadable resources
Self-paced learning
Expert-led content
24/7 access
Mobile friendly

Ready to Start Learning?

Join thousands of finance professionals who have advanced their careers with Learnsignal CPD courses.

Enrol Now

Ready to get started?

Join 100,000+ students across 130 countries. Choose a plan that fits your goals — cancel anytime.

View Pricing