Videos uploaded by user “Ralph Phillips”
Create Mailing Labels in Word using Mail Merge from an Excel Data Set
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: 1886181 Ralph Phillips
Create Access Database - Part 5 (Queries)
Creating queries in an Access database.
Views: 72227 Ralph Phillips
Lock Cells and Protect Sheets in Excel
Protect your complicated formulas in Excel by locking down certain cells, or hiding the formulas used in the cells. Only allow users to edit cells where needed.
Views: 700195 Ralph Phillips
Use Mail Merge to Generate Mailing Labels for 100s of Customers
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: 121694 Ralph Phillips
Making a Gantt Chart in Excel 2007
Using Excel 2007 to create a Gantt chart--a popular project management tool Updated tutorial at https://youtu.be/tnoUhp2ZKxA
Views: 948169 Ralph Phillips
Create a Motion Tween in Flash
Use motion tween settings to create an animation showing a ball bouncing.
Views: 117493 Ralph Phillips
Create Mailing Labels in Word Using Mail Merge from Excel
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: 6549 Ralph Phillips
Excel Functions: AND(), OR() within IF()
Two problems requiring logic functions and() and or() within an if() function. This is a solution to a CIS 235 quiz related to logic functions.
Views: 467142 Ralph Phillips
Use Word Mail Merge to Create Mailing Labels with Clipart Images
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: 21335 Ralph Phillips
PHP Login - Step 3
Views: 39358 Ralph Phillips
Use a combination of concatenate, if, and counta to create a new string depending on a person having a middle initial or not.
Views: 70300 Ralph Phillips
Three-column Web Page Layout Part 3 of 3
Create a fixed or flexible 3-column web page layout with header and footer sections. File: http://www.ralphphillips.com/youtube/layout-demos/three-column.html Donate to Notepad++: http://notepad-plus-plus.org/donate/
Views: 12529 Ralph Phillips
Use the DateDiff Function in an Access Query
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: 66090 Ralph Phillips
Center DIV Containers on a Web Page
Use CSS auto margin to center DIVS and other block elements on a page. Useful for making fixed-width layouts.
Views: 36204 Ralph Phillips
Use Validation Rules and Validation Text in Access
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: 86411 Ralph Phillips
Use a Delete Query in Access
Use a delete query in Access to delete a group of records from a table. Practice while watching with the demo file: http://www.ralphphillips.com/youtube/Access-Action-Queries.accdb
Views: 35333 Ralph Phillips
Create an Update Query in Access
Use an update query to change the value of a numeric field in multiple records.
Views: 94799 Ralph Phillips
Create a Shape Tween in Flash
Use shape tweens to change the color, shape, and/or location of a merge shape.
Views: 113472 Ralph Phillips
Microsoft Word Skills to Make Newsletters
Use some basic features in Word to make a newsletter. Use paragraph borders, page borders, drop caps, columns, and word art instead of templates.
Views: 35988 Ralph Phillips
Use Meta Viewport for Responsive Web Sites
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: 11587 Ralph Phillips
IF Function to Calculate Overtime Pay in Excel
Use the IF function in Excel to determine appropriate overtime pay.
Views: 89620 Ralph Phillips
Intro to AND and OR Functions for Excel
An introductory look at using the AND and OR logic functions in Excel.
Views: 27575 Ralph Phillips
Column-Line 2-Axis Chart in Excel 2007
Create a 2-axis chart in Excel 2007 combining a column chart and line chart
Views: 108117 Ralph Phillips
Create a Movie Clip Symbol in Flash
Create a movie clip symbol with simple frame-by-frame animation.
Views: 24876 Ralph Phillips
Using Background Music with Flash
Start and stop background music with your Flash movie.
Views: 79978 Ralph Phillips
Download / Install Custom Font for PowerPoint Presentations
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: 58512 Ralph Phillips
PHP Login - Step 1
Use PHP to login to a MySQL database.
Views: 83600 Ralph Phillips
VLOOKUP in Excel 2007
Several examples of using the VLOOKUP function in Excel 2007
Views: 913807 Ralph Phillips
Create a Find Unmatched Query in Access
Create a query to find records in one table that don't have entries in a corresponding table. This example looks for clients that have not been serviced during certain period of time.
Views: 18719 Ralph Phillips
HTML5 Structure - Sections and DIVS
Use section tags and div tags to identify key structural parts, or sections, of your web page.
Views: 47241 Ralph Phillips
Create a Crosstab Query in Access
Create a crosstab query in Access to analyze numerical data by multiple categories. This example looks at total billable work performed by employees for several different types of work performed.
Views: 133902 Ralph Phillips
Making a Bubble Chart in Excel
Create a bubble chart in Excel and use a free add-in to make the process of labeling the bubble chart quick and easy. Check out the AppsPro XY Chart Labeler at http://www.appspro.com/Utilities/ChartLabeler.htm
Views: 22308 Ralph Phillips
Cascading Drop-down Navigation Menu with CSS (Part 1)
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: 523763 Ralph Phillips
CSS Transition Basics
Use the CSS Transition property to control how an element can change characteristics over a period of time. Demo File: http://www.sixminutessmarter.com/demofiles/webdev/css-transition-basics.html
Views: 7573 Ralph Phillips
Create a Landscape Page Within a Portrait Word Document
Create a single landscape orientation page within a normal Word document to insert a chart. Then, include footers.
Views: 25153 Ralph Phillips
Left, Mid, and Find Function in Excel 2007
This video demonstrates uses of the left, mid, and find function in Excel 2007 to pull out specific pieces of text from a longer text string.
Views: 44164 Ralph Phillips
Create and Center a Horizontal Navigation Menu
Create a horizonal navigation menul using an unordered list, and center the menu on the page or container
Views: 45232 Ralph Phillips
Form Validation with JavaScript - Check for Multiple Empty Text Fields
Perform form validation and check for multiple empty text fields before the form can be submitted.
Views: 47420 Ralph Phillips
Use Mozilla/SeaMonkey Composer to Make Web Pages
Use Mozilla/SeaMonkey Composer to Make Web Pages
Views: 67019 Ralph Phillips
Retrieve Data from Database with PHP (Part 2)
Use a web form to retrieve specific data from a database.
Views: 47173 Ralph Phillips
Create Access Database - Part 3 (Lookup Data and Forms)
Use the lookup datatype for a field and create a form for faster data entry.
Views: 118672 Ralph Phillips
Use Display Inline-Block CSS to Create a Horizontal Nav Menu
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: 33874 Ralph Phillips
Creating Access Database - Part 1 (Planning a Database)
Explaining the value of a multi-table database by looking at tables of data in a spreadsheet prior to getting into Access.
Views: 208207 Ralph Phillips
Basic Joins in Access Queries
Basic Joins in Access Queries
Views: 14067 Ralph Phillips
Use JavaScript to Hide or Show a Portion of a Form
Use a JavaScript IF Statement to hide the shipping part of an order form if it is the same as the billing part of the form. If statement called by an onclick checkbox. Demo file: http://www.ralphphillips.com/youtube/show-hide-fieldset.html
Views: 27282 Ralph Phillips
Use Excel and the Concatenate Function to Generate E-mail Addresses
Use a combination of functions like if(), counta(), len(), and concatenate() to create complete e-mail addresses when provided usernames and domains for some people. This is a solution to a CIS 235 quiz related to text functions.
Views: 21194 Ralph Phillips
HTML5 Basics - HTML/CSS Part 1 of 2
Use HTML5 to create a basic web page.
Views: 23540 Ralph Phillips
Create a Web Page Layout in Dreamweaver with DIVs - Part 2
Use floats and margins to create a typical 2-column layout with a header and footer section. Then, use a clear property to ensure that the footer is always at the bottom.
Views: 12048 Ralph Phillips