Free Web Design, Development and Programming Training and Tutorial Resources




    



February 21, 2011

CSS Guide

Here is a  CSS Guide, from webmonkey, that will help you with your website and page design work. CSS (Cascading Stylesheets) separate the  visual design elements (fonts, colors, margins, and so on) from the structural logic of a web page, and gives you control without sacrificing the integrity of the data, thus maintaining its usability in multiple environments. It also gives the capability for faster downloads, streamlined site maintenance, and instantaneous global control of design attributes across multiple pages.


CSS Guide Contents:
 - How CSS Works
 - Linking Stylesheets
 - CSS Units of Measure
 - CSS Attributes
 - CSS Properties
 - CSS Examples



Tags for this post>>

February 19, 2011

Excel Functions and Formulas Help and Support

Here are 7 Excel resources that explain and show how to use Excel Functions, Formulas, and some Advances Techniques. One of Excel’s most useful features is that it allows users to create custom formulas to perform calculations on their data. Excel also contains built-in formulas called functions that make it easy to perform common calculations on data.


How to Create Custom User Defined Excel Functions
Excel allows you to create custom functions, called “User Defined Functions” (UDF’s) that can be used the same way you would use SUM() or some other built-in Excel function.


Excel Functions
Provides information and examples of Excel spreadsheet functions and topics such as graphs, testing and short cuts.
  - Functions and Calculations
- IF, conditions and selecting
- Formatting Cells and Values
- Dates and Times
- Sharing data with other programs
- Reference, Input and Navigation
- Auditing and other stuff


Excel Function Reference
Create your own worksheet functions
Go with the cash flow: Calculate NPV and IRR in Excel
List of worksheet functions (by category)
Using worksheet functions for quality control
Creating custom functions
Database Functions
Date and Time Functions
Engineering Functions
External Functions
Financial Functions
Information Functions
Logical Functions
Lookup Functions
Math Functions
Statistical Functions
Text and Data Functions


Excelfunctions.net
Basic Excel
Built-In Functions
Text Functions
Logical Functions
Information Functions
Date & Time Functions
Lookup & Reference Functions
Math Functions
Statistical Functions
Database Functions
Financial Functions
Engineering Functions
Excel Vlookup Tutorial
Pivot Table Tutorial
Excel Formulas
Array Formulas
Tips & Tricks
Common Excel Errors
Excel Templates
Excel Macros
Excel VBA Tutorial


Excel Formulas and Functions
Here you will find step by step tutorials, tips and shortcuts on how to use formulas and the common and less common functions available in Excel. Excel 2010 Functions (48)
IF Functions (14)
Count Functions (8)
Date Functions (15)
Logical Functions (4)
Math Functions (13)
Text Functions (10)
Rounding Number Functions (9)
Excel 2003 Functions (20)
Random Number Functions (3)
Trig Functions (5)
Lookup Functions (11)
Statistical Functions (14)
Information Functions (5)
Engineering Functions (1)
Financial Functions (2)
Basic Excel 2007 Spreadsheet Tutorial
This tutorial covers creating a basic spreadsheet in Excel 2007. The topics covered include how to enter data, using formulas and functions, and formatting the spreadsheet.


Excel Function Dictionary
This Excel Function Dictionary contains over 150 examples of functions.


DigDB
Advanced excel tips, Excel tools, Excel reporting applications, and Excel add-ins.



Tags for this post>> | |

February 17, 2011

2 Excel 2003 eBooks

Here are 2 downloadable Excel ebooks, covering Excel 2003 features, tools, and functionality. These are in pdf format.


Microsoft Office Excel 2003 – ebook.pdf

Microsoft_Office_Excel_2003.pdf



Tags for this post>>

February 16, 2011

32 Photoshop Elements Tutorials

Here are 32 free Photoshop Elements Tutorials from photoshopelementsuser.com. This site has many more of these types of tutorials available in their paid member section. These Photoshop Elements tutorials are well written, with screen shots, or videos, to demonstrate and show you how to use the features and tools being described.


