Group items tagged

With Google Apps and Office 365 revolutionizing the way people work, you may feel that Microsoft Office is quickly becoming a dated product that will soon be packed away to the back of the closet. But with the 2016 version set to launch in autumn of this year, Microsoft is looking to change your mind. Now they're adapting their classic Office package for today's modern workforce. Here are four of the new features that are reinventing the way you look at your Office applications. CLOUD FOCUS FOR OUTLOOK ATTACHMENTS Microsoft knows that sharing attachments amongst co-workers and teams can be a hassle. With many collaborators still sharing documents and files the old fashioned way - attaching it to an email and then sending to others - it's easy for users to get confused and send an incorrect or outdated version. To solve this problem, Microsoft is gently nudging us to use the cloud. Now when you add an attachment to an email, you're now asked if you'd also like to share a link to a file on your OneDrive, OneDrive for Business or SharePoint account. SHOWCASING EASY WAYS TO USE OFFICE BETTER If you're like most people, you probably aren't using Office to its full potential. And who can blame you? Between Word, Excel, PowerPoint and more, there are literally hundreds of features and tools you can use - if only you had the time to discover them all. To help you get the most out of Office, Microsoft has now added a Tell Me box in the top center of your program title bar. This tool gives you an easy way to get questions answered. For example, if you want to project your desktop screen to a second monitor or create a graph in Excel, simply type your question into the Tell Me box and Microsoft will find the answers that most closely fit your search criteria. SWAY Look out PowerPoint, here comes Sway - the new, hipper Office application that makes creating fluid, stylish presentations easy. With Sway, you can now gather content from various source

Sometimes there is frantic need to create links in database table to web pages, files, folders, images, etc. Access 2010 provides a convenient way to link up data field values with anything to complement the database in much better way. In this post we will guide you on creating a table field having Hyperlink data type. To start off with, launch Access 2010 and navigate to Create tab and click Table. createtable1 Create Hyperlink Field In Access 2010 - www.office.com/setup It will create a new table namely Table1. Right-click newly created table and select Design View to add fields with specific Data types. table11 Create Hyperlink Field In Access 2010 - www.office.com/setup Enter an appropriate table name and start adding fields. We will be entering some generic table fields with their data types such as, ID, Name, Phone Number, Email and other Links. design view - www.office.com/setup Select Email table field and under data type options, select Hyperlink. select hyperlink - www.office.com/setup Repeat the procedure for assigning Hyperlink data field for other fields as well. hyperlink other - www.office.com/setup Now close the Design view and save the changes made. Open the database table in Datasheet view. Start filling out table fields with values. In Hyperlink assigned data fields, you will notice that on entering values it will automatically turns them into blue, indicating linked data. hyerplinks created - www.office.com/setup Now we will move to editing Hyperlinks. In Email field, highlight the email address and right-click to select Edit Hyperlink. edit hyperlink - www.office.com/setup It will instantly open Edit Hyperlink dialog. Under E-mail address box, enter the email address, and from Subject box, write the subject of the mail. Click OK. edit hyperlink 1] - www.office.com/setup Upon clicking on hyperlink, it will immediately open Outlook mail compose window, with specified email address and subject inserted. email open - www.office.co

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

Are you using the new Project and wishing you could enhance its powerful capabilities with apps? Project 2013 has great extensibility potential-even across devices. The new apps for Project enhance capabilities of Microsoft Project 2013 applications, including Project Pro for Office 365, Project Professional 2013, Project Online and Project Server 2013. www.office.com/setup HOW DO I ADD AN APP TO PROJECT PRO FOR OFFICE 365 OR PROJECT PROFESSIONAL 2013? Open Project. On the Ribbon, click PROJECT, then click Apps for Office. www.office.com/setup All apps for Project associated with your account will show up. If you need to acquire new Apps from the Microsoft Office Store, click the Find more apps in the Office Store link and follow the instructions on the screen. www.office.com/setup START USING YOUR APPS The example below shows a project plan that has been synchronized to a project site in SharePoint or SharePoint Online and the highlighted app on the right SharkPro Insite shows data from your project site next to your document. www.office.com/setup Here are apps you can acquire for Project Pro for Office 365 or Project Professional 2013: Sensei Task Analyzer SharkPro SharePoint Insite™ for Project Visit the Office Store for more apps HOW DO I ADD AN APP TO PROJECT ONLINE OR PROJECT SERVER 2013? Choose the site where you want to add the app. On the Gear menu, select Add an app. www.office.com/setup The apps you see will depend on your corporate environment and on whether you have already acquired apps from the Office Store. If you don't see the apps you want in the list, you can add them. On the left side of the screen, click the SharePoint Store link to browse all available apps. Follow the on-screen instructions to add the apps you want. www.office.com/setup Once the app is added to your site, launch the app by clicking on its name in the left hand navigation or see all apps that are ready to use on your site through the Site co

WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION www.office.com/setup Blogs: Once your slide show is complete, you'll need to learn how to present it to an audience. PowerPoint offers several tools and features to help make your presentation smooth, engaging, and professional. Optional: Download our practice presentation. Watch the video below to learn more about presenting your slide show. PRESENTING A SLIDE SHOW Before you present your slide show, you'll need to think about the type of equipment that will be available for your presentation. Many presenters use projectors during presentations, so you might want to consider using one as well. This allows you to control and preview slides on one monitor while presenting them to an audience on another screen. TO START A SLIDE SHOW: There are several ways you can begin your presentation: Click the Start From Beginning command on the Quick Access Toolbar, or press the F5 key at the top of your keyboard. The presentation will appear in full-screen mode. clicking the Start From Beginning command on the Quick Access Toolbar - www.office.com/setup Select the Slide Show view command at the bottom of the PowerPoint window to begin a presentation from the current slide. Switching to Slide Show view from the Status bar in the lower-right corner - www.office.com/setup Go to the Slide Show tab on the Ribbon to access even more options. From here, you can start the presentation from the current slide and access advanced presentation options. starting a presentation from the Slide Show tab - www.office.com/setup TO ADVANCE AND REVERSE SLIDES: You can advance to the next slide by clicking your mouse or pressing the spacebar on your keyboard. Alternatively, you can use or arrow keys on your keyboard to move forward or backward through the presentation. You can also hover your mouse over the bottom-left and click the arrows to move forward or backward. hovering the mouse to access navigation buttons in Slide Show view - www.office

www.office.com Blogs: Microsoft Office is an integrated suite of business software applications for Windows and Macintosh computers. Office includes word processing, spreadsheet, presentation graphics and email communication programs that provide functionality which is commonly used to run a business office. Office 2010 for Microsoft Windows and Office 2008 for the Macintosh computer are the versions available as of July 2010. ... - www.office.com/setup Blogs Microsoft Office is a suite of software. WORD PROCESSING Microsoft Office includes Microsoft Word for word processing functionality. The program uses a menu interface to provide many advanced word processing features that can be used easily by business and home users. Word includes templates to design documents used routinely in office environments such as sales letters, mailing label formats and invoices. Word documents can contain graphics, sound and video to create multimedia reports. SPREADSHEETS Microsoft Office includes Microsoft Excel to create spreadsheet solutions for home and business use. A spreadsheet is an electronic grid of rows and columns that can be used to enter, organize and calculate data. Separate spreadsheets can be linked to consolidate data across categories such as time, function, or geographic region. Templates for income statements, balance sheets and expense reports are featured within the program. Excel spreadsheets allow you to analyze and report on large amounts of data quickly and easily. PRESENTATION GRAPHICS The Microsoft Powerpoint application is used to create and deliver presentations that can include text, graphics, sound and video. Powerpoint presentations can be delivered in a slide show format using a computer and projection screen, emailed to other users for review or delivered remotely over the Internet. EMAIL COMMUNICATIONS Microsoft Outlook Express is used to create, send and receive e-mail communications. The program automates the linking and embedding of sp

