Here are several well written Excel 2007 Data Analysis Tutorials that will assist you in analyzing economic data. These tutorials help explain Excel’s power and give you insight into Excel’s analysis tool set. Advanced Excel topics covered include data inspection, and statistical inference  for univariate, bivariate and multivariate expressions. Each of these Excel tutorials is complemented with visual examples to better explain the concepts presented. As a quick crash course, also included is a ‘Getting Started’ tutorial as well. These Excel tutorials are hosted by the University of California at Davis.


Excel 2007 Getting-Started Tutorial:
 - Excel: Tutorial (covers first half of below)

Excel 2007 Basics:
 - Excel 2007: Access and Activating the Data Analysis Add-in
 - Excel 2007: The Windows 2007 Fluent Interface
 - Excel 2007: Workbooks and Worksheets
 - Excel 2007: Data Types and Data Input
 - Excel 2007: Data Manipulation
 - Excel 2007: Formatting, Saving, Printing and Copying Results
 - Excel 2007: Sample text data set (carsdata.txt)
 - Excel 2007: Sample comma-separated values text data set (carsdata.csv)
 - Excel 2007: Sample Excel worksheet (carsdata.xls)

Excel 2007 Univariate: Visual Data Inspection:
 - Excel 2007: Histogram
 - Excel 2007: Charts (column, pie, line)

Excel 2007 Univariate: Data Summary and Statistical Inference:
 - Excel 2007: Descriptive Statistics
 - Excel 2007: Statistical Inference for univariate data
 - Excel 2007: DIST, TINV, NORMSDIST and NORMSINV

Excel 2007 Bivariate: Visual Data Presentation:
 - Excel 2007: Two-way Plots
 - Excel 2007: Two-plots with nonlinear trend (logarithmic, exponential, power, polynomial)

Excel 2007 Bivariate: Data Summary and Statistical Inference:
 - Excel 2007: Correlation and covariance
 - Excel 2007: Two-Variable Regression using Data Analysis Add-in
 - Excel 2007: Statistical Inference for Two-Variable Regression
 - Excel 2007: Two-Variable Regression using Excel function LINEST

Excel 2007 Multivariate: Data Summary and Statistical Inference:
 - Excel 2007: Multiple Regression

Popularity: 35% [?]

Here is my first post of the Excel Tutorials and Tips at excel.tips.net that cover many topics that will help make you a professional at Excel. Excel is a spreadsheet application from Microsoft’s Office suite that creates and manages business transactions that deal with accounting. The below Excel tutorials and tips are a good place to explore  and learn the basics and also some advanced features of Microsoft Excel. These are the best ones in each topic from our review of this site. (Here is my part 2 post of the Excel learning material from this site.)


Conditional Formatting in Excel:
Conditional formatting allows you to set rules for cell formatting. If the rules are met, then the formatting is applied. The tutorials below explain how Conditional formatting work.
 - Conditional Formatting
 - Adding Ordinal Notation to Dates
 - Applying Conditional Formatting to Multiple Worksheets
 - Conditional Formats that Distinguish Blanks and Zeroes
 - Conditionally Formatting for Multiple Date Comparisons
 - Shading a Cell Until Something is Entered
 - Highlighting Cells Containing Specific Text
 - Counting Colors from Conditional Formats
 - Sorting or Filtering by Conditional Format Results
 - Conditional Formatting with Data Imported from Access

Customizing Excel:
Excel makes it easy for you to personalize and customize the menus and toolbars to suit each individuals way of working. The tutorials below explain the level of customization a user can achieve.
 - Adding a Little Animation to Your Life
 - Colors and Fonts for Worksheet Tabs
 - Creating Superscript and Subscript Buttons
 - Specifying the Behavior of the Enter Key
 - Adding Your Own Menu Items
 - Removing Items from a Context Menu
 - Buttons for Workbooks
 - Customizing a Toolbar
 - Renaming a Toolbar
 - Saving Valuable Toolbar and Screen Space

Excel’s Custom Views:
Many of us would also like to extend the level of customization to having pur own Views and these tutorials below explain how to do just that.
 - Arranging Workbook Windows
 - Additional Ways of Displaying a Hidden First Column
 - Arranging Workbook Windows
 - Changing the Size of Spreadsheet Panes
 - Displaying a Hidden First Column
 - Getting Rid of Spreadsheet Panes
 - Splitting Your Spreadsheet Window Into Panes
 - Working With Multiple Workbooks

