This is an interesting way to add a fun contact sheet to your webpage. I havent tried the code yet to see if it works but the site provides everything to build your own. I would like to add something like this to my site.
So you want rounded instead of sharp corners? This trick should help you with that. I'm looking for ways to make my page look smoother and more polished, so I think this should help. I'm trying to use this trick for my Zen Garden CSS page.
This is a good code to know for the future. HR means Horizontal Rule. You can use these dividers anywhere on your site to divide content. It is similar in style to the banners I bookmarked previously. However, I don't think they can be used as dividers between content, but if they can I'm sure you need to know what HR means.
This article, written for the Design Shack website, shows how to code for multiple columns using CSS3. I expect my first site to have just two columns, but adding a third may be in the cards in the future. I expect to impement these ideas in the near future.
This is a really cool way to cheat. You can type in any information you want to be added to a list where a small empty box appears to the left. Here, the viewer of your page can check which ever open box they want that appears on your site. It does it all for you! Just copy and paste the code into your html.
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: 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
In this tutorial, you will lean a quick way to calculate percentages in Excel, find the basic percentage formula and a few more formulas for calculating percentage increase, percent of total and more.
Calculating percentage is useful in many areas of life, whether it is restaurant tipping, reseller commission, your income tax or interest rate. Say, you've been lucky enough to get a 25% off promotion code on a new plasma TV. Is this a good deal? And how much will you eventually have to pay?
In this tutorial, we are going to explore a few techniques that will help you efficiently calculate percent in Excel and learn the basic percentage formulas that will take the guesswork out of your calculations.
Yana Terukhova is a Product Marketing Manager on the Microsoft Visio team.
Visually displaying always up-to-date information on clearly laid out diagrams helps to communicate information effectively. In this post, we will see how to connect data from external sources to a diagram.
Linking data to Visio diagrams was first introduced in 2007 and has been overwhelmingly popular. We've improved the functionality since then and the capability has become increasingly more powerful. Associating data with shapes on a diagram does not require any code. There's a simple wizard which guides you through linking your data source to your diagram. Once you've linked data to diagram shapes, apply data graphics to shapes-text, data bars, icons, or color by value conditional formatting-to visually display numerical data. The important point here is that data-linked diagrams are dynamic; the data graphics change when data is refreshed in the source (like Excel).
As announced earlier today, over the next few days we are releasing an update to Microsoft account. For people who use Outlook.com, this includes a number of new features such as two-step verification, the ability to sign in with an alias and new international domains for your email address.
OPTIONAL TWO-STEP VERIFICATION HELPS KEEP YOU MORE SECURE
You can now choose to enable two-step verification for your entire account. Two-step verification is when we ask you for two pieces of information when you sign in to your account-your password plus a code sent to a phone or email that you gave us as security info. Many of you have asked for this and we're delighted to be able to offer this capability.
Two-step verification is a great way to add extra protection to your account. Once you've enabled two-step verification, even if a criminal gets your password (for example, through malware on a friend's machine that you used, or if you use the same password for another service that gets breached) they can't access your account.
You can read more about two-step verification here, or just start setting it up at https://account.live.com/proofs/Manage -it only takes a few minutes.
SIGN IN WITH ANY ALIAS ON YOUR ACCOUNT
We've heard from a lot of you that you love using Outlook.com but you wish you had more flexibility signing in. Many of you have added an email alias to your account, but you can't use the alias to sign in to your account. Previously the only option was to permanently rename your account, which is a hassle and requires you to reset certain devices.
With this release, you can now sign in with any alias that has been added to your account. We've also simplified the experience of adding and managing aliases, with better advice on when you should add an alias vs. renaming your primary alias.
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.
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: 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
www.office.com/setup Blogs: Today marks the general availability of Office 2016 for Windows, a suite of desktop applications that together with new mobile and web apps pushes Microsoft's new vision for PC-based productivity. Office 2016 is available immediately to Office 365 subscribers, as well as to individuals who would prefer to buy the software in standalone form.
"We see Office 2016 as being just as important as the first release of Office," Microsoft group program manager Shawn Villaron told me in a briefing last week. "In the early days, Office was about bringing really important tools together to empower the individual for personal productivity. That was the way people wanted to work at that time. And for 20 to 30 years, Office fit right in. Today, things are changing. More people collaborate on work as groups and teams, so Office 2016 represents the change from personal productivity to team productivity."
And that, really, is Office 2016 in a nutshell. If you're a typical information worker, student, or other person in need of standard productivity tools, Office 2016 of course works fine and represents an obvious and stable evolution from the Office version you're currently using. But the real meat in this release-now and going forward, as Office will of course be updated regularly, like Windows 10-is the designed around this new way of working.
Confusing matters somewhat, Office-not Office 2016, but Office generally-is all over the place now. In addition to the classic, full-featured desktop suites on both Windows and Mac, Microsoft has high-quality Office Online web apps, mobile apps for Android, iOS, and Windows/Windows phones-and Office 365-specific solutions that are often available as web apps but are sometimes just integrated into the desktop applications. This ain't your father's Office anymore.
Office everywhere: Microsoft Office is available on virtually any device you care to use. - www.office.com/setup
Office eve
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/setupwww.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
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: ML Gomes is getting a new PC running Windows 8, and wants to know which version of Microsoft Office is best for her needs
Microsoft office - www.office.com/setup Blogs
Which version of Microsoft Office is best with Windows 8? Photograph: Justin Sullivan/Getty Images
Which version of Microsoft Office should I use on Windows 8? I am buying a new laptop and need to use Outlook.
ML Gomes
Microsoft usually brings out new versions of Office to match new versions of Windows, and Windows 8 is no exception. The new Office 2013 is designed to work with Windows 8, and both have a similar modern styling that puts the emphasis on your content rather than Microsoft's software. Also, both are designed to work with cloud (online) services, particularly Microsoft's SkyDrive.
However, other things have changed now that Microsoft is not a software company but a cloud-based "devices and services company". As chief executive Steve Ballmer said last year, this "impacts how we run the company, how we develop new experiences, and how we take products to market for both consumers and businesses."
Under the old system, you could buy a copy of Microsoft Office on DVD, and use it without an internet connection. Under the new system, you buy a Product Key, which is 25 alphanumeric characters long. Entering the code online enables you to download your copy of Office, or activate a free trial version pre-installed on your new PC.
FREE OFFICE WEB APPS
The good news is that under the new system, most home users don't need to pay anything for Microsoft Office: they can use the free, cloud-based service in the form of Microsoft Office web apps. Sign up for an email address at Outlook.com, and you get free web-based email, a contacts book (People), a calendar, and 7GB of online storage in SkyDrive. (Outlook.com has replaced Hotmail, so you can use a Hotmail address, if you already have one.)
Log on, click SkyDrive, and you can create and edit files in the four main Of
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