• What's the dif? Gridlines vs borders in spreadsheets

    A lot of you want to know the difference between gridlines and borders. Gridlines help you work in a spreadsheet, and borders help you highlight important information in one for your audience. Gridlines appear automatically so you can see how your data is organized into rows and columns; borders need to be added by you so you can highlight certain cells. This post describes how to work with both of them.

    ...
  • Using crosstab queries in reports

    A well designed database stores data in a normalized format with dates defined in a field so that new data is simply added as additional records. However, people want to see data with dates grouped by columns. This can be done by using a crosstab query. However, when creating reports based on crosstab queries, we need to control the specific column names that are returned by the query. Otherwise, the report cannot refer to the query's fields.

    ...
  • Change page numbers in different sections in a Word document

    Watch this video to find out how to how to use 1, 2, 3 page numbering in the main part of a document and i, ii, iii page numbering in the appendices:

    -- Joannie Stangeland

    ...
  • Webinar: Working with Office for Mac 2011

    Office for Mac 2011 and PCs are working better together. In this week’s webinar we’ll show you Office for Mac 2011 including some features that make that possible.

    What you will learn at Tuesday's webinar:

    • Outlook now on the Mac
    • SkyDrive for the Mac
    • How a Mac and a PC...
    ...
  • Schedule crammed? Try searching your Calendar

    Search Outlook CalendarNow when is that neighborhood planning meeting and will it conflict with the business dinner your boss just asked you to attend? Your calendar is so full that scanning it won't help. You might not know that the Outlook Calendar has its own Search to help you sort out the dates.

    ...
  • Split and merge data in URLs

    Issue: I have a list of URLs with their corresponding page views. The URLs include a section of the site and the date when the page was published. I'd like to calculate the total number of page views by site section and the total number of page views by publication date. I want to reduce the time it would take to manually enter this data into new columns. To save time, I plan on using the Text to Columns wizard and Concatenate function rather than a complex formula. Once you learn the steps, it will take you only a few minutes to complete the tasks.

    ...
  • More SmartArt graphics: Hexagon Radial and Picture Frame

    Smart Art PowerPoint 2010We're always looking for ways to improve our products and provide content that meets your needs. So this post introduces you to two brand new SmartArt graphics -- Hexagon Radial and Picture Frame.

    This is the third in our series of blog posts discussing 10 new SmartArt graphics that are now available, for free. Today's post was written by Adam Callens, Program Manager.

    ...
  • Part 1: The Office 365 approach to privacy in the public cloud – Responsibility
    Microsoft Office 365 is an online business service that was purposely built to optimize the flexibility, responsiveness, and efficiency of the cloud. It was also created with a strong emphasis on data protection and with Microsoft's three tenets of privacy - responsibility, transparency, and choice - at its core. This week we'll explore each principle as explained in the Microsoft whitepaper "Privacy in the Public Cloud: The Office 365 Approach" and on the Office 365 Trust Center , which provides...
  • Filtering emails in Outlook

    Outlook offers several ways to filter emails. A filter lets you see only those messages that meet certain criteria. For example, you could pick a filter that lets you see only emails that have attachments or are unread. Here's how it works.

    ...
  • Webinar: What is Office 365?

    In this week’s webinar, you’ll learn about Office 365. For small and big businesses, it gives secure, anywhere access to email and calendars, and lets you collaborate with others using Office Web Apps, instant messaging, conferencing, and file sharing.

     

    What you will learn at Tuesday's webinar:

    ...

1 2 3 4 5