Skip to content

Donneray Consulting

The Computer Guy

Menu
  • Home
  • Here Be Notes
  • Pay Here
Menu

Contact Me

Help!

Click on this so I can help!

Remote Desktop

Classes

Microsoft Access

Adobe Acrobat

Allete

Data Visualization

Microsoft Excel

Google Forms

HTML Programming

One Note

Outlook

Microsoft PowerPoint

QuickBooks

SQL

Visio

Microsoft Word

WordPress

Cool Projects

ABX Tracker

See More

Northwind Catalog

See More

Recent Posts

  • Download
  • Handout
  • Creating a new folder with YYYY-MM-DD
  • Rules of Programming
  • About Faxes

Recent Comments

No comments to show.

Archives

  • January 2022
  • April 2021
  • October 2015
  • October 2014
  • December 2012
  • October 2012
  • September 2012
  • August 2012

Categories

  • Uncategorized
©2023 Donneray Consulting | Built using WordPress and Responsive Blogily theme by Superb

Microsoft Access

Handout

Northwind 2020

Excel Files for adding to DB

Northwind and Sweetlil

Visual Basic

Nwind2013

Stuff

Adobe Class 1

Handout

Files

Adobe Class 2

Handout

Working with Data

Files

Excel

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

Handouts

Basics of Spreadsheets2010
Beyond the Basics of Spreadsheets 2010
Advanced Excel 2010

Excel Core

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

Excel Expert

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

Linking and Templates

Handout
File

Excel Stats

My class stats
The most up-to-date download.

Excel for Grand Marias

Advanced Excel 2010
Basics Download
Intermediate Download

Excel for St. Louis County

Working with Data

Handout and File

Charts

Handout and File

Functions

(Handout and File)

Excel at UMD

Handouts

Excel 2 for UMD 2018
Excel 3 for UMD 2018
Excel 4 for UMD
Monte Carlo Simulation

Data

Data For Class 1 : ExcelUMD
Data For Class 2 : ExcelUMD
Data For Class 3: ExcelUMD
Widgets
Mailing List for Word

HTML Programming

Download for this Class

JQueryUI Statements:

DatePicker JQuery:

File to download: datepicker

$(function() {
    $("#datepicker").datepicker();
});

Or the secondary:

$(function() {
    $("#datepicker").datepicker();
    $("#datepicker").datepicker("option","showAnim","bounce");
});

The finished file: datepicker_finished

Accordion JQuery:

File to download: accordion

$(function() {
  $( "#accordion" ).accordion();
});

The finished file: accordion_finished

With Sorting: jqueryaccordion_sort

Tooltip jQuery:

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

Tabs jQuery:

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

Completed Form

Can be found here

AutoComplete jQuery:

File to download: jqueryautocomplete

$(function() { 
var availableTags = [ "Aaron", "Abe", "Ben", "Benjamin", "Carl", "Chris", "Christopher" ]; $( "#tags" ).autocomplete({ source: availableTags }); });

Completed: jqueryautocomplete_completed

Droppable

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

AJAX

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

Excel

Advanced Excel 2010
Intermediate Excel 2010
Basic Excel 2010

PowerPoint

Advanced Powerpoint 2010
Basic Powerpoint 2010

Word

Advanced Word 2010
Intermediate Word 2010
Basic Word 2010

Access

Basics of Database Administration
Beyond the Basics of Database Administration

Bootcamp

Bootcamp download

Data files:
Here is the data file for Data Visualizations.
Here is the handout for Data Visualizations.
Here are the two stock price histories since 2000:
apple
microsoft
This is the standard that you are to use throughout your report.
FINAL MASTER REIF reportv2 is the report from last year.

Google Forms Download

Here is the handout (new 2021-11-01)
And these are the files to go with the handout.

Basics of Microsoft Outlook
Advanced Users Manual

Basics of Presentations2010
Data

Data2
Beyond the Basics of Presentations 2010
Training file

far_cry

Handout 2021
Here is the handout
Here is the sample file

Here is the file from last class.
Here is the homework.

Information for the SQL classes using Sweetlil and Northwind.
Databases

Here are the Visio Files.
Here is the newest version of the handout.

Here is the downloads necessary for the Word Class:

Handouts

Layouts and Graphics Handout and Download
Formatting and Templates

Class Files:

Word 1
Word 2
Word 3
Advanced Word
Word Macros: Pieces

St. Louis County:

Handout
Cookbook4
Cookbook5

Class Handouts:

Word 1 Handout
Word 2 Handout
Word 3 Handout

Handouts for:

WordPress I
WordPress II
WordPress III
WordPress IV

Listing Workshops and Lectures
Files for WordPress IV
Social Plugin setup

Social Plugins:

  • Advanced Code Editor (By BaInternet)
  • Facebook Page Publish (By Martin Tschirsich)
  • FB LinkedIN Resume (By Fabrizio Balliano)
  • GD LinkedIn Badge (By Milan Petrovic)
  • LinkedIn SC (By Guillaume Viguier-Just)
  • Pintrest RSS Widget (By bkmacdaddy designs)
  • Status Updater (By Francesco Castaldo)
  • Twitter Goodies Widgets (By NetWebLogic LLC)
  • WP to Twitter (By Joseph Dolson)