How to Insert Special Characters in Google Sheets

If you've ever needed to add a checkmarks, emoji, currency symbol or accented latter to your spreadsheet but Google Sheets doesn't  include a direct special character tool like Google Docs, there are ...