Subscriber only lesson.
Sign up to this course to view this lesson.
About this lesson
Did you know that Excel can display Emojis in the worksheet? Why not leverage that ability to help convey your message?
Download this lesson’s related exercise files.Display Emojis in your Dashboards.xlsx
74.4 KB Display Emojis in your Dashboards - Completed.xlsx
74.5 KB Display Emojis in your Dashboards.xlsx
Display Emojis In Your Dashboards
Adding Emojis to add feeling to your dashboard.
When to use
When you want a bit more of an expressive display to show your performance, Emojis can be the perfect touch.
Identifying your Emoji
- Emojis are identified using a hexadecimal code that looks similar to this: 1F602
- To find an Emoji supported in Excel, download the Emoji Identifier spreadsheet
- Locate the Emoji you want, and build its code by adding its column identifier to the value in column C
Returning an Emoji to your dashboard
- The syntax to return an Emoji to your dashboard is as follows:
- UNICHAR(HEX2DEC("Emoji Hex Code"))
- For example, to return the “see no evil” monkey, you would use:
Hints & tips
- You can use Emojis in an IF or other logical function to return conditional Emojis as well
- The following formula will return a happy face if the value in A5 is greater than 1,000, an angry face if the value is less than -1,000 and a straight face if in between:
- =IF(A5>1000,UNICHAR(HEX2DEC("1F604")),IF(A5<-1000, UNICHAR(HEX2DEC("1F620")),UNICHAR(HEX2DEC("1F610"))))
Lesson notes are only available for subscribers.