Group items tagged

If you're a fan of PowerPoint, you may have heard about Microsoft's latest presentation tool, Microsoft Sway. With Sway, you can create and share presentations like never before! In today's blog, we'll give you a basic overview as to what Sway can do as well as some of our personal favorite features. Let's dive in! Sway is a free app from Microsoft Office that helps gather, format, and share reports, newsletters, web pages, and presentations on an interactive, web-based canvas that looks great on almost any screen. That's right, we said interactive! Use videos or interactive charts to engage your audience like never before.

Most people know that you can create PowerPoint presentations with pictures, music, images, web content, and text, but one little known trick is the ability to save PowerPoint presentations as videos. PowerPoint presentations have been a long time favorite for use in business and academic presentations all over the world. They are highly versatile and offer a wide variety of features that you can use to enhance them. In order to save your PowerPoint as a video you will first need to create a presentation or download the sample we used for this tutorial. Once you have the document open, you will need to save it as a video. Begin by pressing "File." sshot-1 - www.office.com/setup Instead of following the logical train of thought and opening the "Save" section, you will need to click on "Export," then click on "Create a video." sshot-2 - www.office.com/setup Once you do this, you will see the "Create a Video" option. This will offer a few options in the form of two drop-down menus and a time value box. sshot-3 - www.office.com/setup The first drop-down box is where you will choose the quality of your exported video. These three options will also determine the size of your exported video file. For the purposes of this example, we will choose the second option to reduce the size of the video without compromising too much video quality. sshot-4 - www.office.com/setup The second drop-down menu allows you to include or exclude any timings or narrations that you inserted on your PowerPoint presentation. Since the sample document has no timings or narrations, we will leave this as is. The "Use Recorded Timings and Narrations" will be unavailable if you don't have any of them in your presentation. sshot-5 - www.office.com/setup The time value box is where you can edit the amount of time that your slides will appear in the video. The default time is set at 5 seconds. For this tutorial, we will set it to 3 seconds. Lastly, you need

Videos of the Office 15-Minute Webinars are available in new apps for Windows 8 and Windows Phone 8. These videos can help you get the most out of Word, Excel, Outlook, OneNote, PowerPoint, and other Office applications. Watch on your phone or Windows 8 computer, or use the app as a second screen as you follow the steps in the demo on your main screen. So now you have another option to view past Office Webinars in addition to the Office Blog, Office YouTube channel, or joining live-plus participate in the live Q&A session-every Tuesday at http://aka.ms/offweb. Windows 8 App Windows Phone 8 App Or just search for "Office Webinars" next time your are at the Windows Store. -Doug Thomas

Guest blogger Emily Warn is co-owner of Two Pens, which provides blogging services and teaches business how to write content that grows a social media following. My writer friends think I'm a geek. You can do what?! I can create a spreadsheet with book sales numbers that can be sorted by name and number. I know that is only the first rung of Excel Geek-dom, and unlike my compatriots, I aspire to climb into the ranks of those who know how to create snazzy charts and perform other formatting feats. Perhaps I'll be able to brand myself as a writer who plays with numbers.

Remember the vintage game "Pull the Rug Out?" It is a board game where players stack different items on top of a rug. Eventually, one of the players tries to pull out the rug without tumbling the pieces stacked on top of it. Google's recent announcement that it is phasing out several additional services, including the highly popular Google Reader, reminded me of this game, as I recall that the stack most always toppled to the ground. Google introduced Google Reader, gradually built up its popularity, and then pulled the rug out with little warning, causing its customers to stumble. As one Google customer put it: "Google spends millions of wasted dollars on pet projects, then kills one of their best products on a whim." Google's most recent spring cleaning brings the total number of services it has discontinued to 70 in just a year-and-a-half. That's right-a whopping 70 services that have been shut down in just 18 months. Among the services Google will discontinue with little warning is Google Cloud Connect, introduced with a lot of fanfare just two years ago. Cloud Connect is a plug-in that enables Google users to share and edit Microsoft Word, PowerPoint and Excel files. To continue collaborating with Microsoft Office, Google users have just four weeks to uninstall Cloud Connect and install Google Drive. Companies that can't get to it by April 30 will be out of luck, leaving them without a way to collaborate on Office documents used by millions of employees, partners, and customers. But of all the services Google is discontinuing this time, the one that's drawing the biggest backlash is Google Reader, a service used by hundreds of thousands of users to keep track of their favorite websites and blogs via RSS feeds. The news of Google Reader's shut down drew outrage from users, who put together a petition demanding that Google reinstate the service. "Our confidence in Google's other products - Gmail, YouTube, and yes, even Plus - requ