Editing in Excel:
While editing a sentence may seem easy, editing in Excel takes on a whole new approach. The links below explain editing in Excel.
 - Automatically Breaking Text
 - Checking for a Value in a Cell
 - Combining Multiple Rows in a Column
 - Counting Words
 - Easily Entering Dispersed Data
 - Easily Entering Dispersed Data
 - Transposing Your Data
 - Making AutoComplete Work for an Entire Column
 - Using an Input Mask
 - Ranges on Multiple Worksheets

Excel Filtering:
Excel provides filters to quickly find data in an Excel sheet. Filtering does not change data in an Excel sheet, and all data appears the same as before as soon as the filter is removed. The tutorials below provide an in-depth coverage of filters.
 - Counting Filtered Rows
 - Removing Duplicates Based on a Partial Match
 - Extracting Targeted Records from a List
 - Performing Calculations While Filtering
 - More Than Two Conditions for Custom AutoFiltering
 - Suppressing Zero Values in PivotTables
 - Sorting or Filtering by Conditional Format Results
 - Advanced Filtering
 - Limits to Filtering
 - Using AutoFiltering

Find and Replace in Excel:
Find and Replace is a common tool used in most applications, and Excel is no exception. The tutorials given below explain how to use the Find and Replace tool effectively in Excel.
 - Checking for Messages in Cells
 - Finding and Deleting Links
 - Limiting Searching to a Column
 - Searching for Leading Apostrophes
 - Searching for Line Breaks
 - Searching for Wildcards
 - Using Find and Replace to Pre-Pend Characters
 - Wildcards in ‘Replace With’ Text

Formatting in Excel:
To better understand raw data, it must be formatted to some specific criteria. The tutorials below explain how formatting can be applied to cells in an Excel sheet.
 - Formatting Raw Data
 - Partially Blocking Social Security Numbers
 - Removing All Formatting
 - Understanding Date and Time Formatting Codes
 - Making All Occurrences Bold
 - Drawing Borders
 - Automatically Breaking Text
 - Displaying Negative Percentages in Red
 - Matching Formatting when Concatenating
 - Understanding Cell Indenting

Excel Formulas:
Data available in Excel sheets can be manipulated using Formula. Different cells can be grouped together to have their values computed in any fashion. The links below explain how to work with Formula.
 - Activating the Formula Bar with the Keyboard
 - Entering Formulas in Excel
 - Automatically Numbering Rows
 - Calculating Statistical Values on Different-Sized Subsets of Data
 - Calculating the Median Age of a Group of People
 - Complex Lookup Formulas
 - Counting Consecutive Negative Numbers
 - Dealing with Circular References
 - Determining “Highest Since” or “Lowest Since”
 - Saving Common Formulas

Excel Macros:
A macro is usually a set of instructions that are grouped together to carry out small, repetitve tasks. Macros can also be created and used extensively in Excel and these tutorials explain how they work.
 - Adding a Macro to a Toolbar
 - Understanding Functions in Macros
 - Editing Macros
 - Comparing Strings
 -  Creating and Naming a Worksheet Using a Macro
 -  Developing Reciprocal Conversion Formulas
 -  Displaying Messages When Automatic Data Changes
 -  Getting Rid of the “Enable Macros” Notice
 - Macros in Template Files
 - Putting an X in a Clicked Cell

Page Setup:
Put simply, a page in a spreadsheet application can be setup to print values in the landscape or the portrait mode. The page setup also includes page breaks, headers and footers and inserting page numbers. These tutorials explain all these concepts detail.
 -  Changing Paper Size for a Complete Workbook
 - Multiple Line Headers and Footers
 - Forcing a Page Break
 - Turning Headers On and Off
 - Dynamic Headers and Footers
 - Putting a Graphic in a Header or Footer
 - Inserting the Saved Date In a Header or Footer
 - Recognizing a Header Row when Sorting
 - Adding Page Numbers
 - Changing Page Orientation

Printing:
An Excel sheet can be setup to be printed in ways that suit a user. An Excel sheet can even be printed without opening it. These and more printing related tutorials can be found below.
 - Automatically Printing a Range
 - Conditional Printing
 - Hiding Errors on Printouts
 - Printing a Portion of a Worksheet
 - Printing Based on Cell Contents
 - Printing Comments
 - Printing without Opening
 - Protecting Print Settings
 - Repeating Rows at the Bottom of a Page
 - Setting Print Titles

Excel Shortcut Keys:
As with an application, Excel too has a lot of shortcut keys that permit quick and easy navigationn on a worksheet. You can find all Excel shortcuts in these tutorials.
 - A Shortcut for Switching Focus
 - Canceling a Command
 - Changing Font Size Using a Shortcut Key
 - Closing All Open Workbooks
 - Defining Shortcut Keys for Symbols
 - One Shortcut for Two Macros.
 - Shortcut to Merge Cells

