March 2012 - The Excel Team Blog

In honor of VLOOKUP Week, MVP Bill Jelen has created a VLOOKUP tutorial for those of you who have a basic working knowledge of Excel but want to improve your skills. You most likely know the core set of functions that come with Excel and have heard that VLOOKUP is an easy way to look up a value in an Excel spreadsheet, speeding up getting work done. But that's about it. Bill's tutorial starts there. ...( read more ) Read More...

Join Tuesday's free Office 15-Minute Webinar to learn about simpliying data in Excel. You can join the webinar live with the link below at 9:15 am PDT or go to http://aka.ms/offweb for complete information on our webinars. Join online meeting https://join.microsoft.com/meet/dougt/F274WBQZ The best option is to download the free Lync Attendee for sound/video, or you can use your browser and call in for sound: 1 (888) 320-3585. Conference ID: 84172528 What you will learn at Tuesday’s webinar...

Do you belong to LinkedIn ? Did you know that LinkedIn has lots of Excel user groups where Excel trainers, developers, financial modelers, and even Excel blackbelts compete to out geek each other--or just share information. (The Excel Blackbelt group is for data visualization experts.) ...( read more ) Read More...

Ever wanted to see just a part of your Excel worksheet that's way over on the right? You scroll over and find the information you're looking for, but your row or column headings-sometimes both-have disappeared. Or maybe you want to see data in one row that's at the bottom of your worksheet (which might contain hundreds or even thousands of rows). How can you go to that row and still see how its data has been categorized in the headings? By using the Freeze Panes commands on the View tab...

If you're collaborating or creating sensitive material in Excel, you probably need either a DRAFT or CONFIDENTIAL watermark. Excel doesn't come with a built-in way to add a watermark, but there's a pretty painless way to do so. We show you how and give you sample watermarks to get you started. ...( read more ) Read More...