Ms Excel
Microsoft Excel: Advanced Formatting
Cell display, cell protection, and advanced formatting techniques
3 CPD credits on completion
Enrol Now
Certificate on completion
Downloadable resources
Self-paced learning
About This Course
Course Information
This course provides an introduction to advanced formatting and takes you through the basic concepts and techniques..
Certificate on Completion
This course is made up of videos, questions and additional reading materials and accounts for 3 units of CPD. One unit is the equivalent of one hour of learning. A certificate will be issued once you have completed all 3 units.
Course Sections
This course is made up of the following sections:
- Cell Display (Video)
- Cell Protections (Video)
- Advanced Formatting (Notes)
- Advanced Formatting (Multiple Quizzes)
What You Will Learn
- Apply methods for hiding and unhiding rows and columns in Excel
- Distinguish between locking cells and protecting worksheets
- Identify how shifting rows or columns can affect formula references
- Describe how to use custom number formats to control cell display
- Explain the purpose of worksheet protection for shared workbooks
Who This Course Is For
- Excel users who already know the basics and want to control how data is displayed and protected
- Accountants who share workbooks with colleagues and need to restrict editing in certain cells
- Finance professionals preparing reports where formatting consistency matters
Prerequisites
- Working knowledge of Excel including entering data, basic formulas, and simple formatting
- Completion of the Learnsignal Spreadsheet Know How course or equivalent experience
Frequently Asked Questions
Course Details
CPD Credits3
CertificateYes
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