3 Digital Backgrounds to Make
Adding a Boken Light Effect
P.E.T.’s Best Tips and Tricks for Photoshop Elements
Introducing Photoshop Elements 9
A Basic Elements Vocabulary
Picture-Perfect Gift Tags
Creating Masks with Threshold Adjustments
Removing Chromatic Aberration with Elements
Faking the “Looking at the Past” effect
Elements 9: New Guided Edit Modes
Elements 9: Easy Layer Masks
Elements 9: Content-Aware Healing
Adding Whimsical Scribbles to a Photo
Getting the Orton Effect
Create a Reusable Photo Frame
Getting the Hipstamatic Look
Introduction to the Editor
Introduction to the Organizer
Importing Your Camera Images into the Organizer
Adobe Bridge: Introduction
Adobe Bridge: Importing Your Photos
Elements 8: Getting True Symmetry in Your Photos
Quick & Easy Calendars From Templates
Adjustment Layer Panels
Photomerge Exposure
Elements 8: Recompose Tool
Elements 8: Updated Organizer (Windows)
Elements 8: The New Look (Part 2)
Elements 8: The New Look



Tags for this post>>

February 12, 2011

Quick Reference Cards for Office 2007 Apps and more

Here are Quick Reference Cards for 7 Office 2007 Applications: Word, Excel, PowerPoint, Outlook, Access, Publisher, and Visio. Also incuded are quick references for Office 2007, Windows Vista, Windows XP, IE 7 and IE8. These references, or cheat sheets, are hosted by customguide, and are available from this google search. They are in pdf format.


Office 2007 Quick Reference Card

Word 2007 Quick Reference Card

Excel 2007 Quick Referenc Card

PowerPoint 2007 Quick Reference Card

Outlook 2007 Quick Reference Card

Access 2007 Quick Reference Card

Publisher 2007 Quick Reference Card

Visio 2007 Quick Reference Card

Windows Quick Reference Card

Windows XP Quick Referenc Card

Internet Explorer 7 Quick Reference Card

Internet Explorer 8 Quick Reference Card



Tags for this post>> | | | | | | | | |

February 11, 2011

7 Office 2003 Quick Reference Cards

Here are Quick Reference Cards for 7 Office 2003 Applications: Word, Excel, PowerPoint, Outlook, Access, Publisher, and Visio. These references, or cheat sheets, are hosted by customguide, and were found on google, doing this search. They are in pdf format.


Word 2003 Quick Reference, Word 2003 Cheat Sheet

Excel 2003 Quick Reference, Excel 2003 Cheat Sheet

PowerPoint 2003 Quick Reference, Cheat Sheet

Outlook 2003 Quick Reference, Outlook 2003 Cheat Sheet

Access 2003 Quick Reference, Access 2003 Cheat Sheet

Publisher 2003 Quick Reference, Publisher 2003 Cheat Sheet

Visio 2003 Quick Reference, Visio 2003 Cheat Sheet



Tags for this post>> | | | | | | |

5 Quick References for Photoshop and Dreamweaver

Here are 3 Photoshop and 2 Dreamweaver Quick References, or Cheat Sheets, hosted by customguide. I found these on google, doing this search. These quick reference cards are in pdf format. Photoshop versions include 6, 7, and CS3 for Mac, and the Dreamweaver versions are 8 and CS3.


Photoshop 7 Quick Reference, Photoshop 7 Cheat Sheet
(3 pages, 905kb)

Photoshop 6 Quick Reference, Photoshop 6 Cheat Sheet
(3 pages, 905kb)

Photoshop CS3 for Mac Quick Reference
(2 pages, 1.01mb)


Dreamweaver CS3 Quick Reference, Dreamweaver CS3 Cheat Sheet
(3 pages, 990kb)

Dreamweaver 8 Quick Reference, Dreamweaver 8 Cheat Sheet
(2 pages, 1.10mb)



Tags for this post>> |

HTML and XHTML Tutorial

Here is a good HTML and XHTML Tutorial, from State University of New York-Albany. The following is from this tutorial’s introduction:

HTML (Hyper Text Markup Language) and XHTML (Extensible Hyper Text Markup Language) are the markup language from which all Web pages are built. Although there are new types of technology and coding options, including PHP, ASP, XML and others, traditional markup language is the place where “all things Web” starts. Some Web editing software publishers claim that it is not necessary to know HTML if you use their programs to build Web pages. However, this is rarely the case. In almost every instance at least some knowledge of HTML and XHTML is helpful.

In this tutorial we will guide you through the basics of writing HTML/XHTML code. It is important to realize that there is no better way to learn and understand the code than to actually write and use it. This tutorial will get you started on your first steps toward becoming knowledgeable about the code. You may download a printable copy of this HTML tutorial here in pdf format (43 pages, 1.08mb). You may expect this tutorial to take about 45 mintues to 1 hour if you work through it quickly. To fully explore it will take 1 hour to 1 1 1/2 hour.


