Create a sheet of Avery mailing labels from an Excel worksheet of names and addresses. Use Mail Merge to produced labels. Updated video using over 800 addresses: https://youtu.be/l3pfc6W0LJg Practice Excel file: www.sixminutessmarter.com/demofiles/office/fake-addresses.xlsx Add clipart to your mail merge labels: http://youtu.be/IueE4qm0PZM
Views: 1839201 Ralph Phillips
Use a dataset in Excel to generate hundreds of mailing labels for mass mailings. Updated video: https://youtu.be/l3pfc6W0LJg Sample Addresses: www.sixminutessmarter.com/demofiles/office/fake-addresses.xlsx
Views: 118220 Ralph Phillips
Add clipart images to your mailing labels when performing a mail merge. Good for mailing labels, name badges, conference nameplates. Another video using 100s of addresses: https://youtu.be/l3pfc6W0LJg Sample Addresses: www.sixminutessmarter.com/demofiles/office/fake-addresses.xlsx
Views: 19691 Ralph Phillips
Determine the number of days between two dates using the DateDiff function. Find out which customers had a rented movie out for more than a week. Grab my demo database at: http://www.ralphphillips.com/youtube/Best-Worst-Video-Rental-Database.zip The YouTube video at http://www.youtube.com/watch?v=lz_NEBvi4DI demonstrates using the DateDiff function to determine hours between a start time and end time.
Views: 61948 Ralph Phillips
Use meta viewport as the first step to making responsive web sites. Demo file: http://www.sixminutessmarter.com/demofiles/webdev/viewport1.html Tutorial: http://www.sixminutessmarter.com/responsive-mobile/use-meta-viewport-for-responsive-web-design/
Views: 10473 Ralph Phillips
Set validation rules and validation text for a particular field to improve the quality of data entered. This example requires the data entry person to enter a date matching today's date or earlier.
Views: 81996 Ralph Phillips
Use the lookup datatype for a field and create a form for faster data entry.
Views: 118331 Ralph Phillips
Perform form validation and check for multiple empty text fields before the form can be submitted.
Views: 44748 Ralph Phillips
Use CSS to convert a nested unordered list into a multi-level, drop-down, cascading navigation menu. Centered navigation bar Demo File: http://www.sixminutessmarter.com/demofiles/webdev/cascading-menu-centered.html Fixed header navigation at top of page. Demo File: http://www.sixminutessmarter.com/demofiles/webdev/cascading-menu-fixed.html Center the Nav Menu: https://www.youtube.com/watch?v=XRJq1DqYcPs Block vs No-Block: http://www.ralphphillips.com/youtube/links.html Position Absolute: http://www.youtube.com/watch?v=5S1PtC4wRAg Z-index when Positioning: http://www.youtube.com/watch?v=WisFFeOsMIs
Views: 521986 Ralph Phillips
Create a form with a subform. Then, add a calculated control to show a total on the main form based on information in the subform.
Views: 11511 Ralph Phillips
Download a new font off the web and install it on your computer so that it's available for use in PowerPoint, Word, and other Windows applications.
Views: 55991 Ralph Phillips
Starting with a bunch of names and addresses in Excel, use Word and the Mail Merge feature to produce mailing labels. Demo Excel File: www.sixminutessmarter.com/demofiles/office/fake-addresses.xlsx
Views: 2404 Ralph Phillips
Use display inline-block to treat a block element as inline while still retaining abilities to affect size, margins, and padding like it is a block element.
Views: 31632 Ralph Phillips
Get comfortable with several key topics so that you quickly work with resume templates in Word. Many resume templates use tables and tabs to control layout.
Views: 61234 Ralph Phillips
Create an associative entity (table) and establish 1-to-many relationships amongst the tables
Views: 14003 Ralph Phillips
Explaining the value of a multi-table database by looking at tables of data in a spreadsheet prior to getting into Access.
Views: 207854 Ralph Phillips
Views: 23211 Ralph Phillips
Use basic Excel features like cell shading, format painter, relative and absolute references, and sum and average functions to make a budget.
Views: 12246 Ralph Phillips