Home
Videos uploaded by user “Ken Swartwout”
Create a Table of Contents and Table of Figures - Microsoft Word
 
06:27
This tutorial will explain how to create and update a multi-level table of contents and a table a figures using Microsoft Word 2010. We will mark text as Heading 1 and also level 1 as well as apply captions to images. This can all be done under the Reference Tab.
Views: 242293 Ken Swartwout
Create and Format SmartArt - Hierarchy Chart - Microsoft Office 2013
 
07:35
In this video I will demonstrate how to create and format Smart Art in Microsoft Excel 2013. The process is the the same in every other Office product, including Word and PowerPoint. I will create the often time problematic Hierarchy Chart in this video.
Views: 108244 Ken Swartwout
Create Mailing Labels using Mail Merge - Word 2013
 
05:29
In this video, I will illustrate how to create mailing labels using Microsoft Word 2013. This is a specific type of mail merge which relies on an Address Block and an external data source.
Views: 16194 Ken Swartwout
How to Run PHP in XAMPP - Testing PHP Tutorial
 
06:13
This video will describe how and where to save PHP files to run them on a web server, in this case I am using XAMPP. I will discuss file extensions, path names and general PHP syntax. We will discuss phpinfo() as well a a basic test echo. Common mistakes will be discussed
Views: 105762 Ken Swartwout
Connect to MySQL with PHP in XAMPP / Create a new database
 
06:41
This video will discuss how to create a database using PhpMyAdmin and connect to that database using PHP- mysqli. Syntax is discussed as well as some best practices. There a re many outdated tutorials which use mysql - these should not be used interchangeably.
Views: 885131 Ken Swartwout
Simple Horizontal Navigation Bar - HTML/CSS Tutorial
 
12:53
This video will demonstrate the absolute minimum to create a functional horizontal navigation bar using HTML5 and CSS. I will demonstrate how to center the nav bar as well as define the hover state of the links. This video is intended for those with a basic understanding of HTML & CSS who want to create something functional quickly.
Views: 81275 Ken Swartwout
Continuous, Page, Column and Section Breaks - Word 2013
 
07:42
In this video I will illustrate how, why and where to apply breaks in a Microsoft Word document. Breaks are one of the more important concepts in Word. We will look at Section Breaks, Continuous Breaks, Column Breaks, and Page Breaks.
Views: 55015 Ken Swartwout
Word Art in Word 2013
 
03:46
In this video I will show you how to create and modify Word Art in Word 2013. We will talk about rotations, shadows and other text effects.
Views: 39077 Ken Swartwout
Rename Visual Studio VB.Net Project Tutorial
 
06:34
This tutorial will illustrate how to rename a Visual Studio 2010 project. This is also useful for copying one project and modifying it which should include a rename. This will also help to understand the infamous "One or more projects in the solution were not loaded correctly" error message. This fix renames and rebuilds all of the necessary file names and references as well as removes traces of the old name.
Views: 30262 Ken Swartwout
PMT Function - Excel 2013
 
05:13
In this short video, I will explain the PMT (payment) function in Microsoft Excel 2013. The PMT function is used to calculate the amount of a payment on a regular basis with compounding interest. I will apply this function to both a quarterly and monthly scenario.
Views: 13147 Ken Swartwout
3-D References in Excel 2013
 
04:28
In this video I will demonstrate how to create a 3-D cell reference in Excel 2013. These are also known as spear references.
Views: 4657 Ken Swartwout
Tab Stops and Leaders - Microsoft Word 2013 / 2010 / 2007
 
09:23
In this tutorial, I will explain the different variations of tab stops as well as the options for working with leader lines. This video is aimed at intermediate Word users but it would be helpful to anyone working with tab stops.
Views: 29624 Ken Swartwout
What is a Sub Procedure? - Visual Basic .Net Sub Procedures Explained
 
05:29
This video shows the difference between a function and a sub procedure in Visual Basic .NET. Both Functions and Subs are defined and syntax is examined. A function has a return type whereas a sub procedure has no return value.
Views: 15779 Ken Swartwout
Secure Your PHP Connect Script
 
06:08
In this video I will show you how to secure your PHP connect script using requires and a more secure directory. In this video I am connecting to a MySQL database using the mysqli school of functions.
Views: 2600 Ken Swartwout
Select Case - VB.Net - Visual Basic Tutorial
 
06:57
This tutorial will cover all of the basic syntax for creating a select case structure in Visual Basic .Net. This is analogous to a Switch statement is many other languages. I will cover the keywords "To", "Is" and multiple cases.
Views: 19156 Ken Swartwout
PHP Data Validation - Isset - Data Validation Part 1
 
09:53
This video will illustrate why you need to validate form data as well as how to do it. This is the first in a series of videos on data validation. Topics covered are the get method, isset function, warnings and If statements. The next video will discuss data validation beyong the Isset function.
Views: 20760 Ken Swartwout
How to Create Dynamic URLs with PHP and MySQL
 
