Free Microsoft Office Training and Tutorial Resources




    



October 17, 2009

11 Excel 2007 Tutorials

Here are 11 excellent Excel 2007 Tutorials, at the University of Florida, that discuss and present many of Excel’s important features. These Excel turorials, as handouts and notes, cover calculations, navigation, graphing and charting, pivot tables, printing, and sorting and filters. They are in pdf format, and can be downloaded and saved for later reference.


Charts Handout  (918 Kb, 15 pages)
This is a handout that discusses how and why charts are created and used for communicating and presenting things.

Charts Notes  (31 Kb, 3 pages)
This Word document contains important notes on Excel charts and how they are used to represent important details.

Math & Fun Handout  (194 Kb, 11 pages)
This handout discusses math functions used in Excel to carry out calculations from raw data.

Mult Handout  (348 Kb, 11 pages)
This handout demonstrates to users how to use multiple spreadsheets and worksheets.

Mult Notes  (28 Kb, 3 pages)
This Word document provides users with notes and tips on how to use multiple worksheets in Excel.

Nav & Form Handout  (446 Kb, 21 pages)
This handout discusses the navigation and formatting, including moving between cells and editing data.

Nav & Form Notes  (58 Kb, 7 pages)
This Word document provides important notes for users regarding navigation and formatting in Excel 2003.

Pivot Tables Handout  (324 Kb, 14 pages)
This handout explains to users what Pivot tables, how to create them and how they work.

Print Handout  (603 Kb, 16 pages)
This handout explains to users how the Print function works in Excel 2003 and how printing can be customized to suit ones needs.

Print Notes  (44 Kb, 5 pages)
These notes on printing in Excel 2003 offer users quick tips and trick that can be used to suit their printing styles.

Sorting & Filters  (203 Kb, 9 pages)
This tutorial imparts knowledge on how sorting is done in Excel 2003 and how filters can be applied on raw data to get the desired results.

Popularity: 23% [?]


Related Posts:
  • 20 Office 2007 eBooks
  • 6 Excel 2007 Tutorials
  • Excel 2007 Tutorial
  • Excel 2007 Data Analysis Tutorials
  • Guides for Word 2007, Excel 2007, and PowerPoint 2007

  • Tags for this post>> |
    October 26, 2009

    Microsoft Access Tutorial

    Here is a Microsoft Access Tutorial, at Orbit Computer Solutions, that teaches you how to use Access, Microsoft Office’s database application. This Access database tutorial covers creating new databases, and creating and managing tables. The topics include how-to screenshots that help explain what is being described.


    Getting Started With Access 2007
    Here you will get a quick introductory tour through the world of Microsoft Access 2007.

     - The Microsoft Office Button
     - The Ribbon
     - Quick Access Bar


    How To Create A New AccessDatabase
    In this section of the tutorial, you will be able to learn how to create a new database in MS Access 2007. You will also learn about new database terms like query, recordset, forms and reports.

     - Database Terms
     - Query
     - Record Set
     - Forms
     - Report
     - How To Create A New Database
     - How To Create A New Database Using Templates


    How To Create an Access Table
    In this section of the tutorial, we are explaining about creating a table inside the Access database. Adding new fields to the tables. editing and formatting data types are also explained.

     - Table View
     - Design And Datasheet View
     - How To Add New Fields
     - How To Add New Fields In Design View
     - How To Edit Data Types In Fields
     - How To Format Data Types In Design View


    Managing Tables
    In this final section you will learn how to manage the tables which you created in MS Access.

     - How To Rename A Table
     - How To Add A Description In A Table

    Popularity: 37% [?]


    Related Posts:
  • Microsoft Access Tutorial
  • 6 Microsoft Access Tutorials
  • 4 Access Tutorials
  • 17 Access 2007 Database Tutorials
  • Free Microsoft Access Video Training

  • Tags for this post>> |

    Flash and ActionScript References and Cheat Sheets

    Here are some excellent Flash and ActionScript References and Cheat Sheets at appletree’s quick reference cards. Adobe Flash is a multimedia platform for adding animation and interactivity to web pages. Flash is commonly used to integrate video and sound into web pages to create animation and compelling multimedia presentations. These ActionScript and Flash reference materials will help you work more efficiently and effectively with Flash. These are in pdf and jpg format.


    Adobe Flash Platform Rich Internet Application Development 2.1M 
    This document provides an insight of the Adobe Flash platform for creating rich internet applications.

    Flash CS4 OSX Shortcuts 275K
    This document discusses the keyboard shortcuts for Adobe Flash on the OSX platform.

    Flash CS3 Quick Reference 347K 
    This is a quick reference that details the fundamentals, tools and keyboard shortcuts of Flash CS3.

    Flash ActionScript quick reference 200K
    This document is a quick reference to the operators, program flow control, global functions, constants and compiler directives in ActionScript.

    Actionscript 3.0 Flash Display 217K  
    This document discusses the display functions used in ActionScript for displaying various objects.

    Actionscript 3.0 Migration 90K 
    This is a migration document for converting ActionScript 2.0 code to ActionScript 3.0.

    Actionscript 3.0 Packages 24K 
    This document provides a list of ActionScript 3.0 packages.

    Actionscript 3.0 Top Level 50K 
    This document provides a brief look at the top level functions of ActionScript 3.0.

    Actionscript 3.0 Migration Cheatsheet 90K 
    This document acts as a cheatsheet for migration to ActionScript 3.0.

    AcitionScript 3.0 Cheatsheet Migration 90K
    This document is a quick preference that provides migration information on migrating applications to ActionScript 3.0.

    AcitionScript 3.0 Cheatsheet Top Level 50K
    This document provides a top level look at the functions, constants, classes and arguments used in ActionScript 3.0.

    Popularity: 32% [?]


    Related Posts:
  • 12 Photoshop Cheat Sheets
  • HTML And XHTML References and Cheat Sheets
  • Excellent CSS Reference Sheet
  • 5 Quick References for Photoshop and Dreamweaver
  • Photoshop References and Cheat Sheets

  • Tags for this post>> |
    « Previous Page