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

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: While there are four types of database objects in Access, tables are arguably the most important. Even when you're using forms, queries, and reports, you're still working with tables because that's where all of your data is stored. Tables are at the heart of any database, so it's important to understand how to use them. In this lesson, you will learn how to open tables, create and edit records, and modify the appearance of your table to make it easier to view and work with. 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 tables in Access. TABLE BASICS TO OPEN AN EXISTING TABLE: Open your database, and locate the Navigation pane. In the Navigation pane, locate the table you want to open. Double-click the desired table. Opening a table - www.office.com/setup The table will open and appear as a tab in the Document Tabs bar. The open table - www.office.com/setup UNDERSTANDING TABLES All tables are composed of horizontal rows and vertical columns, with small rectangles called cells in the places where rows and columns intersect. In Access, rows and columns are referred to as records and fields. A field is a way of organizing information by type. Think of the field name as a question and every cell within that field as a response to that question. In our example, the Last Name field is selected, which contains all the last names in the table. Fields and field names - www.office.com/setup A record is one unit of information. Every cell on a given row is part of that row's record. In our example, Quinton Boyd's record is selected, which contains all of the information related to him in the table. Records and record ID numbers - www.office.com/setu

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

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. THE BASICS OF CONDITIONAL FORMATTING FOR DATES To find conditional formatting for dates, go to Home > Conditional Formatting > Highlight Cell Rules > A Date Occuring. www.office.com/setup You can select the following date options, ranging from yesterday to next month: www.office.com/setup These 10 date options generate rules based on the current date. If you need to create rules for other dates (e.g., greater than a month from the current date), you can create your own new rule. Below are step-by-step instructions for a few of my favorite conditional formats for dates. HIGHLIGHTING WEEKENDS When you design an automated calendar you don't need to color the weekends yourself. With the conditional formatting tool, you can automatically change the colors of weekends by basing the format on the WEEKDAY function. Assume that you have the date table-a calendar without conditional formatting: www.office.com/setup To change the color of the weekends, open the menu Conditional Formatting > New Rule www.office.com/setup In the next dialog box, select the menu Use a formula to determine which cell to format. www.office.com/setup In the text box Format values where this formula is true, enter the following WEEKDAY formula to determ

WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION www.office.com/setup Blogs: After creating a form, you might want to modify its appearance. Formatting your forms can help make your database look consistent and professional. Some formatting changes can even make your forms easier to use. With the formatting tools in Access, you can customize your forms to look exactly the way you want. In this lesson, you will learn how to add command buttons, modify form layouts, add logos and other images, and change form colors and fonts. 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 formatting forms in Access. FORMATTING FORMS Access offers several options that let you make your forms look exactly the way you want. While some of these options-like command buttons-are unique to forms, others may be familiar to you. COMMAND BUTTONS If you want to create a way for users of your form to quickly perform specific actions and tasks, consider adding command buttons. When you create a command button, you specify an action for it to carry out when clicked. By including commands for common tasks right in your form, you're making the form easier to use. Access offers many different types of command buttons, but they can be divided into a few main categories: Record Navigation command buttons, which allow users to move among the records in your database Record Operation command buttons, which let users do things like save and print a record Form Operation command buttons, which allow users to quickly open or close a form, print the current form, and perform other actions Report Operation command buttons, which offer users a quick way to do things like preview or mail a report from the current record TO ADD A COMMAND BUTTON TO A FORM: In Form Layou

How to Catch a Cheater with the Cell Phone, Ways to Catch a Cheater Catch a Cheater using their Cell Phone SIM card and Catch tat Cheater a with Cell Phone

Catch a Cheater using their Cell Phone SIM card and Catch tat Cheater a with Cell Phone Do you suspect your husband or wife is cheating on you? Catching a cheater with A Cell Phone it may be it a boyfriend or girlfriend or that lifetime mate thats...

Mobile usage has become pervasive, but cell-phone battery life is a matter of concern, especially when you are going on a long trip. Techvedic, a leading tech support vendor, brings effective solution to enhance cell-phone battery life.

WWW.OFFICE.COM/SETUP BLOGS: www.office.com/setup Blogs: In this module, you will learn how to use the Calendar Visualization Power BI Custom Visual. The Calendar Visualization is a very unique visual that allows you to show the distribution of values across a calendar. MODULE 11 - CALENDAR VISUALIZATION DOWNLOADS Power BI Custom Visual - Calendar Visualization Dataset - Sales by Date.xlsx Completed Example - Module 10 - Calendar Visualization.pbix KEY TAKEAWAYS Allows you to visualize a data point on each date on the calendar. The darker the color, the higher the value or density of values. If you have multiple rows on the same date, they are aggregated together The Calendar Visualization can be used for cross filtering. Meaning you can select a square in the calendar and it will filter other visuals down to the date you picked. image - www.office.com/setup This shows a business which has a much higher number of sales occurring on weekdays. Saturday is a particularly weak sales day and no sales occur on Sunday. You should note when you use a date column into Power BI that by default it places it into a date hierarchy. For the purposes of the Calendar Visualization, this hierarchy is not helpful because you need all the values to be at a date level and not Year, Month, etc… To turn off the auto generated hierarchy for this visual, click the down arrow next to the Date field and turn off the Date Hierarchy option as shown below. image - www.office.com/setup This only applies to this one visual so if you bring in Date again it will auto generate the hierarchy again. Or you can change the Power BI settings so it never auto generates date hierarchies for you again. To do this go to File > Options and settings > Options > Data Load and then uncheck Auto Date/Time. image - www.office.com/setup Under the Format paintbrush there are minimal options for customizing the appearance of the Calendar Visualization. The Cells color section gives you the abil

