Lynda.com – FileMaker Pro 11 Essential Training

November 4, 2011 Tinggalkan komentar

Publisher : Lynda.com
Platform : FileMaker Pro
Format : Mov
Size : 1 CD

Links : Homepage

 

Description :

In FileMaker Pro 11 Essential Training, Cris Ippolite demonstrates the principal features and functions of this popular database software, including creating tables and relationships, managing fields and records, and working with layouts. The course shows FileMaker developers how to find, sort, and share data as well as how to create reports, calculations, and scripts. It also covers brand new features in FileMaker Pro 11 such as the Inspector tool, charting, and portal filtering. Exercise files accompany the course.

Topics include:

  • Creating databases from templates
  • Creating fields in spreadsheet format
  • Creating tables and relationships
  • Defining key fields
  • Adding validation and auto-enter values to fields
  • Managing records, including duplicating, locking, and deleting records
  • Creating and managing layouts
  • Formatting layout objects
  • Finding and sorting data
  • Creating calculation fields
  • Building reports
  • Printing and saving as PDF or Excel
  • Writing and triggering scripts
  • Using relationships throughout a database

Screenshot :

Lynda.com - FileMaker Pro 11 Essential Training Screenshot

Lynda.com – Excel 2010 Power Shortcuts

November 4, 2011 Tinggalkan komentar

Publisher : Lynda.com
Platform : Microsoft Excel
Format : Mov
Size : 1 CD

Links : Homepage

 

Description :

In Excel 2010 Power Shortcuts, Excel expert Dennis Taylor shares tips and shortcuts to vastly increase efficiency and get the full power out of Excel 2010. There are tips for working with the Ribbon and Quick Access toolbar, navigating workbooks and selecting cells, rapid data entry and editing, working with formulas, formatting data, working with charts, sorting data, and much more. Exercise files accompany the course.

Topics include:

  • Creating charts with keyboard shortcuts
  • Converting formulas to values by dragging
  • Repeating Undo and Redo actions
  • Displaying formulas instantly
  • Navigating quickly through worksheets and across workbooks
  • Formatting numeric, and date/time data in a flash with keystroke shortcuts
  • Inserting dates or times instantly
  • Grouping rows or columns to create collapsible regions
  • Building data-entry shortcuts with Auto-fill
  • Displaying unique items from large lists

Screenshot :

Lynda.com - Excel 2010 Power Shortcuts Screenshot

Lynda.com – Excel 2007 Working with Dates and Times

November 4, 2011 Tinggalkan komentar

Publisher : Lynda.com
Platform : Microsoft Excel
Format : Mov
Size : 1 CD

Links : Homepage

 

Description :

In Excel 2007: Working with Dates and Times, Dennis Taylor shares his solutions for optimizing the use of dates and times in Excel 2007. This course explains what’s going on behind the scenes when Excel stores dates and times, gives tips for entering dates and times, and shows options for date and time formatting. It also demonstrates the various date and time functions and shows how to calculate with dates and times in a range of scenarios. Exercise files are included with the course.

Topics include:

  • Understanding how Excel records and stores dates and times
  • Looking at standard date/time entry options and acceptable alternatives
  • Using the TODAY and NOW functions
  • Customizing date formats
  • Exploring keyboard shortcuts
  • Formatting time for hours over 24
  • Calculating differences across dates and times
  • Rounding calculations
  • Working with holidays
  • Validating with dates
  • Converting formatted dates to usable data

Screenshot :

Lynda.com - Excel 2007 Working with Dates and Times Screenshot

Lynda.com – eBay Essential Training

November 4, 2011 Tinggalkan komentar

Publisher : Lynda.com
Platform : Multiplatform
Format : Wmv
Size : 1 DVD5

Links : Homepage

 

Description :

In eBay for Sellers Essential Training, Christopher Spencer shows how to understand the selling process on eBay, including community rules and best practices, resources and support, and creating compelling listings. The course explores how to review active and completed listings, establish the value of merchandise, and list products. The course also covers using advanced search techniques, managing payments, and setting up an eBay Store.

