New Feature: Playlist Center! Pick a topic and let our playlists guide the way.

Learn it fast with expert-taught software and skills training at lynda.com. See what you can learn

By Curt Frye | Thursday, June 26, 2014

Getting Started with Excel VBA

excel-cells-in-repose

Excel is a powerful and versatile tool you can use to analyze data—but not every capability you might want is built in.

Using the Visual Basic for Applications (VBA) language, you can script custom processes in Excel. VBA is an object-oriented language, which means that elements of Excel—such as workbooks, worksheets, and the program itself—are represented as objects. An object has three main components:

  • properties, which describe the object
  • methods, which are things the object can do
  • events, which are occurrences the object can recognize and react to

By Megan O. Read | Friday, January 22, 2010

Microsoft Office 2010 Beta training now available on lynda.com

This week, lynda.com published five new Microsoft Office Beta 2010 online training courses.

Gini Courter, author of countless Microsoft Office books and partner of TRIAD Consulting, has been busy authoring many of these new releases, including Powerpoint 2010 Beta: Real-World Projects, Word 2010 Beta: Real-World Projects, Access 2010 Beta: Real-World Projects, and Outlook 2010 Beta: Real-World Projects.

Also available now are Curt Frye’sExcel 2010 Beta: Real-World Projects, and David RiversOffice Beta Preview.

With more Office 2007 and 2010 online courses in the works, this is a rapidly expanding and exciting area of training for lynda.com. Let us know what you think.

By Megan O. Read | Friday, November 20, 2009

lynda.com author (that Excel guy) Curt Frye teaches critical financial skills

When Curt Frye started working with lynda.com, we were all very excited about the slew of new and much needed Microsoft Excel courses he was planning for us. With the state of the economy, and more people doing their own finances, as well as tightening their belts nearly to the point of of asphyxiation, it is becoming more critical for the general public to understand their finances, even on a very basic level.

In the November 2009 issue of the Harvard Business Review, The Forethought column “Teach Workers About the Perils of Debt.” states:

“It’s widely known that many consumers have poor numeracy–they can’t figure out percentages or do other elementary calculations–and have barely a rudimentary grasp of economics. In our research, we looked deeper, studying consumers’ ‘debt literacy,’ the ability to understand how interest rates work and make simple decisions about borrowing. We found it to be strikingly low.”

With the state of the economy, and more people doing their own finances, as well as tightening their belts nearly to the point of of asphyxiation, it is becoming more an more critical for the general public to understand their finances, even on a very basic level. <em>Photo courtesy of iStockphoto, image #3154423</em>

Curt's aim in creating a course on financial analysis was to teach skills required to analyze debt. Photo courtesy of iStockphoto, image #3154423

“My aim in creating Excel 2007: Financial Analysis was to teach the skills required to analyze debt,” said Curt Frye of his first lynda.com course. “I’m hoping that it helps subscribers better understand some critical skills that not everyone is taught at home or in school.”

Curt is currently working on a new book, as well as new lynda.com courses. For a full list of his training, visit his author page.

By Crystal McCullough | Wednesday, September 23, 2009

Microsoft MVP Curt Frye helps dispel the common fear of Excel’s Pivot Tables

In Excel 2008 for Mac: Pivot Tables for Data Analysis, Microsoft Most Valuable Professional Curt Frye helps dispel the common fear of the Pivot Table feature, demonstrating how to use this powerful tool to discover valuable business intelligence. Curt shows how to create Pivot Table reports from internal Excel data and outside data sources, use filters to focus on the most important data in the sheet, and prepare a Pivot Table report by applying formats and rules.

By Megan O. Read | Thursday, August 27, 2009

Meet three fantastic authors, straight from the recording booths at lynda.com

authorsthsweek

Clockwise starting at top: Jeff Sengstack, Simon Allardice, Curt Frye.

Straight from the recording booths this week, we have three FANTASTIC authors who may be familiar faces…

Jeff Sengstack, author of Premiere Elements 7 Essential Training, is back in the booth to bring us a few new and interesting courses that we will share with you soon!

Simon Allardice, all the way from Scottsdale (by way of Scotland), is in recording the highly anticipated iPhone SDK Essential Training. Simon is one of our original instructors from the Ojai classroom days, and recorded the UltraDev 4 course for us way back in 2002. We are thrilled he is finally able to make time in his busy schedule to get back in our booth!

Finally, Curt Frye, who released his first lynda.com course (Excel 2007: Financial Analysis) with us just this week (congrats Curt!), is in town recording two more greatly needed Excel courses: Excel 2007: Pivot Tables for Data Analysis and Excel 2008 for Mac: Pivot Tables for Data Analysis.

Thanks for coming back for more, guys! We look forward to seeing you in the booth again next time!

By Crystal McCullough | Wednesday, August 26, 2009

Avoiding common mistakes in Excel 2007

Numbers and financial data drive today’s business world and the goal of Excel 2007: Financial Analysis is to help decode this information. Microsoft MVP (Most Valuable Professional) and Excel specialist Curt Frye teaches basic fluency in corporate finance, enabling users to see the meaning behind essential financial calculations. In this tutorial, Curt explains how to avoid common mistakes in Excel 2007 to assure fomula accuracy and correct spreadsheet value results.

Interested in more? • Become a lynda.com member • Watch Excel 2007: Financial Analysis at lynda.com • All lynda.com courses by Curt Frye

Get the latest news

  •   New course releases
  •   Pro tips and tricks
  •   News and updates
  
New releases submit clicked

You can change your email preferences at any time. We will never sell your email. More info

Featured articles

A lynda.com membership includes:

Unlimited access to thousands of courses in our library
Certificates of completion
New courses added every week (almost every day!)
Course history to track your progress
Downloadable practice files
Playlists and bookmarks to organize your learning
Become a member

Thanks for signing up.

We’ll send you a confirmation email shortly.


Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

Keep up with news, tips, and latest courses with emails from lynda.com.

Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

   
submit Lightbox submit clicked
Terms and conditions of use

We've updated our terms and conditions (now called terms of service).Go
Review and accept our updated terms of service.