Free Microsoft Office Training and Tutorial Resources




    



April 11, 2007

PowerPoint 2003 Video Tutorials from BSU.edu

Here are some great PowerPoint 2003 Video Training Tutorials provided free by Ball State University. These will help you become a better PowerPoint user, increasing your skills with creating and presenting slide presentations. Features taught by these PowerPoint Tutorials include: choosing a design template, creating a title slide, adding sound, changing the layout, formatting text, inserting clip art, adding a hyperlink, rearranging slides, and printing your presentation.


Getting Started

  • Selecting a Design Template
    PowerPoint comes with many design templates that you can choose from.  Learn how to select one for use with your presentation.

  • Create a Title Slide
    The title slide is typically the first slide in a presentation.  You can use the blank presentation template to create a title slide.

  • Save Your Presentation
    Learn how to use the “Save” and “Save As” functions of PowerPoint.

Enhancing Slides

Modifying a Presentation
Printing a Presentation
  • Printing a Presentation
    Learn to use the different printing options such as printing slides or handouts.  Also learn how to choose to print in black and white, color, or grayscale.

Popularity: 3% [?]


Related Posts:
  • Inserting Video Into PowerPoint Presentations
  • 7 PowerPoint 2007 Tutorials
  • 2 PowerPoint 2003 Tutorials
  • 6 Powerpoint Tutorials
  • 4 PowerPoint 2003 Tutorials

  • Tags for this post>> |
    April 14, 2007

    Access 2003 Video Tutorials from BSU

    Here are Ball State’s Microsoft Access 2003 Video Tutorials. These Access Tutorials will help you use this database application to become more productive with organizing, accessing, and sharing information and data. One thing about Access is that end-users can use it without much training, while developers can use it to write complex applications. These tutorials cover and teach creating tables in Access, creating relationships, entering data into records, udpating data in a database, changing fields and tables, validation rules, working with queries, and printing with Access.

    Getting Started

    • Access 2003 Overview
      Create a database file and learn about some of the basic Access screen elements.

    • Save Your Database
      Access automatically saves your database and all the associated elements when you close the database.

    Creating a Table
    Establishing Relationships
    • Create a One-to-Many Relationship
      Relate two tables to each other using a one-to-many relationship.  Learn why Referential Integrity is important.

    • Open a Relationships Window and Adding Tables
      The Relationships Window gives you a graphical representation of your database and allows you to build or modify the relationships between the tables in your database.  Includes an explanation of the three types of relationships.

    Adding Data to a Database
    Updating Data in an Existing Database
    • Change Existing Data
      Changing data in an existing record.

    • Updating Records
      Updating a record in a table is as easy as opening the table and then typing in the change.

    • Update Multiple Records
      Update multiple records in an existing table using the “Replace” or “Replace All” commands.  This allows you to update information for records in a table that meet certain conditions.

    • Delete a Record from a Table 
      It is easy to delete a record from a table in your database.

    Modifying the Database

    Validation Rules
    • Setting Validation Rules
      Set a validation rule and establish the text properties for the rule.  Validation rules on a field ensure that only valid data gets entered into the field.

    • Validation Rule Testing
      Setting validation rules for fields in your database ensures that only valid data can be entered into each field.  Validation rules can be tested by adding records to a table.

    Navigating the Database and Finding Specific Records
    Working with Queries
    Printing from Access
    • Printing a Table
      There are a couple of ways to print existing tables – you can click on the Print button on the tool bar or access the printer via the File menu.   Learn how to use the “Print Preview” option.

    • Printing the Results of a Query
      After a query is run, it is easy to print the results of the query.

    Popularity: 15% [?]


    Related Posts:
  • Free Microsoft Access Video Training
  • 24 Microsoft Access Tutorials from Towson University
  • 7 PowerPoint 2007 Tutorials
  • 6 Freely available Ebooks on Microsoft Access 2003 and 2002 (XP)
  • Micrsoft Office 2003 and 2002 Tutorials

  • Tags for this post>> |

    Web Site Accessibility Tutorial

    This is a Web Site Accessibility Tutorial from which you can learn all about what web accessibility is, why its important, how to design for it, when to implement it, and who is effected by web accessibility. This is provided by the University of Minnesota.

    You will have learned the following after reading this tutorial:

    • Understanding of the meaning of web accessibility
    • Understanding of who is affected by web accessibility
    • Understanding of the rational of why web sites should be made accessible
    • Awareness of the process of how to make web pages accessible
    • Awareness of relevant web accessibility dates
    Web Accessibility Tutorial Topics:

    Popularity: 5% [?]


    Related Posts:
  • Accessible Web Design Guide
  • Web Design Tutorial
  • Step by Step Accessibility Tutorials for Microsoft Office and Windows
  • Creating Accessible Word Documents
  • Web Site Development Lectures from Harvard University

  • Tags for this post>>
    April 16, 2007

    204 PHP Tips and Tutorials with Scripts

    Here is a blog post I wrote at intelligentedu.com that links to 204 PHP Tips and Tutorials with Scripts at dev.fyicenter.com. The PHP example scripts and techniques demonstrated here will assist you as a beginner or as an experienced PHP web developer. They also include many excellent PHP tutorial exercises.

    PHP Tutorial Topics:

    Popularity: 3% [?]


    Related Posts:
  • HTML, Javascript, and MySQL Tutorials
  • Photoshop 7.0 Scripting Ebook
  • Bignosebird: Webmaster Tutorials and Free Graphics
  • Techtopia’s HTML Tutorials
  • Perl Tutorial

  • Tags for this post>>

    HTML 4 and CSS 2 Reference Help Ebook

    Here is an excellent free HTML 4 and CSS 2 Reference Help Ebook. It also includes a short step-by-step course to help you on developing your first web page.. Here is the download for this HTML and CSS reference ebook.

    Contents:

    • CSS 2 overview 
    • CSS 2 Syntax
    • Sample Style Sheet
    • HTML4 Overview                                        
    • HTML4 Syntax – by group
    • HTML 4 Syntax – Alphabetical
    • Color Reference

    Popularity: 7% [?]


    Related Posts:
  • Free Dreamweaver MX Reference eBook
  • Free Macromedia Dreamweaver 8 Ebook
  • eBooks for Photoshop, Illustrator, Fireworks, Flash, and Dreamweaver
  • Free Flash Ebook
  • 16 eBooks and Books for Photoshop and more

  • Tags for this post>> |
    April 19, 2007

    Free Book – Teach Yourself Office 2003 in 24 Hours

    Here is an excellent free Office training book, titled Sams Teach Yourself Microsoft Office 2003 in 24 Hours. This book will teach you great keyboard shortcuts and efficient methods to perform many of the common tasks in Office. It covers many important topics and features of all of the Office applications. These include the following: Word Formatting, Customizing Word, Advanced Word, Editing and Formatting Excel Worksheets, Excel Charting, Editing and Arranging Powerpoint Presentations, Advanced PowerPoint Features, Animating Your Presentations, Planning and Scheduling with Outlook, Displaying and Retrieving Data in Access, Reporting with Access, Using Office with the Internet, Creating Web Content with Word, Excel, Access, and PowerPoint, and Inserting Art with Publisher Art, and Publishing with Publisher. It also includes chapters covering Web Page Design and Creation using FrontPage, and managing your web site with FrontPage.


    Table of Contents for Sams Teach Yourself Microsoft Office 2003 in 24 Hours

      » Introduction
      » Who Should Read This Book?
      » What This Book Does for You
      » Can This Book Really Teach Office 2003 in 24 Hours?
      » Conventions Used in This Book

      » Part I. Working with Office 2003
      » Hour 1. Getting Acquainted with Office 2003

      » Part II. Processing with Word 2003
      » Hour 2. Welcome to Word 2003
      » Hour 3. Formatting with Word 2003
      » Hour 4. Managing Documents and Customizing Word 2003
      » Hour 5. Advanced Word 2003

      » Part III. Computing with Excel 2003
      » Hour 6. Understanding Excel 2003 Workbooks
      » Hour 7. Restructuring and Editing Excel 2003 Worksheets
      » Hour 8. Using Excel 2003
      » Hour 9. Formatting Worksheets to Look Great
      » Hour 10. Charting with Excel 2003

      » Part IV. Presenting with Flair
      » Hour 11. PowerPoint 2003 Presentations
      » Hour 12. Editing and Arranging Your Presentations
      » Hour 13. PowerPoint 2003 Advanced Features
      » Hour 14. Animating Your Presentations

      » Part V. Organizing with Outlook 2003
      » Hour 15. Communicating with Outlook 2003
      » Hour 16. Planning and Scheduling with Outlook 2003

      » Part VI. Tracking with Access 2003
      » Hour 17. Access 2003 Basics
      » Hour 18. Entering and Displaying Access 2003 Data
      » Hour 19. Retrieving Your Data
      » Hour 20. Reporting with Access 2003

      » Part VII. Combining Office 2003 and the Internet
      » Hour 21. Office 2003 and the Internet
      » Hour 22. Creating Web Content with Word, Excel, Access, and PowerPoint

      » Part VIII. Publishing Eye-Catching Documents
      » Hour 23. Publishing with Flair Using Publisher 2003
      » Hour 24. Adding Art to Your Publications

      » Part IX. Appendixes
      » Appendix B. Business Contact Manager and Office Extras

      » Part X. Bonus Hours
      » Hour 25. Using FrontPage 2003 for Web Page Design and Creation
      » Hour 26. Managing Your Web with FrontPage

    Popularity: 15% [?]


    Related Posts:
  • Teach Yourself Microsoft Office FrontPage 2003 In 24Hours eBook
  • 5 Books for Microsoft Office 2003: Word, Excel, PowerPoint, Outlook, Access
  • 6 Free MS Office eBooks: Word, Excel, Powerpoint, Outlook, Access
  • Free Books on Microsoft Office, Excel, Project, and FrontPage
  • 8 Free Ebooks for Microsoft Word, Excel, Access, Office 2003

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

    Free Book – Teach Yourself HTML 4 in 24 Hours

    Here is a great free online book, titled Sams Teach Yourself HTML 4 in 24 Hours. This will teach you all about HTML, how to code, how to design your graphics, build your web pages and make them dynamic, and get your site online as fast as possible. It is targeted towards the beginners, but will also be useful for more advanced web site developers. Some of the HTML topics it covers includes the following: How HTML and XML work, Publishing Your Web Pages, Text Alignment and Formatting, HTML Forms, Web Page Graphics, Backgrounds and Colors, Page Design and Layout, Graphical Links and Imagemaps, Advanced Layout using Tables, Using Style Sheets, Embedding Multimedia in Web Pages, Interactive Web Pages, Web Scripting, Using Dynamic HTML, and Organizing and Managing a Web Site. A complete HTML 4 Quick Reference is also included in the appendix.


    Table of Contents of Sams Teach Yourself HTML 4 in 24 Hours

      » About the Author
      » Acknowledgments
      » Tell Us What You Think!
      » Put Your HTML Page Online Today

      » I. Your First Web Page
      » Hour 1. Understanding HTML and XML
      » Hour 2. Create a Web Page Right Now
      » Hour 3. Linking to Other Web Pages
      » Hour 4. Publishing Your HTML Pages

      » II. Web Page Text
      » Hour 5. Text Alignment and Lists
      » Hour 6. Text Formatting and Font Control
      » Hour 7. Email Links and Links Within a Page
      » Hour 8. Creating HTML Forms

      » III. Web Page Graphics
      » Hour 9. Creating Your Own Web Page Graphics
      » Hour 10. Putting Graphics on a Web Page
      » Hour 11. Custom Backgrounds and Colors
      » Hour 12. Creating Animated Graphics

      » IV. Web Page Design
      » Hour 13. Page Design and Layout
      » Hour 14. Graphical Links and Imagemaps
      » Hour 15. Advanced Layout with Tables
      » Hour 16. Using Style Sheets

      » V. Dynamic Web Pages
      » Hour 17. Embedding Multimedia in Web Pages
      » Hour 18. Interactive Pages with Applets and ActiveX
      » Hour 19. Web Page Scripting for Non-Programmers
      » Hour 20. Setting Pages in Motion with Dynamic HTML

      » VI. Building a Web Site
      » Hour 21. Multipage Layout with Frames
      » Hour 22. Organizing and Managing a Web Site
      » Hour 23. Helping People Find Your Web Pages
      » Hour 24. Planning for the Future of HTML

      » VII. Appendixes
      » A. Readers’ Most Frequently Asked Questions
      » B. HTML Learning Resources on the Internet
      » C. Complete HTML 4 Quick Reference
      » D. HTML Character Entities

    Popularity: 8% [?]


    Related Posts:
  • Photoshop and Illustrator Free Books
  • Teach Yourself Microsoft Office FrontPage 2003 In 24Hours eBook
  • 5 Books for Microsoft Office 2003: Word, Excel, PowerPoint, Outlook, Access
  • 6 Free MS Office eBooks: Word, Excel, Powerpoint, Outlook, Access
  • 8 Free Books on JSP, PHP, MySQL, Apache, Perl, ASP.Net

  • Tags for this post>> |
    April 25, 2007

    Free Book – Teach Yourself JavaScript in 24 Hours

    Here is a free online JavaScript book, Sams Teach Yourself JavaScript in 24 Hours. This book will teach you how to effectively use and code JavaScript in your web pages. Using JavaScript is a relatively easy method to give your website more user interactivity and make it easier and more friendly to use. Sams Teach Yourself JavaScript in 24 Hours provides many step-by-step lessons that you can use to learn both scripting basics and the details of the JavaScript scripting language


    Table of Contents of Sams Teach Yourself JavaScript in 24 Hours

      » About the Author
      » Acknowledgments
      » We Want to Hear from You!
      » Reader Services
      » Introduction

      » Part I: Getting Started
      » Hour 1. Understanding JavaScript
      » Hour 2. Creating a Simple Script
      » Hour 3. How JavaScript Programs Work

      » Part II: Learning JavaScript Basics
      » Hour 4. Using Functions and Variables
      » Hour 5. Using Strings and Arrays
      » Hour 6. Testing and Comparing Values
      » Hour 7. Repeating Yourself: Using Loops
      » Hour 8. Using Math and Date Functions

      » Part III: The Document Object Model (DOM)
      » Hour 9. Working with the Document Object Model
      » Hour 10. Responding to Events
      » Hour 11. Using Windows and Frames
      » Hour 12. Getting Data with Forms
      » Hour 13. Using Graphics and Animation

      » Part IV: Moving on to Advanced JavaScript Features
      » Hour 14. Creating Cross-Browser Scripts
      » Hour 15. Creating Custom Objects
      » Hour 16. Working with Sounds and Plug-Ins
      » Hour 17. Debugging JavaScript Applications

      » Part V: Working with Dynamic HTML (DHTML)
      » Hour 18. Working with Style Sheets
      » Hour 19. Using Dynamic HTML (DHTML)
      » Hour 20. Using Advanced DOM Features

      » Part VI: Putting It All Together
      » Hour 21. Improving a Web Page with JavaScript
      » Hour 22. Creating a JavaScript Game
      » Hour 23. Creating DHTML Applications
      » Hour 24. JavaScript Tips and Tricks

      » Part VII: Appendices
      » Appendix A. Other JavaScript Resources
      » Appendix B. Tools for JavaScript Developers
      » Appendix C. Glossary
      » Appendix D. JavaScript Quick Reference
      » Appendix E. DOM Quick Reference

    Popularity: 11% [?]


    Related Posts:
  • Photoshop and Illustrator Free Books
  • 4 Free Web Development Books
  • Teach Yourself Microsoft Office FrontPage 2003 In 24Hours eBook
  • 4 Free Chapters from Javascript: The Complete Reference
  • 8 Free Books on JSP, PHP, MySQL, Apache, Perl, ASP.Net

  • Tags for this post>> |

    Free Word 2007 Course from Dell

    This is a free course from Dell, titled What’s New in Microsoft Office Word 2007. This free Word course teaches you how to understand and use the new user interface and application navigation to access the common Word tools you need to use. To start the free Word 2007 course, on Dell’s web page, click on the “Launch Your Free Course Now!” link or the course’s title. (Your pop-up blocker must be disabled and free registration is required.)


    Word 2007 Course Overview: Modules & Lessons:

    • Course Overview
    • Navigation Overview   
    • What’s New in Microsoft Office Word 2007
    • Exploring the New Interface
    • The Ribbon   
    • Tasks and Tabs   
    • The Full Screen Reading View   
    • Self Test   
    • Creating Professional-Looking Documents
    • How to Insert Tables, Illustrations, and Equations   
    • What Are Building Blocks?   
    • Insert Building Blocks in a Document   
    • How to Change the Layout of a Document   
    • How to Add References in a Document   
    • Self Test   
    • Reviewing and Finalizing Documents
    • How to Finalize Documents   
    • What Are Workflows?   
    • How to Initiate Workflows   
    • How to Compare Multiple Versions of a Document   
    • Available File Formats   
    • Self Test   
    • Module Summary   
    • Glossary
    • Next Steps

    Popularity: 10% [?]


    Related Posts:
  • Free Visio 2007 Course from Dell
  • Free Excel 2007 Course from Dell
  • Free PowerPoint 2007 Course from Dell
  • Free Outlook 2007 Course from Dell
  • Free Access 2007 Course from Dell

  • Tags for this post>>
    April 26, 2007

    3 Ebooks for Adobe Photoshop 6

    Here are 3 great ebooks for Adobe Photoshop 6 that show and demonstrate many of Photoshops features and functionality. These will help you learn this important graphics and imaging editing application. Many of these features are also available in previous versions of Photoshop and in more recent versions.


    Photoshop 6 Ebook #1
    (448 pages, 6.2mb, pdf format)

    Table of Contents:

    • Getting Started
    • Adobe Photoshop Basics
    • What’s New in Adobe Photoshop 6.0
    • Chapter 1 – Looking at the Work Area
    • Chapter 2 – Getting Images into Photoshop and ImageReady
    • Chapter 3 – Working with Color
    • Chapter 4 – Producing Consistent Color (Photoshop)
    • Chapter 5 – Selecting
    • Chapter 6 – Drawing and Editing
    • Chapter 7 – Using Channels and Masks
    • Chapter 8 – Using Layers
    • Chapter 9 – Using Type
    • Chapter 10 – Designing Web Pages
    • Chapter 11 – Creating Animations (ImageReady)
    • Chapter 12 - Optimizing Images for the Web
    • Chapter 13 – Saving and Exporting Images
    • Chapter 14 – Printing
    • Chapter 15 – Automating Tasks

    Photoshop 6 Ebook #2
    (1047 pages, 15.1mb, pdf format)

    Table of Contents:
    • Part I: Welcome to Photoshop
      • Chapter 1: What’s Up with Photoshop 6?
      • Chapter 2: Inside Photoshop
      • Chapter 3: Image Fundamentals
    • Part II: Painting and Retouching
      • Chapter 4: Defining Colors
      • Chapter 5: Painting and Editing
      • Chapter 6: Filling and Stroking
      • Chapter 7: Retouching, Repeating, and Restoring
    • Part III: Selections, Masks, and Filters
      • Chapter 8: Selections and Paths
      • Chapter 9: Masks and Extractions
      • Chapter 10: Corrective Filtering
      • Chapter 11: Full-Court Filtering
    • Part IV: Layers, Objects, and Text
      • Chapter 12: Working with Layers
      • Chapter 13: The Wonders of Blend Modes
      • Chapter 14: Shapes and Styles
      • Chapter 15: Fully Editable Text
    • Part V: Color for Print and the Web
      • Chapter 16: Essential Color Management
      • Chapter 17: Mapping and Adjusting Colors
      • Chapter 18: Printing Images
      • Chapter 19: Creating Graphics for the Web

    Photoshop 6 Ebook #3
    (441 pages, 47.2mb, pdf format)

    Table of Contents:
    • Getting Started
    • Prerequisites
    • Lesson 1 – Getting to Know the Work Area
    • Lesson 2 - Working with Selections
    • Lesson 3 – Layer Basics
    • Lesson 4 – Painting and Editing
    • Lesson 5 – Masks and Channels
    • Lesson 6 – Photo Retouching
    • Lesson 7 – Basic Pen Tool Techniques
    • Lesson 8 – Vector Shapes and Clipping Paths
    • Lesson 9 – Advanced Layer Techniques
    • Lesson 10 – Creating Special Effects
    • Lesson 11 – Setting Up Your Monitor for Color Management
    • Lesson 12 – Producing and Printing Consistent Color
    • Lesson 13 – Preparing Images for Two-Color Printing
    • Lesson 14 – Optimizing Images for the Web
    • Lesson 15 - Creating Web Graphics Using Slices and Rollovers
    • Lesson 16 – Designing Web Pages Using Multiple Adobe Programs
    • Lesson 17 – Creating Animated Images for the Web
    • Review Questions
    • Review Answers

    Popularity: 4% [?]


    Related Posts:
  • 16 eBooks and Books for Photoshop and more
  • 3 Photoshop eBooks
  • 3 Freely available Ebooks for Photoshop CS and Photoshop 7
  • Free Ebooks for Adobe Applications
  • 19 Free eBooks for Adobe and Macromedia Applications -Flash, Photoshop, etc

  • Tags for this post>>
    « Previous PageNext Page »