This post is brought to you by Seayoung Rhee, Product Marketing Manager in the SharePoint Product Marketing Group. Reliable business intelligence and insight are key to a thriving business. Excel, SharePoint and Office 365 make business intelligence (BI) in the new Office more accessible to everyone across an organization as part of their everyday work. New and enhanced features in familiar tools such as Excel empower everyone in a business to easily explore, model, analyze, and visualize data from various sources. With SharePoint, users of all levels can collaboratively develop and share insights through dashboards and scorecards, and this experience continues seamlessly in the cloud with Office 365. For corporate environments, these features are further enhanced by SQL Server for higher levels of performance and scalability both on-premises and in the cloud with BI Azure. Ultimately with Microsoft BI, anyone in the organization can develop the insights that help drive new discoveries and make better, more informed decisions. EXPLORE YOUR DATA PowerPivot was a popular add-in to Excel 2010, allowing users to create large data models with hundreds of millions of rows in Excel. This feature is now natively embedded in Excel to reduce the hassle of downloads and installation. PowerPivot is also supported in SharePoint with SQL Server Analysis Services where the workbooks with PowerPivot models can be shared broadly across the organization. New features like Quick Explore aid users in navigating their data, and Quick Analysis provides previews of their charts, graphs, and scorecards. Users can: Combine and analyze large datasets with PowerPivot Summarize data and discover trends with Quick Explore Instantly preview charts and pivot tables with Quick Analysis www.office.com/setup VISUALIZE YOUR INSIGHTS Introduced with SQL Server 2012, Power View provided a canvas to create visual dashboards in SharePoint. Now this feature is embedded into Excel and SharePoint so

www.office.com/setup Blogs: Microsoft today detailed the new features and improvements that it delivered to Office 365 users this month. Key among them are new Excel co-authoring capabilities, Microsoft Teams, and new OneNote inking and accessibility updates. "Office 365 provides the broadest and deepest toolkit for collaboration between individuals, teams and entire organizations," Microsoft corporate vice president Kirk Koenigsbauer explains. Here's what's new in March. CO-AUTHORING IN EXCEL 2016 FOR WINDOWS Following similar functionality in Word and PowerPoint, Microsoft has enabled co-authoring capabilities in Excel for the Windows desktop (Excel 2016). (This feature is also available in Excel Online and Excel Mobile on Android, iOS, and Windows 10; Excel for Mac support is coming soon.) "This allows you to know who else is working with you in a spreadsheet, see where they're working and view changes automatically within seconds," Mr. Koenigsbauer says. Co-authoring in Excel 2016 for Windows is rolling out for Office 365 subscribers in Office Insider Fast, Microsoft says. Co-authoring in Excel for iOS is currently available for Office Insider. The feature is generally available in Excel Mobile for Android and Windows, and in Excel Online. AUTOSAVE Microsoft is working to expand the availability of AutoSave beyond mobile versions of Office: Office 365 subscribers in Office Insider Fast now have access to AutoSave in Word, Excel and PowerPoint on Windows desktop, for files stored in SharePoint Online, OneDrive and OneDrive for Business. "With AutoSave, you can stop worrying about hitting the Save button, whether you're working alone or with others," Mr. Koenigsbauer explains. MICROSOFT TEAMS Microsoft delivered its long-awaited Slack alternative, called Microsoft Teams, earlier this month to all Office 365 commercial customers. And last week, it shipped Microsoft Teams to all Office 365 Education subscribers as well. "We are thri

