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: 1802909 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: 115785 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: 18385 Ralph Phillips
Use the lookup datatype for a field and create a form for faster data entry.
Views: 118047 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: 59086 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: 9725 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: 78745 Ralph Phillips
Perform form validation and check for multiple empty text fields before the form can be submitted.
Views: 43216 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: 517188 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: 52875 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: 30037 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: 11124 Ralph Phillips
Use relative and absolute position to put elements of your page exactly where you want them.
Views: 36808 Ralph Phillips
Create a Print-friendly Stylesheet for Printable Web Pages
Views: 9912 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: 12137 Ralph Phillips
Views: 20866 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: 207507 Ralph Phillips
Use Flash CS4 to create a simple scene animation and then use Dreamweaver to include it into a web page.
Views: 149033 Ralph Phillips
Create an associative entity (table) and establish 1-to-many relationships amongst the tables
Views: 13733 Ralph Phillips