Chapter 7. Finding Functions: Mine Excel’s features on your own
Excel has more functions than you will ever use.
Over many years and many versions, the program has accumulated specialized functions that are terribly important to the small group of people who use them. That’s not a problem for you. But what is a problem for you is the group of functions that you don’t know but that are useful in your work. Which functions are we talking about? Only you can know for sure, and you’re about to learn some tips and techniques to finding quickly the formulas you need to get your work done efficiently.
Should you rent additional parking?
You’re in charge of the Dataville Convention Center parking program. They do a big entertainment business in Dataville, but they have a problem. If they are expecting more than 1,000 ticket buyers to attend an event, they need to rent more parking spaces.
In the upcoming month, are they expecting more than 1,000 attendees for any of their events? Your challenge is to find out using their ticket sales data, and you’ll get free box seats to your favorite shows if you can set up a workflow.
You need formulas to count tickets sold for each day in this month’s weekends. ...
Get Head First Excel now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
