Microsoft Excel: Formatting Data
Fonts, styles, number formats, currencies, and date display
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
Pricing
Invest in your professional development with flexible payment options.
Everything included in your subscription:
Ready to Start Learning?
Join thousands of finance professionals who have advanced their careers with Learnsignal CPD courses.
Enrol Now