www.office.com/setup Blogs: If you are still using Microsoft Office 2003, you should be aware that Official support has long ended. If you are using Office 2007, support is due to end in 2 short years. Microsoft Office 2016, the latest Windows-based version of the major technology company's application suite, is scheduled for a release sometime in spring, 2015. However, we already know quite a bit about the product, thanks to a preview and testing program that Microsoft has been running. Here are 6 details to look forward to, ahead of the product's mainstream release: 1. Better Security Microsoft Office 2016 will emphasize the value of better security parameters. In addition to a file-level encryption functionality, new data loss protection tools inside of Microsoft Word, Microsoft Excel, and Microsoft PowerPoint will warn users when they attempt to save confidential files to unsafe locations. Microsoft Outlook will also be more secure, thanks to a multi-factor authentication feature. Similarly, the application suite will have stronger information rights management tools that let you limit what people can do with your documents or emails after you've shared access with them. For example, you can allow access to a certain document to expire after a set period of time, and prevent it from being forwarded. These tools will also stop people from copying and pasting information out of Microsoft Office 2016 applications. 2. Business Intelligence Features Microsoft Excel lives up to its name in Microsoft Office 2016. The latest version of this application features a built-in business intelligence tool called Power Query. This tool can dramatically change the way that you approach your data. Using it, you can quickly combine your own numbers with figures from public databases like Data.gov and Microsoft Azure Marketplace. After doing this, the application has another tool that lets you create detailed visualizations of the combined data. The data analysis tool

Liam Bastick has provided financial modelling services and training to clients for more than two decades. A senior accountant and professional mathematician, he has worked in numerous countries with many internationally recognized clients, providing and reviewing strategic and operational models for various key business assignments. You can check out Liam's previous articles at www.sumproduct.com/thought, where you can also subscribe to the monthly tips and tricks newsletter. Ever had to sum data based on multiple criteria situated in different Microsoft Excel worksheets? This article provides a quick tour of INDIRECT references and Table functionality while combining qualities of the SUMPRODUCT function with the SUMIFS function, providing a solution to the mother-of-all Multiple Criteria problems. The functionality is best explained by walking through an example: Ivana: Car Sales has four divisions, cunningly called North, South, East and West. Each quarter, the four divisions are required to submit sales reports detailing the month of sale, the sales person, the car color and the price the car was sold for. www.office.com/setup The question is: how can you determine how many red cars Charlie sold in February in total across all four divisions? The answer would be fairly straightforward if the data were all on one worksheet. For a single criterion, SUMIF would cope admirably well, while for several criteria, SUMPRODUCT could be used to generate the answer (for further information see my blog posts on the SUMPRODUCT function and approaches to addressing multiple criteria in one worksheet).

EMAILS STUCK IN YOUR OUTBOX? www.office.com/setup Blogs: A common complaint of Outlook users is that their email send process takes too long, "hangs," or traps messages in the outbox. Has that ever happened to you? We collected some troubleshooting instructions that should help you get your messages traveling smoothly again. These steps apply to Outlook 2013 and Outlook 2016.

While we are lucky enough to work with extremely innovative clients that are eager to embrace the latest technology, we always advise them not to adopt the latest version of software until after the kinks are worked out. For a consumer it's not a big deal to be test driving new features and experimenting with the latest version. For a business user, if there's a bit of a learning curve, buggy features or errors that make an application crash, it can be a huge detriment to productivity. That's why we take a lot of time testing out new applications and operating systems before we encourage our clients to adopt them. You may have read that Microsoft recently unveiled Office 2016. We spent some time with it and have some mixed feedback for our business users. Here's the good, bad and the ugly surrounding the Office 2016 suite: The Good: Built to make business better. Word is probably our favorite when it comes to the new suite of products. While there has been minimal change to formatting and structure - the overall design has definitely gotten a facelift. We're all about function, though and when it comes to function we see definite improvements. Word has many more templates. This allows businesses to refine their documents and be more professional without having to go online and download templates to use inside Word. There are also some pretty awesome co-authoring features that we wrote about in this blog. Attachments in Outlook reference recent documents. This is a great feature since it's available on any device that you use Office on. You can easily attach documents in e-mails in Outlook or reference them in an e-mail on your phone. This is really valuable for mobile users or users that work from more than one machine. (Which, lets face is, 90% of the workforce these days does.) OneDrive is also attempting to make its way into the life of business users by making sharing documents, collaborating on documents and authoring documents across devices a l

