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

Keyboard Lessons OnlinePiano Keyboard Online

Are you still using the same plastic keyboard that came with your PC? Then it's time to go for a change. Just go through this tutorial and choose an apt keyboard for your PC.

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: Tables are another tool you can use to display information in PowerPoint. A table is a grid of cells arranged in rows and columns. Tables are useful for various tasks, including presenting text information and numerical data. You can even customize tables to fit your presentation. Optional: Download our practice presentation. Watch the video below to learn more about inserting tables in PowerPoint. TO INSERT A TABLE: From the Insert tab, click the Table command. Hover the mouse over the grid of squares to select the desired number of columns and rows in the table. In our example, we'll insert a table with six rows and six columns (6x6). inserting a table - www.office.com/setup The table will appear on the currently selected slide. In our example, that's slide 3. Click anywhere in the table, and begin typing to add text. You can also use the Tab key or the arrow keys on your keyboard to navigate through the table. adding text to a new table - www.office.com/setup You can also insert a table by clicking the Insert Table command in a placeholder. inserting a table from a placeholder - www.office.com/setup MODIFYING TABLES PowerPoint includes several options for customizing tables, including moving and resizing, as well as adding rows and columns. TO MOVE A TABLE: Click and drag the edge of a table to move it to a new location on a slide. moving a table - www.office.com/setup TO RESIZE A TABLE: Click and drag the sizing handles until the table is the desired size. resizing a table - www.office.com/setup TO ADD A ROW OR COLUMN: Click a cell adjacent to the location where you want to add a row or column. In our example, we'll select the cell that says Mystery. selecting a cell - www.office.com/setup Click the Layout tab on the right side of the Ribbon. Locate the Rows & Columns group. If you want to insert a new row, select either Insert Above or Insert Below. If you want to insert a new column, select either Insert Left or Insert Ri

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 takes up a lot of space, and c

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

Free Online Keyboarding GamesOnline Games For Free

Symbols have remained as the most important aspect of communication. Thanks to the Alt button provisioned with the computer keyboard. Using this you can convey your message easily across people and organizations in a quick and easy manner.

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

WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION www.office.com/setup Blogs: If you need to share information from your database with someone but don't want that person actually working with your database, consider creating a report. Reports allow you to organize and present your data in a reader-friendly, visually appealing format. Access makes it easy to create and customize a report using data from any query or table in your database. In this lesson, you will learn how to create, modify, and print reports. 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 creating reports. TO CREATE A REPORT: Reports give you the ability to present components of your database in an easy-to-read, printable format. Access lets you create reports from both tables and queries. Open the table or query you want to use in your report. We want to print a list of cookies we've sold, so we'll open the Cookies Sold query. The Cookies Sold query - www.office.com/setup Select the Create tab on the Ribbon. Locate the Reports group, then click the Report command. Clicking the Report command - www.office.com/setup Access will create a new report based on your object. It's likely that some of your data will be located on the other side of the page break. To fix this, resize your fields. Simply select a field, then click and drag its edge until the field is the desired size. Repeat with additional fields until all of your fields fit. Resizing fields in the report - www.office.com/setup To save your report, click the Save command on the Quick Access Toolbar. When prompted, type a name for your report, then click OK. Saving and naming the report - www.office.com/setup Just like tables and queries, reports can be sorted and filtered. Simply right-click the field you w

