Group items tagged

WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION www.office.com/setup Blogs: Whenever you work with Excel, you'll enter information-or content-into cells. Cells are the basic building blocks of a worksheet. You'll need to learn the basics of cells and cell content to calculate, analyze, and organize data in Excel. Optional: Download our practice workbook. Watch the video below to learn more about the basics of working with cells. UNDERSTANDING CELLS Every worksheet is made up of thousands of rectangles, which are called cells. A cell is the intersection of a row and a column-in other words, where a row and column meet. Columns are identified by letters (A, B, C), while rows are identified by numbers (1, 2, 3). Each cell has its own name-or cell address-based on its column and row. In the example below, the selected cell intersects column C and row 5, so the cell address is C5. cell C5 - www.office.com/setup Note that the cell address also appears in the Name box in the top-left corner, and that a cell's column and row headings are highlighted when the cell is selected. You can also select multiple cells at the same time. A group of cells is known as a cell range. Rather than a single cell address, you will refer to a cell range using the cell addresses of the first and last cells in the cell range, separated by a colon. For example, a cell range that included cells A1, A2, A3, A4, and A5 would be written as A1:A5. Take a look at the different cell ranges below: Cell range A1:A8cell range A1:A8 - www.office.com/setup Cell range A1:F1 cell range A1:F1 - www.office.com/setup Cell range A1:F8 cell range A1:F8 - www.office.com/setup If the columns in your spreadsheet are labeled with numbers instead of letters, you'll need to change the default reference style for Excel. Review our Extra on What are Reference Styles? to learn how. TO SELECT A CELL: To input or edit cell content, you'll first need to select the cell. Click a cell to select it. In our exampl

WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION www.office.com/setup Blogs: While there are four types of database objects in Access, tables are arguably the most important. Even when you're using forms, queries, and reports, you're still working with tables because that's where all of your data is stored. Tables are at the heart of any database, so it's important to understand how to use them. In this lesson, you will learn how to open tables, create and edit records, and modify the appearance of your table to make it easier to view and work with. 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 working with tables in Access. TABLE BASICS TO OPEN AN EXISTING TABLE: Open your database, and locate the Navigation pane. In the Navigation pane, locate the table you want to open. Double-click the desired table. Opening a table - www.office.com/setup The table will open and appear as a tab in the Document Tabs bar. The open table - www.office.com/setup UNDERSTANDING TABLES All tables are composed of horizontal rows and vertical columns, with small rectangles called cells in the places where rows and columns intersect. In Access, rows and columns are referred to as records and fields. A field is a way of organizing information by type. Think of the field name as a question and every cell within that field as a response to that question. In our example, the Last Name field is selected, which contains all the last names in the table. Fields and field names - www.office.com/setup A record is one unit of information. Every cell on a given row is part of that row's record. In our example, Quinton Boyd's record is selected, which contains all of the information related to him in the table. Records and record ID numbers - www.office.com/setu

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

WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION www.office.com/setup Blogs: In the previous lesson, you learned how to create a simple query with one table. Most queries you design in Access will likely use multiple tables, allowing you to answer more complex questions. In this lesson, you'll learn how to design and create a multi-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 how to create a multi-table query (Part 1). Watch the video below to learn more about joins and query criteria (Part 2). DESIGNING A MULTI-TABLE QUERY Queries can be difficult to understand and build if you don't have a good idea of what you're trying to find and how to find it. A one-table query can be simple enough to make up as you go along, but to build anything more powerful you'll need to plan the query in advance. PLANNING A QUERY When planning a query that uses more than one table, you should go through these four steps: Pinpoint exactly what you want to know. If you could ask your database any question, what would it be? Building a query is more complicated than just asking a question, but knowing precisely what question you want to answer is essential to building a useful query. Identify every type of information you want included in your query results. Which fields contain this information? Locate the fields you want to include in your query. Which tables are they contained in? Determine the criteria the information in each field needs to meet. Think about the question you asked in the first step. Which fields do you need to search for specific information? What information are you looking for? How will you search for it? This process might seem abstract at first, but as we go through the process of planning our own multi-table query you sho

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: WHICH VERSION OF MICROSOFT OFFICE IS BEST FOR ME? www.office.com/setup Blogs: Office 365 and Office 2016 share a lot of similarities, yet deciding between the two involves a lot of factors. Office 365 is a subscription-based service that currently uses Office 2016 apps, but when the next version of Office is released, users will get that as part of their subscription. Office 2016 is a buy-once app suite that brings you the Office 2016 apps as they are, without any available updates in the future. If you want to upgrade to the latest version of Office without paying for a subscription, you'll have to pay full price for the new version - there's no discounted upgrade option. These are only a couple differences between the two products. Looking to invest in Office? We break down the differences between the two products to help you decide which is better for personal and home use. See at Microsoft Store Quick-reference table Apps and pricing Multiple devices Connectivity Support Storage Conclusion QUICK-REFERENCE TABLE Category Office 365 Home Office 365 Personal Office Home & Student 2016 Office Home & Business 2016 Office Professional 2016 Price $99.99 /year $9.99 /month $69.99 /year $6.99 /month $149.99 $229.99 $399.99 Users Up to 5 1 1 1 1 Apps Word Excel PowerPoint OneNote Outlook Publisher Access Word Excel PowerPoint OneNote Outlook Publisher Access Word Excel PowerPoint OneNote Word Excel PowerPoint OneNote Outlook Word Excel PowerPoint OneNote Outlook Publisher Access Devices 5 PCs or Macs 5 tablets 5 phones 1 PC or Mac 1 tablet 1 phone 1 PC 1 PC 1 PC Skype minutes 60 per month for each user 60 None None None OneDrive storage 1TB each for five users 1TB None None None APPS AND PRICING Office apps on the go. - www.office.com/setup Office 365 is a subscription-based service. If you choose to pay on a yearly basis, you essentially get a discount that works out to two free months per year. If you choose to pay on a monthly b

WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION www.office.com/setup Blogs: Databases in Access are composed of four objects: tables, queries, forms, and reports. Together, these objects allow you to enter, store, analyze, and compile data however you want. In this lesson, you will learn about each of the four objects and come to understand how they interact with each other to create a fully functional relational database. Watch the video below to learn more about objects in Access. TABLES By this point, you should already understand that a database is a collection of data organized into many connected lists. In Access, all data is stored in tables, which puts tables at the heart of any database. You might already know that tables are organized into vertical columns and horizontal rows. Rows and columns in an Access table - www.office.com/setup In Access, rows and columns are referred to as records and fields. A field is more than just a column; it's a way of organizing information by the type of data it is. Every piece of information within a field is of the same type. For example, every entry in a field called First Name would be a name, and every entry in field called Street Address would be an address. Fields and field names - www.office.com/setup Likewise, a record is more than just a row; it's a unit of information. Every cell in a given row is part of that row's record. A record - www.office.com/setup Notice how each record spans several fields. Even though the information in each record is organized into fields, it belongs with the other information in that record. See the number at the left of each row? It's the ID number that identifies each record. The ID number for a record refers to every piece of information contained on that row. Record ID numbers - www.office.com/setup Tables are good for storing closely related information. Let's say you own a bakery and have a database that includes a table with your customers' names and information, lik

"iPhone 5 Called ""Gadget off the Year"" by Time Magazine, Apple's iPhone 5 (from $199 on 2-year AT&T, Sprint or Verizon plan) is a serious piece of hardware. Along with its powerful new A6 chip, iPhone 5 works on 4G/Long Term Evolution (LTE) networks for wireless speeds that rivals your home's broadband connection. iPhone 5 also has improved cameras: an eight-megapixel iSight rear-facing camera (3264 x 2448 pixels) and front-facing FaceTime camera with 720p HD quality for video calling. Samsung Galaxy S III The Samsung Galaxy S III (from $149 on 2-year plan with AT&T, Sprint, T-Mobile, U.S. Cellular, Verizon) is a true smartphone in every sense of the word -- and we're not even referring to its stunning 4.8-inch display, fast LTE speeds or versatile Android operating system. the Galaxy S III's front-facing camera knows when you're looking at the screen, so it'll give you the bright display you seek, but if your eyes look away it'll dim itself to preserve its battery. It also knows when you want to talk: if you're messaging with someone and want to call them, simply lift the smartphone to your ear and it'll dial for you. Nokia Lumia 920 As the flagship Windows Phone 8 device, Nokia's Lumia 920 (from $99.99 on 2-year AT&T plan), has a lot to offer, including a colorful Start screen with ""live tiles""; familiar Microsoft apps like Outlook, Word, Excel, PowerPoint and OneNote; and a People hub that aggregates all your contacts into one page per person (so you don't need to close, say Outlook, to see what that friend is up to on Facebook or Twitter). HTC Droid DNA and HTC One X+ A pair of Android-powered HTC devices are also worthy of ""best of 2012"" nods: the HTC Droid DNA ($149.99 on 2-year Verizon Wireless plan) and HTC One X+ ($199.99 on 2-year AT&T plan). Protected by Corning's uber-durable Gorilla Glass 2 technology, the Droid DNA's 5-inch 1080p HD screen was built for video, games, ebooks and web browsing. Integrated Beats Audio - an

