Free Training for Photoshop, Flash, Dreamweaver, FrontPage, and other Adobe & Macromedia Apps




    



March 30, 2009

55 Excellent Dreamweaver Tutorials

Here are 55 well-written Dreamweaver Tutorials, from layersmagazine, teaching a wide variety of Dreamweaver features that you need to know in order to make the most out of this popular web design and development application. Topics covered by these illustrated and video Dreamweaver tutorials include: Ajax menus, Web templates, Photoshop integration, Flash integration, Selectors, CSS, iFrames, Smart objects, Widgets, Forms, Spry navigation, Behaviors, New Extensions, Layers, and Accessibility. (The tutorials are for Dreamweaver versions CS4, CS3 and 8).


55 Dreamweaver Tutorials:

 - Using Dynamic Web Templates in Dreamweaver, Part 1
 - Using Dynamic Web Templates in Dreamweaver, Part 2
 - Edit an AJAX Drop-Down Menu in Dreamweaver
 - Test Driving Dreamweaver CS4
 - Taking Image Slicing from Photoshop to Dreamweaver
 - Insert Google Ads with Dreamweaver
 - Advanced Selectors in Dreamweaver
 - Dreamweaver Slide Shows: Quick and Creative
 - Redefined HTML Tags
 - Building CSS-Based Layout in Dreamweaver
 - Using IFrames in Adobe Dreamweaver
 - CSS Basics in Adobe Dreamweaver
 - Dreamweaver XML Flash Slideshow Extension
 - Using the Dreamweaver 3D Wall Extension
 - Creating CSS Columns in Dreamweaver
 - Flash Video the Easy Way, Part 1
 - Flash Video the Easy Way, Part 2
 - Dreamweaver CS4 Interface
 - Dreamweaver CS4 Smart Objects
 - Dreamweaver CS4 Widgets
 - Dreamweaver CS4 CSS Features
 - Creating Rollovers in Dreamweaver CS3
 - Printer-Friendly Pages Using Dreamweaver and External Style Sheets
 - Troubleshooting CSS in Dreamweaver
 - Adding Flash Files to a Webpage in Dreamweaver
 - Feathered Transparency With Photoshop & Dreamweaver
 - Feathered Transparency With Photoshop & Dreamweaver
 - Image Slicing in Photoshop CS3
 - Using Forms in Dreamweaver
 - Dreamweaver: Give Your Site a Little Flash with CS3
 - When HTML Goes Bad
 - Cascading Style Sheets: Choosing the Right Selector
 - Dreamweaver and Photoshop Integration
 - Spry Navigation in Dreamweaver CS3
 - Building a Newsletter App in PHP with Dreamweaver CS3
 - Creating Collapsible Panels with Spry in Dreamweaver
 - Three Approaches to Design in Dreamweaver
 - Dreamweaver Code and File Tips
 - Dreamweaver: CSS Jump-Start
 - Time-Saving Templates In Dreamweaver 8
 - Dreamweaver: Spry Collapsing Panel
 - Passing Variables Using Flash and Dreamweaver
 - Swapping Behaviors with Dreamweaver
 - Using Behaviors in Dreamweaver
 - Enhancing Dreamweaver with New Extensions
 - Create Accessible CSS Layouts in Dreamweaver
 - Creating Accessible Tables for Data Using Dreamweaver 8
 - Creating a Navigation Bar with CSS in Dreamweaver
 - Connecting an HTML Form with a CGI Script in Dreamweaver
 - Designing with Layers in Dreamweaver 8
 - Layers vs. Other Design Options in Dreamweaver
 - Defining a Site in Dreamweaver
 - An Overview of CSS in Dreamweaver 8
 - Implementing accessibility in Dreamweaver
 - Site building with DW’s power tools: templates



Tags for this post>>

78 Keyboard Shortcuts for Microsoft Word

Here are 78 Microsoft Word Keyboard Shortcuts, which include keyboard shortcuts for formating text, line spacing, and selecting text. These shortcuts will help you become more efficient at using Word. They will work with all recent versions of Word.


Word Function Keys
F1: Gets Help or visit Microsoft Office Online
F2: Moves text or graphics
F3: Inserts an AutoText entry
F4: Repeats the last action
F5: Chooses the Go To command (Edit menu)
F6: Goes to the next frame
F7: Chooses the Spelling command (Tools menu)
F8: Extends a selection
F9: Updates selected fields
F10:Activates the menu bar
F11: Goes to the next field
F12: Save As command


Control + Function Key
Ctrl + F2: Print Preview command (File menu)
Ctrl + F3: Cut to the Spike
Ctrl + F4: Closes the window
Ctrl + F5: Restores the document window size (for example, after maximising it)
Ctrl + F6: Goes to the next window
Ctrl + F7: Move command (title bar shortcut menu)
Ctrl + F8: Size command (title bar shortcut menu)
Ctrl + F9: Inserts an empty field
Ctrl + F10: Maximises document window
Ctrl + F11: Locks a field
Ctrl + F12: Open command (File menu)