Cell Phone BatteryLg Cell Phone Batteries

WWW.OFFICE.COM/SETUP BLOGS: GO TEAM! THAT'S WHAT OFFICE 2016 IS BUILT TO ENCOURAGE, WITH NEW COLLABORATIVE TOOLS AND OTHER WAYS TO TIE WORKERS AND CONTENT TOGETHER. pcw office primary 2 - www.office.com/setup www.office.com/setup Blogs: Office 2016 is a major upgrade, but not in the way you'd first suppose. Just as Windows 10 ties notebooks, desktops, phones and tablets together, and adds a layer of intelligence, Office 2016 wants to connect you and your coworkers together, using some baked-in smarts to help you along. I tested the client-facing portion of Office 2016. Microsoft released the trial version of Office 2016 in March as a developer preview with a focus on administrative features (data loss protection, multi-factor authentication and more) that we didn't test. I've been using it since the consumer preview release in May. Microsoft seeded reviewers with a Microsoft Surface 3 with the "final code" upon it. That's a slight misnomer, as the Office 2016 apps upon it used the same version that Microsoft had tested with the public, with a few exceptions: Outlook was pre-populated with links and contacts of a virtual company to give reviewers the look and feel of Delve, Outlook's new Groups feature, and more. Office 2013 users can rest easy about one thing: Office 2016's applications are almost indistinguishable from their previous versions in look and feature set. To the basic Office apps, Microsoft has added its Sway app for light content creation, and the enterprise information aggregator, Delve. Collaboration in the cloud is the real difference with Office 2016. Office now encourages you to share documents online, in a collaborative workspace. Printing out a document and marking it up with a pen? Medieval. Even emailing copies back and forth is now tacitly discouraged. office 2016 review powerpoint demo shot - www.office.com/setupMicrosoft Microsoft says its new collaborative workflow reflects how people do things now, from study groups

If you're setting up a worksheet only for yourself, you can simply leave an empty cell for this purpose. To check it, just type in an x or any other character. Then use a formula with the =isblank() function to make the contents of that cell affect the rest of the spreadsheet. But you might want something more mouse-friendly--especially if you're designing a spreadsheet for other people. I've tested the technique below on Excel 2007, 2010, and 2013. I'm not sure about earlier versions. You can insert checkboxes on Excel's Developer tab. Unfortunately, that tab is hidden by default. To make it visible in Excel 2010 or 2013, click the File tab and select Options. ClickCustomize Ribbon. You'll see two lists. Make sure that the one on the right is titled Main Tabs. Check Developer.

mSpy is a mobile monitoring app that allows you to track every detail of the target cell phone's activities. This application is easy to use and boasts a wide range of features that make it the best cell phone tracker on the market.

Shop Warehouse Pro for electronics, computers, appliances, cell phones, video games & more. Choose free shipping or same day in-store pickup on thousands of items.

Microsoft Word's table templates are great timesavers. With them, you can quickly apply your own custom formatting to any table in Word. Here's how to create your own table style and save it as a template. The easiest way to create your own table template is to start with one of Word's built-in table styles and then tweak it to your preferences. Go to the Insert tab and click Table. insert table - www.office.com/setup Mouse over the squares in the table grid to select the number of columns and rows you want in the table. Click on the last square to insert the table. Word will now switch you to the Design tab for formatting the table. Click inside the table. Select a style from the Table Styles gallery and take note of the style name. You'll need the name in the steps below. table style - www.office.com/setup table style gallery - www.office.com/setup Click the down arrow next to the Table Styles and select New Table Style. table style new - www.office.com/setup Give this table style a new name. table style create - www.office.com/setup Select the table style you want to base yours on in the dropdown box next to "Style based on" option. table style create select - www.office.com/setup Select your formatting options. For example, you can change the font and font style, change the border and cell colors, and change the text alignment. table style options - www.office.com/setup For additional formatting options, click the Format button at the bottom left of the window. table style format - www.office.com/setup Select "New documents based on this template" so the table style will be available in future Word docs. table style newdocs - www.office.com/setup11. Click OK.