Subtotals in Excel:
Subtotals of a column can be calculated and stored for quick reference. The tutorials below help understand Subtotals better.
 - Copying Subtotals
 - Counting with Subtotals
 - Formatting Subtotal Rows
 - Moving Subtotals
 - Problems with Nested Subtotals
 - Subtotals Option Grayed Out.
 - Using Subtotals and Totals

Worksheet Functions:
In Excel worksheets, functions can be implemeted on the data. These functions include database functions, date and time functions and text functions to name a few. The tutorials help explain the concept of worksheet functions.
 - Calculating Fractions of Years
 - Counting Unique Values with Functions
 - Functions Within Functions.
 - Looking Up Names when Key Values are Identical
 - Determining Columns in a Range
 - Counting with Two Criteria
 - Exiting a For … Next Loop Early
 - Understanding the VLOOKUP Function
 - Using the IF Worksheet Function
 - Calculating Business Days

Excel Worksheets:
A single Excel file can hold multiple worksheets. The tutorials below explain the manipulations that can be carried out on Excel worksheets.
 - Condensing Multiple Worksheets Into One
 - Ordering Worksheets Based on a Cell Value
 - Saving Versions
 - Protecting Worksheets.
 - Sheets for Days
 - Functioning Check Boxes in a Protected Worksheet
 - Changing Excel’s Background Color
 - Synchronized Workbook and Worksheet Names
 - Hiding and Unhiding Worksheets
 - Determining a Worksheet’s Number

Excel’s Environment and Interface:
The folowing tutorials help you to get accustomed to Excel’s Environment and Interface.
 - Getting Rid of the Startup Spreadsheet
 - I Hate the Excel 2007 User Interface
 - Precision and Number Display
 - Precision in Excel
 - Saving Non-Existent Changes
 - Where is Toolbar Customization Information Stored?
 - Changing the Size of Spreadsheet Panes
 - Getting Rid of Spreadsheet Panes
 - Keep Your Headings in View
 - Splitting Your Spreadsheet Window Into Panes

Popularity: 27% [?]

Here is my second post of the Excel Tutorials and Tips at excel.tips.net that cover a host of Excel features as detailed in the links below, which are what we have judged to be the best ones for each topic. To help you become a better Excel user, these Excel tutorials and tips assist you with creating lists of transactions, then using those list to create charts and other analysis tools. (Here is my part 1 post of the Excel learning material from this site.)


Excel Tools:
Various application components can be implemented in Excel. These components include Combo Box and Drop Down Lists. These tutorials explain how to implement them in you worksheet.
 - Adding and Using a Combo Box
 - Adding Buttons to Your Worksheet
 - Creating Dependent Drop-Lists
 - Tracing Errors
 - Creating Scenarios
 - Understanding Auditing
 - Comparing Lists for Duplicates
 - Goal Seeking
 - Hiding Outline Symbols
 - Inserting a Voice Annotation in Your Worksheet

Sorting in Excel:
Sorting data in a worksheet based on certain criteria is paramount to achieving user-understandable data. And these tutorials below explain the sorting process
 - Controlling Sorting Order
 - Creating a Sort Order
 - Determining Sorting Criteria
 - Fixing Odd Sorting Behavior
 - Ignoring Selected Words when Sorting
 - Non-standard Sorting
 - Sorting Data Containing Merged Cells
 - Sorting Dates by Month
 - Sorting Worksheets
 - Sorting while Ignoring Leading Characters

Excel Workbooks:
Workbooks in Excel are the files themselves. And each workbook can hold multiple worksheets. The tutorials below explain the intricacies of working with Workbooks.
 - Accessing a Problem Shared Workbook
 - Creating a Workbook Clone
 - Calculating Only the Active Workbook
 - Making Changes in a Group of Workbooks
 - Merging Many Workbooks
 - Opening a Workbook to a Specific Worksheet
 - Sharing Your Workbook
 - Updating Links in Copied Files
 - Using a Single Password for Multiple Workbooks
 - Automatically Protecting After Input

Data Entry in Excel:
These Data Entry tutorials deal with the shortcuts used to enter data quickly in an Excel worksheet.
 - Entering Dates in Excel
 - Entering Dates Without Separators
 - Entering Large Time Values
 - Jumping to the Start of the Next Data Entry Row
 - Modifying Default Year for Dates
 - Quickly Entering Dates and Times
 - Recording a Data Entry Time
 - Using Early Dates
 - Adding Pop-Up Documentation to a Cell
 - Specifying a Data Validation Error Message

