课程: Excel: Tracking Data Easily and Efficiently

今天就学习课程吧！

今天就开通帐号，24,600 门业界名师课程任您挑！

Hiding zeroes

Hiding zeroes - Microsoft Excel教程

课程: Excel: Tracking Data Easily and Efficiently

开始一个月试用 购买团队方案

Hiding zeroes

“

- [Instructor] Here we're starting off 2024 by setting up a tracker so that we can see how many workshops, blog posts, and videos we generate over the year. We see on January 6th, there were two activities, a workshop and a blog post by Dorinda and Laz, and then there is a formula that's peeling out the month for us. But now let's look over at the summary page. We've got everything set up for the entire year. Hmm, but you know, of course, August is a zero. We're still only in March. What can we do? This is what we can do. We can go to File, Options, Advanced, scroll down. We are looking for display options for this worksheet. Show a zero in sales that have zero value. We want to uncheck that. Okay, now our summary sheet is no longer clogged up with all of those zeros, but now here is a downside to this. If something is a zero and you want to know that it's a zero because something was missing, then this is not the way…

内容