Group items tagged

WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION www.office.com/setup Blogs: Many of the features in Office are geared toward saving and sharing files online. OneDrive is Microsoft's online storage space that you can use to save, edit, and share your presentations and other files. You can access OneDrive from your computer, smartphone, or any of the devices you use. To get started with OneDrive, all you need to do is set up a free Microsoft account if you don't already have one. If you don't already have a Microsoft account, you can go to the Creating a Microsoft Account lesson in our Microsoft Account tutorial. Once you have a Microsoft account, you'll be able to sign in to Office. Just click Sign in in the upper-right corner of the PowerPoint window. signing in to OneDrive - www.office.com/setup BENEFITS OF USING ONEDRIVE Once you're signed in to your Microsoft account, here are a few of the things you'll be able to do with OneDrive: Access your files anywhere: When you save your files to OneDrive, you'll be able to access them from any computer, tablet, or smartphone that has an Internet connection. You'll also be able to create new presentations from OneDrive. Back up your files: Saving files to OneDrive gives them an extra layer of protection. Even if something happens to your computer, OneDrive will keep your files safe and accessible. Share files: It's easy to share your OneDrive files with friends and coworkers. You can choose whether they can edit or simply read files. This option is great for collaboration because multiple people can edit a presentation at the same time (also known as co-authoring). SAVING AND OPENING FILES When you're signed in to your Microsoft account, OneDrive will appear as an option whenever you save or open a file. You still have the option of saving files to your computer. However, saving files to your OneDrive allows you to access them from any other computer, and it also allows you to share files with friends and co

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: 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: While you can always enter data directly into database tables, you might find it easier to use forms. Forms ensure you're entering the right data in the right location and format. This can help keep your database accurate and consistent. This lesson will address the benefits of using forms in a database. You will review examples of different forms and form components. Finally, you will learn how to use forms to enter new records and view and edit existing ones. 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 forms in Access. WHY USE FORMS? Many of us fill out forms so often that we hardly notice when we're asked to use them. Forms are so popular because they're useful to the person asking for the information and to the person providing it. They are a way of requiring information in a specific format, which means the person filling out the form knows exactly which information to include and where to put it. Illustration of a paper form - www.office.com/setup This is just as true of forms in Access. When you enter information into a form in Access, the data goes exactly where it's supposed to go: into one or more related tables. While entering data into simple tables is fairly straightforward, data entry becomes more complicated as you start populating tables with records from elsewhere in the database. For instance, the orders table in a bakery's database might link to information on customers, products, and prices drawn from related tables. For example, in the Orders Table below the Customer ID field is linked to the Customers table. The Customer ID field links to the Customers table - www.office.com/setup In fact, in order to see the entire order you would also have to look at the

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?

Pre-installed copies of Office may come with a product key, or it will activate over the Internet with no product key being required. If the product key is not required, please note that this is a limited time offer and expires six months after you activate Windows. The expiry date will be shown as below.

It's been a very busy year for SkyDrive and we'd like to thank all of you for helping us improve the service through your feedback, tweets, Facebook posts, and comments. The service continues to grow: since October 2012 when Windows 8 launched, 50 million more people have started using SkyDrive, helping us reach an important milestone - over 250 million people are now using SkyDrive as the new place to save their files. In just the past few months we've made SkyDrive the default save location for the new Office, updated the SkyDrive app for iOS, and made substantial performance improvements to SkyDrive uploading. Recently, we also announced that Microsoft accounts have grown to 700 million, that we've improved the security of our service with things like two-step verification, and that we now have Extended Validation Certificates integrated on SkyDrive.com. And a few days ago, our friends over at Outlook.com announced that they're rolling out a new feature that allows you to insert anything from your SkyDrive directly into an email message. We continue to push forward to a world where all your stuff is in SkyDrive, so you can always have it with you.