Excel Data Validation:
Validating data in an Excel sheet is as important as data entry itself and these tutorials teach you to validate the data in an Excel sheet.
 - Adding Pop-Up Documentation to a Cell
 - Changing Fonts in Data Validation Drop-Down Lists
 - Ensuring Unique Values in a Column
 - External Data Validation
 - Limiting Entries to Numeric Values
 - Limiting Input to a Format
 - Setting Data Validation Input Messages
 - Specifying a Data Validation Error Message
 - Triggering a Macro for Drop-Down List Changes

Excel Charts:
We now move onto the visual aspect of Excel. Charts help evaluate values in two columns and display them as charts. The tutorials below have an in-depth coverage of Charts in Excel.
 - Changing Chart Size
 - Changing Elements in Lots of Charts at One Time
 - Deleting a Chart
 - Excel Charts in PowerPoint
 - Labeling X-Y Scatter Plots
 - Moving a Chart’s Legend
 - Positive and Negative Colors in a Chart
 - Reordering the Display of a Data Series
 - Unlocking Charts
 - Using Go To to Jump to a Chart Sheet

Excel Graphics:
As with any application in Microsoft’s Office suite, graphics can be inserted in Excel as well. These tutorials deal with creating autoshapes as well as inserting image files.     
 - Creating an AutoShape
 - Displaying Images based on a Result
 - Formatting the Border of a Legend.
 - Inserting from a Camera or Scanner
 - Moving Drawing Objects
 - Placing Textbox Text Into a Worksheet
 - ScreenTip for an Image
 - Smoothing Out Data Series
 - Styles for Lines, Dashes, and Arrows
 - Watermarks in Excel

Excel PivotTables:
One of the most powerful features of Excel is Pivot Tables which is a reporting tool works independent of the data layout in the Excel sheet. To further explore the power of Pivot Tables, the tutorials will help you.
 - Bogging Down with Calculated Items
 - Changing the Default PivotTable Functions
 - Editing PivotTables without Underlying Data
 - Excluding Zero Values from a PivotTable
 - Maintaining Formatting when Refreshing PivotTables
 - Missing PivotTable Data
 - Reducing File Sizes for Workbooks with PivotTables
 - Suppressing Zero Values in PivotTables
 - Text Truncated in PivotTable
 - Weighted Averages in a PivotTable

Excel Files:
The section below explain the different files in Excel and their uses.
 - Adding a File Path and Filename
 - Aligning Cells when Importing from CSV
 - Appending to a Non-Document Text File
 - Avoiding Scientific Notation on File Imports
 - Comma-Delimited Differences for PC and Mac
 - Converting from SuperCalc
 - Correctly Saving Delimited Files
 - Creating a CSV File
 - Faster Text File Conversions
 - How Excel Treats Disk Files

Excel Add-Ins:
An Excel Add-In is a file that loads when Excel starts. This file can contain additional functionality to Excel, and the tutorials below explain how Excel Add-Ins work.
 - Automatically Loading Add-ins
 - Excluding a Specific Add-In at Startup
 - Removing Add-ins
 - The EDATE Function
 - Understanding Add-Ins
 - Using Custom Add-Ins
 - Converting Units
 - Finding the Analysis ToolPak Add-In
 - Adding a Report
 - Using the Report Manager

Online and Web:
The tutorials below explain Excel’s ability to interface with the web, including generating a web page with it.
 - Automatic Text in an E-mail
 - Extracting URLs from Hyperlinks
 - Get Rid of Web Stuff
 - Linking to a Specific Page in a PDF File
 - References to Hyperlinks Aren’t Hyperlinks
 - Retrieving Web Query Data without Interruption
 - Connecting To a Discussion Server
 - Filtering Web Discussions
 - Adding Excel Information to a Web Page
 - Generating a Web Page

Working with Other Programs:
Excel can also interface with other applications such as AutoCAD and Lotus 1-2-3, thereby allowing users to exchange data between them. Thee tutorials further explain this concept.
 - Exporting from Excel to AutoCAD
 - File Formats that Include Field Formats
 - Ignoring Other Applications
 - Importing Huge Data Files
 - Working with Lotus 1-2-3 Spreadsheets
 - Preparing Data for Import into Access
 - Snapshots of Excel Worksheets for PowerPoint
 - Working with Imperial Linear Distances
 - Embedding Fonts in Excel
 - Word Documents from Excel Macros