www.office.com/setup Blogs: Office 2016 isn't just about new Microsoft Word and PowerPoint layouts. The new productivity suite has a ton of amazing new tricks and features that are designed to make your work (and play) a lot easier. If you still think of Office as something you tinkered with to write terms papers back on Windows 95, well you're in for a treat. Download the new Office 2016 and you'll get access to tools that automatically separate important and unimportant emails, connect to your social media accounts to help you plan your weekend, and help you plan group trips and activities. For the business user, there are a ton of new Office features that help you better communicate, collaborate and create. I'll walk you through some of these new features and how you can use them to improve your Office 2016 experience. 1. CLUTTER Our SPAM folders are amazing. They collect emails from retailers and businesses with whom we don't want to have any contact whatsoever. But what about that uncle you just can't stand? Or that annoying coworker who constantly asks you to go to lunch? With Clutter for Outlook, your email usage signals whether or not emails should actually enter your inbox. For example: if you never, ever open your uncle's emails, Clutter will automatically send those incoming messages to a folder where they will land alongside your annoying coworker's lunch requests. You can access this folder anytime and move messages back to the normal old inbox. If you're worried you'll miss something important, don't fret. Clutter sends you a weekly digest that tells you exactly what was hidden. You can then command Clutter to never pull in that type of content again. 2. SKYPE INTEGRATION Office 2016 - www.office.com/setup Office 2016 Microsoft has made cloud document collaboration possible (years and years after Google, but I digress). Now, you and a friend can edit a Microsoft Word document simultaneously without having to save and share the document via emai

www.office.com/setup Blogs: In today's post we take a look at the key admin setup steps of a Office 365 license. If you'd like the complete guide to Office 365 setup, you can download it here. This guide will walk you through the necessary steps to establish your Office 365 account, add your end users, and jumpstart collaboration. In today's post, we'll be discussing the setup process for you and your employee's Office 365 accounts from start to finish. What to Expect During The Setup Process Office 365 The process begins with the purchase of Office 365 licenses for all of your employees. There are different plans available, with options that include the full Microsoft Office downloadable suite of tools, and those that only provide the online, or web-based versions of the Office suite. There are plans available for an individual, small business, and for the enterprise. Each license type includes options for online and offline apps, email, and productivity solutions. Purchasing a New Office 365 Plan Once your plan is selected, you as the Administrator will walk through the purchasing process, allowing you to associate your new plan with any existing subscriptions, as well as associate your account to your personal Microsoft ID. If you've ever attended a Microsoft event or webinar, or purchased software from the Microsoft store, you probably already have a personal Microsoft ID. You can connect this to your new Office 365 account, or create a new Microsoft ID. The signup process has four simple steps: Provide your contact details Create a new ID (or associate your account with an existing ID) Review your order Place your order Once purchased, you will receive a welcome letter as the new Office 365 Administrator with details on signing onto the platform and getting started. If the license was purchased on your behalf, your profile will be added to the company account, and you will likewise receive a welcome email with your User ID and a temporary passw

www.office.com/setup Blogs: In today's post we take a look at the key admin setup steps of a Office 365 license. If you'd like the complete guide to Office 365 setup, you can download it here. This guide will walk you through the necessary steps to establish your Office 365 account, add your end users, and jumpstart collaboration. In today's post, we'll be discussing the setup process for you and your employee's Office 365 accounts from start to finish. What to Expect During The Setup Process Office 365 The process begins with the purchase of Office 365 licenses for all of your employees. There are different plans available, with options that include the full Microsoft Office downloadable suite of tools, and those that only provide the online, or web-based versions of the Office suite. There are plans available for an individual, small business, and for the enterprise. Each license type includes options for online and offline apps, email, and productivity solutions. Purchasing a New Office 365 Plan Once your plan is selected, you as the Administrator will walk through the purchasing process, allowing you to associate your new plan with any existing subscriptions, as well as associate your account to your personal Microsoft ID. If you've ever attended a Microsoft event or webinar, or purchased software from the Microsoft store, you probably already have a personal Microsoft ID. You can connect this to your new Office 365 account, or create a new Microsoft ID. The signup process has four simple steps: Provide your contact details Create a new ID (or associate your account with an existing ID) Review your order Place your order Once purchased, you will receive a welcome letter as the new Office 365 Administrator with details on signing onto the platform and getting started. If the license was purchased on your behalf, your profile will be added to the company account, and you will likewise receive a welcome email with your User ID and a temporary passw