HTML/XHTML Tutorial Contents:

 - About HTML/XHTML
 - Technique
 - Tools
 - Web vs. Print
 - Getting Started
 - Setting Up the Basic Code
 - Adding and Formatting Text
 - Nesting Tags
 - Advanced Text Formatting
 - Color and the Web
 - Headings
 - Lists
 - Links
 - Layout and Tables
 - Advanced Table Formatting
 - Images
 - Putting It All Together
 - Adding An Image
 - Adding A Simple Table
 - Main Body Information
 - Finishing Touches
 - If You Continue On

Most Commonly Used HTML/XHTML Tag List
The most commonly used HTML and XHTML tags are presented on this page in an easy-to-use format.



Tags for this post>> |

February 9, 2011

Acrobat PDF Tutorial

Here is an Adobe Acrobat PDF Tutorial, from the University of Texas, that shows you how to create PDF files using various methods and also how to edit these files. PDF stands for portable document format. A portable document format (PDF) can be read on any computer and any platform (Windows, Mac, Unix). There are a variety of programs which read PDFs, the most common being Adobe applications such as Adobe Acrobat Professional, Adobe Reader, Adobe Designer. PDFs are particularly useful for those in the information fields.  Once a file or document is converted to a PDF, the “look” is preserved exactly as it was intended. This PDF tutorial is also available in pdf format here: PDF Tutorial (12 pages, 481kb).


Tutorial Objectives:

1) You will learn several ways to create static PDFs.  You can:
       – create a PDF by converting a file
       - create PDF by converting multiple files
       - create PDF by converting a website
       - create PDF by scanning a document

2) You will learn basic editing tools in Adobe Acrobat Pro.


Contents of this PDF Tutorial:

Create From One File

Create From Multiple Files

Create by Converting a Website

Create by Scanning a Document

Editing a PDF

Conclusion



Tags for this post>>

Graphics and Multimedia Tutorials

Here are several well done Graphics and Multimedia Tutorials, from the School of Information at the Unversity of Texas. These tutorials cover many applications and areas, such as Digitzing Video, Illustrator, Photoshop, SnagIt, Gimp, Digital imaging, iDVD, i Movie, and Windows Movie Maker.


Audio


Digitization
Graphics
Photos
Video


Tags for this post>> | |
February 8, 2011

Publisher 2007 Quick References and Flashcards

Here are  2 Publisher 2007 Quick References, and 45 Publisher 2007 Flashcards with answers. Each quick reference document lists Publisher tasks or features to be performed along with their corresponding commands or menu items using the Mouse, the Ribbon, the Shortcut Menu, and Keyboard Shortcuts. The first quick reference lists about 85 Publisher 2007 tasks, and the second one details out about 140 tasks.


Publisher 2007 Quick Reference 1  (8 pages, pdf format, 61kb)

Publisher 2007 Quick Reference 2  (9 pages, pdf format, 171kb)


Chapter 1:
Flashcards
Practice Test
Who Wants to be a Computer Genius2?
Wheel of Terms
Crossword Puzzle Challenge

Chapter 2:
Flashcards
Practice Test
Who Wants to be a Computer Genius2?
Wheel of Terms
Crossword Puzzle Challenge

Chapter 3:
Flashcards
Practice Test
Who Wants to be a Computer Genius2?
Wheel of Terms
Crossword Puzzle Challenge

Chapter 4:
Flashcards
Practice Test
Who Wants to be a Computer Genius2?
Wheel of Terms
Crossword Puzzle Challenge

Chapter 5:
Flashcards
Practice Test
Who Wants to be a Computer Genius2?
Wheel of Terms
Crossword Puzzle Challenge

Chapter 6:
Flashcards
Practice Test
Who Wants to be a Computer Genius2?
Wheel of Terms
Crossword Puzzle Challenge



Tags for this post>> |
February 3, 2011

Office 2010 References, Videos, and Guides

Here are References, Videos, and Guides for all of the Office 2010 Applications: Word, Excel, Outlook, PowerPoint, Publisher, Access, InfoPath, OneNote, Project, Visio, and Sharepoint. These tutorials and learning documents will help you become productive with this new version of Office from Microsoft. To view the guides from Microsoft, you may need to allow blocked content.


Microsoft Word 2010 References and Videos:

Word 2010 Quick Reference 2010 Guide from Microsoft  (mirror)

Microsoft Word 2010 Higlights

MS Word 2010 – First Look