Control + Shift + Function Key
Ctrl + Shift + F3: Inserts contents of Spike
Ctrl + Shift + F5: Edit a bookmark
Ctrl + Shift + F6: Goes to the previous window
Ctrl + Shift + F7: Updates linked information in a Word source document
Ctrl + Shift + F8: Makes vertical text block
Ctrl + Shift + F9: Unlinks a field
Ctrl + Shift + F11: Unlocks a field
Ctrl + Shift + F12: Print command (File menu)


Shift + Function Key
Shift + F1: Starts context-sensitive Help or reveals formatting
Shift + F2: Copies text
Shift + F3: Changes case of letters
Shift + F4: Repeats a Find o
Shift + F5: Moves to the last change
Shift + F6: Goes to the previous pane or frame
Shift + F7: Launches Thesaurus (Tools menu, Language submenu)
Shift + F8: Shrinks a selection
Shift + F9: Switches between a field code and its result
Shift + F10: Displays a shortcut menu
Shift + F11: Goes to the previous field
Shift + F12: Save command (File menu)


Alt + Function Key
Alt + F1: Goes to next field
Alt + F3: Creates an AutoText entry.
Alt + F4: Quits Word
Alt + F5: Restores program window size
Alt + F6: Moves from an open dialog box back to the document for some dialog boxes like Find and Replace.
Alt + F7: Finds the next misspelling or grammatical error. Check spelling as you type check box must be selected.
Alt + F8: Runs a macro
Alt + F9: Switches between all field codes and their results
Alt + F10: Maximises the program window
Alt + F11: Displays Visual Basic code


Alt + Shift + Function Key
Alt + Shift + F1: Goes to the previous field
Alt + Shift + F2: Save command (File menu)
Alt + Shift + F9: Runs GOTOBUTTON or MACROBUTTON from the field that displays the field results
Alt + Shift + F10: Displays the menu or message for a smart tag. If more than one smart tag is present, switch to the next smart tag and display its menu or message
Alt + Shift + F11: Starts Microsoft Script Editor


Control + Alt + Function Key
Ctrl + Alt + F1: Displays Microsoft System Information
Ctrl + Alt + F2: Open command (File menu)


Basic Character Formatting

  • To change text to bold, press Ctrl+B, and to reverse bold back to normal text, press Ctrl+B again.
  • To change text to italic, press Ctrl+I, and to reverse italics back to normal text, press Ctrl+I again.
  • Underline text by pressing Ctrl+U, and to reverse underlining, press Ctrl+U again.

Changing Line Spacing

Changing the line spacing inserts extra space between the lines of text in a paragraph (or all paragraphs in a block). In Word, there are three keyboard shortcuts for three common types of line spacing: single-spacing, 1 1/2-line spacing, and double spacing:
  • To single-space a paragraph (or all paragraphs within a text selection), press Ctrl+1.
  • To double-space a paragraph (or paragraphs that are selected), press Ctrl+2.
  • To space 1 1/2 lines, press Ctrl+5. 
Selecting a Block with the Keyboard

To quickly select characters and lines as a block, you can use the Shift key in combination with any of the cursor control keys as described on the following pages.

  • Shift+Left Arrow: to select one character at a time to the left of the toothpick cursor.
  • Shift+Right Arrow: to select one character at a time to the right of the toothpick cursor.
  • Shift+Home: to select a block of text from the toothpick cursor to the beginning of the line.
  • Shift+End: to select a block of text from the toothpick cursor to the end of the line.
  • Shift+Up Arrow: to select a block of text from the toothpick cursor to the line above.
  • Shift+Down Arrow: to select a block of text from the toothpick cursor to the line below.

Shift+Click to Select Text Block of Any Size

To select a text block of any size, use the Shift+click technique as follows:
  1. Positioning the mouse toothpick cursor where you want the block to start (the anchor point).
  2. Navigate through your document using the vertical scroll bar.
  3. Press and hold the Shift key and then click the mouse where you want the block to end.
  4. The text from the toothpick cursor to wherever you Shift+clicked the mouse is selected as a block.

F8 Extended Selection Mode

Press the F8 key multiple times to select specific text, as follows:
  • Select a Word: Press the F8 key twice to select a word. (However, its easier to just double-click the word to select it.)
  • Select a Sentence: Press the F8 key three times with the mouse cursor within a sentence to select that sentence.
  • Select a Paragraph: Press the F8 key four times with the mouse cursor within a paragraph to select that whole paragraph.
  • Select the Entire Document: Press the F8 key five times to select the whole document. (Or press Ctrl+A.)