www.office.com/setup Blogs: Today marks the general availability of Office 2016 for Windows, a suite of desktop applications that together with new mobile and web apps pushes Microsoft's new vision for PC-based productivity. Office 2016 is available immediately to Office 365 subscribers, as well as to individuals who would prefer to buy the software in standalone form. "We see Office 2016 as being just as important as the first release of Office," Microsoft group program manager Shawn Villaron told me in a briefing last week. "In the early days, Office was about bringing really important tools together to empower the individual for personal productivity. That was the way people wanted to work at that time. And for 20 to 30 years, Office fit right in. Today, things are changing. More people collaborate on work as groups and teams, so Office 2016 represents the change from personal productivity to team productivity." And that, really, is Office 2016 in a nutshell. If you're a typical information worker, student, or other person in need of standard productivity tools, Office 2016 of course works fine and represents an obvious and stable evolution from the Office version you're currently using. But the real meat in this release-now and going forward, as Office will of course be updated regularly, like Windows 10-is the designed around this new way of working. Confusing matters somewhat, Office-not Office 2016, but Office generally-is all over the place now. In addition to the classic, full-featured desktop suites on both Windows and Mac, Microsoft has high-quality Office Online web apps, mobile apps for Android, iOS, and Windows/Windows phones-and Office 365-specific solutions that are often available as web apps but are sometimes just integrated into the desktop applications. This ain't your father's Office anymore. Office everywhere: Microsoft Office is available on virtually any device you care to use. - www.office.com/setup Office eve

www.office.com/setup Blogs: Good Morning America's newest segment, "Boosting Your Business," sponsored by Microsoft Office, provides entrepreneurs with simple tips and tools to help grow their businesses. In this first segment, Good Morning America brought in Carol Roth, a small business expert and host of Microsoft's Office Small Business Academy, to visit a popular Chicago salon. Living out the American dream, Goran Cobanovski opened his own hair salon after arriving in the U.S. from Macedonia, where his flagship location now employs a team of 18 people and serves up to 50 clients a day. Carol gives Goran advice on employee engagement, delegating responsibilities and scheduling appointments. She shows him how Microsoft Bookings can make front-desk scheduling run more efficiently-creating happier customers. Microsoft Bookings is a new service as part of Office 365 that allows customers to book appointments online directly through your website or Facebook page. Unique vision and unquestionable talent made Goran's dream his reality. Microsoft Office will give him more free time to enjoy it. Register for the Office Small Business Academy webcast series to get more tips and tricks to help you start, grow and manage your business.

www.office.com/setup Blogs: When it comes to technology in the workplace, most every convenience is balanced against a potential threat. Email and the cloud-for as much as they've revolutionized the way we do business-have enabled new methods of theft and fraud and necessitated new regulations. That means planning a secure future for your company is no easy task. Thankfully, you don't have to set out on the road to protection without a map. Keeping a few key considerations in mind can help guide your way and keep your business safe from harm.

www.office.com/setup Blogs: Previews of PowerPoint2013 show that it will be easier to create and share professional presentations with a range of new and improved features. 1. NEW RANGE OF DESIGN THEMES Powerpoint 2013 start screen - www.office.com/setup Easier inclusion of videos, or pictures to give a more professional edge to presentations. Easy access to a collection of new themes available via the start screen. The ability to quickly change themes using theme variants. Alignment Guides have been added that make it easier to align text boxes, graphics and shapes with text. Merge Shapes tools -2013 includes Union, Combine, Fragment, Intersect, and Subtract tools making it easier for the user to merge two or more shapes into the shape required. 2. IMPROVEMENTS TO THE PRESENTER'S VIEW AND ORGANISATION OF THE PRESENTATION. The One click Slide Zoom allows the user to zoom in and out on diagram, or chart. The addition of a presenter's Navigation Grid, making it easier for the presenter to switch slides within a sequence using a navigation grid that the audience cannot see. The ability to easily project a presentation on a second screen using Auto-extend. 3. IMPROVED COLLABORATION WITH EASIER SHARING AND CO-AUTHORING. The Reply Comment feature. PowerPoint 2013 makes it easier to add and track comments next to the relevant section of text. Everyone working on the presentation can follow the discussion easily and act on any suggestions. Collaboration and Sharing. With Microsoft's emphasis on improved collaboration, the new default setting means that presentations are saved online to SkyDrive or SharePoint . This allows the author to send a link to the same file to everyone involved, complete with personalised viewing and editing permissions, so that everyone is working on the same version. The PowerPoint Web App Co-authoringfeature via PowerPoint Web. 2013 makes it easier for several people to work on the same presentation at the same time from the desktop or in bro

