Group items tagged

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

ACCESS 2016: DESIGNING A SIMPLE QUERY MARCH 27, 2017 TRAINING / WWW.OFFICE.COM/SETUP ADMIN LEAVE A COMMENT WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION www.office.com/setup Blogs: The real power of a relational database lies in its ability to quickly retrieve and analyze your data by running a query. Queries allow you to pull information from one or more tables based on a set of search conditions you define. In this lesson, you will learn how to create a simple one-table query. Throughout this tutorial, we will be using a sample database. If you would like to follow along, you'll need to download our Access 2016 sample database. You will need to have Access 2016 installed on your computer in order to open the example. Watch the video below to learn more about designing a simple query in Access. WHAT ARE QUERIES? Queries are a way of searching for and compiling data from one or more tables. Running a query is like asking a detailed question of your database. When you build a query in Access, you are defining specific search conditions to find exactly the data you want. HOW ARE QUERIES USED? Queries are far more powerful than the simple searches or filters you might use to find data within a table. This is because queries can draw their information from multiple tables. For example, while you could use a search in the customers table to find the name of one customer at your business or a filter on the orders table to view only orders placed within the past week, neither would let you view both customers and orders at once. However, you could easily run a query to find the name and phone number of every customer who's made a purchase within the past week. A well-designed query can give information you might not be able to find out just by examining the data in your tables. When you run a query, the results are presented to you in a table, but when you design one you use a different view. This is called Query Design view, and it lets you see how your query is put

www.office.com/setup Blogs: I've been installing Office 2013 on a lot of computers lately and I've ran into quite a few problems along the way. From annoying messages like "Sorry we ran into a problem" and "Something went wrong" to slow downloads, hanging at certain percentages during the install, it's been typical Microsoft problems all along the way. If you've been trying to install Office 2013 on Windows 8 or Windows 7 and you're running into issues, I'm going to try and give you as many possible solutions as I could find. If you run into a different issue not mentioned here, feel free to post a comment and let us know. It's also worth noting that you can't install Office 2013 on Windows Vista or Windows XP, it's just not possible. You'll get an error message like: This is not a valid Win32 application or We are sorry, you couldn't install your Office product because you don't have a modern Windows operating system. You need Microsoft windows 7 (or newer) to install this product or The procedure entry point K32GetProcessImageFileNameW could not be located in the dynamic link library KERNERL32.dll Now let's talk about some of the problems that can occur when installing Office 2013 on Windows 7 and Windows 8. FIX "SOMETHING WENT WRONG" OFFICE 2013 You might get this error if a first installation stalled and you ended up starting a second installation over the first one. You might also get this error if the computer restarted for some reason before the installation was finished. In this case, you should go to the Control Panel, click on Microsoft Office 2013 or Microsoft Office 365 and click on Change. Office 2013 change - www.office.com/setup Blogs Depending on your version of Office installed, you should either see an option called Repair or Online Repair. If you have Office 365, you'll see Online Repair and then the Repair option. Office 2013 repair - www.office.com/setup Blogs If, for some reason, this fails or

www.office.com/setup Blogs: Missing a key security signal could mean not catching a breach, but the number of security signals is increasing exponentially. It's becoming impossible to manually prioritize them. That's why Office 365 applies intelligence to help you proactively manage risk and ward off threats. Today, we're pleased to introduce several new capabilities in Office 365 that help you manage risk and stay ahead of threats: Office 365 Secure Score-A new security analytics tool that applies a score to Office 365 customers' current Office 365 security configuration. Office 365 Threat Intelligence Private Preview-Service that leverages billions of data points from the Microsoft Intelligent Security Graph to provide actionable insights to the global threat landscape and help customers stay ahead of cyber threats. Office 365 Threat Intelligence is now in private preview, with general availability planned for later this quarter. Office 365 Advanced Data Governance Preview-Applies machine learning to help customers find and retain the most important data to them while eliminating redundant, obsolete and trivial data that could cause risk if compromised. Office 365 Advanced Data Governance is now in preview, with general availability planned for later this quarter. KNOW YOUR OFFICE 365 SECURE SCORE Do you know how you'd be rated if someone were to evaluate your security configuration? To give you better visibility into your Office 365 security configuration and the security features available to you, we're pleased to introduce Secure Score-a new security analytics tool. Secure Score helps you understand your current Office 365 security configuration and shows you how implementing additional controls can further enhance your security and reduce risk.* Here's how it works: Secure Score Summary-Displays your Secure Score and provides access to view your Score Analyzer. Your Secure Score, the numerator, is the sum of the points associated wi

WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION www.office.com/setup Blogs: Access offers several advanced options for creating and modifying reports. The Report Wizard is a tool that guides you through the process of creating complex reports. Once you've created a report-whether through the Report Wizard or the Report command-you can then format it to make it look exactly how you want. In this lesson, you'll learn how to use the Report Wizard to create complex reports. You'll also learn how to use formatting options to format text, change report colors and fonts, and add a logo. Throughout this tutorial, we will be using a sample database. If you would like to follow along, you'll need to download our Access 2016 sample database. You will need to have Access 2016 installed on your computer in order to open the example. Watch the video below to learn more about the Report Wizard in Access. THE REPORT WIZARD While using the Report command is a quick way to create reports from the current object, it's not as helpful if you want to create a report with data from multiple objects. The Report Wizard makes it easy to create reports using fields from multiple tables and queries. It even lets you choose how your data will be organized. TO CREATE A REPORT WITH THE REPORT WIZARD: Select the Create tab and locate the Reports group. Click the Report Wizard command. Clicking the Report Wizard command - www.office.com/setup Blogs The Report Wizard will appear. In the procedures below, we'll discuss the different pages in the Report Wizard. The Report Wizard dialog box - www.office.com/setup Blogs STEP 1: SELECT THE FIELDS TO INCLUDE IN YOUR REPORT Click the drop-down arrow to select the table or query that contains the desired field(s). Selecting a table that contains fields to include in the report - www.office.com/setup Blogs Select a field from the list on the left, and click the right arrow to add it to the report. Adding fields to a report - www.office.com/setup Blogs

WWW.OFFICE.COM/SETUP BLOGS: FROM USING ONENOTE FOR PROJECT MANAGEMENT TO DISCOVERING HIDDEN FEATURES IN WORD, THERE ARE TONS OF WAYS YOU CAN GET MORE OUT OF OFFICE 365. HERE'S A LOOK BACK AT THIS YEAR'S MOST POPULAR TIPS. @MENTIONS IN OUTLOOK www.office.com/setup Blogs: This is an excerpt from our post Get Someone's Attention in Outlook with @Mentions. Using the @ symbol is a quick way to draw people's attention to important things. Microsoft has rolled this handy feature into Outlook, so here's how you can use it to get people's attention in emails and also save time. (Note: This feature is only available in Outlook 2016, Outlook 2016 for Mac, Outlook on the web for Office 365 Business, Outlook.com, and Outlook on the web for Exchange Server 2016.) ONENOTE FOR PROJECT MANAGEMENT This is an excerpt from our post 5 Keys to Using OneNote for Project Management. Instead of investing in costly project management software, how about using a free program like Microsoft OneNote? OneNote digital notebooks are available on all your devices and can be used for a variety of projects. Whether you are planning a wedding, heading up an office presentation, or writing a thesis paper, OneNote bends to your needs. This post focuses on tips for the office, but personal and school projects can be managed with OneNote using many of these same key principles. HIDDEN FEATURES IN WORD This is an excerpt from our post 3 Hidden & Useful Tricks in Microsoft Word. There are lots of great hidden features tucked away in Microsoft Word that you probably don't know about. From activating research tools, to changing the page color of documents to reduce eye strain, to easily capturing screenshots, here are three tricks that you will enjoy. WORD ONLINE VS. WORD DESKTOP This is an excerpt from our post 3 Things You Can Do With Word Online That You Can't Do With Word Desktop. Word Online isn't just a simple online word processor. To get the full value of the product

www.office.com/setup Blogs: Having come around to the idea that it needed different versions of Office for different kind of users, Microsoft introduced lightweight versions of Word, Excel, Power Point and OneNote that are neither as pricey or as feature laden as the main versions included in Office. iPad users were the first to get their hands on this new take on Office. With Windows 10, the free Microsoft Office Mobile apps have arrived for some Windows users. 10 Things to Love About Windows 10 (7) - www.office.com/setup Blogs Read: Windows 10 Review - A Love Affair Here's how to get that free Microsoft Office in Windows 10, and what you need to know about it why it's possible for some to take advantage and not possible for others. HOW TO GET FREE MICROSOFT OFFICE IN WINDOWS 10: WHAT IS IT? Microsoft Office is wildly successful. Everyday millions of users all open it to get work done. Millions of documents are written in Microsoft Word. Millions of budgets and sales breakdowns are created in Microsoft Excel. Everyone has created a Microsoft PowerPoint presentation at some point in their life. Screenshot (236) - www.office.com/setup Blogs Windows and Microsoft Office are synonymous. Because the two are often used together and both made by Microsoft, many assume that one comes included with the other. That's never been true. Windows device makers often included shortcuts to trials for Microsoft Office with new PCs. Some even bundled it with their PCs, passing the cost on to buyers. Microsoft Office costs $149 if purchased outright or $6.99 a month through Microsoft's Office 365 subscription service. Office Mobile is what Microsoft collectively calls the free Microsoft Office apps that are now available. Word Mobile lets Windows 10 users view documents. Excel Mobile focuses on spreadsheets. PowerPoint Mobile lets users look at presentations. Outlook is separated into to apps, Outlook Calendar and Outlook Mail. Outlook Mail and Outlook Calendar are a