General Excel Tutorials:
The tutorials below follow a general theme of interacting with Excel providing file properties and editing custom dictionaries.
 - A Ruler in Excel
 - Additional Ways of Displaying a Hidden First Column
 - Backing Up Your AutoCorrect Entries
 - Changing Error Checking Rules
 - Changing Excel’s Starting Date
 - Controlling Display of Page Breaks
 - Determining Your Version of Excel
 - Editing Custom Dictionaries
 - Embedding Fonts in Excel
 - Finding Commands in Excel 2007

Popularity: 24% [?]

Here is my first post of the PowerPoint Tutorials and Tips at ellenfinkelstein.com, explaining many of Powerpoint’s potent features and how they can be used in your presentation. The difference between a good presentation and a great presentation is how effectively you use Powerpoint’s capabilities in your presentation. Powerpoint is the presentation program from Microsoft’s Office suite of applications (Here is the second part of the Powerpoint material from this site.)


PowerPoint AutoShapes (Shapes) & Text Boxes:
Powerpoint users can extend their creativity using auto shapes to create custom shapes to be used in their presentations. The tutorials below explain working with auto shapes and text boxes.
 - Creating soft edges
 - Changing the default for new objects
 - Create multi-color gradients
 - Turn AutoShapes into pictures
 - 3D effects with radial gradients
 - Cycle through overlapping objects to select them
 - Layer two fill effects
 - Rotation tips
 - Use transparency gradients
 - Attach objects exactly
 - Create Bezier curves
 - Create cutouts
 - Use materials and lighting for interesting fills
 - Create text reflections
 - Create soft shadows


PowerPoint Backgrounds & Color:
Keeping in line with creating simple and effective presentations, it is essential to maintain a single color and texture. The background can also be divided into specify sections on the presentation. A Color Scheme is usually a standard that is used in the design of the slide. The links below explain how a background can be set and how to use color schemes.
 - Backgrounds: Using mid-range colors
 - Using Web page backgrounds in PowerPoint
 - Copying colors from a Web site
 - Create multi-color gradients
 - Create an instant background from a photo
 - Choose fonts and colors for legibility
 - Create a simple border
 - Choose colors based on desired results


PowerPoint Charts, Tables & Diagrams:
To further augment the visual appeal of Powerpoint, we can use charts and tables to explain, say the growth of a company or the increase in sales. The tutorials given below show how you can create and use charts and tables.
 - Designing chart titles
 - Formatting bar charts
 - Animate a chart or table
 - Push PowerPoint charting options to the limit
 - Create effective graphs/charts
 - Create a timeline/agenda in PresentationZen style NEW


Hyperlinks:
Web browsers have a front and back button. Similarly, Powerpoint uses hyperlinks to move front and back between slides to allow users review them. The links below explain how to implement hyperlinks in your Powerpoint presentation.
 - Create hyperlinks in a timed presentation
 - Create invisible buttons


Images in PowerPoint:
In these tutorials, we further explain the manipulations that can be carried out on images in a Powerpoint presentation.
 - Managing graphics to reduce size
 - Importing art into the Clip Gallery
 - Resizing your presentation
 - Colorizing a photo for a background
 - Turn AutoShapes into pictures
 - Recolor bitmap images
 - Find free photos
 - Where and how to insert an image
 - Inside secrets to making your visuals look professional
 - Crop around an image
 - Emphasize a section of text or an image
 - The Magic of False Backgrounds
 - Recolor graphics in PowerPoint 2007
 - Cool contour shadows
 - 3D and reflection technique
 - Magnify an image
 - Change a picture in PowerPoint 2007


Music, Sound, & Video in PowerPoint:
Apart from using pictures and custom shapes, we can also use audio and video content in a slide to make it more interactive. These tutorials explain how to use audio and video in a Powerpoint slide.
 - Playing music continuously in a Web-based presentation
 - Play music or narration throughout a presentation
 - Control movies with buttons
 - Synchronize animation with music


PowerPoint Slide Layout:
To help with slide layout, we can use Guides that are easily available in Powerpoint. We can also use a pre-defined master Guide for the rest of the slides in a presentation. The links below deal with slide layout and its intricacies.
 - Creating a grid for perfect layout
 - Nudging objects slightly
 - Reapply the slide layout
 - Beyond Words
 - Create a custom layout
 - Put objects exactly on top of each other
 - Align objects perfectly


PowerPoint Slide Masters & Templates:
At some point during the presentation, you may want to follow a design throughout your slides. This can be done using Templates and the tutorials below explain how do go about working with them.
 - Creating multiple slide “Masters” in PowerPoint 2000
 - Create your own template
 - Get rid of a template