www.office.com/setup Blogs: Sway: Microsoft Office presentation software. PowerPoint: Microsoft Office presentation software. So what's the difference? You're watching Jeopardy! when the presenter utters the following answer in keeping with the game show's famous format: "A software tool from Microsoft for creating presentations, web-based reports and projects." Quick as a flash you spit out the question in unison with the contestant: "What is PowerPoint?" To your astonishment, presenter Alex Trebek shakes his head and utters a curt "No". The correct question was "What is Sway?" To the best of our knowledge, that scenario has yet to surface on the American quiz show, but it's hypothetically possible. After all, there are a number of similarities between PowerPoint and Sway on first inspection: Both are part of Microsoft Office Both can be used to create rich presentations Both support multimedia including video, audio and images Both feature customisable templates There's no disputing that there are areas where PowerPoint and Sway overlap. But if you're thinking Sway is just a web-based clone of PowerPoint, think again - each piece of software has highly specific functions. It's well worth familiarising yourself with the differences between the two, cos if you Sway when you're meant to PowerPoint, you're gonna have a bad time. POWERPOINT IN A PARAGRAPH As the world's preeminent slideshow software, PowerPoint requires no introduction. From classroom projects to delivering keynote addresses, Microsoft's easy to use presentation software has graced overhead projectors on every continent. Slides; audience handouts; speaker's notes. Whatever you choose to create and however you choose to deliver your story, PowerPoint makes it simple. SWAY IN SUMMARY Sway is an online presentation and storytelling app that's free for anyone with a Microsoft or Office 365 account. The newest addition to Microsoft Office, Sway helps

www.office.com/setup Blogs: YES. Microsoft has some FREE help with the NEW Office 365. One of the places that I send people to first is the Ignite Online training center. How to configure federated identity sign-in model for Office 365 OFFICE 365 GUIDES Exploring the Office 365 Administration Center - In this guide, you will become familiar with the Office 365 Administration Center and learn how to perform key administration tasks. Office 365 Overview for IT Administrators - See how the new Office 365 Administration Center provides improved ease-of-management for IT professionals. There is also a great three part series on how to setup Identity Management. 1. Installing and Configuring Active Directory Federation Services - Learn how to prepare for and install AD FS, which is a preliminary step for the Office 365 federation and hybrid scenarios. 2. Configuring Active Directory Federation Services and Verifying Federation - In this guide, you will learn how to add and verify federated domains in Office 365. 3. Installing and Configuring Active Directory Synchronization - Learn how to install and configure Active Directory Synchronization in Office 365, which is a preliminary step for the Office 365 federation and hybrid scenarios.

www.office.com/setup Blogs: With the release of Office 2016, you might wonder how you can get the latest version of Office if you a one-time purchase of Office 2013 or an existing Office 365 subscription. If you're not sure what version of Office you have, see What version of Office am I using? If you want to upgrade to Office 2016 from an Office 365 for business subscription, see How do I get the new Office 2016 apps using Office 365 for business? GET OFFICE 2016 USING AN OFFICE 365 SUBSCRIPTION OR A ONE-TIME PURCHASE OR OLDER VERSION OF OFFICE For Office 365 Home, Personal, or University subscriptions If you want to install the 64-bit version or install Office in another language, follow the step-by-step instructions in Install Office on your PC or Mac. Otherwise, use the steps below to install Office 2016. Go to www.office.com/myaccount. Sign in with your Microsoft account. This is the account you associated with the version of Office you're trying to install. On My Office Account, select Install. The process to uninstall Office 2013 and install Office 2016 can take some time. When the installation completes, you'll see a welcome video that explains how to find your apps and start Office 2016. For a one-time purchase or older version of Office If you installed a one-time purchase of Office 2013, you can't upgrade directly from within the Office 2013 software. You'll need to either purchase one of the Office 2016 suites of products, such as Office Home & Student 2016, or purchase an Office 365 subscription. For more information about the different options available for purchasing Office 2016, see Choose your Office.