06:11
In this video, I will use PHP to create dynamic URLs from a MySQL database table. In my bext video, I will illustrate how to process the dynamic URLs and populate the following page.
Views: 14049 Ken Swartwout
Hello World! - Create a Basic Form - Visual Basic - VB.Net 2013
 
03:40
This video will demonstrate how to properly create and name a form with a button and a text box in Visual Studio 2012/2010. This is a basic "Hello World!" program where output is displayed to a text box following a button click.
Views: 15090 Ken Swartwout
How to Salt & Hash a Password Using PHP and MySQL - Create a Login Pt 3
 
05:25
In this video I will discuss and illustrate password storage with salting and hashing using PHP and MySQL. I will use a simple salt and hash with SHA-512 and discuss some security issues. In production, you should strongly consider unique or random salt of your passwords. In the next video, I will discuss the login process.
Views: 13812 Ken Swartwout
IF Statements, ElseIF and Else (Decision Structures) - VB.Net Tutorial
 
08:10
This video will discuss how to properly implement a decision structure using an If statement in VB.Net. I will discuss the implications of setting up your IF incorrectly and explain exactly what is essential and what is not.
Views: 27801 Ken Swartwout
Visual Basic Do While Loop Tutorial Using a List Box - VB.NET Algorithm
 
07:13
This tutorial describes how to use a Do While loop to display data to a list box. We will display the odd numbers between 1 and 50. We will discuss counters and other basic syntax. Watch my next video on Do Until loops.
Views: 55404 Ken Swartwout
Insert Text Boxes and Shapes - Excel 2013
 
03:40
In this video I will demonstrate how to insert text boxes and shapes in Excel 2013. I will also cover some minor formatting as well.
Views: 9095 Ken Swartwout
Explicit Type Conversions (Option Strict) - VB.Net Tutorial - Visual Studio
 
03:49
In this video, I will explain what option strict is and why you need it. I will show how to change project settings as well as how to change default settings. I will also briefly discuss option explicit and explicit type conversions.
Views: 4574 Ken Swartwout
PHP Protection From SQL Injection Attack - Real Escape String
 
06:34
In this video I will illustrate a SQL injection attack and prevention using mysqli_real_escape_string.
Views: 3534 Ken Swartwout
Display Dynamic Database-Driven Content Using PHP and MySQL
 
07:05
In this video I will show you how to display dynamic content from dynamic URLs using MySQL and PHP. It would be helpful to view the the previous video on creating dynamic links.
Views: 11234 Ken Swartwout
Visual Basic VB.Net Function With Parameters Tutorial
 
05:36
This tutorial on functions covers functions with parameters / arguments. We are using Microsoft Visual Basic Express 2010. The tutorial covers basic vocabulary, syntax and implementation of a simple "Hello World" function. There are 6 videos in the series. This function takes a single parameter as opposed to no parameters.
Views: 9143 Ken Swartwout
Visual Basic VB.Net Function Tutorial - Hello World
 
05:52
This is the absolute introductory video in my series on functions using Microsoft Visual Basic Express 2010. The tutorial covers basic vocabulary and implementation of a simple "Hello World" function. There are 6 videos in the series.
Views: 3947 Ken Swartwout
Inspect a Document and Remove Hidden Properties - Excel 2013
 
03:33
In this video, I will show you how to set hidden properties such as Title, Tags, Author, etc. Additionally, I will show you how to inspect for these hidden properties and remove them.
Views: 10800 Ken Swartwout
Custom Number Formats in Excel 2013
 
07:01
In this video, I will illustrate how to create a custom number format in Microsoft Excel 2013. I will talk about formatting positive, negative, zero and non-numeric values. Subscribe for more great videos!
Views: 40131 Ken Swartwout
Display MySQL Query Results in a HTML Table with PHP
 
09:07
In this video I will show you the process for displaying a MySQL query result in a table using PHP.
Views: 27020 Ken Swartwout
Quick Parts & Building Blocks Organizer - Create a Custom Header - Word 2013
 
06:29
In this video, I will introduce you to Quick Parts and the Building Block Organizer in Microsoft Word 2013. We will look at fields, building blocks and then create a pre-defined custom header.
Views: 5384 Ken Swartwout
Future Value Function - Excel 2013
 
03:00
In this video I will show you how to use the Future Value (FV) function to estimate an account balance with regular contributions and compounding interest. Subscribe! Check out my playlists for other great Microsoft Office & Excel video tutorials.
Views: 11470 Ken Swartwout
Sub Procedure Tutorial - VB.Net Introduction to Subs
 
04:26
This is an introductory tutorial on creating a sub procedure using Visual Studio 2010. In this example we generate the infamous, "Hello World!" string through use of a sub procedure (frequently referenced as a sub routine). In the previous video, I examined the difference between a function and a sub. The next 2 videos use subs in more applicable contexts. This video is intended for a beginning or intermediate programming student who wants to understand how to use a sub procedure.
Views: 3725 Ken Swartwout
Find Max from List Box Tutorial Using a While Loop in Visual Basic - VB.Net Algorithm
 
11:40
This video will explain one possible method to find the maximum value from a list box. We will use a Do While loop as well as the Items.Count attribute to achieve our goal. * Fixed audio levels
Views: 15796 Ken Swartwout
Create, Edit and Format Charts in Word 2013
 
05:28
In this video I will show you how to create a chart in Microsoft Word 2013. I will show you how to edit and format your chart as well.
Views: 8166 Ken Swartwout
Concatenate and Proper - Nested Functions -Excel 2013
 
03:44
This video will introduce you to the concatenate and proper functions in Excel. Additionally, I will illustrate how to nest these functions.
Views: 1965 Ken Swartwout
Contains and IndexOf String Functions - VB .Net
 
05:50
In this tutorial I will explain and demonstrate the IndexOf and Contains functions. Contains is a boolean function and it simply returns true or false based on whether the calling function contains the specified Substring. IndexOf returns the position of the first occurrence of the specified Substring - if the Substring is not found it will return -1.
Views: 9742 Ken Swartwout
How to Hash a Password Using PHP and MySQL - Create a Login Pt 2
 
06:29
In this video I will discuss and illustrate password storage using PHP and MySQL. I will hash using SHA-512 and discuss some security issues. In the next video, I will discuss salting a password.
Views: 7349 Ken Swartwout
IsNumeric Data Validation Function in Visual Basic - VB.Net
 
07:28
This video will explore the IsNumeric() function in visual basic .net. This example will also include nested if functions and touch on data conversions as well.
Views: 15353 Ken Swartwout
Declare Variables Syntax in PHP
 
03:44
This is the first video in a series of tutorials for beginning PHP. In this video, I discuss the syntax for creating variables as well as how to display (echo) them to a browser. This series is fragmented into the smallest possible videos to make them easy to digest. I also briefly discuss data types (String, Integer, Double, Boolean). My next video will discuss the various types of variables.
Views: 3724 Ken Swartwout
Visual Basic Do Until Loop Tutorial Using a List Box - VB.NET Algorithm
 
04:52
This tutorial describes how to use a Do Until loop to display data to a list box. We will display the numbers between 1 and 10 using a Do and a While loop. We will discuss counters and other basic syntax. Watch my next video on sentinel loops.
Views: 10506 Ken Swartwout
For Next Loop in Visual Basic Tutorial With a List Box - VB.Net Algorithm
 
05:34
This video will introduce the concept of a For Next loop. We will contrast with a while loop and explain the involved syntax.
Views: 10651 Ken Swartwout
Insert into MySQL Database Table With PHP & Debugging Tips
 
06:55
In this video I will demonstrate how to insert data into a MySQL database using mysqli_query(). I will also show some helpful debugging tips.
Views: 1753 Ken Swartwout
Display a Dynamic Image Gallery With PHP and MySQL
 
07:53
In this video I will show you how to display a gallery of images stored in a MySQL database using PHP. Images will be stored in a tabular format. We will set the src and the alt text for our images dynamically as well.
Views: 21938 Ken Swartwout
Create Random Text - Rand and Lorem Functions - Word 2013
 
02:01
In this video I will show you how to create random text with Rand and Lorem functions in Microsoft Word.
Views: 3488 Ken Swartwout
Creating a Table in PHP - Nested Loop Example
 
08:01
In this video, we will use nested loops to create an HTML table in PHP.
Views: 3189 Ken Swartwout
Connect Script in PHP - Mysqli_connect
 
05:55
In this video, I will discuss connecting to a MySQL database using PHP via the mysqli_connect function. If you choose this method of connection, then you must use the mysqli family of functions to interface with you database as well.
Views: 2624 Ken Swartwout
How to use Goal Seek (WhatIf Analysis) in Excel 2013
 
03:53
In this video I will show you how to use Goal Seek (WhatIf Analysis) in Excel 2013. I will apply this tool to the FV function and demonstrate some common mistakes when using this tool. Subscribe! Check out my playlists for other great Microsoft Office & Excel video tutorials.
Views: 5822 Ken Swartwout
Overloading Functions - VB.Net Example - Currency Converter
 
09:30
This tutorial illustrates how and why you may overload a function or sub procedure. We will use Visual Basic to create a program which converts currency from one unit to another. We will create three different functions with the same name but differing parameters.
Views: 7411 Ken Swartwout
Download and Install Visual Basic 2010 Express .NET - Visual Studio 2010 Express
 
06:05
I will show you how and where to download Microsoft Visual Basic 2010 Express (Free). This is part of the Visual Studio 2010 Suite. The Express version is free but requires registaration after 30 days - registration is free, but it requires a valid email address.
Views: 103704 Ken Swartwout

Jobs applications for 15 year olds in memphis tn
Job cover letter opening greeting
Online admission university of burdwan
What is a cover letter supposed to say
Uw whitewater admissions essay for college