Group items tagged

www.office.com/setup Blogs: Project 2016 has all the functionality and features you're used to, with some enhancements and the best new features from Office 2016. NOTE: The following feature updates are available to Project Online subscribers. They will first roll out to Office Insider participants. If you have a Project Online subscription, make sure you have the latest version of Office. MARCH 2017 TASK SUMMARY NAME FIELD With long lists of tasks, it can be difficult to know what a task is indented under in the overall project plan. The Task Summary Name field is a read-only field that shows the name of a task's summary task. Adding this field as a column in your Task view can help clarify your project's structure. To add this field, right-click the title of a column (to the right of where you want to add the field), select Insert Column, and then choose Task Summary Name from the drop-down list. Task Summary Name column - www.office.com/setup NOVEMBER 2016 TIMELINE BAR LABELS AND TASK PROGRESS Communicating project progress just got easier! Timeline bars can now be labeled, and task progress is shown right on the tasks themselves, making it simple to quickly illustrate your plan and the work in progress when sharing status. Timeline bars with labels and task progress - www.office.com/setup OCTOBER 2016 IN-APP FEEDBACK Have a comment or suggestion about Microsoft Office? We need your feedback to help us deliver great products. In Project, you can suggest new features, tell us what you like or what's not working by clicking File > Feedback. Click File > Feedback to offer comments or suggestions about Microsoft Project - www.office.com/setup SEPTEMBER 2015 MORE FLEXIBLE TIMELINES With Project 2016, not only can you leverage multiple timelines to illustrate different phases or categories of work, but you can also set the start and end dates for each timeline separately, to paint a clearer overall picture of the work involved. Formatted timeline in Project

www.office.com/setup Blogs: We're moving deeper into the modern "walled garden" of digital life. Generally speaking, you choose the garden you like best - be it Apple, Google or Microsoft - and the more time and money you invest, the more painful it is to leave that ecosystem. Similarly, many people pick Evernote or Microsoft OneNote as their repository of choice for digital scraps, doodlings and scanned documents. Then they usually stick with that choice, because it's not easy to toggle between them or switch. About a year ago, I chose Evernote over OneNote, and I started amassing my own digital archive. At the time, Evernote's Mac software was far superior to OneNote's Mac app. However, Microsoft has continually upgraded OneNote for Mac and iOS, and today it's a legitimate Evernote rival; if I were facing the Mac Evernote versus Mac OneNote decision today, it would be a different situation. If you're a Windows user, the choice is even more challenging, because the OneNote 2013 Windows desktop app has valuable features that aren't available in Evernote or OneNote for Mac. To help you decide between these two notebook tools, I've come up with seven things OneNote does that Evernote can't. Of course, this is only one side of the story. For the flip side, read "6 things Evernote does that OneNote can't." 1) ONENOTE IS A DESIGN-FRIENDLY, FREEFORM CANVAS Each OneNote note is a blank canvas, every element its own movable container. If you have a stylus, you can draw anywhere within the note, and you can insert handwriting, blocks of text, images or any other element wherever you want. onenote freeform canvas - www.office.com/setup OneNote 2013 for Windows also lets you customize your notes. For example, you can change the "paper" color, add rule or grid lines, change the dimensions of notes, create new page templates or apply existing ones, and apply text styles. Other versions of OneNote, including the iPad and Mac apps, offer some but not all, of these capab

WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION www.office.com/setup Blogs: Excel is a spreadsheet program that allows you to store, organize, and analyzeinformation. While you may believe Excel is only used by certain people to process complicated data, anyone can learn how to take advantage of the program's powerful features. Whether you're keeping a budget, organizing a training log, or creating an invoice, Excel makes it easy to work with different types of data. Watch the video below to learn more about Excel. GETTING TO KNOW EXCEL If you've previously used Excel 2010 or Excel 2013, then Excel 2016 should feel familiar. If you are new to Excel or have more experience with older versions, you should first take some time to become familiar with the Excel interface. THE EXCEL INTERFACE When you open Excel 2016 for the first time, the Excel Start Screen will appear. From here, you'll be able to create a new workbook, choose a template, and access your recently edited workbooks. From the Excel Start Screen, locate and select Blank workbook to access the Excel interface. The Excel Start screen - www.office.com/setup Click the buttons in the interactive below to become familiar with the Excel interface. - www.office.com/setup WORKING WITH THE EXCEL ENVIRONMENT The Ribbon and Quick Access Toolbar are where you will find the commands to perform common tasks in Excel. The Backstage view gives you various options for saving, opening a file, printing, and sharing your document. THE RIBBON Excel 2016 uses a tabbed Ribbon system instead of traditional menus. The Ribbon contains multiple tabs, each with several groups of commands. You will use these tabs to perform the most common tasks in Excel. Each tab will have one or more groups. Groups on the ribbon - www.office.com/setup Some groups will have an arrow you can click for more options. Some groups have a menu for more options - www.office.com/setup Click a tab to see more commands. Tabs on the ribbon - www.office.c

WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION www.office.com/setup Blogs: Microsoft Word 2016 is a word processing application that allows you to create a variety of documents, including letters, resumes, and more. In this lesson, you'll learn how to navigate the Word interface and become familiar with some of its most important features, such as the Ribbon, Quick Access Toolbar, and Backstage view. Watch the video below to become more familiar with Word 2016. GETTING TO KNOW WORD 2016 Word 2016 is similar to Word 2013 and Word 2010. If you've previously used either version, then Word 2016 should feel familiar. But if you are new to Word or have more experience with older versions, you should first take some time to become familiar with the Word 2016 interface. THE WORD INTERFACE When you open Word for the first time, the Start Screen will appear. From here, you'll be able to create a new document, choose a template, and access your recently edited documents. From the Start Screen, locate and select Blank document to access the Word interface. creating a new blank document - www.office.com/setup Click the buttons in the interactive below to learn more about the Word interface: the Word 2016 interface - www.office.com/setup WORKING WITH THE WORD ENVIRONMENT Like other recent versions, Word 2016 continues to use features like the Ribbon and the Quick Access Toolbar-where you will find commands to perform common tasks in Word-as well as Backstage view. THE RIBBON Word uses a tabbed Ribbon system instead of traditional menus. The Ribbon contains multiple tabs, which you can find near the top of the Word window. tabs on the Ribbon - www.office.com/setup Each tab contains several groups of related commands. For example, the Font group on the Home tab contains commands for formatting text in your document. the Font group on the Home tab - www.office.com/setup Some groups also have a small arrow in the bottom-right corner that you can click for even more option

Forms are the cornerstone of business applications, and plenty of options exist to create a form in SharePoint. Which one you use will depend on your needs, technical skill and the version of SharePoint you are using. In this article we'll explore seven ways to build forms in SharePoint along with some of the pros and cons of each. All these options will be storing the data in an existing SharePoint list. SHAREPOINT LISTS Default forms are available for any SharePoint list. Create a list and you have a corresponding form to add and modify items. Options are available to organize the order of fields, format them, validate input, add basic calculations and attach files. There are also more advanced options such as limiting permissions to item owners and enabling workflows. You can modify all of these under List Settings for the list. These generic SharePoint forms are a good choice for simple applications that don't have too many columns or records and that only require basic functionality. Lists also offer a data sheet view to edit a limited set of columns, much like a spreadsheet. What you see is what you get with these basic forms. If you need to break fields up into multiple tabs, or perhaps have business logic run on them in real time, you'll need to keep on reading. And although theoretically a list can store millions of items, you can only access up to 5,000 items in any view (in reality the numbers are far lower before performance degrades considerably). Basic Sharepoint list form - www.office.com/setup SHAREPOINT DESIGNER Creating a custom form in SharePoint Designer is relatively easy. You take an existing SharePoint list and use Designer to create a new .aspx page which renders and controls the form. There are files used by a list to create forms, one each to add, edit and view. These are located in the same folder as their associated SharePoint list. With Designer you can show or hide fields based on certain criteria, change the layout, use va

