lyndacom
Lynda.com provides training to more than 2 million people, helping individuals as well as university, corporate, and government members learn what they need to succeed.
Courses for every skill level cover more than 140 specialties in these subjects:
- 3D + Animation
- Audio
- Business
- Design
- Developer
- Photography
- Video
- Web
Learn anytime, anywhere. The entire library is available through our website, mobile site, and our free iPhone and iPad app.
Efficient, focused learning. Make the most of your online learning with these tools:
- earn and share certificates of completion
- track your progress with course history
- organize and prioritize with queue and bookmarks
- find answers fast with searchable transcripts
- practice while you learn with downloadable project files
- closed captioning
Subscription Information
| Monthly | Annual |
| Popular & affordable | $239.88/year |
| $24.99/month | $19.99/month |
|
No long-term commitment Over 104,000 tutorials Anytime access |
Save $50 per year Over 104,000 tutorials Anytime access |
|
|
|
|
Monthly Premium |
Annual Premium |
| Affordable premium plan | $359.88/year |
| $34.99/month | $29.99/month |
|
Includes exercise files No long-term commitment Anytime access |
Includes exercise files Over 104,000 tutorials Anytime access |
|
|
|
Course List
In Excel 2010: Macros in Depth, author Dennis Taylor explains how macros can be used to automate tasks in Excel and walks through the process of creating and running simple macros. This course also covers advanced topics such as making macros widely available through the Personal Macro Workbook, recording a macro in stages, absolute and relative recording, and using Visual Basic for Applications (VBA) for actions that can't be recorded. The course wraps up with a macro project that brings together each of the elements in a real-world scenario. Exercise files are included with the course.
Add to course comparison | | View your course lists
In Excel 2010: Managing Multiple Worksheets and Workbooks, author Dennis Taylor shows how to share data between multiple worksheets and workbooks and gives tips for adding, moving, and navigating worksheets and workbooks efficiently. This course covers how to make global changes, create simple formulas that connect worksheets, make super-efficient 3D formulas to calculate summary totals from multiple worksheets, and use pivot tables to summarize data from multiple workbooks. Exercise files accompany the course.
Add to course comparison | | View your course listsIn Excel 2010: Pivot Tables in Depth, author Curt Frye provides comprehensive, hands-on tutorials on Excel PivotTables, including more advanced techniques such as using macros and the new PowerPivot add-in. The course shows how to connect and consolidate data sources to power PivotTables, sort and filter records, display data in a PivotChart, print tables and charts, and also introduces the DAX language for performing advanced summaries in PowerPivot. Exercise files are included with the course.
Add to course comparison | | View your course listsIn Excel 2010: Real-World Projects, author Curt Frye demonstrates five important new features in Excel 2010. Using real-world examples, Curt shows how Excel 2010 will be a beneficial upgrade for all users. He highlights the improvements in PivotTables and the visual presentation of data. The release of this important business application will give users a number of new ways to review and present information. Exercise files accompany this course.
Add to course comparison | | View your course lists
In Excel 2010: Working with Dates and Times, Dennis Taylor shares his solutions for optimizing the use of dates and times in Excel 2010. 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.
Add to course comparison | | View your course listsWhether you're a novice or an expert wanting to refresh your skillset with Microsoft Excel, this course covers all the basics you need to start entering your data and building organized workbooks. Author Dennis Taylor teaches you how to enter and organize data, perform calculations with simple functions, work with multiple worksheets, format the appearance of your data, and build charts and PivotTables. Other lessons cover the powerful IF, VLOOKUP, and COUNTIF family of functions; the Goal Seek, Solver, and other data analysis tools; and how to automate many of these tasks with macros.
Add to course comparison | | View your course listsDiscover over 65 tips, tricks, and shortcuts in Microsoft Excel. In this course, Curt Frye reveals how to invoke commands, manage and organize data, and build formulas in Excel. Curt shares his power shortcuts for saving time on basic tasks, from entering data and selecting cell ranges to summarizing data with charts and tables and quickly finding information.
Add to course comparison | | View your course listsJoin Curt Frye as he explains how to leverage PivotTables to summarize, sort, count, and chart your data in Microsoft Excel. Curt shows you how to navigate the complexity of PivotTables while taking advantage of their power. This course shows how to build PivotTables from single or multiple data sources, add calculated fields, filter your results, and format your layout to make it more readable. Plus, learn how to enhance PivotTable with macros, DAX expressions, and the PowerPivot add-in for analyzing millions of rows of data.
Add to course comparison | | View your course listsIn Excel for Mac 2011 Essential Training, author Curt Frye gives a comprehensive overview of Excel, the full-featured spreadsheet software from Microsoft. The course covers key skills such as manipulating workbook and cell data, using functions, automating actions, printing worksheets, and collaborating with others. Exercise files accompany the course.
Add to course comparison | | View your course lists
By utilizing social media platforms like Facebook, you can increase your brand's visiblity and take advantage of free features to communicate and advertise your photography or videos. This course shows how to succeed as a creative professional using the Facebook platform. Author Rich Harrington charts the evolution of the platform, and shows how to find new connections, create events, and decide what and when to post. The course also covers creating a company profile distinct from your personal profile, and using Facebook groups and messaging to manage client projects.
Add to course comparison | | View your course lists