www.office.com/setup Blogs: Today marks general availability of Microsoft Flow and PowerApps, which enable people to automate workflows and quickly build custom apps that suit their specific needs. Earlier this year, we announced integration of SharePoint with Microsoft Flow, enabling you to create and launch flows directly from a SharePoint list. We also announced that native integration of PowerApps and SharePoint would drive rich new experiences to continue reinventing business processes with modern document libraries and modern lists in SharePoint. We know that tight integration is essential to unlocking productivity gains for the digital workplace. Accessing data from mobile devices was a first step. Bringing business processes to the same site for team documents and data is next. That's why SharePoint is a great home for your enterprise business applications. As we recognize today's milestones for PowerApps and Microsoft Flow, you can also look ahead to even deeper integration of these business tools as part of SharePoint, as we showcased at Ignite in September. UPCOMING INTEGRATION WITH SHAREPOINT PowerApps will be fully integrated into the SharePoint web experience. PowerApps provides a great mobile experience, and now that experience is connected to the data stored in SharePoint lists. Soon you'll be able to integrate PowerApps as the default in-browser experience for any SharePoint modern list. sharepoint-welcomes-powerapps-and-microsoft-flow-1 - www.office.com/setup PowerApps embedded in a SharePoint list. This means: You'll be able to launch PowerApps directly from the SharePoint mobile app. Modern document libraries will be made available as a data source for PowerApps and Microsoft Flow. For Microsoft Flow, you'll be able to run any flow on demand for a specific document or list item, in addition to waiting for an automated trigger to fire. Using the data gateway, PowerApps and Microsoft Flow will work with on-premises data in SQL and

www.office.com/setup Blogs: Last year, we released Microsoft Bookings to customers in the U.S. and Canada, introducing an easy way for small businesses to schedule and manage appointments with their customers. Today, we are pleased to announce that we're beginning to roll out the service to Office 365 Business Premium subscribers worldwide. Based on your feedback, we are bringing several new features to Bookings: Add your Office 365 calendar to Bookings-Connect your Office 365 calendar to Bookings, so that the times you are busy will automatically be blocked in your public Booking page. Add buffer time before and after your appointments-Do you need prep time before or after an appointment? Adding buffer time to a service automatically blocks that time in your Booking page too. Bookings apps for your iOS and Android phone-Now you can book an appointment, contact a customer or check a staff member's appointments while away from the office. Customize your Booking page-We added more color customization options, so you can better personalize your Booking page. These new capabilities will start showing up automatically in Bookings in the coming weeks. Let's take a detailed look at what's new. ADD YOUR OFFICE 365 CALENDAR TO BOOKINGS One of the top pieces of feedback we've heard is that you want to be able to add events from your Office 365 calendar to Bookings. So, we added integration between these calendars to help you avoid booking customer meetings during the time you've set aside for personal appointments, staff and partner meetings or other aspects of running your business. To add Office 365 calendars to Bookings, click the Staff tab on the left navigation panel. On the Staff details page, select the Events on Office 365 calendar affect availability checkbox. www.office.com/setup Add Office 365 calendar events to Bookings. Once you activate this option, the system automatically blocks busy times on the Bookings calendar and on the self-ser

www.office.com/setup Blogs: Microsoft announced two new tools, Researcher and Editor, for Word 2016 today that introduce better research integration and writing assistance. Word 2016 is the newest version of the popular word editing software that is available to Office 365 users and customers who purchased a standalone copy of Office 2016. The update is available today to all Office 365 subscribers who are using Word 2016 on the Windows desktop according to Microsoft. The easiest way to find out whether you have it or not is to open Word 2016 on the Windows desktop and check whether the new "Researcher" option is available under References when you edit a document. RESEARCHER word 2016 researcher - www.office.com/setup Researcher is a new tool that you may use to find references directly from within Word 2016. The feature uses Bing's Knowledge Graph for that and displays data in a sidebar in the Word 2016 when enabled. You find the new option under References > Researcher. Researcher is a new service in Word that helps you find and incorporate reliable sources and content for your paper in fewer steps. Right within your Word document you can explore material related to your topic and add it-and its properly-formatted citation-in one click. Researcher uses the Bing Knowledge Graph to pull in the appropriate content from the web and provide structured, safe and credible information. You may use the new tool to add quotes and "properly formatted citation" to documents. While this may not be suitable for science-grade documents, it may do for many other types of documents. EDITOR word 2016 editor - www.office.com/setup Editor is touted as a new digital writing assistant that assists you with proofing and editing services. The initial release flags unclear phrases, redundancy or complex words, and makes recommendations by displaying alternatives to you. The service uses machine learning and natural language processing for that, and will improve over time

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.

These days it's all about Sway - the first of many native apps to be rolled out to Microsoft Office 365 subscribers. To put it simply, Sway is a web browser-based storytelling app. It allows anyone with the most basic computing knowledge to create beautiful-looking websites and presentations with images, text, tweets, videos or whatever other media you want to include. It works a bit like Word and Powerpoint combined - and finished products can be used on websites to display family photos, or in a beautiful work presentation.

