Here are several good Excel Tutorial Videos at free-training-tutorial.com that will help you master using important Excel features, such as editing cells, rows, and columns; using the sum, average, countif, and VLOOKUP functions; using Excel formulas; creating charts and graphs; and working with filters and pivot tables. They give you step-by-step and easy-to-follow directions for managing and presenting your data with Excel. Each of the links below contain several Excel video training tutorials.


Excel Basics:
 - Formatting Cells
 - Worksheets
 - Edit Cells
 - Rows and Columns
 - Find and Replace
 - The Fill Handle

Excel Calculations:
 - Sum, Average, Countif Functions
 - Quick Functions
 - The IF Statement
 - VLOOKUP Function
 - Excel Formulas

Special Excel Features:
 - Charts and Graphs
 - Sort Data
 - Filter Data
 - Conditional Formatting
 - Pivot Table  
 - First Aid

Popularity: 1% [?]

Here is Psdtut's Photoshop Wiki, which is an ongoing wiki for learning how to use Photoshop, offering Photoshop Tutorials, Tips, and Resources for the beginner and more advanced users. The tutorials covering many features and tools of Photoshop are linked below. This site also provides a comprehensive list of Photoshop Shortcuts and a section being worked on that teaches and explains Photoshop's Tools. Also, here are all of their Photoshop Articles.


Photoshop Tutorials from wiki.psdtuts.com

 - Actions
 - Adjust Sharpness and Blur
 - Camera Raw
 - Channels
 - Color
 - Color Modes
 - Color Settings
 - Correct Image Distortion and Noise
 - Create Images
 - Create Panoramic Images
 - Crop Images
 - Delete and Extract Objects
 - Draw
 - Filters
 - Getting Started
 - Grid
 - Guides
 - HDR Images
 - Image Size and Resolution
 - Import Images
 - Keyboard Shortcuts
 - Layers
 - Liquify Filter
 - Optimize Images
 - Options Bar
 - Paint
 - Palettes
 - Performance Tips
 - Photomerge
 - Plugins
 - Preferences
 - Preset Manager
 - Print
 - Remove the Background
 - Retouch and Transform
 - Rotate an Image
 - Rulers
 - Save and Export
 - Selection
 - Tool Presets
 - Transform Objects
 - Type
 - Undo Changes
 - Vanishing Point
 - Viewing Options
 - Video and Animation
 - Web Graphics
 - Workspace

Popularity: 77% [?]

Here are some good technical Excel 2003 Tutorials and Articles from Microsoft. These will help you learn the technical side of Excel, including how to use XML functionality with Exel, Map Data, use Windows Forms, create a Report Templare, and write macros using Visual Basic for Applications (VBA). Also, here is Chapter 20: Creating Advanced User Forms, from the book "Microsoft Office Excel 2003 Programming Inside Out".


 - Add XML Functionality in Microsoft Office Excel 2003 from Microsoft Visual Basic .NET
 - Creating Charts in Microsoft Office Excel 2003 Using Visual Basic for Applications Code
 - Creating XML Mappings in Excel 2003
 - Different Ways of Using Web Queries in Microsoft Office Excel 2003
 - How Excel 2003 Infers XSDs When Importing XML Data
 - Microsoft Office Excel 2003 Preview
 - Part 1: Automating the XML Data Mapping Process in Excel 2003
 - Part 2: Mapping XML from SQL Server to a Single Cell in Excel 2003
 - Part 3: Replicating Excel 2003 Formulas to SQL Server
 - Populating an Excel 2003 Worksheet with Multiple Related Records from a Windows Form
 - Super-Easy Guide to the Microsoft Office Excel 2003 Object Model
 - Understanding Security for Add-ins and VBA Macros in Excel 2003
 - Using the Excel 2003 XML Tools Add-in Version 1.1
 - Using the Excel XML Toolbox for Microsoft Office Excel 2003
 - Using Visual Basic and ASP with XML to Generate Excel 2003 Workbooks
 - XML and Microsoft Office Excel 2003: Creating an Expense Report Template

Popularity: 100% [?]

I have posted information about a great Free PHP Programming Book on our other free computer training blog at intelligentedu.com. If you need or are looking for instruction with coding PHP on your web pages, here is Practical PHP Programming, a free online book covering how to program using PHP. The objective of this PHP book is to have fun while you learn how to program web pages and sites using PHP, even if you have not coded with PHP before. 


Table of Contents of Practical PHP Programming:

1. Introducing PHP
2. Simple variables and operators
3. Functions
4. Arrays
5. Object-oriented programming
6. HTML forms
7. Working with files
8. Databases
9. Cookies and sessions
10. Multimedia
11. XML and XSLT
12. Output buffering
13. Java and COM
14. Networks
15. Miscellaneous topics
16. Security concerns
17. Performance
18. Writing PHP
19. Writing extensions
20. Alternative PHP uses
21. Practical PHP
22. Bringing it to a close
23. The future of PHP
24. Choosing an ISP
25. Glossary 