www.office.com/setup Blogs: PowerPoint allows you to insert a video onto a slide and play it during your presentation. This is a great way to make your presentation more engaging for your audience. You can even edit the video within PowerPoint and customize its appearance. For example, you can trim the video's length, add a fade in, and much more. Optional: Download our practice presentation. Watch the video below to learn more about inserting videos in PowerPoint. TO INSERT A VIDEO FROM A FILE: In our example, we'll insert a video from a file saved locally on our computer. If you'd like to work along with our example, right-click this link to our example video and save it to your computer. From the Insert tab, click the Video drop-down arrow, then select Video on My PC. Inserting a video from a file - www.office.com/setup Locate and select the desired video file, then click Insert. Selecting a video to insert - www.office.com/setup The video will be added to the slide. The inserted video - www.office.com/setup With the Screen Recording feature on the Insert tab, you can create a video of anything you are doing on your computer and insert it into a slide. the Screen Recording button on the Insert tab - www.office.com/setup TO INSERT AN ONLINE VIDEO: Some websites-like YouTube-allow you to embed videos into your slides. An embedded video will still be hosted on its original website, meaning the video itself won't be added to your file. Embedding can be a convenient way to reduce the file size of your presentation, but you'll also need to be connected to the Internet for the video to play. Inserting an online video - www.office.com/setup WORKING WITH VIDEOS TO PREVIEW A VIDEO: Click a video to select it. Click the Play/Pause button below the video. The video will begin playing, and the timeline next to the Play/Pause button will advance. The Play/Pause button and the timeline - www.office.com/setup To jump to a different part of the video, click anywhe

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: By default, every row and column of a new workbook is set to the same height and width. Excel allows you to modify column width and row height in different ways, including wrapping text and merging cells. Optional: Download our practice workbook. Watch the video below to learn more about modifying columns, rows, and cells. TO MODIFY COLUMN WIDTH: In our example below, column C is too narrow to display all of the content in these cells. We can make all of this content visible by changing the width of column C. Position the mouse over the column line in the column heading so the cursor becomes a double arrow. positioning the mouse over the column line - www.office.com/setup Click and drag the mouse to increase or decrease the column width. increasing the column width - www.office.com/setup Release the mouse. The column width will be changed. the resized column - www.office.com/setup With numerical data, the cell will display pound signs (#######) if the column is too narrow. Simply increase the column width to make the data visible. TO AUTOFIT COLUMN WIDTH: The AutoFit feature will allow you to set a column's width to fit its content automatically. Position the mouse over the column line in the column heading so the cursor becomes a double arrow. autofitting the column width - www.office.com/setup Double-click the mouse. The column width will be changed automatically to fit the content. the autofit column width - www.office.com/setup You can also AutoFit the width for several columns at the same time. Simply select the columns you want to AutoFit, then select the AutoFit Column Width command from the Format drop-down menu on the Home tab. This method can also be used for row height. autofitting column width for multiple columns - www.office.com/setup TO MODIFY ROW HEIGHT: Position the cursor over the row line so the cursor becomes a double arrow. hovering over a <a href=row line - www.of

WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION www.office.com/setup Blogs: PowerPoint allows you to add audio to your presentation. For example, you could add background music to one slide, a sound effect to another, and even record your own narration or commentary. You can then edit the audio to customize it for your presentation. Optional: Download our practice presentation. Watch the video below to learn more about inserting audio in PowerPoint. TO INSERT AUDIO FROM A FILE: In our example, we'll insert an audio file saved locally on our computer. If you'd like to work along with our example, right-click this link to our example file and save it to your computer (music credit: Something Small (Instrumental) by Minden, CC BY-NC 3.0). From the Insert tab, click the Audio drop-down arrow, then select Audio on My PC. Inserting audio from a file - www.office.com/setup Locate and select the desired audio file, then click Insert. Selecting the desired audio file - www.office.com/setup The audio file will be added to the slide. The inserted audio file - www.office.com/setup RECORDING YOUR OWN AUDIO Sometimes you may want to record audio directly into a presentation. For example, you might want the presentation to include narration. Before you begin, make sure you have a microphone that is compatible with your computer; many computers have built-in microphones or ones that can be plugged in to the computer. TO RECORD AUDIO: From the Insert tab, click the Audio drop-down arrow, then select Record Audio. Clicking Record Audio - www.office.com/setup Type a name for the audio recording if you want. Renaming the audio recording - www.office.com/setup Click the Record button to start recording. Clicking the Record button - www.office.com/setup When you're finished recording, click the Stop button. Clicking the Stop button - www.office.com/setup To preview your recording, click the Play button. Previewing the recording - www.office.com/setup When you're done, click OK. The au

www.office.com/setup Blogs: When you're working with longer presentations, it can be difficult and time consuming to locate a specific word or phrase. PowerPoint can automatically search your presentation using the Find feature, and it allows you to quickly change words or phrases using the Replace feature. Optional: Download our practice presentation. Watch the video below to learn more about the basics of using Find and Replace in PowerPoint. TO FIND TEXT: From the Home tab, click the Find command. www.office.com/setup A dialog box will appear. Enter the text you want to find in the Find what: field, then click Find Next. www.office.com/setup If the text is found, it will be selected. www.office.com/setup You can also access the Find command by pressing Ctrl+F on your keyboard. TO REPLACE TEXT: At times, you may discover that you've repeatedly made a mistake throughout your presentation-such as misspelling someone's name-or that you need to exchange a particular word or phrase for another. You can use the Replace feature to make quick revisions. From the Home tab, click the Replace command. www.office.com/setup A dialog box will appear. Type the text you want to find in the Find what: field. Type the text you want to replace it with in the Replace with: field, then click Find Next. www.office.com/setup If the text is found, it will be selected. Review the text to make sure you want to replace it. If you want to replace it, select one of the replace options. Replace will replace individual instances, and Replace All will replace every instance. In our example, we'll use the Replace option. www.office.com/setup The selected text will be replaced. www.office.com/setup PowerPoint will move to the next instance of the text in the presentation. When you are finished replacing text, click Close to exit the dialog box. When it comes to using Replace All, it's important to remember that it could find matches you didn't anticipate and might not actually want

WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION www.office.com/setup Blogs: If you're new to PowerPoint, you'll need to learn the basics of working with text. In this lesson, you'll learn how to cut, copy, paste, and format text. Optional: Download our practice presentation. Watch the video below to learn more about the basics of working with text in PowerPoint. TO SELECT TEXT: Before you can move or arrange text, you'll need to select it. Click next to the text you want to select, drag the mouse over the text, then release your mouse. The text will be selected. www.office.com/setup Blogs COPYING AND MOVING TEXT PowerPoint allows you to copy text that is already on a slide and paste it elsewhere, which can save you time. If you want to move text, you can cut and paste or drag and drop the text. TO COPY AND PASTE TEXT: Select the text you want to copy, then click the Copy command on the Home tab. www.office.com/setup Blogs Place the insertion point where you want the text to appear. Click the Paste command on the Home tab. www.office.com/setup Blogs The copied text will appear. TO CUT AND PASTE TEXT: Select the text you want to move, then click the Cut command. www.office.com/setup Blogs Place the insertion point where you want the text to appear, then click the Paste command. www.office.com/setup Blogs The text will appear in the new location. You can access the cut, copy, and paste commands by using keyboard shortcuts. Press Ctrl+X to cut, Ctrl+C to copy, and Ctrl+V to paste. TO DRAG AND DROP TEXT: Select the text you want to move, then click and drag the text to the desired location. www.office.com/setup Blogs The text will appear in the new location. www.office.com/setup Blogs FORMATTING AND ALIGNING TEXT

www.office.com/setup Blogs: Microsoft Word is an essential tool for any individual in today's digital age. Whether you are a working professional, a diligent student or an active retiree, proficiency in Microsoft Word is a vital skill1 that is useful for both complex business requirements as well as basic day-to-day purposes. Not only is Microsoft Word a flexible tool that allows you to achieve many of your digital document needs, it is also one of the most user- friendly applications from the Microsoft Office suite. Below are 10 MS Word features that you should be using at work, school or home but likely aren't. 1. SMART ART The Office 2007 and Office 2010 applications share very similar features for working with a range of graphics including pictures, Clip Art, Shapes, diagrams and Charts. It's easy to confuse SmartArt with the similarly named WordArt. Where WordArt just allows you to display text using a wide variety of different formats and effects, SmartArt is a comprehensive and flexible business diagram tool that greatly improves upon the 'Diagram Gallery' feature found in previous versions of Office. Smart Art screen shot 2 - www.office.com/setup The great thing about SmartArt is the ability to swap between different diagrams, even diagrams from other categories, without losing the information that you have already entered. From the selection available, use whichever SmartArt is appropriate to give your document that little bit extra charm. 2. TURN DATA INTO VISUAL CHARTS Charts are created using the same chart 'engine' that Excel uses. Accordingly, as your chart is created, another window will appear containing the Excel-generated data that the chart is based on. Use the Insert Chart button in the Illustrations group to insert a chart and select from the variety of options. The charts are versatile, just like the user-friendly data represented separately in MS Excel to smooth out the whole data-input-to-graph process. Visual Charts -

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

You can connect keyboard, USB hard drives as well as gaming controllers to your Android phone or tablet using a USB OTG adapter. Have a look on this tutorial.