To use the mouse and the F8 key together to select text of any size, place the mouse cursor at either end of the selection block and then press the F8 key. Then, go to the other side of the text you need to select and click the mouse cursor.

To exit F8 Extended Selection mode, press the Esc key.



Tags for this post>> | |

17 Access 2007 Database Tutorials

Here are 17 Microsoft Access 2007 Database Tutorials hosted by bukisa.com. Access is Microsoft’s database management application with a graphical interface. These Access Tutorials cover many Access features and concepts, including table creation, database template creation, and database access options. The tutorials also provide an general overview of the Access database, and details on database objects, and adding custom commands in the Access toolbar. 


17 Access Tutorials:

 - How to Convert Older Version of Microsoft Access Database
 - How to Create a Table in a Microsoft Access Database
 - How to Use the Database Tools Tab in Microsoft Access 2007
 - Overview of Microsoft Access 2007 Database – Access Options
 - How to Use the Create Tab in Microsoft Access 2007
 - How to Use the Home Tab in Microsoft Access 2007- Part 1
 - How to Use the Office Menu in Microsoft Access 2007
 - How to Use the External Data Tab in Microsoft Access 2007
 - How to Create a Microsoft Access 2007 Database Template
 - How to Use the Home Tab in Microsoft Access 2007 – Part 2
 - Overview of Microsoft Access 2007 Database Objects
 - How to Build a Microsoft Access 2007 Database
 - Overview of Microsoft Access 2007 Database
 - How to Enable the Security Warning in Microsoft Access 2007
 - Overview of Microsoft Access 2007 Database Templates
 - How to Add Custom Commands in the Quick Access Toolbar
 - How to Customize the Navigation Pane of Microsoft Access



Tags for this post>>

8 Outlook 2007 Tutorials

Given below are 8 very good Outlook 2007 Tutorials at the University of New Hampshire. Outlook is Microsoft’s email client and includes a calendar, a task manager, a contact manager, and note taking as well. These Outlook 2007 Tutorials explain how to create views for individual folders, maintaining an Address Book, organizing a Calendar and using Outlook without an internet connection and synchronizing it with web mail. Also taught here is how Outlook provides an option to save space on the hard disk by archiving and organizing mails.


8 Outlook 2007 Tutorials:

Outlook Views Tutorial
This Outlook tutorial deals with the stlyes and customization you can carry out on the view available to you when you open Outlook. The arrangement of the folders, frames and windows are explained here.

Outlook Settings Tutorial
The level to which Outlook can be customized is explained in this tutorial. The Settings tab in Outlook provides a high level of customization for the user, in terms of folders, archiving and signature handling.

Outlook Mail Tutorial
This tutorial explains sending and receiving email messages using Outlook. It also provides instructions on how to create a new email, add the recipients, create signature files, and view other mailboxes.

Outlook Address Book Tutorial
The Address Book in Outlook holds all addresses from the Global Address Book and other contacts that the user has stored. This tutorial explains how to create new contacts and store their details, and also how to create contact folders and distribution lists.

Outlook Calendar Tutorial
Much like any other calendar, the Outlook Calendar stores the monthly and yearly calendar. However, the Outlook calendar differs in the sense that it allows users create and schedule meetings and appointments with contacts in the Address Book and this tutorial explains how to do just that.

Outlook Organization Tutorial
Organizing the folders in Outlook is paramount in quickly and easily finding mails. This tutorial explains the Organize Tool in Outlook 2007 which keeps the view neat and clean. It also discusses the steps for creating sub-folders and rules.

Outlook Saving Space Tutorial
Every mailbox is allowed a storage space quota. It is important that the user follows good email management principles to keep this quota in check. This tutorial explains these principles in detail and how to archive your email messages.

Outlook Offline Access Tutorial
Offline access is a way to work with outlook when a network connection. This tutorial provides instructions on how Outlook can be setup in this environment and synchronize mails without a network connection.



Tags for this post>>

Web Design Tutorials

There is no limit to the extent to which an element can be designed, as there is room for infinite perfection and these Web Design Tutorials emphasize that at alistapart.com. Web Design principles focus a great deal of emphasis on web page layout, text and typography, and shapes and colors to create a visual experience that has a lasting appeal. Very often, web design combines the process and the product that stylizes and presents the designers idea.


Web Graphic Design Tutorials:
These tutorials deal with aspects related to graphic design and style guides. It also explains graphic design for the internet and reiterates how the positioning of an element in a layout can make a huge difference to the overall design.
 - Fluid Grids
 - The Details That Matter
 - Faux Absolute Positioning
 - Writing an Interface Style Guide
 - Saving the Spark: Developing Creative Ideas
 - Design is in the Details
 - Designing For Flow
 - Understanding Web Design
 - Design by Metaphor
 - Staying Motivated