WWW.OFFICE.COM/SETUP BLOGS: OFFICE 2016 OFFERS MANY ENHANCEMENTS THAT INTEGRATE MORE TIGHTLY WITH SHAREPOINT AND ONEDRIVE. IT CAN BE CONFUSING TO KEEP TRACK OF ALL THE FEATURES, SO WE PICK 10 YOU ARE SURE TO LOVE. Collaboration is the key to Microsoft's still-ubiquitous productivity suite. To the casual user, the applications that make upOffice 2016 - Word, Excel, PowerPoint and Outlook are the anchor tenants, of course, rounded out by OneNote, Access and Publisher - will be indistinguishable from their predecessors. But make no mistake about it; Microsoft's reboot of its flagship software suite is a major update, offering a wealth of collaboration capabilities that integrate more tightly with SharePoint and OneDrive than before. The many tweaks and enhancements across the board can be confusing though, and we peek under the hood to highlight the features that matter most. 1. REAL-TIME CO-AUTHORING The capability to work on the same document simultaneously with your colleagues comes to the desktop version of the productivity suite in Office 2016. Colleagues can work on the same Word documents and PowerPoint presentations that are saved on SharePoint or OneDrive without overwriting each other's changes. Note that the "real-time typing" feature in which you can see your colleagues working on the same document is only available in Word for now. PowerPoint supports co-authoring, but without real-time typing. 2. SIMPLIFIED DOCUMENT SHARING You can now easily share your documents in Office 2016, courtesy of a prominent "Share" button in the Ribbon. Available across Word, Excel and PowerPoint, the Share button lets you share access to a document to your team members, and serves as a one-stop location to review access permissions or see who is currently working on the document. As with co-authoring, the files must be saved in either SharePoint or OneDrive in order to be shared. 3. CAPABILITY TO SEND LARGE FILES USING ONEDRIVE While the ability to sha

www.office.com/setup Blogs: Microsoft Office files are still very common, but if you're more of a Google Docs, Sheets, and Slides user, you can still edit Word, Excel, and PowerPoint files in Google Drive-if you know how. On the desktop, you'll need to use the Google Chrome browser and an official Chrome extension to edit Microsoft Office documents, using Google Drive's Office Compatibility Mode (OCM). You can edit them like that, or convert them to Google Docs format, which will provide more features. (Don't worry-even if you convert them to Google Docs format, you can re-download them in Microsoft Office format later). You can also edit Microsoft Office files using the Google Drive app and the Google Docs, Google Sheets, and Google Slides apps on iOS or Android. We'll show you both methods in the guide below. HOW TO WORK WITH MICROSOFT OFFICE FILES ON GOOGLE DRIVE ON A PC OR MAC Let's start with the desktop. If the Office file you want to edit and share is still on your PC's hard drive, you can easily upload it to Google Drive and open it for editing in Chrome using a Chrome extension. Open Chrome, go to the Office Editing for Docs, Sheets & Slides extension page, click "Add to Chrome", and follow the on-screen instructions to install it. 01_adding_extension_to_chrome - www.office.com/setup Blogs Once the extension is installed, drag the Office file onto the Chrome window until you see a copy icon as shown below. For my example throughout this article, I'm going to use a Word/Google Docs file, but the procedure is the same for Excel/Google Sheets files and PowerPoint/Google Slides files. 04_dragging_word_file_onto_chrome - www.office.com/setup The first time you drag an Office file onto the Chrome window, the following dialog box displays. Click "Got it" to close the window. You won't see this dialog box again. 05_office_editing_popup - www.office.com/setup Blogs The Office file is uploaded to your Google Drive account and

CONTACT GMAIL SUPPORT HELP CONTACT PHONE NUMBER UK 0800-014-8929 Gmail is well known for the mailing service it offers and there is no requirement of introducing it. As it is a part of Google this mail service has always offered the safest and quality mailing service to its user and that supported in developing its image in the minds of the users base. The number of services and all the new features this mailing service have done really well on the user front. Gmail offers multiple services for all its users that include the Gmail mailing services and many more characteristics in it. All the services are obtainable for the users who own Gmail account. Once you begin using Gmail account you can use all the characteristics that this mailing service offers. Gmail keeps on updating its user policies and services in order to enhance the user experience. This emailing service also offers you with the best quality printing service along with some technical problems in it. When you face some technical glitches in Gmail, you required to get connected with the Gmail Support technicians on our Gmail Phone Number of Snavs UK and you will get your problems fixed instantly. If you are Gmail (or) Google Mail user and you are facing problems related to your Gmail account then you need to Contact Gmail technicians immediately. The support technicians of our Gmail UK help desk are always there to help you with the solution that is required for your concern tech problem. You can call the support technicians at Gmail Contact Number 0800-014-8929 any time you require and they are 24x7 available to help you with the solution regarding your concern tech problems. Call Gmail Customer Service of Snavs UK any time you need help and you will get the support technicians ready to support you with this task. If any technical glitches or fluctuation arise related to Gmail account then you can reach us on our Gmail Help desk at Gmail Contact Helpline (UK) Toll-free Number 0800-014-8929. Our tec

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