Word 2010: Menu to Ribbon Reference workbook
Find the new locations of Word 2003 menu and toolbar commands in Word 2010. This cross references the old commands to the new ones in Word 2010.

Word 2010 Guide from Microsoft


Microsoft Excel 2010 References, Videos, and Guide:

Excel 2010 Quick Reference 2010 Guide from Microsoft  (mirror)

MS Excel 2010 Highlights

Excel 2010 – Sparklines and Slices

Slices for Pivot Tables or Cube Functions in Excel 2010

Excel 2010: Menu to Ribbon Reference workbook
Find the new locations of Excel 2003 menu and toolbar commands in Excel 2010. This cross references the old commands to the new ones in Excel 2010.

Excel 2010 Guide from Microsoft


Outlook 2010 References, Videos, and Guide:

Outlook 2010 Quick Reference 2010 Guide from Microsoft  (mirror)

Outlook 2010 Highlights

Outlook 2010 – First Look

Microsoft Outlook 2010 – more features
Mail messages in conversation view with mail threads.

How to see your important stuff in Outlook 2010

Business Card in 90 Seconds

Outlook 2010: Menu to Ribbon Reference workbook
Find the new locations of Outlook 2003 menu and toolbar commands in Outlook 2010. This cross references the old commands to the new ones in Outlook 2010.

Outlook 2010 Guide from Microsoft


PowerPoint 2010 References, Videos, and Guide:

PowerPoint 2010 Quick Reference 2010 Guide from Microsoft  (mirror)

PowerPoint 2010 Highlights

Microsoft PowerPoint 2010 – more features

PowerPoint Animations & Transitions (and Reading view) Tutorial

How to improve your PowerPoint with SmartArt

Video Rocks in PowerPoint 2010

PowerPoint 2010: Menu to ribbon reference workbook
Find the new locations of PowerPoint 2003 menu and toolbar commands in PowerPoint 2010. This cross references the old commands to the new ones in PowerPoint 2010.

PowerPoint 2010 Guide from Microsoft


Microsoft Publisher Reference, Video, and Guide:

Publisher 2010 Highlights

Publisher 2010: Menu to ribbon reference workbook
Find the new locations of Publisher 2007 menu and toolbar commands in Publisher 2010. This cross references the old commands to the new ones in Publisher 2010.

Publisher 2010 Guide from Microsoft


Microsoft Access 2010 Reference, Video and Guide:

Access 2010 Highlights

Access 2010: Menu to Ribbon Reference workbook
Find the new locations of Access 2003 menu and toolbar commands in Access 2010. This cross references the old commands to the new ones in Access 2010.

Access 2010 Guide from Microsoft


InfoPath 2010 Reference and Guide:

InfoPath 2010: Menu to ribbon reference workbook
Find the new locations of InfoPath 2007 menu and toolbar commands in InfoPath 2010. This cross references the old commands to the new ones in InfoPath 2010.

InfoPath 2010 Guide from Microsoft


OneNote 2010 Reference and Guide:

OneNote 2010: Menu to Ribbon Reference workbook
Find the new locations of OneNote 2007 menu and toolbar commands in OneNote 2010. This cross references the old commands to the new ones in OneNote 2010.

OneNote 2010 Guide from Microsoft


Project  2010 Reference and Guide:

Project 2010: Menu to Ribbon Reference workbook
Find the new locations of Project 2007 menu and toolbar commands in Project 2010. This cross references the old commands to the new ones in Project 2010.

Project 2010 Guide from Microsoft


Visio 2010 Reference and Guide:

Visio 2010: Menu to Ribbon Reference workbook
Find the new locations of Visio 2007 menu and toolbar commands in Visio 2010. This cross references the old commands to the new ones in Visio 2010.

Visio 2010 Guide from Microsoft


SharePoint 2010 References:

SharePoint Server Ribbon Reference workbook
Find the new locations of SharePoint Server 2007 menu and toolbar commands in SharePoint Server 2010. This cross references the old commands to the new ones in Sharepoint Server 2010.

SharePoint Designer 2010: Menu to ribbon reference workbook
Find the new locations of SharePoint Designer 2007 menu and toolbar commands in SharePoint Designer 2010. This cross references the old commands to the new ones in Sharepoint Designer 2010.



Tags for this post>> | | | | | | | |

February 1, 2011

61 Adobe Acrobat 9 Tutorials