Text & Fonts:
Fonts and text on a slide must be readable and should have the right color. They should also have a constant size and weight. The tutorials below give you an in-depth coverage on the kind of text and fonts you can use in a slide.
 - Choosing the most readable font
 - Controlling text shadows
 - Animating text on top of text
 - Fitting more text in a Placeholder or AutoShape
 - Text animation techniques
 - Choose fonts and colors for legibility
 - Set vertical alignment of text
 - Emphasize a section of text or an image
 - Highlight important words
 - Quickly change text color line by line


Animation & Transitions in PowerPoint:
Powerpoint’s animation feature is used to create slide-by-slide animations for use in presentations. The tutorials below help you create and use various animations and effects with objects on the screen.
 - Putting Flash animation in PowerPoint
 - Animating text on top of text
 - Animate a chart or table
 - Motion path animation effects
 - Create the effect of a line drawing itself
 - Use triggers to create interactive charts
 - Synchronize animation with music
 - Text animation techniques
 - Multimedia animation techniques
 - Create a pop-up window
 - Animate a revolving earth
 - Cascading animation
 - Dissolve one image into another
 - Create a slide show that really slides!
 - Highlight important words
 - Use advanced animation to show growth & motion
 - Make an object disappear behind another object
 - Magnify an image
 - Animate a table in 2007
 - Quickly change text color line by line
 - Match the end of a motion path animation to the beginning of another
 - Animate a bouncing ball
 - Circle an object
 - Tutorial on animation and best practices
 - Duplicate animation
 - Animation for entertainment

Popularity: 24% [?]

Here is my second post of the PowerPoint Tutorials and Tips at ellenfinkelstein.com, describing how to harness Powerpoint power to make compelling and memorable presentations. It is the ease of use and sophistication of Powerpoint that has made it a popular visual aid to help better explain ideas and concepts of almost any topic. (Here is the first part of the Powerpoint material from this site.)


PowerPoint Design Principles:
As with any application that helps creating visuals, it is important to follow design principles while creating them. And these tutorials help implement design principles in Powerpoint.
 - Beyond Words
 - Design guidelines for web conferences
 - Simplicity and understatement
 - The importance of design
 - Try design variations
 - Best practices for PowerPoint presentations in Second Life
 - Tell ‘n’ show slide design
 - Put one point on a slide


Craft Memorable Content: Writing & Organizing:
Simplicity has its virtues. Using clear language helps people understand concepts better when presenting them. And this makes it effective as people tend to remember it longer. The tutorials given below will explain how to go about making your presentation more attractive and memorable.
 - Using hyperlinks
 - Expanding one slide into two
 - Organizing content
 - Complete set of PowerPoint tutorials
 - Using a Summary Slide for questions & answers
 - Designing a Web-style presentation
 - Mind Mapping to organize your presentation
 - Repurpose presentations for a kiosk or the Web
 - 3 Components of an effective presentation
 - Create slides from audience input
 - Beyond words
 - Cliff Atkinson’s Beyond Bullet Points
 - Create a quiz in PowerPoint
 - Is PowerPoint evil?
 - Link to other presentations and return to the original presentation
 - Choose titles for a summary slide
 - Base content on your audience
 - Quickly get rid of bullets
 - Tell a story, or where’s the point in all this?
 - Hyperlink to a specific slide in another presentation, or specific location in another file
 - Protect slide content
 - Import text from Word or Notepad
 - Choose words for your audience
 - Add relevance with layers of meaning
 - Add notes during a presentation
 - Understand the types of speeches
 - PowerPoint principles for education
 - A good introduction/opener
 - Export all presentation text
 - Create a visual menu
 - Add flexibility with custom shows
 - Use an audience-centered structure
 - How many bullets should I put on a slide?
 - Create a drop-down menu
 - Create a looping introduction
 - Create section markers
 - Do the research!
 - Create a WebQuest in PowerPoint
 - Stay focused with pecha kucha
 - Create a fast-moving presentation
 - Put one point on a slide
 - Use copywriting principles for your presentations
 - Support your statements