Topics include:

  • Creating eBay and PayPal accounts
  • Building an About Me page
  • Performing advanced searches
  • Reviewing the competition
  • Understanding listing fees
  • Writing effective titles and descriptions
  • Exploring best practices for product photography
  • Understanding warranties and guarantees
  • Creating listings
  • Connecting eBay with social media
  • Handling offers
  • Packing and shipping merchandise
  • Leaving feedback
  • Tracking sales

eBay for Buyers Essential Trainingshows how to shop in the international online marketplace, from finding and evaluating items and sellers to making purchases safely. The course offers tips and tricks for getting the best prices from trustworthy sellers, searching for goods, bidding, disputing transactions, and finding help through eBay Customer Support, educational resources, and communities.

Topics include:

  • Creating an eBay account
  • Contacting Customer Support
  • Browsing listings
  • Shopping for real estate and cars
  • Saving and filtering search results
  • Reviewing seller feedback
  • Reviewing payment terms and shipping options
  • Bidding and re-bidding on an item
  • Using the Shopping Cart feature
  • Handling problem transactions
  • Avoiding phishing attempts and scams
Screenshot :

Lynda.com - eBay Essential Training Screenshot

Lynda.com – Designing Business cards

November 4, 2011 Tinggalkan komentar

Publisher : Lynda.com
Platform : Adobe InDesign – Illustrator
Format : Mov
Size : 1 CD

Links : Homepage

 

Description :

A successful business card design needs to be both professional and functional. It might be the first piece of branding someone sees relating to a company, so it should make a positive impression. Designer Nigel French shares his techniques and experience in Designing Business Cards Hands-On Workshop. He walks through the fundamental decisions, such as what information to include, what size and orientation the card should have, and whether to use both sides. He demonstrates how to set up a template and work with type alignment and color. Nigel also discusses paper selection and preparing the file for printing. Example files accompany the course.

Screenshot :

Lynda.com - Designing Business cards Screenshot

Lynda.com – Designing Book Covers Hands-On Workshop

November 4, 2011 Tinggalkan komentar

Publisher : Lynda.com
Platform : Adobe InDesign
Format : Mov
Size : 1 CD

Links : Homepage

 

Description :

Join author Nigel French in Designing Book Covers Hands-On Workshopas he walks through several approaches to creating professional, engaging book covers using Adobe Creative Suite applications. This course covers document setup, composition and layout, illustration, typography essentials, and printing. Exercise files accompany the course.

Topics include:

  • Researching the design and brainstorming ideas
  • Setting up a document in InDesign or Illustrator
  • Choosing typefaces, colors, shapes, and imagery
  • Hand-drawing type and using different type treatments
  • Creating illustrations from scratch
  • Using and adapting photographs for illustration
  • Preparing the book covers for printing

Screenshot :

Lynda.com - Designing Book Covers Hands-On Workshop Screenshot

Lynda.com – Designing a Magazine Layout Hands-On Workshop

November 4, 2011 Tinggalkan komentar

Publisher : Lynda.com
Platform : Adobe InDesign
Format : Mov
Size : 1 DVD5

Links : Homepage

 

Description :

Building a great magazine layout can be a time-consuming and difficult process, and can involve working with a number of applications and perhaps a group of designers to achieve a satisfactory result. In Designing a Magazine Layout Hands-On Workshop, graphic designer and Adobe Certified Instructor Nigel French teaches effective design and production techniques using InDesign, Illustrator, Photoshop, and Bridge to create dynamic magazine layouts. He establishes an efficient workflow using multiple programs, examines the aesthetics of integrating text with images, and teaches best practices for outputting the final document. Exercise files accompany the course.

Topics include:

  • Identifying the common parts of a magazine feature article
  • Creating an efficient workflow using Bridge
  • Designing with bleeds and crossovers
  • Creating and applying paragraph, character, and object styles
  • Designing and working with a baseline grid
  • Preflighting documents
  • Creating print-ready PDFs

Screenshot :

Lynda.com - Designing a Magazine Layout Hands-On Workshop Screenshot