Join Dennis Taylor for an in-depth discussion in this video Building a flexible monthly table using functions, part of Excel Tips Weekly.
- In this worksheet, we're setting up…a data entry vehicle for someone who…doesn't necessarily know a lot about Excel.…Ultimately, all this person or persons will be doing…is selecting a month in cell A2,…and as I click there, you'll see a drop arrow,…it's a picklist, I'll show you how to do that…by way of data validation.…Same thing in column B, in cell B2,…we pick a year, and depending upon that choice,…we want our display here to reflect…how many days there are in that month.…Now, I've hidden some of the rows ahead of time…because, as we look at this model,…we want to be viewing some of the early days…along with the other data here,…and then the later days toward the end of the month.…
So you'll notice that rows 14, and then we see row 29.…The other rows have been hidden.…So, let's talk about how this is set up.…And a lot of different functions are in use in this model,…including the ones we see over here.…These are simply here for reference purposes;…eventually, we'd get rid of them.…The list that we see in columns J, K and L…
Skill Level Appropriate for all
Q: Why can't I earn a Certificate of Completion for this course?
A: We publish a new tutorial or tutorials for this course on a regular basis. We are unable to offer a Certificate of Completion because it is an ever-evolving course that is not designed to be completed. Check back often for new movies.
Excel Tips - New This Week
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.