Cleaning Up Your Excel Data

Lynda.com Inc.

In this course, Dennis Taylor explores the functions, commands, and techniques in Excel that restructure data, remove unwanted characters, convert date data into the desired format, and prepare data for efficient analysis.

This course helps get data from a business management system file, other database software, a text file, or a poorly designed Excel worksheet into optimal shape for working with in Excel. Exercise files are included with the course.

Topic includes:

  • Converting dates with text functions
Along with the free video training tutorials you will also receive monthly offers, tips, and insider information you won't hear elsewhere--including special discounts extended to newsletter subscribers.

After taking advantage of the free video training, you can access all of their video tutorials by becoming a member of the Online Training Library®. Membership plans start at $25 per month, and require no long-term commitment.

Click here to request Your Complimentary Online Tutorial NOW!

Other Publications You May Be Interested In

Click here to see all 1064 other offer(s) that may interest you.

Advances in Deduplication Help Tame Big Data

Advances in Deduplication Help Tame Big Data

A(n) Report by Hewlett-Packard Company
This report covers the challenges of first generation deduplication technology and the advantages of next-gen deduplication products.

Enterprise Strategy Group: The Next Wave of Data Deduplication

Enterprise Strategy Group: The Next Wave of Data Deduplication

A(n) White Paper by Hewlett-Packard Company
Leveraging deduplication in backup environments yields significant advantages.

Hardware vs. Software Deduplication: Finding What's Right for You

Hardware vs. Software Deduplication: Finding What's Right for You

A(n) White Paper by Hewlett-Packard Company
Clearly both software deduplication and dedicated hardware deduplication appliances can offer good return on investment.

B2B Collaboration: No Longer Optional

B2B Collaboration: No Longer Optional

A(n) Research Report by Aberdeen Group
Access Your Complimentary Copy Today. This $399 Value Offer Expires 06/10/2012.

Business Intelligence - A Guide for Midsize Companies

Business Intelligence - A Guide for Midsize Companies

A(n) Guide by SAP
How Business Intelligence Can Help Improve Your Company's Performance No Matter What Its Size.

Cloud Financial Management: Cost-Effective Implementation of Budgeting and Forecasting Measures

Cloud Financial Management: Cost-Effective Implementation of Budgeting and Forecasting Measures

A(n) Research Report by Aberdeen Group
Access Your Complimentary Copy Today. This $399 Value Offer Expires 06/10/2012.

Building an Ecommerce Web Site Using Dreamweaver with PHP

Building an Ecommerce Web Site Using Dreamweaver with PHP

A(n) Video by Lynda.com Inc.
In this course, author Lawrence Cramer offers two approaches to implementing ecommerce functionality in Dreamweaver: introducing basic ecommerce functions to an existing site and creating a stand-alone ecommerce solution with PHP and MySQL. The course explores choosing a payment vendor, creating a simple buy button, configuring a store with the Cartweaver extension, adding products and discounts, and managing inventory. The course also provides guidance on securing an ecommerce site, preparing for the site's launch, and effectively promoting a store. Exercise files accompany the course.

Designing Web Sites from Photoshop to Dreamweaver

Designing Web Sites from Photoshop to Dreamweaver

A(n) Video by Lynda.com Inc.
This course teaches web design beginners how to turn their design in Photoshop into a fully functioning web site in Dreamweaver. Sue Jenkins shows how to create mockups, slice, and optimize web graphics, and build a site using the Dreamweaver HTML and CSS templates.

Dreamweaver and WordPress: Building Mobile Sites

Dreamweaver and WordPress: Building Mobile Sites

A(n) Video by Lynda.com Inc.
In this course, author Joseph Lowery shows how to build a mobile WordPress site in Adobe Dreamweaver. The course explains how to prepare a site to go mobile, optimize a site's styles for tablets and phones, and implement a full mobile redesign. The course also covers working with WordPress child themes, integrating media queries, incorporating screen-optimized graphics, designing for touch screens, and working with orientation changes. Exercise files accompany the course.

Dreamweaver and WordPress: Building Themes

Dreamweaver and WordPress: Building Themes

A(n) Video by Lynda.com Inc.
In this course, author Joseph Lowery builds a WordPress theme from the ground up using Dreamweaver. The course examines the core structure of a theme, demonstrates constructing and customizing a theme, and explains how to create the site's CSS. The course also covers setting up the single post page, handling search results, and customizing error pages. Exercise files are included with the course.

Dreamweaver and WordPress: Building Sites

Dreamweaver and WordPress: Building Sites

A(n) Video by Lynda.com Inc.
In this course, author Joseph Lowery shows how to create a robust WordPress-based site using Dreamweaver. The course lays out the essentials of planning a site, explains how to implement custom sidebars, and demonstrates building page templates.

Facebook Essential Training

Facebook Essential Training

A(n) Video by Lynda.com Inc.
In Facebook Essential Training, Garrick Chow shows how to start navigating the world of social networking and put the best face forward online. The course covers the basics: creating a profile; making Facebook friends; viewing their posts with the Ticker and Timeline; communicating via status updates, the wall, and chat; and sharing photos, videos, and links. Garrick also touches on the delicate subject of removing friends and respecting other people's privacy online. The advanced features of Facebook—including permissions, add-in applications, and dedicated groups—are also covered.