Part of the thrill of working for the Office Division is the opportunity to tackle thorny business issues on behalf of our customers while providing them with a road map for the future. That may be why an interesting article caught my attention this week. In it, the author examined some of the investments Microsoft is making in the unified communications space. While I didn't agree with all of the conclusions it contained, the article certainly underscored the interest in communications and collaboration and how to make people more productive. Communicating and collaborating with others is really at the heart of what we do every day. Whether at work or at home, people have the need to make meaningful connections with one another. Compounding that need are the realities of the world we live in where instant access to information is expected, friends and coworkers are scattered across geographies and many adults are juggling multiple mobile devices. At Microsoft, we believe technology isn't the problem to these complexities, it's the answer. We're committed to providing capabilities that help people make sense of it all and to do so in a way that is intuitive, barrier free and agnostic to the devices on which we rely. We're incredibly proud of the fact that our long term-term vision for communications and collaboration not only marries the best of the cloud and the desktop, it's a holistic approach that spans "from the living room to the boardroom" placing people at the center of everything we do. Our communication and collaboration vision comes to life utilizing client and cloud assets, including Lync, Skype, Yammer, Outlook and SharePoint. These tools are enabling enterprise social capabilities, HD video conferencing and document collaboration as part of a highly secured, reliable and extensible platform. At the risk of looking geeky, I have to admit that I have a soft spot for Lync and it's comforting to know I'm not alone. More than 90% of

A teacher would never be satisfied with her performance if she discovered that the entire back row of her classroom was unable to hear her lecture. In the world of cloud services for business, we see things the same way. With Office 365, every user counts! Google has a different approach. It starts counting downtime only after at least 5 percent of users are affected. Imagine if 100 of your 2,000 users had no access to email. Would you, as an IT professional, be satisfied with your performance? Would your business hold you accountable for your performance? The answers to these questions are clear. Calculating downtime only after 5 percent of your users cannot access email, as Google does, makes it more difficult for you to assess impact to user productivity. Google's approach doesn't help your business with meaningful performance metrics. With Office 365, every affected customer and every service counts when we calculate downtime. Downtime means the total minutes in a month during which service is unavailable, excluding scheduled downtime. For services like email, there is no scheduled downtime, an experience that our many Exchange Server customers have long been accustomed to-system maintenance while they continue to be productive in their Outlook inboxes. In addition to the way it calculates downtime, Google also combines consumer and commercial service availability when reporting the availability of Gmail. This means if you are considering Google Apps for Business, you cannot get accurate information regarding the availability of the commercial service that you need. On the other hand, Microsoft's approach to calculating downtime, which includes every user minute, helps you understand whether your users' productivity is being impacted by downtime of email. Google takes a "use at your risk" approach around Google+, Hangout and Google Voice. These services are not part of Google Apps for Business and are excluded from the SLA. Excluding these serv

www.office.com/setup Blogs: Today, we are pleased to announce the availability of Microsoft Forms for our Office 365 Education customers. Forms is the result of direct feedback from educators that they want to have a quizzing function with Office 365 Education. Educators told us they need an easy way to assess student progress on an ongoing basis. They also told us they want an assessment solution that will save them time, help differentiate instruction for all students and provide quiz takers with real-time personalized feedback. We designed Forms to be super easy so that anyone could confidently create a form and easily see results as they come in. Forms lets anyone with an Office 365 Education account create and/or respond to quizzes. What makes Forms unique and so valuable for educators is the automatic grading and in-quiz feedback functionality. Automatic grading does exactly what the name implies and greatly reduces the time spent grading. In-quiz feedback is a feature that lets quiz authors personalize messages depending how a student answers a question. For example, if a student answers a question incorrectly they may get a message, such as: "The answer is incorrect. I suggest you review chapter four as this will be on the final." HOW FORMS WORKS When an instructor wants to assess how well the students understand a given topic, they can quickly author a quiz directly from their desktop or mobile web browser. The instructor simply determines the questions they would like to ask and then chooses an answer type, such as multiple choice, text or a rating. The Forms authors can then send a link or QR code to quiz takers or embed the quiz into a web page, blog or Learning Management System (LMS), and recipients can complete the quiz on phones, tablets or PCs. And with the real-time feedback in Forms, the instructor can very quickly see where the class may need additional instruction or could advance more rapidly. Forms responses can also be exported to Mi