www.office.com/setup Blogs: Last week, Outlook for Mac released two highly requested features designed to help you get more done, quickly. First, we added support for the Touch Bar for MacBook Pro users. Through the Touch Bar, we intelligently put the most common inbox, formatting and view commands at your fingertips-all based on what you're doing in Outlook. Additionally, we're bringing your favorite apps to your inbox with add-ins for Outlook for Mac. Whether it's translating emails on the fly or updating your notes or project board, you will now be able to accomplish all this and more right from your inbox. These add-ins are also available across Outlook for Windows, iOS and the web, so your favorite apps are always there to help you accomplish tasks quickly. Here's a look at what's new! INTUITIVE COMMANDS AT YOUR FINGERTIPS WITH TOUCH BAR SUPPORT IN OUTLOOK FOR MAC The Touch Bar in Outlook intelligently provides quick access to the most commonly used commands as you work on email and manage your calendar. When composing a new mail or meeting request, the Touch Bar displays the common formatting options. When viewing your calendar, you can switch between different views. And when viewing the reminders window, you can join an online meeting with one tap on the Touch Bar. www.office.com/setup Support for Touch Bar in Outlook for Mac is available to all Office 365 subscribers, as well as all Office 2016 for Mac customers. ACCOMPLISH TASKS QUICKLY WITH NEW ADD-INS Add-ins bring your favorite apps right inside Outlook, so you can accomplish tasks quickly without needing to switch back and forth between email and other apps. Last year, we announced the rollout of add-ins to Outlook 2016 for Mac in Office Insider. We are now making add-ins available to all Outlook 2016 for Mac customers who have Exchange 2013 Service Pack 1 or higher, or Office 365 or Outlook.com mailboxes. Use these add-ins to translate emails on the fly, edit a record in your CRM s

WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION www.office.com/setup Blogs: As you add more slides to a presentation, it can be difficult to keep everything organized. Fortunately, PowerPoint offers tools to help you organize and prepare your slide show. Optional: Download our practice presentation. Watch the video below to learn more about managing slides in PowerPoint. ABOUT SLIDE VIEWS PowerPoint includes several different slide views, which are all useful for various tasks. The slide view commands are located in the bottom-right of the PowerPoint window. There are four main slide views. The different slide view commands - www.office.com/setup Normal view: This is the default view, where you create and edit slides. You can also move slides in the Slide Navigation pane on the left. Normal View - www.office.com/setup Slide sorter view: In this view, you'll see a thumbnail version of each slide. You can drag and drop slides to reorder them quickly. Slide Sorter - www.office.com/setup Reading view: This view fills the PowerPoint window with a preview of your presentation. It includes easily accessible navigation buttons at the bottom-right. Reading View - www.office.com/setup Slide show view: This is the view you'll use to present to an audience. This command will begin the presentation from the current slide. You can also press F5 on your keyboard to start from the beginning. A menu will appear in the bottom-left corner when you move the mouse. These commands allow you to navigate through the slides and access other features, such as the pen and highlighter. Playing a slide show - www.office.com/setup OUTLINE VIEW Outline view shows your slide text in outline form. This allows you to quickly edit your slide text and view the content of multiple slides at once. You could use this layout to review the organization of your slide show and prepare to deliver your presentation. TO VIEW AN OUTLINE: From the View tab, click the Outline View command. Clicking the Outline V

