Here is a quick productivity tip if you work with same set of excel (or word or powerpoint) documents everyday. Just pin the documents to recent documents list in the Office Menu in MS Office 2007.
See this:
How to calculate WEEKNUMBER in Month / Quarter / Year with Excel?
Let’s say you have daily data and your boss wants to see the trends by week in month or week in quarter? How do you calculate the week number in a month or quarter? In this article, let me explain the logic and formulas we can use Excel for this.
3 Responses to “Pin Frequently Used Documents to File Menu to Save Time”
I've been doing this for the last year or so, and my list of pinned workbooks has grown substantially. One additional tip: In Excel Options, under the Advanced/Display section, make sure to bump up the number of recent documents displayed (mine's set to 30).
@Matthew... I have discovered this one recently. I find it pretty useful. 30 documents one is good too. I guess I would need lot of spreadsheeting before I end up accessing 30 documents everyday.
Hi Chandoo,
Can we add web links and folder path to customized ribbon?
Thanks,
Sainath