Deliver with Confidence:
The key to carry out a good PowerPoint presentation is to rehearse it beforehand. Essentially, telling the audience about the agenda and crafting your presentation to look more like a story does a better job than having to read out content from the slide. These tutorials below help you deal with presenting to a range of audiences, young and old, and how to keep them engrossed throughout.
 - Rehearsing with narration
 - PowerPoint and the Future of Education
 - Making great handouts
 - Creating a slide list
 - Creating a compact list of notes
 - Going to the previous slide when you have text animation (builds)
 - Export the text in a presentation
 - Reduce the size of your presentation files
 - 12 steps to becoming a charismatic speaker
 - Print in black & white or grayscale
 - Play sound or music by passing mouse over an icon (without clicking)
 - Presentation styles
 - Black out the screen and other delivery tips
 - Create a background for printed handouts
 - Manage the process from conception to rehearsal to handouts
 - Keys to being a unique and memorable presenter
 - Start a presentation at a specified time
 - Don’t look at the screen!
 - Create notes as you deliver in PowerPoint 2003
 - Presenting to young audiences
 - Add taped narration to a presentation
 - Public speaking is the number 1 fear — How to beat it
 - Use feedback to complete the communication cycle
 - Life after death by PowerPoint
 - Have a conversation with your audience
 - A good introduction/opener
 - Undim bulleted text
 - Add flexibility with custom shows
 - Put a presentation on a CD that runs automatically
 - Turn off pop-ups when presenting
 - Best practices for PowerPoint presentations in Second Life
 - Importing a PowerPoint presentation into Flash
 - Collect information or feedback
 - Create a game quiz (similar to Jeopardy)
 - Create a timer
 - Display a quarter-size slide show view
 - Guest Expert: Dana Bristol-Smith on “It’s All About Presentation: Eight Lessons from Japan”
 - Guest Expert Suzanne Bates: How to Be Yourself in Front of an Audience
 - Successfully print presentations
 - Ask the audience questions
 - Create a timeline/agenda in PresentationZen style

Popularity: 26% [?]

Here are 25 Adobe Photoshop Tutorials at bukisa.com that cover diverse topics, such as Layers, Actions, Mattes, Curves, Filters, and Color Tones. Over the years, Photoshop has become the de-facto standard in professional image editing and for creating digital graphics. There are many variants of Photoshop, namely Photoshop Elements which is a consumer-oriented version that has all the tools of Photoshop but with simpler options and Photoshop Express which is a quick and easy-to-use online tool for editing images. Included in these Photoshop tutorials are some video tutorials as well for a more interactive learning experience. 


25 Photoshop Tutorials:

 - How to create an action in Adobe Photoshop
 - Photoshop Simple Step Creating Water Texture
 - Creating Perfect Mattes Using Channels in Adobe Photoshop CS3
 - Learning how to draw cartoons in photoshop
 - How to Photoshop a Movie Poster Desktop Wall Paper
 - How to Photoshop a Movie Poster Desktop Wall Paper – Part 2
 - Making an abstract signature with Photoshop
 - How to Make Aqua Text in Photoshop
 - Creating Navigation in Photoshop
 - Site of Photoshop Video Tutorial
 - Old Photo Effect with Photoshop
 - Clean up lo-rez Bitmap images in Photoshop
 - Photoshop Mama’s Layer Comps to PDF CS3-PART 2
 - Photoshop Mama’s Layer Comps to PDF CS3-PART 1
 - Advanced Glow Effects with Photoshop
 - From dull to interesting picture
 - Optimize Adobe BridgeCS3 for Photographers      
 - Changing the color tone in Photoshop    
 - Creating a Reflection with Photoshop
 - How to use Photoshop Actions
 - Photoshop: Using the Liquify Effect
 - How to Use Curves in Photoshop
 - How to Make Poster using Photoshop
 - How to Burn and Dodge in Photoshop
 - Photoshop: Using Distort Filters

Popularity: 21% [?]

Here are 21 Flash Tutorials at bukisa.com that deal with creating animation and effects for web pages. Flash, earlier developed by Macromedia and currently by Adobe, is a popular application for integrating animation, audio and video in web pages to create rich Internet applications. These Adobe Flash Tutorials demonstrate Flash-based concepts such as masks, transitions, sound, and programming using Flash, not to mention animation tools such as Adobe Flex. To get you up and running in Flash, they show you how to download and install Flash players for browsers and using drag-and-drop components to develop a top-of-the-line user interface. These text and video-based Adobe Flash tutorials deal with the intricacies of creating simple and easy-to-use Flash movies and also integrating them in web pages. These Flash tutorials also provide a few simple games that can be quickly developed in Flash.