Popularity: 61% [?]

Here are lots of excellent Photoshop Tutorials from Psdtuts.com. These are broken down into several Photoshop topics and functionality, as shown below. Areas covered by category include Designing, Drawing, Photoshop Effects, Photoshop Interface, Photo Effects, Text Effects, and Photoshop Tools and Tips. The latest Photoshop tutorials for each category are linked here.


Photoshop Tutorial Categories at psdtuts.com:

Photoshop Designing Tutorials
 - Create a Sleek Illustration that Fades from Line Art to Color
 - Create and Then Shatter a Grid, while Making a Typographic Poster
 - Design a High Impact Gig Poster Suitable for Screen-Printing
 - 23 Awesome Examples of Design as a Force For Good
 - Designing a Typographic Concept Poster
 - Design a Detailed Compass Icon in Photoshop
 - Create a Custom Mac OSX Style Ring Binder Address Book Icon
 - Make an Inspiring Artistic Poster with Drawn Elements
 - Mascot Design In Real Time Order - the SOSFactory Way
 - Make a Turn of the Century Vaudeville Poster


Photoshop Drawing Tutorials
 - How to Create a Classic Guitar from Scratch In Photoshop
 - New PLUS Tutorial - How to Make 3D Neon Light Typography
 - Design a Shiny Bass Guitar Illustration Using Photoshop
 - How to Illustrate a Wooden Frame on a Wall Scene
 - How to Create a Delicious Green Apple Illustration
 - Create a Poster Illustration with Floating Floral Elements
 - Design a Detailed Compass Icon in Photoshop
 - Create a Custom Mac OSX Style Ring Binder Address Book Icon
 - How to Make a Bangin’ Woofer Embedded in Wood
 - Make an Inspiring Artistic Poster with Drawn Elements


Photoshop Effects Tutorials
 - How to Simulate Fractals in Photoshop
 - 50 Dirty, Filthy Grunge Photoshop Effects
 - 45 Explosively Colorful Photoshop Effects
 - 50 Creative Photoshop Text Effects
 - 40 Dark and Futuristic Photoshop Effects
 - Inspiration: Water and Ice
 - Using Ink Drops in Your Digital Compositions
 - Create an Energy Drink Ad Design
 - Create a Space Explosion From Scratch in Photoshop
 - Create a Magic Crystal Ball


Photoshop Interface Tutorials
 - How to Create a Grunge Web Design in Photoshop
 - From PSD to HTML - Site Build over at NETTUTS
 - Create a Dark Themed Web Design from Scratch
 - Create a Sleek, High-End Web Design from Scratch
 - Design a Cartoon Grunge Web site Layout
 - How to Create a 3D Shelf Element Similar to Dragon Interactive
 - Creating a Cool Brushed Metal Surface in Photoshop
 - How to Create a Simple & Sleek Web 2.0 Site Footer
 - Handy Web 2.0 Icons In Photoshop


Photo Effects with Photoshop
 - Create a Sleek Illustration that Fades from Line Art to Color
 - How to Illustrate a Wooden Frame on a Wall Scene
 - Create an Explosive Cover with Precise Photo Manipulation Techniques
 - Design a Halloween Pumpkin Wallpaper in Photoshop
 - Design a High Impact Gig Poster Suitable for Screen-Printing
 - How to Make a Musical Giraffe Digital Illustration
 - How to Design a Dramatic Winged Dragon with Photoshop
 - Getting to Grips with the Vanishing Point Filter
 - How To Render a Dramatic 3D Wood Cup in Photoshop
 - Achieve HDR Style Effects Using Photoshop and the Lucis Art Filter


Text Effects with Photoshop
 - How to Quickly Create a Stylish Retro Text Effect
 - New PLUS Tutorial - How to Make 3D Neon Light Typography
 - Create a Layered Glowing Text Effect
 - Dramatic Text on Fire Effect in Photoshop
 - 6 Quick’n'Dirty Photoshop Text Effects From Scratch
 - Create a Spectacular Grass Text Effect in Photoshop Design Soft Stylized 3D Type
 - How to Put Smokin’ Bullet Holes and a Wanted Sign into a Piece of Wood
 - How To Create A Gold Text Effect In Photoshop


Photoshop Tools & Tips
 - A Comprehensive Introduction to Photoshop Selection Techniques
 - 30+ Useful Resources for Improving Your Photoshop Efficiency
 - Useful Applications for the Clone Stamp Tool
 - Getting to Grips with the Vanishing Point Filter
 - Font Management: Linotype FontExplorer X
 - Tools & Tips: Smart Objects and Smart Filters
 - Tools & Tips: Photoshop Brushes
 - Tools & Tips: Photoshop Actions

Popularity: 76% [?]