Custom Number Formatting - Advanced Level Formatting in Excel

Alan Murray, IT Trainer, Coffee Lover and Lifelong learner

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
9 Lessons (35m)
    • 1. Introduction

      2:18
    • 2. Combine Text and Numbers in a Cell

      3:51
    • 3. Show the Weekday of a Date

      2:51
    • 4. Keep the Leading Zeroes of a Value

      3:08
    • 5. Display Negative Values in Red

      3:28
    • 6. Show Zero Values as Blank Cells

      2:48
    • 7. Display Symbols with Custom Formatting to Show Change

      7:15
    • 8. Conditional Colour with Custom Formatting

      5:24
    • 9. Setting Thresholds for your Custom Formatting

      4:13

About This Class

f80c0b2d

In this class, we look at using custom number formatting to take your Excel formatting to advanced levels.

We begin with some simple (but very useful) examples. We complete common tasks such as hiding zero values, combining text and numbers in the same cell (but still storing it as a number) and also displaying the weekday of a date.

We then move onto advanced examples which will display symbols or colours conditionally. Perfect for anybody involved in creating reports and dashboards.

So, let's get started.

Enrol and I'll see you on the inside.