21 Adobe Flash Tutorials:

 - How to Play Kanye West Flashing Lights – Piano Tutorial
 - How to Add Flash SWF Files to a Page in Dreamweaver CS4
 - How to use Masks in Flash
 - Animation using a motion guide in Flash – Tutorial
 - Fashion style logo animation in Flash – Tutorial
 - Animation using clipping mask in Flash – Tutorial
 - black and white mask animation in Flash – Tutorial
 - Glowing object animation in Flash – Tutorial
 - Drag and drop object in Flash – Tutorial
 - Cool Image Presentation with nice transitions in Flash - Tutorial
 - Changing the pivot point position in Flash – Tutorial
 - Introducing the Flash Player – Adobe Flex 2
 - How to Download and Install the Adobe Flash Player Plug-in
 - How to Test Adobe Flash, Shockwave, Acrobat and Java Plug-ins/Readers
 - How to use Audio in Flash Animation
 - How kids Can learn and have fun with Flash games
 - Away3D Programming Tutorial – Effects
 - Pandemic II: The Free Flash Game That Gives Users a Chance to Create a Super Virus, Bacteria, or Parasite
 - Papervision 3D Programming Tutorial – Creating a Papervision Component
 - Away3D Programming Tutorials – Getting Started
 - Papervision 3D Programming Tutorial – Enhanced Fog

Popularity: 21% [?]

Here is a nice Microsoft Word 2003 Reference Tutorial hosted at windowsreference.com. It provides detailed bulleted instructions for each sub-feature shown below. This Word tutorial reference is also available in pdf format here: microsoft-word-2003-reference.pdf.


Word Features Explained:

File Management:
 - Create a New File
 - Open an Existing File
 - Save a File
 - Save a File as a Web Page
 - Save a Formatted Document as a Template
 - Print a File
 - Print Preview

Set AutoRecover and Automatic File Backup:
 - To set AutoRecover & Automatic Backup:
 - To recover your document after a power failure or other shut-down
 - To replace a damaged file with its backup copy

File Navigation:
 - Go to Beginning of Document
 - Go to End of Document
 - Go to Next Page
 - Go to Previous Page

File Editing: Delete, Select, & Copy/Paste:
 - Delete
 - Selecting Text
 - Copy or Cut (Move) & Paste

Searching:
 - Word Search
 - Customize Word Search
 - Replace Word

Formatting Features:
 - Formatting Toolbar
 - Using Document Themes
 - Font Properties (alternate method)
 - Footnotes & Endnotes
 - Header & Footer
 - Hyperlink
 - Lists: Numbered or Bulleted
 - Margins
 - Page Break
 - Page Numbering
 - Page Orientation
 - Line Spacing
 - Special Symbols or Characters
 - Subscripts & Superscripts
 - Tables
 - Tabs

Images:
 - Insert an Image File
 - Delete an Image
 - Move an Image
 - Re-size an Image
 - Wrap Text Around an Image

Screen Views:
 - Normal View
 - Print Layout View
 - Outline View
 - View Multiple Documents on Screen

Spelling & Grammar:
 - Spellcheck
 - Grammar-check

Popularity: 26% [?]

Here are two recent Web Programming Tutorials posts that I’ve recently published at our other blog tutorial site, intelligentedu.com/blogs.


51 Web Development Tutorials

Here are 51 Web Development Tutorials at devhood.mit.edu. The web development topics covered by these tutorials are vast and varied, and include HTML, DHTML, CSS, CGI, ASP, PHP, Perl, Java, Javascript and XML. Each of these topic has multiple, easy-to-understand tutorials, and they should get you up to speed in no time.


8 PHP Tutorials

Posted here are 8 good PHP Tutorials at bukisa.com. PHP is a scripting language for designing and generating web pages and its freely available on most web servers. These PHP tutorials explain various concepts of PHP and how to get started with coding this scripting language.

Popularity: 31% [?]

Here are 17 Adobe Photoshop Tutorials, with well-illustrated with screenshots that cover effects that include glowing and 3D text effects. These tutorials also deal with inserting lighting effects to photos and even enhancing them. Also provided are a list of shortcuts every designer should know, and a comprehensive coverage of Photoshop’s Brush tool. These Adobe Photoshop Tutorials are a great starting point to create some really good-looking glow effects and lighting effects.


17 Photoshop Tutorials:

 - Great looking, Easy Collage Effect
 - Create a simple spaceship in Illustrator
 - 3D Text On Fire
 - Into the Light
 - Create great looking text, easily
 - The Brush Experiment
 - Create 3-D text with some extreme lighting
 - Photoshop Lighting Effects
 - Beginners Guide to Photoshop Brushes
 - Creating a Billboard scene in Photoshop
 - Quick tips on how to enhance your photos
 - Transform a day photo into a creepy night one
 - Glowing text in space scene
 - A List of Photoshop Shortcuts Every Designer should Know
 - What does your website say?
 - Create great looking text, easily: Part 2
 - Beginners Guide to Photoshop Brushes

Popularity: 20% [?]