www.office.com/setup Blogs: Evernote and OneNote are two of our favorite tools, but both have changed substantially since we last compared these two apps-in some ways, not for the best. Here's where these two stand today. www.office.com/setup LIFEHACKER FACEOFF: ONENOTE VS. EVERNOTE Now that Microsoft OneNote is free for Mac and Windows, the price and cross-platform barriers to…Read more WHAT'S NEW IN EVERNOTE In the last year, Evernote introduced a new pricing plan, redesigned its webapp, and added new features for its Android and iOS apps. THE FREE PLAN LOSES A FEATURE, BUT NOW THERE'S A MORE AFFORDABLE PAID PLAN Let's talk price first with Evernote, since it's the biggest change in the last year. The free plan no longer lets you email notes to Evernote, something most users enjoyed and used often prior to that change. Although you can get around this limitation with an IFTTT recipe, you won't get the full flexibility of Evernote's email-to-notes feature, such as specifying your destination notebook in the email subject line. So that's a bummer. On the positive side, however, Evernote introduced a new, more affordable paid plan called Evernote Plus. For $25 a year, you get offline notebooks for Evernote's mobile apps and the ability to lock the app on your phone with a PIN. Both of these used to require Evernote's Premium plan, which used to cost $45 a year. Finally, Evernote's Premium plan now costs $50 a year. But in return for those five extra bucks, you get larger upload limits: 10GB a month, instead of the previous 4GB data cap. With Evernote Premium, you can search attachments, scan business cards, view previous note versions, annotate PDFs, and use the new note presentation mode. EVERNOTE'S USER INTERFACE KEEPS EVOLVING www.office.com/setup Last year, Evernote took its redesigned, minimalist web client out of beta. Though slicker and easier on the eyes, the makeover also made the webapp less functional. You can't order

www.office.com/setup Blogs: The OneNote API team is pleased to announce that we have enabled application-level permissions support for the OneNote API. Until now, OneNote API calls could only be made with user-delegated permissions. This meant that your application would be restricted to scenarios that required a user to be signed in. With application-level permissions support, your application now supports scenarios that do not require a user to be signed in! Read the MSDN article for details of the OneNote API application-level permissions support. With the availability of OneNote API application-level permissions support, many new scenarios that weren't possible earlier are now enabled. Some example scenarios include: Analytics (based on OneNote metadata and content exposed by the OneNote API). Dashboards (based on OneNote metadata and content exposed by the OneNote API). Background provisioning of OneNote content. Background update of OneNote content. During the development process of building the new application-level permissions support for OneNote API, our Product Management and Engineering teams worked closely with third-party partners to ensure that relevant and key education scenarios were implemented. We also ensured that our API would work well with new and upcoming third-party solutions. One of these education companies we worked closely with during the API development was Hapara. "The Hapara Dashboard provides educators with a bird's-eye view into student work across the Office 365 platform. With Dashboard, educators view and access student work from OneDrive and OneNote Class Notebooks from a central hub, making it easier to engage with students and their work across the Office 365 platform. Hapara relies on the new OneNote API to help co-teachers, counselors, coaches and school administrators gain appropriate access to student work in any classroom, something that previously required manual sharing and significant administrative effort by th

www.office.com/setup Blogs: Good Morning America's "Boosting Your Business" segment, sponsored by Microsoft, provides entrepreneurs and small businesses with simple advice and tools to help them grow. On March 15, Good Morning America brought in Maxie McCoy, a career expert, to give tips and tricks to help businesses across the country be more productive and collaborative. To demonstrate some of these tips, Maxie visited WeWork, the hugely successful shared-office space startup, and talked about how the WeWork Creator Awards team can work together in a new way using Microsoft Teams, a new chat-based workspace in Office 365. Maxie gave the Creator Awards team advice on aligning their vision, delegating responsibility and communicating clearly within team workspaces. She showed them how Microsoft Teams creates a secure hub for teamwork, helping them communicate and collaborate more effectively. Unique vision and unquestionable talent has made the WeWork team into what it is today. Microsoft Teams gives them a new way to work together and continue to grow. Watch the segment now: Check out Microsoft Teams to see how your team can be more productive and collaborative as well. Download and read "The Ultimate Guide to Chat-Based Tools."

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

