Group items tagged

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.

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

www.office.com/setup Blogs: Productivity? Sweet www.office.com/setup Blogs: Office 2016 for Mac was a long time coming, but it brings plenty of new features and better feature parity with the Windows version than ever. Microsoft has done a lot to streamline the experience, with a customizable, collapsible Ribbon as well as cross-platform keyboard shortcuts, but with any major Office update, there's bound to be a learning curve. These tips for Word, PowerPoint, Excel, Outlook, and OneNote should come in handy, and if you're stumped about anything specific, let us know in the comments. Office 2016 is available for Office365 subscribers, with a wider release coming in September. Don't forget to save! This is probably our most important tip: Don't forget to save! When Apple introduced Auto Save and Versions into OS X, many Mac users started losing our ingrained habit of hitting Command-S often. Unfortunately, Office 2016 (except for OneNote-more on that in a bit) doesn't take advantage of Auto Save. So don't forget to save often. Versioning is also missing, but on the plus side, fans of Save As will find the command in its rightful place in the File menu. Store your files in OneDrive or SharePoint If you need access to your files from anywhere, Office 2016's built-in OneDrive & SharePoint integration makes cloud storage simple. To save to your OneDrive or SharePoint account, click the Online Locations button in the lower-left corner of a Save dialog box. Choose your existing account from the list, or click the Plus button to add another location. What's the difference? Glad you asked. OneDrive is a consumer product for cloud storage, like iCloud Drive. Aimed more at businesses, SharePoint acts like an intranet, letting teams share and collaborate on files. Office 2016 for Mac: Ribbon - www.office.com/setup See larger image Maximize your workspace The redesigned Ribbon in Office 2016 unifies the look and functionality across all platforms. It also ta

A chart is a tool you can use to communicate data graphically. Including a chart in a presentation allows your audience to see the meaning behind the numbers, which makes it easy to visualize comparisons and trends. Optional: Download our practice presentation for this lesson. Watch the video below to learn more about using charts in PowerPoint. TYPES OF CHARTS PowerPoint has several types of charts, allowing you to choose the one that best fits your data. In order to use charts effectively, you'll need to understand how different charts are used. Click the arrows in the slideshow below to learn more about the types of charts in PowerPoint. Slide 1 - www.office.com/setupPowerPoint has a variety of chart types, each with its own advantages. Click the arrows to see some of the different types of charts available in PowerPoint. Slide 1 - www.office.com/setup Slide 1 - www.office.com/setup Slide 1 - www.office.com/setup Slide 1 - www.office.com/setup Slide 1 - www.office.com/setup IDENTIFYING THE PARTS OF A CHART In addition to chart types, you'll need to understand how to read a chart. Charts contain several different elements-or parts-that can help you interpret data. Click the buttons in the interactive below to learn about the different parts of a chart. Book sales chart - www.office.com/setup LEGEND The legend identifies which data series each color on the chart represents. In this example, the legend identifies the different months in the chart. INSERTING CHARTS PowerPoint uses a spreadsheet as a placeholder for entering chart data, much like Excel. The process of entering data is fairly simple, but if you are unfamiliar with Excel you might want to review our Excel 2016 Cell Basics lesson.

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

MANY POWERPOINT PRESENTATIONS INCLUDE HYPERLINKS TO OUTSIDE SOURCES LIKE WEBPAGES, BUT YOU CAN ALSO ADD LINKS TO LOCAL FILES OR OTHER SLIDES WITHIN THE PRESENTATION. ADDING THESE TYPES OF LINKS IS ANOTHER WAY TO MAKE PRESENTATIONS MORE INTERACTIVE, AND THE PROCESS IS SIMPLE.

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. OVERVIEW OF MICROSOFT PROJECT BENEFITS Arguably one of the best among the currently available project management tools, Microsoft Project is the tool for any company that is tired of trying to boost productivity with whiteboard scribblings, post-it notes, as well as scraps of paper. The tool deals with complexity in a very simple manner. While the tool has an impressively huge range of capabilities, it is relatively easy for any user to get it to do exactly what he or she needs. Microsoft Project is designed by people who have managed real-life projects and know that some things and processes are always changing. Thus with this tool, adding new tasks or revising the organization of a project midway through will be an easy thing to do. It is extremely intuitive and offers great balance of usability and complexity. Project is used in various industries including manufacturing, pharmaceuticals, construction, retail, financial services, government, a

A few weeks ago, preview versions of Microsoft Office products for 2016 were released. The release included Microsoft Office 2016 suite products, plus Project and Visio. All the products are available in desktop and office 365 formats for trials. We shared the links to download/install preview of Microsoft Office and Project 2016 in this post a while ago. Since then, I wanted to write my first hand review of Project 2016, so here it goes. INSTALLATION OF PROJECT 2016 First things first, installation challenges. Prior to installing Microsoft Project 2016 (this is the same for Office 2016) you will need to uninstall the 2013 version of the same product, as they can't both be installed at the same time. It's easy to uninstall and then reinstall a new version, right? Not really. Unfortunately, this isn't as simple as it sounds particularly if you have ever had Microsoft Project 2013 office 365 version installed on your machine along with Project 2013 desktop version. At least in my case, I have tried every possible way of removing 2013 version, but Microsoft Project 2016 kept crashing soon after it started. Here, and may be few other places, described a solution to an issue but it never worked for me and eventually I end up installing to a fresh VM that has no traces of prior version.

Yana Terukhova is a Product Marketing Manager on the Microsoft Visio team. Visio offers over 60 types of professional templates to build compelling diagrams, and organization charts are among most the frequently created. Visio organization charts are simple and visual, but what if you want to connect them to key business indicators tracked by your organization, such as sales by region, budget by department, vacation status, or training progress? Sometimes this information is located in another source, like Excel or a complex database. Data-linked diagrams let you add data to Visio diagrams-no code required-and anyone in an organization can quickly create such dashboards to get better insights into data using Visio Professional 2013 or Visio Pro for Office 365.

If you've got a really killer PowerPoint presentation but would like to extract all the information to Microsoft Word - you can. Sometimes this is necessary because the size of your PowerPoint presentation is rather large and you would like to share it with others over email or an intranet. Converting it to Word will help reduce the size and make it easier to view for everyone involved. It's also possible that you would like your slides presented as thumbnails, with or without speaker notes included, for easier reviewing, editing, or handing out during the presentation itself. You can convert your presentation in one of three ways. The directions for converting on a Mac OS and a Windows OS are as follows. If you're feeling a bit ambitious, why not become a PowerPoint Ninja?

This article, written by German CSS expert Jens Meiert, shows how to make one's page more organized. He opens up by explaining how important it is to make your page orderly. While I am just starting out with this Web Design endeavor, I expect to employ some of Meiert's suggestions with my own work.