For information on course costs and booking onto a course, please click here. For any queries please contact us on business@nptcgroup.ac.uk or call: 0330 81 88 100Welcome, Guest

Microsoft Excel 365: Custom Formatting to Control Your Data

Course Overview

Explore the power of custom format as a visual tool without altering the underlying data in this comprehensive training course, "Excel Custom Formatting to Control your Data." Whether dealing with numbers, currency, or text, this course empowers you to create visually appealing and dynamic spreadsheets.

Unlock the potential of custom formats as you decipher the language of hash and zeros. Beginning with small datasets, you'll grasp fundamental principles, such as applying basic number formats, managing positive and negative values, and creatively handling zero values.

Discover how to seamlessly merge text into your cells without sacrificing the ability to perform calculations. Integrate symbols, apply vibrant colors, and use engaging icons such as thumbs up and down. Learn to combine logic and emojis for intuitive visual representation. Dive into conditional formatting to highlight specific rows based on customized criteria.

By the end of the course, you should be able to confidently wield Excel's formatting features, producing polished, professional spreadsheets that convey insights effectively.

Learning Objectives:

At the end of this course, you should be able to:

  • Apply custom formatting to numbers for improved data visualization in Excel.
  • Distinguish between hash and zero for precise data alignment.
  • Integrate text seamlessly into cells while maintaining calculation capabilities.
  • Combine logical conditions and symbols dynamically based on customized criteria.