Windows 10 has grabbed the attention of social media and customers alike more so because it is a crucial operating system for Microsoft after the debacle of Windows 8 and a not so great reception for Windows 8.1. But, Microsoft has another major product on their cards now, Office, which enhances the Windows productivity of five major products into a system of applications. With Office 2016, Microsoft plans to build from scratch, a mobile and cloud first approach which is customer centric and doesn't only focus on web compared to Office 365 and 2013. Office 2016 has recently been launched on September 22, 2015. www.office.com/setup The Cost factor The first and the most important thing we look at during major software products and updates is the price tag that comes along with it as there are so multiple updates for major software and it is not feasible to go through each and every revision. The all new Office 2016 suite is free for customers on mobile and tablets (conditions apply) and pretty cheap at $145 for "Office Home & Student 2016" and the RRP version of the same is priced at $165, along with subscription version of the suite (Office 365 Personal) at about $70 per year.

www.office.com/setup Blogs: Once your slide show is complete, you'll need to learn how to present it to an audience. PowerPoint offers several tools and features to help make your presentation smooth, engaging, and professional. Optional: Download our practice presentation. Watch the video below to learn more about presenting your slide show. PRESENTING A SLIDE SHOW Before you present your slide show, you'll need to think about the type of equipment that will be available for your presentation. Many presenters use projectors during presentations, so you might want to consider using one as well. This allows you to control and preview slides on one monitor while presenting them to an audience on another screen. TO START A SLIDE SHOW: There are several ways you can begin your presentation: Click the Start From Beginning command on the Quick Access Toolbar, or press the F5 key at the top of your keyboard. The presentation will appear in full-screen mode. clicking the Start From Beginning command on the Quick Access Toolbar - www.office.com/setup Select the Slide Show view command at the bottom of the PowerPoint window to begin a presentation from the current slide. Switching to Slide Show view from the Status bar in the lower-right corner - www.office.com/setup Go to the Slide Show tab on the Ribbon to access even more options. From here, you can start the presentation from the current slide and access advanced presentation options. starting a presentation from the Slide Show tab - www.office.com/setup TO ADVANCE AND REVERSE SLIDES: You can advance to the next slide by clicking your mouse or pressing the spacebar on your keyboard. Alternatively, you can use or arrow keys on your keyboard to move forward or backward through the presentation. You can also hover your mouse over the bottom-left and click the arrows to move forward or backward. hovering the mouse to access navigation buttons in Slide Show view - www.office.com/setup TO STOP A SLIDE SHOW: You can

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."

Microsoft Forms is a new part of Office 365 Education that allows teachers and students to quickly and easily create custom quizzes, surveys, questionnaires, registrations and more. When you create a quiz or form, you can invite others to respond to it using any web browser, even on mobile devices. As results are submitted, you can use built-in analytics to evaluate responses. Form data, such as quiz results, can be easily exported to Excel for additional analysis or grading.

We're all creators-each in our own way. I'm part of an organization that advocates for those who are creatively talented or gifted: artists, creators, and entrepreneurs. But I've found that we all bring creativity to our jobs in some form or another. I know that I can approach problems in a more creative way and find innovative solutions when I have the right tools and information within easy reach. At Copyright Alliance, we're a small team that serves more than 40 institutional members and thousands of artists around the country. For each of us, the ability to find and share files while on the go is a huge priority, especially because we tend to fill in for each other on different projects at a moment's notice. Balancing tasks like writing opinion pieces for news publications, giving talks at conferences, and meeting with members-all in the same day-is the norm. In the past, technology issues sometimes sapped my creative energy, making it difficult to stay focused on the task in front of me. Instead, I would have to scramble to find a document or a presentation that I needed. We had a file server at the office and I would routinely download all the documents I thought I would need before dashing off to the next engagement. This not only took extra time out of my day, it also wasn't a foolproof system. There were times when I just couldn't access the information I needed while out in the field. With Microsoft Office 365, all that has changed. Now that we have an online suite of tools for creating documents and managing them in a systematic way, we can all work together more fluidly. The menus and navigation in Microsoft SharePoint Online are simple to use, and it's reassuring to see exactly when a document was last updated. We're looking forward to using more of the tools in Office 365, including Microsoft Lync Online to make calls and hold meetings-all in a couple of clicks. I hardly think about the technology we use anymore. The transition to