Last week, we welcomed Brian Solis, Altimeter principal analyst, thought leader and book author, to Yammer HQ to give a fireside chat, followed by signing of his new book: "What's The Future of Business?" I was thrilled to interview Brian, and we covered a variety of really meaty subjects - just check out the video below! The theme of the evening was transformation - transformation that is happening in our lives as individuals, how we relate to each other through technology and what we as businesses must do to stay relevant to the connected customer. Even the book itself is transformation of the book publishing convention. Unlike a regular, information-dense business book, "What's the Future of Business" attempts to bring together the best of both worlds: hard-hitting facts and practical frameworks, as well as a visual experience. The experience of the book is just as important as the content therein. What is the future of business? The future of business is experience, according to Solis. We as connected consumers make decisions outside of the sales funnel that companies have organized themselves around. We reference experiences of consumers who came before us, and contribute our own experiences to this dynamic tapestry. When consumers share, they are reacting to an experience, and the future of any business depends on its ability to provide experiences that are worth sharing. In his talk, Brian talked about the 4 moments of truth that add up to shareable experiences. At every stage of the customer journey, it is our job as businesses to design an experience to trigger the sharing of a moment. The Zero Moment of Truth comes when the consumer is starting to explore choices and is just becoming aware of needs and possible solutions. 1st Moment of Truth happens when the consumer is ready to buy. Consumer packaged goods companies have perfected providing the right experience at this point. 2nd Moment of Truth happens after the consumer purchases,

You can access and share Office documents with browser-based versions of Word, PowerPoint, Excel, and OneNote. Learn some of the basics and the latest features of these free tools. Note: Office Online was formerly known as Office Web Apps. There is an updated webinar about Office Online at http://aka.ms/online123. Can't see this video? It's also available at Microsoft Showcase? Need a sneak peek? Here's a 30-second trailer. What you will learn at Tuesday's webinar Yes, Office Online is different than Office 365 Storing docs with OneDrive New features customers asked for Working on a doc with someone else at the same time References for this webinar Office Web Apps: Office Online Home Page Get started with Office Online (how-to & video) Edit documents in OneDrive (how-to) Sign-in no longer required to edit Office docs in OneDrive (blog post) 4 new ways to edit Office documents in your browser (blog post) Co-authoring: Two dudes share a spreadsheet (video) SkyDrive: OneDrive Home Page Sign into OneDrive Share Office documents stored on OneDrive OneDrive tips including Fetch NEW! Download free Office Webinar Apps: Windows 8 App and the Windows Phone 8 App. Go to http://aka.ms/offweb to join us live every Tuesday for an Office Webinar and a Q&A session. -Doug Thomas

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

This tutorial on using conditional formatting to highlight dates is brought to us by MVP Frédéric Le Guen, with special acknowledgment and thanks to Ken Puls for assistance with translation from French to English. Date functions in Excel make it is possible to perform date calculations, like addition or subtraction, resulting in automated or semi-automated worksheets. The NOW function, which calculates values based on the current date and time, is a great example of this. Taking this functionality a step further, when you mix date functions with conditional formatting, you can create spreadsheets that display date alerts automatically when a deadline is near or differentiates between types of days, like weekends and weekdays. THE BASICS OF CONDITIONAL FORMATTING FOR DATES To find conditional formatting for dates, go to Home > Conditional Formatting > Highlight Cell Rules > A Date Occuring. www.office.com/setup You can select the following date options, ranging from yesterday to next month: www.office.com/setup These 10 date options generate rules based on the current date. If you need to create rules for other dates (e.g., greater than a month from the current date), you can create your own new rule. Below are step-by-step instructions for a few of my favorite conditional formats for dates. HIGHLIGHTING WEEKENDS When you design an automated calendar you don't need to color the weekends yourself. With the conditional formatting tool, you can automatically change the colors of weekends by basing the format on the WEEKDAY function. Assume that you have the date table-a calendar without conditional formatting: www.office.com/setup To change the color of the weekends, open the menu Conditional Formatting > New Rule www.office.com/setup In the next dialog box, select the menu Use a formula to determine which cell to format. www.office.com/setup In the text box Format values where this formula is true, enter the following WEEKDAY formula to determ

WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION www.office.com/setup Blogs: Access offers several options that let you design and run queries that return exactly the information you're looking for. For instance, what if you need to find out how many of something exists within your database? Or what if you would like your query results to automatically be sorted a certain way? If you know how to use query options in Access, you can design almost any query you want. In this lesson, you'll learn how to modify and sort your queries within Query Design view, as well as how to use the Totals function to create a query that can perform calculations with your data. You'll also learn about additional query-building options offered in Access. 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 modifying queries. MODIFYING QUERIES Access offers several options for making your queries work better for you. In addition to modifying your query criteria and joins after you build your queries, you can choose to sort and hide fields in your query results. TO MODIFY YOUR QUERY: When you open an existing query in Access, it is displayed in Datasheet view, meaning you will see your query results in a table. To modify your query, you must enter Design view, the view you used when creating it. There are two ways to switch to Design view: On the Home tab of the Ribbon, click the View command. Select Design View from the drop-down menu that appears. Switching to Design View with the View command on the Ribbon - www.office.com/setup In the bottom-right corner of your Access window, locate the small view icons. Click the Design View icon, which is the icon farthest to the right. Switching to Design View using the View Icon - www.office.com/setup Once in Desig

www.office.com/setup Blogs: Whenever you use the Internet, you use hyperlinks to navigate from one webpage to another. If you want to include a web address or email address in your PowerPoint presentation, you can choose to format it as a hyperlink so a person can easily click it. It's also possible to link to files and other slides within a presentation. Optional: Download our practice presentation. Watch the video below to learn more about inserting hyperlinks in PowerPoint. ABOUT HYPERLINKS Hyperlinks have two basic parts: the address of the webpage, email address, or other location they are linking to, and the display text (which can also be a picture or a shape). For example, the address could be http://www.youtube.com, and YouTube could be the display text. In some cases, the display text might be the same as the address. When you're creating a hyperlink in PowerPoint, you'll be able to choose both the address and the display text or image. TO INSERT A HYPERLINK: Select the image or text you want to make a hyperlink. Right-click the selected text or image, then click Hyperlink. Alternatively, you can go to the Insert tab and click the Hyperlink command. - www.office.com/setup The Insert Hyperlink dialog box will open. - www.office.com/setup If you selected text, the words will appear in the Text to display field at the top. You can change this text if you want. Type the address you want to link to in the Address field. Click OK. The text or image you selected will now be a hyperlink to the web address. - www.office.com/setup TO INSERT A HYPERLINK TO AN EMAIL ADDRESS: Right-click the selected text or image, then click Hyperlink. The Insert Hyperlink dialog box will open. On the left side of the dialog box, click Email Address. - www.office.com/setup Type the email address you want to connect to in the Email Address box, then click OK. - www.office.com/setup PowerPoint often recognizes email and web addresses as you type and will format them as hyperlin

Meeting notes, vacation plans, grocery lists, great quotes, notes to self-let me count the ways to use OneNote. Consolidate all of your crucial information chunks and snippets in one place, then link with OneDrive to share this virtual notebook with yourself (roaming), with other people (collaboration), and with other devices (OneNote ecosystem). Can't view this video? It's also on Microsoft Showcase. Need a peek? Here's a 30-second trailer. Note SkyDrive is now OneDrive, and SkyDrive Pro is now OneDrive for Business. Read more about this change at From SkyDrive to OneDrive. What you will learn at Tuesday's webinar Using OneNote for your next household project Ways to share OneNote meeting notes Share with OneNote, even if you don't have it OneNote for Android, iPhone, iPad. References for this webinar Share your notebook (video) Share notes with other people (how-to) Work together on a shared notebook (OneNote 2010 training course) Share notes in a meeting (how-to) Plan a trip with others (video) OneNote keyboard shortcuts (2010) and (2013) OneNote mobile apps Go to http://aka.ms/offweb for more information on how to join the series. -Doug Thomas

WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION www.office.com/setup Blogs: Microsoft Access is a database creation and management program. To understand Access, you must first understand databases. In this lesson, you will learn about databases and how they are used. You will familiarize yourself with the differences between data management in Microsoft Access and Microsoft Excel. Finally, you will get a look ahead at the rest of the Access tutorial. Watch the video below to learn more about databases in Access. WHAT IS A DATABASE? A database is a collection of data that is stored in a computer system. Databases allow their users to enter, access, and analyze their data quickly and easily. They're such a useful tool that you see them all the time. Ever waited while a doctor's receptionist entered your personal information into a computer, or watched a store employee use a computer to see whether an item was in stock? If so, then you've seen a database in action. The easiest way to understand a database is to think of it as a collection of lists. Think about one of the databases we mentioned above: the database of patient information at a doctor's office. What lists are contained in a database like this? To start with, there's a list of patients' names. Then there's a list of past appointments, a list with medical history for each patient, a list of contact information, and so on. This is true of all databases, from the simplest to the most complex. For instance, if you like to bake you might decide to keep a database containing the types of cookies you know how to make and the friends you give these cookies to. This is one of the simplest databases imaginable. It contains two lists: a list of your friends, and a list of cookies. An illustration of two lists - www.office.com/setup However, if you were a professional baker, you would have many more lists to keep track of: a list of customers, a list of products sold, a list of prices, a list of orders, and so on.

www.office.com/setup Blogs: ML Gomes is getting a new PC running Windows 8, and wants to know which version of Microsoft Office is best for her needs Microsoft office - www.office.com/setup Blogs Which version of Microsoft Office is best with Windows 8? Photograph: Justin Sullivan/Getty Images Which version of Microsoft Office should I use on Windows 8? I am buying a new laptop and need to use Outlook. ML Gomes Microsoft usually brings out new versions of Office to match new versions of Windows, and Windows 8 is no exception. The new Office 2013 is designed to work with Windows 8, and both have a similar modern styling that puts the emphasis on your content rather than Microsoft's software. Also, both are designed to work with cloud (online) services, particularly Microsoft's SkyDrive. However, other things have changed now that Microsoft is not a software company but a cloud-based "devices and services company". As chief executive Steve Ballmer said last year, this "impacts how we run the company, how we develop new experiences, and how we take products to market for both consumers and businesses." Under the old system, you could buy a copy of Microsoft Office on DVD, and use it without an internet connection. Under the new system, you buy a Product Key, which is 25 alphanumeric characters long. Entering the code online enables you to download your copy of Office, or activate a free trial version pre-installed on your new PC. FREE OFFICE WEB APPS The good news is that under the new system, most home users don't need to pay anything for Microsoft Office: they can use the free, cloud-based service in the form of Microsoft Office web apps. Sign up for an email address at Outlook.com, and you get free web-based email, a contacts book (People), a calendar, and 7GB of online storage in SkyDrive. (Outlook.com has replaced Hotmail, so you can use a Hotmail address, if you already have one.) Log on, click SkyDrive, and you can create and edit files in the four main Of

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: 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: Excel 2016 includes a powerful new set of features based on the Power Query technology, which provides fast, easy data gathering and shaping capabilities and can be accessed through the Get & Transform section on the Data ribbon. Today, we are pleased to announce 10 new data transformation and connectivity features that have been requested by customers. These updates are available as part of an Office 365 subscription. If you are an Office 365 subscriber, find out how to get these latest updates. If you have Excel 2010 or Excel 2013, you can take advantage of these updates by downloading the latest Power Query for Excel add-in. Updates include the following new or improved data connectivity and transformation features: Web Connector-UX support for specifying HTTP Request Headers. OData Connector-support for "Select Related Tables" option. Oracle Connector-improved Navigator preview performance. SAP HANA Connector-enhancements to parameter input UX. Query Dependencies view from Query Editor. Query Editor ribbon support for scalar values. Add custom column based on function invocation. Expand & Aggregate columns provide support for "Load More" values. Convert table column to a list-new transformation. Select as you type in drop-down menus. WEB CONNECTOR-UX SUPPORT FOR SPECIFYING HTTP REQUEST HEADERS With this update, we have added support for specifying HTTP Request Headers within the Web connector dialog. Users can specify header name/value pairs from the Advanced mode in this dialog. november-2016-updates-for-get-transform-in-excel-1 - www.office.com/setup ODATA CONNECTOR-SUPPORT FOR "SELECT RELATED TABLES" OPTION In this update, we have added relationship detection support for OData V4 feeds. When connecting to OData V4 feeds, users will be able to use the Select Related Tables button in the Navigator dialog to help you easily select all the tables needed for your reports. november-2016-updates-for-get-