http://blogs.office.com/b/en-USTelligent Community 1.5.134.15456 (Build: 5.5.134.15456)http://blogs.office.com/b/microsoft-excel/archive/2012/05/30/excel-tutorials-on-charts-.aspxWed, 30 May 2012 17:27:00 GMT53587256-c606-4c9b-bad4-97c86b12ce62:31369Emily Warn1<p><img src="/resized-image.ashx/__size/550x0/__key/CommunityServer-Blogs-Components-WeblogFiles/00-00-00-00-44/3884.1680_5F00_Summary_5F00_PowerPivot_5F00_300x166_5F00_jpg_2D00_550x0.jpg" alt="Excel tutorials on charts" title="Excel tutorials on charts" style="border: 0px currentColor; margin-right: 12px; float: left;" />Excel spreadsheets are all about numbers. But tons of numbers are often not the most effective way to communicate what you want. That's where charts come in handy. Charts can display numeric data in a graphical format, making it easy to understand large quantities of data and the relationships among data.</p> <p>If you want to learn about Excel charts, you've come to the right place. We've pulled together out best tutorials and articles to get you started. </p>...(<a href="http://blogs.office.com/b/microsoft-excel/archive/2012/05/30/excel-tutorials-on-charts-.aspx">read more</a>)<img src="http://blogs.office.com/aggbug.aspx?PostID=31369" width="1" height="1">Excel 2010Excel tutorialschartshttp://blogs.office.com/b/microsoft_office_365_blog/archive/2012/05/30/announcing-office-365-for-government-a-us-government-community-cloud.aspxWed, 30 May 2012 16:00:00 GMT53587256-c606-4c9b-bad4-97c86b12ce62:31362Kirk Koenigsbauer9<p>Today, I'm pleased to announce some great news for government customers in the United States. </p> <p>First, we're introducing Office 365 for Government.&nbsp; Office 365 for Government is a new multi-tenant service that stores US government data in a segregated community cloud. Like other Office 365 offerings, it includes productivity and collaboration services including Exchange Online, Lync Online, SharePoint Online, and Office Professional Plus.&nbsp; Customers can contact their Microsoft representative for details and to explore the service.</p> <p>We also know that security and privacy play a big role in any decision to move to the cloud.&nbsp; Today, Office 365 supports the most rigorous global and regional <a href="http://www.microsoft.com/en-us/office365/trust-center.aspx#fbid=FhNP1ga4j_6?Compliance">standards</a> such as ISO 27001, SAS70 Type II, EU Safe Harbor, EU Model Clauses, the US Health Insurance Portability and Accountability Act (HIPAA), the US Family Educational Rights and Privacy Act (FERPA), and the <a href="http://blogs.office.com/b/microsoft_office_365_blog/archive/2012/05/03/fisma-security-certification-office-365.aspx">US Federal Information Security Management Act (FISMA)</a>.&nbsp; To meet evolving needs, we also plan to support IPv6 in Office 365 for Government by September of this year, and we're taking steps to soon support Criminal Justice Information Security (<a href="http://publicintelligence.net/u-s-doj-fbi-criminal-justice-information-services-cjis-security-policy-2011-draft/">CJIS</a>) policies.&nbsp; </p> <p>We look forward to working with our government customers on these initiatives in the coming months.</p> <p> <p><em> <p><i>Kirk Koenigsbauer</i>&nbsp;</p> <em>Corporate Vice President</em></em></p> </p> <p><em>Microsoft Office Division</em></p> <p><img width="160" src="http://blogs.office.com/resized-image.ashx/__size/550x0/__key/CommunityServer-Blogs-Components-WeblogFiles/00-00-00-00-60/5751.logo_2D00_office_2D00_365.png" alt="Office 365 " style="float: left; margin-right: 12px; border-width: 0px;" title="Office 365" /></p><div style="clear:both;"></div>SecuritySharePoint OnlineExchange OnlineLync OnlinegovernmentCloud SolutionOffice 365 cloudOffice 365 Bloghttp://blogs.office.com/b/office_blog/archive/2012/05/30/mommasaid-office-timesaver-tips.aspxWed, 30 May 2012 14:56:00 GMT53587256-c606-4c9b-bad4-97c86b12ce62:31340Emily Warn0<p><img src="/resized-image.ashx/__size/550x0/__key/CommunityServer-Blogs-Components-WeblogFiles/00-00-00-00-06/3618.Summary_5F00_AndersonCooper_5F00_300x166-_2800_2_2900_.png" alt="Anderson Cooper &amp; Jen Singer Office Tips" title="Anderson Cooper &amp; Jen Singer Office Tips" style="border: 0px currentColor; margin-right: 12px; float: left;" /><img src="/resized-image.ashx/__size/550x0/__key/CommunityServer-Blogs-Components-WeblogFiles/00-00-00-00-46/0083.TransparentSpacer_5F00_1x1.gif" border="0" /><em>(Guest blogger Jen Singer is the creator of </em><a href="http://mommasaid.net/"><em>MommaSaid.net</em></a><em>,<b> </b>a Forbes Best of the Web community for moms, and </em><a href="http://parentingwithcancer.com/"><em>ParentingWithCancer.com</em></a><em>. </em></p> <p>In this post, I share some ways that I keep my <a href="http://mommasaid.net/">MommaSaid.net</a> empire running from home (and my car, and soccer practice) with the help of Microsoft Office. I let Anderson Cooper in on some when I appeared on his TV show, but time was too short to fit them all in. Check out all the tips here. </p>...(<a href="http://blogs.office.com/b/office_blog/archive/2012/05/30/mommasaid-office-timesaver-tips.aspx">read more</a>)<img src="http://blogs.office.com/aggbug.aspx?PostID=31340" width="1" height="1">Anderson Cooperjen singerOffice 2010 tipshttp://blogs.office.com/b/office_blog/archive/2012/05/25/office-15-minute-webinar-favorite-office-timesavers-mommasaid.aspxFri, 25 May 2012 21:56:00 GMT53587256-c606-4c9b-bad4-97c86b12ce62:31336Doug Thomas3<p><a href="http://mommasaid.net"></a><a href="http://mommasaid.net"></a>In this week's webinar, author and popular blogger Jen Singer (<a href="http://MommaSaid.net">Momma Said.net</a>) joins us to share some of her favorite Office timesavers. Plus, you'll learn more of them from the Help writers at Office.com who use every day. </p> <p>&nbsp;<iframe width="640" frameborder="0" src="http://www.youtube.com/embed/KyYJq9dmXqI" height="480"></iframe></p>...(<a href="http://blogs.office.com/b/office_blog/archive/2012/05/25/office-15-minute-webinar-favorite-office-timesavers-mommasaid.aspx">read more</a>)<img src="http://blogs.office.com/aggbug.aspx?PostID=31336" width="1" height="1">tipsOffice webinarhttp://blogs.office.com/b/microsoft-excel/archive/2012/05/23/the-difference-between-gridlines-and-borders-in-excel.aspxWed, 23 May 2012 16:58:00 GMT53587256-c606-4c9b-bad4-97c86b12ce62:31316Dail Bridges0<p><img src="/resized-image.ashx/__size/550x0/__key/CommunityServer-Blogs-Components-WeblogFiles/00-00-00-00-44/2768.Summary_5F00_Gridlines_5F00_300x166.jpg" alt="Gridlines and borders in Excel" title="Gridlines and borders in Excel" style="border: 0px currentColor; margin-right: 12px; float: left;" />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.&nbsp;This post describes how to work with both of them. </p>...(<a href="http://blogs.office.com/b/microsoft-excel/archive/2012/05/23/the-difference-between-gridlines-and-borders-in-excel.aspx">read more</a>)<img src="http://blogs.office.com/aggbug.aspx?PostID=31316" width="1" height="1">Excel 2010gridlinesbordershttp://blogs.office.com/b/microsoft-access/archive/2012/05/23/using-crosstab-queries-in-reports.aspxWed, 23 May 2012 16:21:00 GMT53587256-c606-4c9b-bad4-97c86b12ce62:31319Emily Warn0<p>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.&nbsp;This can be done by using a <a href="http://office.microsoft.com/en-us/access-help/make-summary-data-easier-to-read-by-using-a-crosstab-query-HA010341832.aspx?CTT=1">crosstab query</a>. 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.</p>...(<a href="http://blogs.office.com/b/microsoft-access/archive/2012/05/23/using-crosstab-queries-in-reports.aspx">read more</a>)<img src="http://blogs.office.com/aggbug.aspx?PostID=31319" width="1" height="1">Access 2010cross tab querieshttp://blogs.office.com/b/microsoft-word/archive/2012/05/22/word-of-the-week-different-page-numbers-in-different-sections.aspxTue, 22 May 2012 18:48:00 GMT53587256-c606-4c9b-bad4-97c86b12ce62:2303Joannie Stangeland38<p><span style="font-family: 'Arial','sans-serif'; color: black; font-size: 9pt;">Watch this video to find out how to </span><span style="font-family: 'Arial','sans-serif'; color: black; font-size: 9pt;">how to use 1, 2, 3 page numbering in the main part of a document and i, ii, iii page numbering in the appendices:</span></p> <p><embed src="http://www.youtube.com/v/X-L2jnwxKeI&amp;hl=en_US&amp;fs=1?rel=0" width="480" height="385"></embed><embed></embed><embed></embed><embed></embed><embed></embed><embed></embed><embed></embed><embed></embed><embed></embed><embed></embed><embed></embed><embed></embed><embed></embed><embed></embed><embed></embed><embed></embed><embed></embed><embed></embed><embed></embed><embed></embed><embed></embed><embed></embed><embed></embed><embed></embed><embed></embed><embed></embed><embed></embed><embed></embed><embed></embed><embed></embed><embed></embed><embed></embed> </p> <p><i>-- Joannie Stangeland</i></p>...(<a href="http://blogs.office.com/b/microsoft-word/archive/2012/05/22/word-of-the-week-different-page-numbers-in-different-sections.aspx">read more</a>)<img src="http://blogs.office.com/aggbug.aspx?PostID=2303" width="1" height="1">Word 2010page numberinghttp://blogs.office.com/b/office_blog/archive/2012/05/21/office-15-minute-webinar-office-for-mac-2011.aspxMon, 21 May 2012 16:38:00 GMT53587256-c606-4c9b-bad4-97c86b12ce62:31279Doug Thomas2<p>Office for Mac 2011 and PCs are working better together. In this week&rsquo;s webinar we&rsquo;ll show you Office for Mac 2011 including some features that make that possible. </p> <div></div> <p><iframe width="640" frameborder="0" src="http://www.youtube.com/embed/7agXnCHTJl8" height="480"></iframe></p> <p><strong>What you will learn at Tuesday's webinar:</strong></p> <ul> <li>Outlook now on the Mac </li> <li>SkyDrive for the Mac</li> <li>How a Mac and a PC...</li> </ul>...(<a href="http://blogs.office.com/b/office_blog/archive/2012/05/21/office-15-minute-webinar-office-for-mac-2011.aspx">read more</a>)<img src="http://blogs.office.com/aggbug.aspx?PostID=31279" width="1" height="1">Office for MacOffice webinarhttp://blogs.office.com/b/microsoft-outlook/archive/2012/05/17/how-to-search-calendars-in-outlook.aspxThu, 17 May 2012 14:20:00 GMT53587256-c606-4c9b-bad4-97c86b12ce62:31249Dail Bridges0<p><img src="/resized-image.ashx/__size/550x0/__key/CommunityServer-Blogs-Components-WeblogFiles/00-00-00-00-55/7433.Summary_5F00_SelectCalendar_5F00_300x166.jpg" alt="Search Outlook Calendar" title="Search Outlook Calendar" style="border: 0px currentColor; margin-right: 12px; float: left;" />Now 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. </p>...(<a href="http://blogs.office.com/b/microsoft-outlook/archive/2012/05/17/how-to-search-calendars-in-outlook.aspx">read more</a>)<img src="http://blogs.office.com/aggbug.aspx?PostID=31249" width="1" height="1">Outlook 2010Outlook Calendarhttp://blogs.office.com/b/microsoft-excel/archive/2012/05/16/splitting-and-recombining-data-in-urls-.aspxWed, 16 May 2012 21:43:00 GMT53587256-c606-4c9b-bad4-97c86b12ce62:31270Stacey Armstrong3<p>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 <b>Text to Columns wizard</b> and <b>Concatenate</b> <strong>function </strong>rather than a complex formula. Once you learn the steps, it will take you only a few minutes to complete the tasks. </p>...(<a href="http://blogs.office.com/b/microsoft-excel/archive/2012/05/16/splitting-and-recombining-data-in-urls-.aspx">read more</a>)<img src="http://blogs.office.com/aggbug.aspx?PostID=31270" width="1" height="1">Excel 2010split and merge datahttp://blogs.office.com/b/microsoft-powerpoint/archive/2012/05/16/more-new-free-smartart-graphics-hexagon-radial-and-picture-frame.aspxWed, 16 May 2012 19:07:00 GMT53587256-c606-4c9b-bad4-97c86b12ce62:26398Erik Jensen11<p><a href="/b/microsoft-powerpoint/archive/2011/07/11/more-new-free-smartart-graphics-hexagon-radial-and-picture-frame.aspx"></a><img src="/resized-image.ashx/__size/550x0/__key/CommunityServer-Blogs-Components-WeblogFiles/00-00-00-00-46/3286.Summary_5F00_SmartArt_5F00_300x166.jpg" alt="Smart Art PowerPoint 2010" title="Smart Art PowerPoint 2010" style="border: 0px currentColor; margin-right: 12px; float: left;" />We'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 <a href="http://office.microsoft.com/en-us/powerpoint-help/learn-more-about-smartart-graphics-HA010354757.aspx?CTT=1">SmartArt graphics</a> -- <b>Hexagon Radial</b> and <b>Picture Frame</b>.</p> <p><i>This is the third in our series of blog posts discussing <a href="/b/office_blog/archive/2011/06/27/10-new-smartart-graphics-available-for-excel-outlook-powerpoint-and-word.aspx">10 new SmartArt graphics</a> that are now available, for free. Today's post was written by Adam Callens, Program Manager. </i></p>...(<a href="http://blogs.office.com/b/microsoft-powerpoint/archive/2012/05/16/more-new-free-smartart-graphics-hexagon-radial-and-picture-frame.aspx">read more</a>)<img src="http://blogs.office.com/aggbug.aspx?PostID=26398" width="1" height="1">designSmartArthttp://blogs.office.com/b/microsoft_office_365_blog/archive/2012/05/15/privacy-public-cloud-office-365.aspxTue, 15 May 2012 16:00:00 GMT53587256-c606-4c9b-bad4-97c86b12ce62:31217Stephen Bury1Microsoft 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...(<a href="http://blogs.office.com/b/microsoft_office_365_blog/archive/2012/05/15/privacy-public-cloud-office-365.aspx">read more</a>)Office 365Trust CenterSecurityCloud SolutionOffice 365 cloudOffice 365 Blogprivacyhttp://blogs.office.com/b/microsoft-outlook/archive/2012/05/14/filtering-emails-in-outlook.aspxMon, 14 May 2012 22:38:00 GMT53587256-c606-4c9b-bad4-97c86b12ce62:31248Dail Bridges2<p>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.</p>...(<a href="http://blogs.office.com/b/microsoft-outlook/archive/2012/05/14/filtering-emails-in-outlook.aspx">read more</a>)<img src="http://blogs.office.com/aggbug.aspx?PostID=31248" width="1" height="1">Outlook 2010filter emailshttp://blogs.office.com/b/office_blog/archive/2012/05/14/office-15-minute-webinar-office-365.aspxMon, 14 May 2012 17:38:00 GMT53587256-c606-4c9b-bad4-97c86b12ce62:31247Doug Thomas0<p>In this week&rsquo;s webinar, you&rsquo;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. </p> <p>&nbsp;<iframe width="640" frameborder="0" src="http://www.youtube.com/embed/fcU5fNH2kaM" height="480"></iframe></p> <p><strong>What you will learn at Tuesday's webinar:</strong></p>...(<a href="http://blogs.office.com/b/office_blog/archive/2012/05/14/office-15-minute-webinar-office-365.aspx">read more</a>)<img src="http://blogs.office.com/aggbug.aspx?PostID=31247" width="1" height="1">Office 365Office webinarhttp://blogs.office.com/b/microsoft-excel/archive/2012/05/14/changing-column-widths-in-pivot-tables.aspxMon, 14 May 2012 16:39:00 GMT53587256-c606-4c9b-bad4-97c86b12ce62:31214Stacey Armstrong4<p>Who could be better than a Business Intelligence analyst at teaching us a thing or two about Excel? We asked our own number-crunching wizard Stacey Armstrong to share some Excel tricks she's learned along the way. </p> <p>In this first one, she shows us how to change the default width of a column in a pivot table.&nbsp;Knowing this is especially helpful when you're working with data that that makes a row really long.</p>...(<a href="http://blogs.office.com/b/microsoft-excel/archive/2012/05/14/changing-column-widths-in-pivot-tables.aspx">read more</a>)<img src="http://blogs.office.com/aggbug.aspx?PostID=31214" width="1" height="1">Excel 2010Pivot Tableshttp://blogs.office.com/b/microsoft-outlook/archive/2012/05/11/grouping-emails-by-conversation-in-outlook.aspxFri, 11 May 2012 18:53:00 GMT53587256-c606-4c9b-bad4-97c86b12ce62:31238Dail Bridges3<p><img src="/resized-image.ashx/__size/550x0/__key/CommunityServer-Blogs-Components-WeblogFiles/00-00-00-00-55/0207.Summary_5F00_ShowConversation_5F00_300x166.jpg" alt="Group emails by conversation in Outlook" title="Group emails by conversation in Outlook" style="border: 0px currentColor; margin-right: 12px; margin-left: 12px; float: left;" />Have you ever had to find an email that was part of a long thread--an email with lots of replies about the same topic? For example, your boss might have asked for the results of last month's important meeting, and you know Sherry sent an email outlining them, but then you remember that Todd followed hers with more information. </p> <p>If you group your emails into conversations, you can find the emails you want more quickly.</p>...(<a href="http://blogs.office.com/b/microsoft-outlook/archive/2012/05/11/grouping-emails-by-conversation-in-outlook.aspx">read more</a>)<img src="http://blogs.office.com/aggbug.aspx?PostID=31238" width="1" height="1">Outlook 2010Conversation viewhttp://blogs.office.com/b/microsoft-word/archive/2012/05/11/hilary-pwer.aspxFri, 11 May 2012 18:19:00 GMT53587256-c606-4c9b-bad4-97c86b12ce62:31243Emily Warn0If Hilary Powers can teach editors tricks about using Word, then we ordinary folk can definitely benefit from listening to her. Hilary's the author of Making Word Work for You , a handbook for editors, and the maker of creatures out of felt. As an editor, I collaborate with a lot of people and so continually use Track Changes . If you know how to use it, your back and forth with co-workers, or in my line of work, with authors, speeds up getting a document from first draft to final draft. Here are...(<a href="http://blogs.office.com/b/microsoft-word/archive/2012/05/11/hilary-pwer.aspx">read more</a>)<img src="http://blogs.office.com/aggbug.aspx?PostID=31243" width="1" height="1">Track ChangesOutlook 2010http://blogs.office.com/b/microsoft-outlook/archive/2012/05/10/conditional-formatting-highlight-your-most-important-mails.aspxThu, 10 May 2012 18:08:00 GMT53587256-c606-4c9b-bad4-97c86b12ce62:18927Outlook Team28<p>Conditional formatting is an Outlook tool for making sure your important email messages stick out in your Inbox. The tool lets you customize how different messages appear in your Inbox based on criteria that you set. This post shows you how.</p>...(<a href="http://blogs.office.com/b/microsoft-outlook/archive/2012/05/10/conditional-formatting-highlight-your-most-important-mails.aspx">read more</a>)<img src="http://blogs.office.com/aggbug.aspx?PostID=18927" width="1" height="1">mail2010Outlook 2010inboxinformation overloadhttp://blogs.office.com/b/microsoft_office_365_blog/archive/2012/05/10/customize-public-website-office-365--gadgets.aspxThu, 10 May 2012 16:00:00 GMT53587256-c606-4c9b-bad4-97c86b12ce62:31216Stephen Bury3<p>Microsoft Office 365 provides small businesses with simple tools to create professional-looking websites. Powered by SharePoint Online, you can choose your own domain and use the provided tools and templates to build, publish and maintain your site. Gadgets, which are standalone applications that come with SharePoint Online, allow you to further enhance your website with everything from videos to a PayPal button. </p>...(<a href="http://blogs.office.com/b/microsoft_office_365_blog/archive/2012/05/10/customize-public-website-office-365--gadgets.aspx">read more</a>)small businessSharePoint OnlinewebsitevideodomainsCloud SolutionOffice 365 Bloggadgetshttp://blogs.office.com/b/microsoft-powerpoint/archive/2012/05/09/powerpoint-viewer-available-for-download.aspxWed, 09 May 2012 21:55:00 GMT53587256-c606-4c9b-bad4-97c86b12ce62:13234PowerPoint Team62(This post, originally published in 2010, announced the availability of the PowerPoint 2010 Viewer. This post remains incredibly popular because so people find the Viewer to be a useful tool. We're republishing it so readers of our blog can find and use it, too.) I&rsquo;m excited to announce that our new PowerPoint Viewer is now available here for free download . By installing the PowerPoint Viewer, you can open and watch PowerPoint presentations in all formats, no matter what computer you&rsquo;re...(<a href="http://blogs.office.com/b/microsoft-powerpoint/archive/2012/05/09/powerpoint-viewer-available-for-download.aspx">read more</a>)<img src="http://blogs.office.com/aggbug.aspx?PostID=13234" width="1" height="1">Viewerhttp://blogs.office.com/b/microsoft-word/archive/2012/05/09/how-to-make-table-headers-repeat-in-word.aspxWed, 09 May 2012 18:02:00 GMT53587256-c606-4c9b-bad4-97c86b12ce62:31196Steve Birge2<p><img src="/resized-image.ashx/__size/550x0/__key/CommunityServer-Blogs-Components-WeblogFiles/00-00-00-00-45/7345.Summary_5F00_TipClassicsParents300x166.jpg" alt="how to make table headers repeat in Microsoft Word" title="how to make table headers repeat in Microsoft Word" style="border: 0px currentColor; margin-right: 12px; float: left;" />Edna Jean's parents aren't sure about Conrad taking her to the prom, even though he's her "hunky wunk". Then she tells them that in Word, he can make table headers repeat over multiple-page tables. Will this seal the deal with Edna Jean's parents?</p>...(<a href="http://blogs.office.com/b/microsoft-word/archive/2012/05/09/how-to-make-table-headers-repeat-in-word.aspx">read more</a>)<img src="http://blogs.office.com/aggbug.aspx?PostID=31196" width="1" height="1">Microsoft Word 2010table headershttp://blogs.office.com/b/office_blog/archive/2012/05/07/office-15-minute-webinar-keyboard-shortcuts.aspxMon, 07 May 2012 16:17:00 GMT53587256-c606-4c9b-bad4-97c86b12ce62:31183Doug Thomas2<p>In this week's webinar, you'll learn about nifty keyboard shortcuts in Excel, PowerPoint, and Word. There's a lot more than Ctrl+X for Cut and Ctrl+V for Paste. </p> <div></div> <p><iframe width="640" frameborder="0" src="http://www.youtube.com/embed/niI1pi9uNOM" height="480"></iframe></p> <p><strong>What you will learn at Tuesday's webinar:</strong></p> <ul> <li>Why shortcuts? </li> <li>Keyboard shortcuts in</li> </ul>...(<a href="http://blogs.office.com/b/office_blog/archive/2012/05/07/office-15-minute-webinar-keyboard-shortcuts.aspx">read more</a>)<img src="http://blogs.office.com/aggbug.aspx?PostID=31183" width="1" height="1">office trainingOffice webinarhttp://blogs.office.com/b/microsoft-excel/archive/2012/05/04/count-values-that-meet-a-condition-with-the-countif-function.aspxFri, 04 May 2012 16:39:00 GMT53587256-c606-4c9b-bad4-97c86b12ce62:24548Gary Willoughby3<p><a href="/b/microsoft-excel/archive/2011/03/15/count-values-that-meet-a-condition-with-the-countif-function.aspx"><img width="160" src="/cfs-file.ashx/__key/CommunityServer-Blogs-Components-WeblogFiles/00-00-00-00-44/3005.COUNTIF_5F00_img1.png" alt="Try it for free: Count values that meet a condition with the COUNTIF function" title="Try it for free: Count values that meet a condition with the COUNTIF function" style="float: left; margin-right: 12px; border: 0px;" /></a><b>Update: See near the bottom of this post for the latest Office how-tos on embedding Excel and PowerPoint files on web pages.</b></p> <p><b></b>You probably know how to use the COUNT function to count cells that contain a value. But what if you want to count only the cells that meet a condition, such as being greater than or equal to a number or date you specify, or that matches text? That's where the COUNTIF function comes in really handy.</p> <p>Keep reading to learn more, and try out this great function for free using the embedded worksheet in this post.</p>...(<a href="http://blogs.office.com/b/microsoft-excel/archive/2012/05/04/count-values-that-meet-a-condition-with-the-countif-function.aspx">read more</a>)<img src="http://blogs.office.com/aggbug.aspx?PostID=24548" width="1" height="1">functionsembedhttp://blogs.office.com/b/microsoft-onenote/archive/2012/05/04/turn-onenote-notes-into-outlook-emails.aspxFri, 04 May 2012 14:59:00 GMT53587256-c606-4c9b-bad4-97c86b12ce62:31155Dail Bridges3<p><img src="/resized-image.ashx/__size/550x0/__key/CommunityServer-Blogs-Components-WeblogFiles/00-00-00-00-17/2500.Summary_5F00_ON_2B00_OneNote_5F00_300x166.jpg" alt="Turn OneNote Notes into Outlook Email" title="Turn OneNote Notes into Outlook Email" style="border: 0px currentColor; margin-right: 12px; margin-left: 12px; float: left;" />Did you know OneNote and Outlook are well connected? You can send emails via Outlook right from OneNote. And you can track your To-Do list in both of them at the same time. This post shows you how. </p>...(<a href="http://blogs.office.com/b/microsoft-onenote/archive/2012/05/04/turn-onenote-notes-into-outlook-emails.aspx">read more</a>)<img src="http://blogs.office.com/aggbug.aspx?PostID=31155" width="1" height="1">OneNote 2010http://blogs.office.com/b/microsoft_office_365_blog/archive/2012/05/03/fisma-security-certification-office-365.aspxThu, 03 May 2012 23:39:00 GMT53587256-c606-4c9b-bad4-97c86b12ce62:31175Julia White12<p>Today, we're pleased to announce Office 365 was granted the authorization to operate under the Federal Information Security Management Act (FISMA) by the <a href="http://www.bbg.gov/">Broadcasting Board of Governors</a>. FISMA is important to our customers because it creates a process for federal agencies to certify and accredit the security of their information management systems.&nbsp; IT solutions with FISMA certification and accreditation have federal agency approval for their use in line with the level of security established by that agency. &nbsp;</p>...(<a href="http://blogs.office.com/b/microsoft_office_365_blog/archive/2012/05/03/fisma-security-certification-office-365.aspx">read more</a>)Office 365Trust CenterSecuritycloud service provider