www.office.com/setup Blogs: Microsoft Office 2016 for Windows has landed and it brings many smart new features, including co-authoring with real-time collaboration, simplified sharing, a great feature search engine called Tell Me, and much more. The Mac version of Office 2016 has actually been around for a few months already. If you have an Office 365 subscription, you can get it now for free and we show you how below.A Microsoft Office 2016 Preview: Smart & Subtle Changes A Microsoft Office 2016 Preview: Smart & Subtle ChangesOffice 2016 for Mac was just released and the Windows version will follow in the fall. We show you the new look and features of the world's most popular productivity suite. Will you upgrade?READ MORE Alternatively, you can buy it at the Microsoft store (different packages available and Microsoft has a guide for installing it) or your local retailer and if you're unsure, we have a guide for what Office suite to get. Note that if you're running Office 2010 on Windows 10, you can get a 50% discount on a one year subscription of Office 365 Home; simply use the Get Office app in Windows 10. Get Office - www.office.com/setup Before you overspend your budget, remember you can get Microsoft Word for free and you can choose from many free alternatives for the entire Microsoft suite.This Is How You Can Get Microsoft Word for Free This Is How You Can Get Microsoft Word for FreeDo you really want the entire Microsoft Office suite? If all you need is Word without the fancy features, Microsoft will give it to you for free. Here is how.READ MORE FIND OUT YOUR VERSION OF OFFICE Unsure whether you have an Office 365 subscription? You can look up your status. Open a file, any Office document, then navigate to File > Account and under you'll see whether you have an Office 365 subscription. Office 2016 Account - www.office.com/setup Here is a complete list of ways to check your version of Office from Microsoft. YOUR UPGRADE WILL BE FINAL Before you

www.office.com/setup Blogs: Office 2016 for Mac is here, so we bring you everything you need to know about the new version of Office for Mac 2016, including Office 365, UK pricing, new features and more. OFFICE FOR MAC 2016 FIRST LAUNCHED AS PART OF OFFICE 365 IN JULY OF 2015, BUT MAC USERS WANTING TO BUY A COPY OUTRIGHT, RATHER THAN SUBSCRIBE, HAD TO WAIT FOR MICROSOFT TO LAUNCH THE BOXED VERSION. THAT FINALLY HAPPENED IN SEPTEMBER 2015, WHEN THOSE MAC USERS GOT THEIR WISH AND OFFICE 2016 FOR MAC BECAME AVAILABLE FOR £119.99 UPFRONT. HERE, WE TALK YOU THROUGH THE FEATURES IN OFFICE FOR MAC 2016, AND HELP YOU DECIDE WHETHER TO SUBSCRIBE TO OFFICE 365 OR BUY A COPY OUTRIGHT. PLUS, WE SHARE OFFICE FOR MAC 2016 UK PRICING FOR EACH VERSION. A number of new features for the MacBook Pro Touch Bar have been added as of February 2017, these are discussed here. Don't expect Microsoft Office for Mac 2017 anytime soon (or at all, for that matter). There was a five year gap between this current version of Office for Mac and its predecessor, Microsoft Office for Mac 2011. However, those with an Office 365 account will get regular, automatic updates since it is an online subscription. If you buy Office outright as a one-time software download, you won't get these benefits, so something to bear in mind. MICROSOFT OFFICE FOR MAC 2016 UK PRICE: HOW MUCH DOES OFFICE FOR MAC 2016 COST? Office Home & Student 2016 for Mac costs £119.99 ($149.99) and includes Word, Excel, PowerPoint and OneNote. It's available to buy from Microsoft UK here or Microsoft US here. Office Home & Business 2016 for Mac costs £229.99 ($229.99) and includes Outlook as well as Word, Excel, PowerPoint and OneNote. It's available to buy from Microsoft UK here or Microsoft US here. These versions are only available for one Mac. To install on more than one Mac Microsoft appears to be pushing users towards the 365 subscription model. If you buy a copy outright, you will only be able to install the copy on