www.office.com/setup Blogs: Andy Wolber shows you how to edit Word, Excel, and PowerPoint documents stored on Google Drive from your desktop or mobile device. Office and Drive - www.office.com/setup Many organizations that rely on Google Apps also use Microsoft Office applications. Mass conversion of highly formatted documents, complex spreadsheets, or animated presentations may not always be practical. As a result, people still open and edit Word, Excel, and PowerPoint documents after a move to Google Apps. Microsoft Office files, however, no longer need to be stored on your local computer, server, or even on MIcrosoft's OneDrive. Google Drive stores Microsoft Word, Excel, and PowerPoint files much like any file server. And Google encrypts the files when you upload them to Drive, and it stores the files in an encrypted state, too. Google also offers several ways to edit Microsoft Office files stored on Google Drive. Edit capabilities vary by operating system. Here's a look at the options as of August 2015. EDIT WITH MICROSOFT OFFICE The most full-featured way to edit a Word, Excel, or PowerPoint file stored on Google Drive is with Microsoft Office, of course. People who use Office on Windows may open Office files from Google Drive with a plug-in. Simply install the Google Drive plug-in for Microsoft Office, and Google Drive will display as a file storage location in Word, Excel, and PowerPoint (Figure A). From within your Office app, open a file on Google Drive, make your changes, then save the file back to Google Drive. Figure A Figure A - www.office.com/setup OPEN MICROSOFT OFFICE FILES STORED ON GOOGLE DRIVE WITH A GOOGLE-CREATED PLUG-IN. You can also open an Office file stored on Google Drive from your Chrome browser-on either Windows or a Mac. First, install the Google Drive app for your system. Next, start Chrome and browse to your file on Google Drive (http://drive.google.com). Right-click (or, [Ctrl]+click) on a Word, Excel, or PowerPoint documen

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-

www.office.com/setup Blogs: Office 365 is a subscription based package that buys you time limited access to a number of Microsoft services and software packages, including the latest desktop Office suite, an online version of Office, cloud storage, and premium mobile apps.Stop Bashing Microsoft: 5 Ways In Which They're Awesome Stop Bashing Microsoft: 5 Ways In Which They're AwesomeMicrosoft doesn't always get fair treatment. When it comes down to it, they're a pretty awesome company. There's been enough Microsoft bashing, now it's time for some love.READ MORE Office 365 follows a business model known as Software as a Service (SaaS), which has commonly been used for deploying enterprise software. With subscription-based services like Spotify, Napster, or Amazon Prime, it has found its way into the consumer software market some time ago. Does Office 365 provide enough value to be worth the money? CAN YOU STILL USE IT ON YOUR DESKTOP? Yes, absolutely! Microsoft isn't moving Office entirely into the cloud just yet. While you can access Office Online via the browser and store your documents on OneDrive, Office 365 offers many other ways to access and edit your documents. The current package of Office 365 includes the Office 2013 desktop suite (Office 2011 for Mac users). In the summer or fall of this year, you will be able to upgrade to Office 2016.Don't Pay For Word! 5 Reasons You Should Use Office Online Don't Pay For Word! 5 Reasons You Should Use Office OnlineOffice Online is the free and cloud-connected version of Microsoft Office. Limitations are compensated by features, useful even to users of desktop Office. Best of all is itsREAD MORE Microsoft Office - www.office.com/setup WHAT IS INCLUDED & WHAT IS THE PRICE TAG? The exact composition of the package depends on the Office flavor you choose. Office 365 Home, Office 365 Personal, and Office 365 University include the following software: Word Excel PowerPoint OneNote (now free for everyone) Outlook Publ

WHAT IS MICROSOFT PROJECT? www.office.com/setup Blogs: Microsoft Project is a flexible tool for project portfolio management (PPM) and daily work, delivered through Office 365. The first place in this category of products is held by Wrike which has a total score of 9.8/10 and is the winner of our Best Project Management Software Award for 2016. You can try out Wrike for free here. You can also compare Microsoft Project with Wrike and see which one is better for your company. Microsoft Project enables businesses to get started, manage project portfolio investments, and deliver successfully with the intended business value. Microsoft Project Professional gives businesses a powerful, visually enhanced way to efficiently manage a wide range of their projects and programs. From meeting important deadlines, to choosing the right resources and empowering your office teams, Project Professional delivers new as well as intuitive experiences to plan, manage, and collaborate with various individuals, teams, and the enterprise.

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