Here are 61 of the latest Adobe Acrobat 9 Tutorials, hosted by Adobe. These Acrobat tutorials will show you how to use Acrobat more effectively, become more productive with it; and you’ll learn how to make the most of Acrobat’s tools and features. The “Getting Started” tutorials will help you to get up to speed with Acrobat, and the “Learn More” section will help you if you are a more experienced user. These tutorials are in video and pdf format. Tuttorials marked with an asterisk* are available only in Adobe Video Workshop, to locate these videos click the link to open Video Workshop, choose Acrobat 9 Family from the Select A Product list, and scroll through the Title list.


Acrobat 9 Tutorials Table of Contents:

Getting Started

Introduction and PDF workflows:
 - Introducing Acrobat 9 Pro
 - What is Acrobat?
 - Sharing your ideas
 - Working with others
 - Simplifying form creation
 - Business workflow
 - Creative workflow

Creating PDFs:
 - Creating PDFs from 2D content
 - Creating PDFs from 3D content*
 - Combining documents into a single PDF
 - Creating PDFs from window capture, screen capture or selection
 - Web capture & compare
 - Achieving accurate content in your PDF
 - Ensuring your PDF conforms to a PDF standard
 - Overview of PDF Portfolios
 - Customizing a PDF Portfolio template
 - Combining files into a PDF Portfolio
 - Enabling usage rights for Adobe Reader

Editing PDFs:
 - Editing/updating files within a PDF Portfolio
 - Adding headers/footers to your PDF documents
 - Adding watermarks to your PDF documents
 - Optimizing your PDF document


Learn More

Creating and editing PDFs—advanced techniques:
 - Comparing two PDF documents
 - Working with layers
 - Bates numbering
 - Using batch processing to automate tasks in Acrobat*
 - Archiving e-mails as PDF from Microsoft Outlook*
 - Working with geospatially-enabled PDFs
 - Scan & OCR—paper to PDF*
 - Using Adobe Presenter to augment PPT presentations

Working with forms:
 - Creating basic fillable forms (using Form Wizard)
 - Automating form field creation
 - Understanding Acrobat Tracker for forms
 - Adding formatting and calculations to PDF forms*
 - Editing forms in Acrobat*
 - Acrobat and InDesign forms workflow

Adding multimedia and interactivity:
 - Adding interactivity to your PDF document (links and bookmarks)
 - Adding multimedia to your PDF document
 - Attaching a Flash widget to PDF documents
 - Insert Vvideo (i.e. FLV) into Word or PowerPoint through PDFMaker*

Collaboration, review, and commenting:
 - Document collaboration using shared reviews
 - Collaboration using shared reviews via Acrobat.com
 - Co-navigating PDF documents using Acrobat.com
 - Send documents for review by e-mail
 - Enable for commenting in Adobe Reader
 - Initiating a shared review using Microsoft SharePoint
 - Setting up Microsoft SharePoint for a shared review with Adobe Acrobat 9
 - Using familiar commenting tools
 - Commenting on video in Acrobat
 - Combining comments
 - Initiating a data collection workflow using Acrobat.com*

Security:
 - Protecting your PDF using a password
 - Signing PDF files and creating appearances
 - Creating a self-signed digital ID
 - Using examine document to remove sensitive information
 - Remove sensitive information using redaction tools
 - Create secure attachments using security envelopes*

Exporting, printing, and sharing:
 - Exporting PDF files to Office formats
 - Printing documents
 - Preflighting for creative pros
 - Sharing your document on Acrobat.com*



Tags for this post>>

Office 2010 Tutorials and Videos

Here are some tutorials, references, and videos for learning how to use Office 2010, Microsoft’s latest version of Office. These will help you become familiar with Office 2010′s interface, Ribbon, Backstage (File menu), and more.


Office 2010 Quick Reference Guide (mirror)

Introducing Backstage
The File tab which opens the Microsoft Office Backstage view replaces the Microsoft Office Button and the File menu used in earlier releases of Microsoft Office.

Learn About the Office 2010 Ribbon

Office 2010 Menu and Toolbar Commands


Microsoft Office 2010 Videos:

 - What’s New in Office 2010?

 - What Can You Do in Office 2010?

 - First Look at Office 2010
   A look at Word, Excel, PowerPoint, and Outlook.

 - Overview of Word, Excel, Outlook & PowerPoint 2010

 - Microsoft Office Backstage (File menu)

 - File This – A Tour of the Office 2010 Backstage

 - How to Work with the Ribbon

 - How to shortcut your shortcuts with a click (right click shortcut menus)



Tags for this post>>