![]() In my case, all the events (Masterclass sessions) are in May & June 2013. If your events span several months, then you can use formulas to generate calendar. Just enter event data in a table like below: How to create an interactive calendar from a set of events 1. If you live near any of these cities and want to become awesome in Excel, please consider enrolling in my Masterclass.Ĭlick here for details & to book your spot | Download Masterclass brochure Back to the interactive calendarĬoming back to our topic at hand – interactive calendar, what do we mean by this? We will be doing 2 day interactive sessions on Excel, advanced Excel, interactive charts, pivot tables & dashboards in Chicago, New York, Washington (DC) & Columbus (OH). But first, a reminder to join my Advanced Excel masterclass in USAĪs you may know, I am running my first ever Advanced Excel & Dashboards Masterclass in USA this summer (May / June 2013). But we can use little creativity, conditional formatting, few formulas & 3 lines of VBA code to create a slick, interactive calendar in Excel. ![]() While Excel shines easily when you want to log this data, it has no quick way to visualize this information. One of the popular uses of Excel is to maintain a list of events, appointments or other calendar related stuff.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |