The Computer Guy
Click on this so I can help!
Microsoft Access
Adobe Acrobat
Allete
Data Visualization
Microsoft Excel
Google Forms
HTML Programming
One Note
Outlook
Microsoft PowerPoint
QuickBooks
SQL
Visio
Microsoft Word
WordPress
Example Files:
vlookup
Sorting_Lists
moving_average
More Charts
Secondary+
Excel Addendum
Excel Addendum Handout
The Excel Document with Macro Or. just copy from this post
Beyond Basics Excel
Pallet Solver
Histogram
Audit
Projections
Advanced Excel 2012
Data
Basics of Spreadsheets2010
Beyond the Basics of Spreadsheets 2010
Advanced Excel 2010
The actual study guide is MOS 2016 Study Guide
Handout Session 1 – Handout
Session 2 – Handout and Data
Session 3 – Handout and Data
Session 4 – Handout and Data
Session 5 – Handout and Data
The actual study guide is MOS 2016 Study Guide
Session 1 Handout and Files
Session 2 Handout and Files
Session 3 Handout and Files
Session 4 Handout and Files
My class stats
The most up-to-date download.
Advanced Excel 2010
Basics Download
Intermediate Download
Excel 2 for UMD 2018
Excel 3 for UMD 2018
Excel 4 for UMD
Monte Carlo Simulation
Data For Class 1 : ExcelUMD
Data For Class 2 : ExcelUMD
Data For Class 3: ExcelUMD
Widgets
Mailing List for Word
Download for this Class
File to download: datepicker
$(function() {
$("#datepicker").datepicker();
});
Or the secondary:
$(function() {
$("#datepicker").datepicker();
$("#datepicker").datepicker("option","showAnim","bounce");
});
The finished file: datepicker_finished
File to download: accordion
$(function() {
$( "#accordion" ).accordion();
});
The finished file: accordion_finished
With Sorting: jqueryaccordion_sort
File to download: jquerytooltip
$(function() {
$( document ).tooltip();
});
Here is another tag with more attributes. In this case, let’s track the mouse:
$(function() {
$( document ).tooltip({
track: true
});
});
Completed: jquerytooltip_completed
File to download: jquerytabs
$(function() {
$( "#tabs" ).tabs();
});
Or the secondary:
$(function() {
var tabs = $( "#tabs" ).tabs();
tabs.find( ".ui-tabs-nav" ).sortable({
axis: "x",
stop: function() {
tabs.tabs( "refresh" );
}
});
});
Completed : jquerytabs_completed
Can be found here
File to download: jqueryautocomplete
$(function() {
var availableTags = [
"Aaron",
"Abe",
"Ben",
"Benjamin",
"Carl",
"Chris",
"Christopher"
];
$( "#tags" ).autocomplete({
source: availableTags
});
});
Completed: jqueryautocomplete_completed
File to download: jQueryDroppable
$(function() {
$( "#draggable" ).draggable();
$( "#droppable" ).droppable({
drop: function( event, ui ) {
$( this )
.addClass( "ui-state-highlight" )
.find( "p" )
.html( "Dropped!" );
}
});
});
Completed: jQueryDroppable_completed
Download File : ajax_example
AJAX 1:
self.xmlHttpReq.open('POST', strURL, true);
self.xmlHttpReq.setRequestHeader('Content-Type', 'application/x-www-form-urlencoded');
self.xmlHttpReq.onreadystatechange = function() {
if (self.xmlHttpReq.readyState == 4) {
updatepage(self.xmlHttpReq.responseText);
}
AJAX 2:
<p>word: <input name="wordtochange" type="text">
<input value="Go" type="button" onclick='JavaScript:xmlhttpPost ("http://donneray.com/class-stuff/ajax2.php")'></p>
<div id="result"></div>
Completed File: ajax_completed
Google Forms Download
Handout 2021
Here is the handout
Here is the sample file
Information for the SQL classes using Sweetlil and Northwind.
Databases
Here is the downloads necessary for the Word Class:
Layouts and Graphics Handout and Download
Formatting and Templates
Word 1
Word 2
Word 3
Advanced Word
Word Macros: Pieces
WordPress I
WordPress II
WordPress III
WordPress IV
Listing Workshops and Lectures
Files for WordPress IV
Social Plugin setup