Group items tagged

Amazon is planning to double its tech workforce by adding 400 new jobs at the Chicago Tech Hub in Illinois, US. The jobs will be in various fields, such as cloud computing, advertising, and business development. The retailer will also add more than 70,000ft2 of additional space to accommodate the new jobs.

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

The RetroBlox will come with an optical drive to support discs from both the PS1 and Sega CD in addition to the cartridges and Turbo Chips, unlike the RetroN and Game Freak. The console is also supposed to support modes like online, connectivity, a modern user interface.

Air has been built with a 5.2 mm customized speaker driver. The Air has free iOS and Android Crazybaby apps. Air delivers high-performance sound without additional bulk.

Freestyle Edge mechanical keyboard that can split. it is popular in gamers. Additional Features: LED Backlighting, Cherry MX Switches, Game Bank

Krishna Mamidipaka is a Senior Product Marketing Manager on the Microsoft Visio team. Visio diagram templates - www.office.com/setupMicrosoft Visio is one of the most widely used tools for Business Process Modeling (BPM) projects worldwide, and people use Visio for a variety of tasks within the context of their BPM projects. From creating process flows that are validated for critical compliance needs to automating human and document centric workflows, and monitoring these workflows, Microsoft Visio supports BPM efforts of varying complexity. The new Microsoft Visio, powered by interoperability with Microsoft SharePoint and Office 365, provides a strong social, mobile and cloud-based infrastructure for BPM initiatives. In addition to the newer workflows and collaboration features, it also offers several new diagram templates that support the latest industry standards, such as BPMN 2.0 and UML 2.4. Look for us at the Gartner BPM Summit April 2-4, 2013 as we take our very compelling and well-recognized BPM story to the Washington D.C. area. Microsoft is a Platinum sponsor of the summit, and we are very excited to speak with a variety of customers, partners, analysts and press while at the event. Do join us if you can! Learn more about new and improved BPM capabilities in Visio with our Microsoft BPM Whitepaper. -Krishna Mamidipaka, Senior Product Marketing Manager

Microsoft Forms is a new part of Office 365 Education that allows teachers and students to quickly and easily create custom quizzes, surveys, questionnaires, registrations and more. When you create a quiz or form, you can invite others to respond to it using any web browser, even on mobile devices. As results are submitted, you can use built-in analytics to evaluate responses. Form data, such as quiz results, can be easily exported to Excel for additional analysis or grading.

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.

www.office.com/setup Blogs: All cell content uses the same formatting by default, which can make it difficult to read a workbook with a lot of information. Basic formatting can customize the look and feel of your workbook, allowing you to draw attention to specific sections and making your content easier to view and understand. Optional: Download our practice workbook. Watch the video below to learn more about formatting cells in Excel. TO CHANGE THE FONT SIZE: Select the cell(s) you want to modify. Selecting a cell - www.office.com/setup On the Home tab, click the drop-down arrow next to the Font Size command, then select the desired font size. In our example, we will choose 24 to make the text larger. Selecting a font size in the dropdown menu - www.office.com/setup The text will change to the selected font size. The selected cell is a larger font size now - www.office.com/setup You can also use the Increase Font Size and Decrease Font Size commands or enter a custom font size using your keyboard. The custom font box, increase font size button, and decrease font size button - www.office.com/setup TO CHANGE THE FONT: By default, the font of each new workbook is set to Calibri. However, Excel provides many other fonts you can use to customize your cell text. In the example below, we'll format our title cell to help distinguish it from the rest of the worksheet. Select the cell(s) you want to modify. Selecting a cell - www.office.com/setup On the Home tab, click the drop-down arrow next to the Font command, then select the desired font. In our example, we'll choose Century Gothic. Selecting a font in the dropdown menu - www.office.com/setup The text will change to the selected font. The selected cell is a different font now - www.office.com/setup When creating a workbook in the workplace, you'll want to select a font that is easy to read. Along with Calibri, standard reading fonts include Cambria, Times New Roman, and Arial. TO CHANGE THE FONT COLOR: Select

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 example, we'll select cell D9. A border will app

