• Word of the week: Add the filename to your header or footer

    People often want to add the location of their document--the filename and the file path--to the header or footer.

    In Word 2010, you can do this by using field codes. It sounds more complicated than it is, so let's take a look.

     

    For more information on field codes, see Insert and format field codes in Word.

    -- Joannie Stangeland

    ...
  • Using RSS Feeds in Outlook 2007
    Using Outlook to manage and read your RSS feeds has several advantages over a stand-alone aggregator, including the ability to place flags and run rules on any RSS feed to which you subscribe. Some of you might be wondering what is RSS? Really Simple Syndication (usually referred to as RSS) is a way to get updates to websites sent to you instead of having to go back to the web to see if any changes have been made. In this way, you can keep up-to-date on news and information from many different sources...
  • Chart Templates
    Today's author, Ben Rampson, a Program Manager on the Excel team. Customers who author charts in presentations and reports often spend a significant amount of effort modifying their charts to get them looking just the way they want. While the new Chart Style and Chart Layout features in Office 2007 provide some great one-click options to quickly alter the appearance of a chart, there are still times when one needs to modify a chart even further. A company policy may require that a chart use particular...
  • Excel 2010: New Search Filter
    Exploring large data sets and creating filters has never been easier than with Excel 2010. Tables, PivotTables and PivotCharts now have a new search functionality that easily enables you to find what you need, filter and repeat for a faster more efficient way of navigating those enormous data sets. Filtering FAST! In Excel 2010 when you click on the dropdown for autofilters, tables, PivotTables and PivotCharts you will now find a new search interface that enable swift navigation of extremely large...
  • Living in Outlook: Using Quick Parts
    The Living in Outlook series is about sharing tips and workflows around real-world scenarios. We’ll start the conversation with a topic – you can add to it by posting your tips and workflows in the comments! In previous posts I have talked about Message Templates and Advanced Message Templates , and how I use them to easily manage status reports or any other type of e-mail that I regularly send. While Message Templates are very powerful, sometimes I just want a simple way to easily insert...
  • Function Improvements in Excel 2010
    Thanks to Jessica Liu for putting together the next few posts on function improvements. In Excel 2010, we made many improvements to Excel's function library. Excel 2010 will feature an accurate and consistent function library while remaining compatible with previous versions of Excel. In this first blog post, I will be giving an overview of the work we did in this area as well as talk about the function accuracy improvements. Subsequent posts will go into the details of the consistency improvements...
  • Easy (and Even Fun!) Data Exploration: Introducing Excel 2010 Slicers
    Thanks to Karen Cheng for putting together this series on Slicers. New to Excel 2010 are slicers, which are visual controls that allow you to quickly and easily filter your data in an interactive way. They float above the grid, like charts and shapes. Here’s an example of the same slicer in three different states. You can select one, all, or some countries. A slicer acts like a report filter, so you can hook it up to a PivotTable, PivotChart, or CUBE function to create an interactive report...
  • A first look at Microsoft OneNote on the iPhone

    Since I began looking at Microsoft Office 2010 Beta feedback last year, the one question so many of you asked perhaps more than any other was "When will you release a OneNote app for the iPhone?" I'm happy to say that the time has come. OneNote Mobile for iPhone is now available on the iTunes App Store. It works on any iPhone or iPod touch running iOS 4.2 or later, and it's free for a limited time.

    With OneNote Mobile, you can create and view notes and lists right on your iPhone. Create shopping lists and to-do lists, prepare for a trip or project, and  take class or meeting notes without lugging around your laptop. OneNote Mobile for iPhone is also great for collecting ideas and tracking project notes, capturing ad hoc information about stuff you need to deal with at home or at work, as well as tracking activities, wish lists, gift lists — anything you can think of!

    Read my full blog post for information about where to download the app, how to get started with the basics, view screenshots of sample notebooks and pages, and learn how to leave feedback and get technical support.

    ...
  • Charlie’s List, or “214 Keyboard Shortcuts”
    One of the program managers on my team (Charlie) has put together a list of 214 keyboard shortcuts available in Excel. While it isn’t exhaustive (for example, it doesn’t cover shortcuts available in dialogs), I find it a useful presentation of the shortcuts that are available when performing basic editing in Excel, so I thought I would share it with you. If you click the picture below, you will access a PDF file which you can download and print. (The PDF was generated by a recent build of Microsoft...
  • Send Text Messages Using Outlook 2010

    With Microsoft Outlook 2010, you can stay connected by sending and receiving text messages (SMS). For instance, you could send a quick note to a co-worker saying you're running late for a meeting. You can also forward your upcoming Outlook schedule or important e-mail messages as a text message directly to a mobile device.  This post shows you the two ways to set up text messaging in Outlook.

    ...

« First ...     9 10 11 12 13