The Essential Cell Format in Excel - Hit the Ground Running in Excel Series
This video is part of the Hit the Ground Running In Excel series, and by watching it, you will learn all there is to know about the Essential Cell Format in Excel. The Essential Cell Format is a Four for the Price of One where you can individually assign formats to Positive Numbers, Negative Numbers, Zeroes, and Text. And the key is, it's a single cell format—no need for adding conditional formatting.
This tutorial was made using Excel 365 but applies to older versions of Excel back to Excel 1997.
Chapters:
0:00 Intro
0:22 Excel Olympics Animation
0:30 What is the Essential Cell Format
3:30 Assigning the Essential Cell Format
6:13 Where Can I Use This
10:43 Tips and Tricks beyond
14:33 Outro
You can read the accompanying blog post here: https://bit.ly/3w9sivG
Gear Used:
US Links
Camera: Canon EOS R6 - https://amzn.to/3e9zxML
Microphone: AKG C3000 (Analog Mic) - https://amzn.to/3tYd37w
Audio converter: Zoom UAC-2 - https://amzn.to/3dgM8wS
Laptop: Dell XPS 15 - https://amzn.to/3w8CyoK
Lights: Elgato Key Light - https://amzn.to/3rurte7
EU Links
Camera: Canon EOS R6 - https://amzn.to/3tubwGy
Microphone: AKG C3000 (Analog Mic) - https://amzn.to/32pi2m0
Audio converter: Zoom UAC-2 - https://amzn.to/3amDRXP
Laptop: Dell XPS 15 - https://amzn.to/3effMmT
Lights: Elgato Key Light - https://amzn.to/3vcs6v9
Green Screen (visible in bloopers): https://amzn.to/3ajUm6Y
Recorded With: Camtasia - https://www.techsmith.com/video-edito...
#excel #excelolympics #gasperkamensek
Subscribe for more Excel tutorials on the Excel Olympics YouTube Channel: http://bit.ly/EOYTsub
Subscribe for the Excel Olympics Newsletter: https://bit.ly/3w3rkjK
DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links that I provide I may receive a small commission with NO additional charge to you! Thank you for your support!
#Excel #ExcelOlympics #gasperkamensek