www.office.com/setup Blogs: Once your slide show is complete, you'll need to learn how to present it to an audience. PowerPoint offers several tools and features to help make your presentation smooth, engaging, and professional. Optional: Download our practice presentation. Watch the video below to learn more about presenting your slide show. PRESENTING A SLIDE SHOW Before you present your slide show, you'll need to think about the type of equipment that will be available for your presentation. Many presenters use projectors during presentations, so you might want to consider using one as well. This allows you to control and preview slides on one monitor while presenting them to an audience on another screen. TO START A SLIDE SHOW: There are several ways you can begin your presentation: Click the Start From Beginning command on the Quick Access Toolbar, or press the F5 key at the top of your keyboard. The presentation will appear in full-screen mode. clicking the Start From Beginning command on the Quick Access Toolbar - www.office.com/setup Select the Slide Show view command at the bottom of the PowerPoint window to begin a presentation from the current slide. Switching to Slide Show view from the Status bar in the lower-right corner - www.office.com/setup Go to the Slide Show tab on the Ribbon to access even more options. From here, you can start the presentation from the current slide and access advanced presentation options. starting a presentation from the Slide Show tab - www.office.com/setup TO ADVANCE AND REVERSE SLIDES: You can advance to the next slide by clicking your mouse or pressing the spacebar on your keyboard. Alternatively, you can use or arrow keys on your keyboard to move forward or backward through the presentation. You can also hover your mouse over the bottom-left and click the arrows to move forward or backward. hovering the mouse to access navigation buttons in Slide Show view - www.office.com/setup TO STOP A SLIDE SHOW: You can

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

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.

EasyQA contains the simplest but the most varied functionality which will help users to write test cases easier and faster. In our article we give answers to the following questions: What is a test case? How to write test cases? What additional useful features you can use to manage test cases in EasyQA?

This post is brought to you by Seayoung Rhee, Product Marketing Manager in the SharePoint Product Marketing Group. Reliable business intelligence and insight are key to a thriving business. Excel, SharePoint and Office 365 make business intelligence (BI) in the new Office more accessible to everyone across an organization as part of their everyday work. New and enhanced features in familiar tools such as Excel empower everyone in a business to easily explore, model, analyze, and visualize data from various sources. With SharePoint, users of all levels can collaboratively develop and share insights through dashboards and scorecards, and this experience continues seamlessly in the cloud with Office 365. For corporate environments, these features are further enhanced by SQL Server for higher levels of performance and scalability both on-premises and in the cloud with BI Azure. Ultimately with Microsoft BI, anyone in the organization can develop the insights that help drive new discoveries and make better, more informed decisions. EXPLORE YOUR DATA PowerPivot was a popular add-in to Excel 2010, allowing users to create large data models with hundreds of millions of rows in Excel. This feature is now natively embedded in Excel to reduce the hassle of downloads and installation. PowerPivot is also supported in SharePoint with SQL Server Analysis Services where the workbooks with PowerPivot models can be shared broadly across the organization. New features like Quick Explore aid users in navigating their data, and Quick Analysis provides previews of their charts, graphs, and scorecards. Users can: Combine and analyze large datasets with PowerPivot Summarize data and discover trends with Quick Explore Instantly preview charts and pivot tables with Quick Analysis www.office.com/setup VISUALIZE YOUR INSIGHTS Introduced with SQL Server 2012, Power View provided a canvas to create visual dashboards in SharePoint. Now this feature is embedded into Excel and SharePoint so

WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION www.office.com/setup Blogs: Once your slide show is complete, you'll need to learn how to present it to an audience. PowerPoint offers several tools and features to help make your presentation smooth, engaging, and professional. Optional: Download our practice presentation. Watch the video below to learn more about presenting your slide show. PRESENTING A SLIDE SHOW Before you present your slide show, you'll need to think about the type of equipment that will be available for your presentation. Many presenters use projectors during presentations, so you might want to consider using one as well. This allows you to control and preview slides on one monitor while presenting them to an audience on another screen. TO START A SLIDE SHOW: There are several ways you can begin your presentation: Click the Start From Beginning command on the Quick Access Toolbar, or press the F5 key at the top of your keyboard. The presentation will appear in full-screen mode. clicking the Start From Beginning command on the Quick Access Toolbar - www.office.com/setup Select the Slide Show view command at the bottom of the PowerPoint window to begin a presentation from the current slide. Switching to Slide Show view from the Status bar in the lower-right corner - www.office.com/setup Go to the Slide Show tab on the Ribbon to access even more options. From here, you can start the presentation from the current slide and access advanced presentation options. starting a presentation from the Slide Show tab - www.office.com/setup TO ADVANCE AND REVERSE SLIDES: You can advance to the next slide by clicking your mouse or pressing the spacebar on your keyboard. Alternatively, you can use or arrow keys on your keyboard to move forward or backward through the presentation. You can also hover your mouse over the bottom-left and click the arrows to move forward or backward. hovering the mouse to access navigation buttons in Slide Show view - www.office

Videos of the Office 15-Minute Webinars are available in new apps for Windows 8 and Windows Phone 8. These videos can help you get the most out of Word, Excel, Outlook, OneNote, PowerPoint, and other Office applications. Watch on your phone or Windows 8 computer, or use the app as a second screen as you follow the steps in the demo on your main screen. So now you have another option to view past Office Webinars in addition to the Office Blog, Office YouTube channel, or joining live-plus participate in the live Q&A session-every Tuesday at http://aka.ms/offweb. Windows 8 App Windows Phone 8 App Or just search for "Office Webinars" next time your are at the Windows Store. -Doug Thomas

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