User Interface Design Tutorials:
Better known as UI Design, these tutorials help in maintaining a consistent design flow when designing web pages and user interfaces for applications.
 - The Elegance of Imperfection
 - The Elements of Social Architecture
 - Deafness and the User Experience
 - Writing an Interface Style Guide
 - Sign Up Forms Must Die
 - Designing For Flow
 - Understanding Web Design
 - Put Your Content in my Pocket, Part II
 - Never Use a Warning When you Mean Undo
 - Quick CSS Mockups with Photoshop


Typography Tutorials:
Typography deals with how text should be displayed for an aesthetic appeal during design. These tutorials cover text size, weight, type and having a flicker free display for avoiding elasticity.
 - Understanding Web Design
 - How to Size Text in CSS
 - CSS @ Ten: The Next Big Thing
 - Setting Type on the Web to a Baseline Grid
 - Big, Stark & Chunky
 - Dynamic Text Replacement
 - Power To The People: Relative Font Sizes
 - Elastic Design
 - Reading Design
 - The Trouble With EM ’n EN (and Other Shady Characters)


Web Layout Tutorials:
Essentially, the layout of text and graphics on the screen and how it is done has a deep impact on how things are perceived on the display. These tutorials outline how the layout can be used effectively for displaying these components on the screen.
 - The Elegance of Imperfection
 - Fluid Grids
 - In Defense of Readers
 - The Details That Matter
 - Return of the Mobile Style Sheet
 - Zebra Striping: More Data for the Case
 - Faux Absolute Positioning
 - Sketching in Code: the Magic of Prototyping
 - Zebra Striping: Does it Really Help?
 - Sign Up Forms Must Die



Tags for this post>>

59 Flash Tutorials

Here are 59 well-written Flash Tutorials from flashmymind.com that cover Flash fundamentals and an introduction to the latest version of Flash’s native object-oriented programming language, ActionScript 3, with various coding examples. Most of the animation explained in these Flash Tutorials is done programmatically to better explain ActionScript, its variables and how to build the script. These Flash Tutorials also deal with XML, menu creation, loading multiple images and mouse-based image animation.


59 Flash Tutorials:

 - Basic Concepts of Flash
 - Animating with Flash
 - Vertical 3D Carousel with ActionScript 3
 - Flash Bubbles with ActionScript 3
 - Multiple 3D Carousels with ActionScript 3
 - Flash 3D Carousel with XML and ActionScript 3
 - 3D Tunnel with ActionScript 3
 - Flipping Image Pieces with ActionScript 3
 - Modern Preloader with ActionScript 3
 - Glowing Text Effect with ActionScript 3
 - Cool Menu with ActionScript 3
 - Random Boxes Text Effect with ActionScript 3
 - Advanced XML Menu with ActionScript 3
 - Cool MovieClip Scroller
 - Creating a Menu via XML
 - XML Pages with ActionScript 3
 - ActionScript 3 TransitionManager
 - ActionScript 3 Trail Effect
 - ActionScript 3 Spiral
 - ActionScript 3 Snowfall Effect
 - Shooting Masks via ActionScript 3
 - ActionScript 3 Shake Effect
 - ActionScript 3 Custom Scrollbar
 - Rotating Mouse Trail with ActionScript 3
 - Rotating Menu via ActionScript 3
 - Revealing an Image with ActionScript 3
 - ActionScript 3 Random Lines
 - ActionScript 3 Random Circles on Image
 - ActionScript 3 Web Portfolio
 - ActionScript 3 Physics
 - Mouse Over Image Animation
 - Cool Mask Animation with ActionScript 3
 - Loading Multiple Images
 - ActionScript 3 Image Mask Animation
 - Image Fill with ActionScript 3
 - ActionScript 3 Growing Lines
 - ActionScript 3 Magnifying Glass Effect



Tags for this post>> |

17 Photoshop Tutorials

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



Tags for this post>>

March 27, 2009

Web Programming and PHP Tutorials

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.



Tags for this post>> |

Word 2003 Reference Tutorial

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



Tags for this post>> |

21 Flash Tutorials

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



Tags for this post>>

March 26, 2009

25 Adobe Photoshop Tutorials

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

Tags for this post>>

March 25, 2009

PowerPoint Tutorials and Tips, Part 2

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



Tags for this post>>

PowerPoint Tutorials and Tips, Part 1

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



Tags for this post>>

March 24, 2009

Excel Tutorials and Tips, Part 2

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



Tags for this post>>

Excel Tutorials and Tips, Part 1

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



Tags for this post>>

March 21, 2009

Excel 2007 Data Analysis Tutorials

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



Tags for this post>>