WWW.OFFICE.COM/SETUP BLOGS: USING THE FORMAT PAINTER IN POWERPOINT AND WORD www.office.com/setup Blogs: Themes can be a great way to make your PowerPoint presentation or Word document look nice, but sometimes you might want to add custom design elements to your project. Custom formatting can be tedious, though, especially when you're doing a lot of it. For instance, take this PowerPoint slide. Let's say you've applied a series of effects to the photo on the left, and now you'd like to do the same to the photo on the right. Screenshot of Microsoft PowerPoint - www.office.com/setup You could try to remember all of the effects applied and apply them to the second photo as well-or you could save some time and use the Format Painter. The Format Painter is a tool in Word and PowerPoint that lets you copy all of the formatting from one object and apply it to another one. Think of it as copying and pasting for formatting. USING THE FORMAT PAINTER Select the object with the formatting you want to copy. Screenshot of Microsoft PowerPoint - www.office.com/setup Click the Format Painter icon. It may be located in a slightly different place, depending on your version of Office, but it always looks like a paintbrush. Screenshot of Microsoft PowerPoint - www.office.com/setup Select the object you want to apply the formatting to. The object will be formatted. Screenshot of Microsoft PowerPoint - www.office.com/setup See? Simple! That was much quicker than applying the individual effects one at a time. If you want, you can even use the Format Painter to apply the formatting to multiple objects. Just double-click the Format Painter icon instead of clicking it once. Screenshot of Microsoft PowerPoint - www.office.com/setup Even though weonly looked at using the Format Painter for photos in PowerPoint, you can use it for anything you can apply formatting to in Word or PowerPoint. This includes text, table cells, and shapes. Once you start using it, you'll be surprised how often

ACCESS 2016: DESIGNING A SIMPLE QUERY MARCH 27, 2017 TRAINING / WWW.OFFICE.COM/SETUP ADMIN LEAVE A COMMENT WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION www.office.com/setup Blogs: The real power of a relational database lies in its ability to quickly retrieve and analyze your data by running a query. Queries allow you to pull information from one or more tables based on a set of search conditions you define. In this lesson, you will learn how to create a simple one-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 more about designing a simple query in Access. WHAT ARE QUERIES? Queries are a way of searching for and compiling data from one or more tables. Running a query is like asking a detailed question of your database. When you build a query in Access, you are defining specific search conditions to find exactly the data you want. HOW ARE QUERIES USED? Queries are far more powerful than the simple searches or filters you might use to find data within a table. This is because queries can draw their information from multiple tables. For example, while you could use a search in the customers table to find the name of one customer at your business or a filter on the orders table to view only orders placed within the past week, neither would let you view both customers and orders at once. However, you could easily run a query to find the name and phone number of every customer who's made a purchase within the past week. A well-designed query can give information you might not be able to find out just by examining the data in your tables. When you run a query, the results are presented to you in a table, but when you design one you use a different view. This is called Query Design view, and it lets you see how your query is put

WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION www.office.com/setup Blogs: Access offers several options that let you design and run queries that return exactly the information you're looking for. For instance, what if you need to find out how many of something exists within your database? Or what if you would like your query results to automatically be sorted a certain way? If you know how to use query options in Access, you can design almost any query you want. In this lesson, you'll learn how to modify and sort your queries within Query Design view, as well as how to use the Totals function to create a query that can perform calculations with your data. You'll also learn about additional query-building options offered in Access. 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 modifying queries. MODIFYING QUERIES Access offers several options for making your queries work better for you. In addition to modifying your query criteria and joins after you build your queries, you can choose to sort and hide fields in your query results. TO MODIFY YOUR QUERY: When you open an existing query in Access, it is displayed in Datasheet view, meaning you will see your query results in a table. To modify your query, you must enter Design view, the view you used when creating it. There are two ways to switch to Design view: On the Home tab of the Ribbon, click the View command. Select Design View from the drop-down menu that appears. Switching to Design View with the View command on the Ribbon - www.office.com/setup In the bottom-right corner of your Access window, locate the small view icons. Click the Design View icon, which is the icon farthest to the right. Switching to Design View using the View Icon - www.office.com/setup Once in Desig

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: Microsoft Office www.office.com/setup Blogs: Windows 10 has grabbed the attention of social media and customers alike more so because it is a crucial operating system for Microsoft after the debacle of Windows 8 and a not so great reception for Windows 8.1. But, Microsoft has another major product on their cards now, Office, which enhances the Windows productivity of five major products into a system of applications. With Office 2016, Microsoft plans to build from scratch, a mobile and cloud first approach which is customer centric and doesn't only focus on web compared to Office 365 and 2013. Office 2016 has recently been launched on September 22, 2015. www.office.com/setup The Cost factor The first and the most important thing we look at during major software products and updates is the price tag that comes along with it as there are so multiple updates for major software and it is not feasible to go through each and every revision. The all new Office 2016 suite is free for customers on mobile and tablets (conditions apply) and pretty cheap at $145 for "Office Home & Student 2016" and the RRP version of the same is priced at $165, along with subscription version of the suite (Office 365 Personal) at about $70 per year. Built for collaboration Office suite has changed how businesses operate and more focus is laid on connectivity and collaboration of projects. So, the latest offering from Microsoft, Office 2016 is emphasized on collaborations among spread out team members who may never work in the same office environment, but easily enhance productivity by accomplishing a major task that took a week to get it done. Touch centric user interface If you have used the Office for Windows 10, it is quite evident that Microsoft has given a universal app style for the apps and a touch friendly UI which is more familiar to the iPad owners. For instance, in Word, Microsoft lays focus on providing touch friendly controls for ease of